The County - Developer's Site

Home

Architecture

Database

JoCC Paper

Lilac Docs

Manage Test Server

NSF Stuff

Technical
Standards

Tools

Prototype

Old Papers

Old Prototypes

Database

This page is for the database underlying the county. It's in MySQL. Here is the ERD:

This was created in MyERD (see the tools page to get it). You can download the file for the ER diagram in MyERD format.

Notes:

1. The content field in document_component contains an XML representation of the the content. We still need to set the XML standards for each document type.
2. A space is either a room or a public area in a village.
3. Spaces are owned by either a person or a village. owner_type specifies which.
4. In permission_lists, either p_id or v_id is specified. The other is null.
5. When a comment is created, its initial view permissions are copied from the document to which it applies.

Contact Kieran Mathieson (mathieso@oakland.edu) with questions or comments.