The community database is the foundation for a set of social software applications. The primary focus is a user roster, a node roster, and a whuffie/mojo calculation and management system. The database is currently implemented in SQL tables on postgresql.

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

community database take three. February 2004

Users Table BR Description

Table Relationships

Fields

Table attributes - Cascade BR

Create Record BR

Delete Record BR

Node table BR Description

Table relationships

Fields

Check constraints: BR

Router table BR Description

Table relationships

Fields

Interface table BR Description

Table relationships

Fields

Addresses Table BR Description Street address of users, nodes, etc.

Table Relationships

Fields BR

Community BR Description

General table design notes:

When indexing one table to another table, ie when table A contains a foreign key from table B, follow these practices: BR

System for getting at the data

Implementation


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


[CategoryDocumentation]