The community database is the foundation for a set of applications that will serve the wireless community. The primary focus is a The database is currently implemented in SQL tables on postgresql.

The roster of tables.

User Table BR Description

Table Relationships

Fields

Node table BR Description

Table relationships

Fields

Indexes: node_nodeid_key unique btree (nodeid)

Check constraints: "$1" (srid(node_geom) = -1)

DonPark and AdamShand are thinking about ways to create a SQL (or maybe LDAP or XML or something) schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that a community wireless group would want to keep track of (yes we know we're doomed to failure :-).

Databases

System for getting at the data

Implementation


[http://www.nodedb.com/ndbcom.dtd] NodeDB.com xml schema...


community database take two. March 2003 AdamShand, JerrittCollord, AaronBaer, (insert your name here)

I pulled this right out of postgresql since it doesnt appear to be documented anywhere else -- DonPark


[CategoryDocumentation]