Odyssey 3 Applications Database

All data are stored in the Postgres database at appdb.cs:5433. Each application has a schema.

Naming Conventions

Tables are named using all lowercase letters with underscores to separate words. This convention is chosen because it ensures that the table names as written in the schema definitions match exactly the table names used within the database. Postgres has case-sensitive identifiers, but interprets identifiers written in SQL commands in a subtle way: identifiers written alone are lower-cased as part of the parsing process; identifiers surrounded by double quotes are left alone.

The first word of a table name identifies the portion of an application to which it relates. This is essentially a way of getting around the fact that Postgres has only a two-level namespace (within each database), where each table is identified by a schemaname and a tablename. In practice one additional level is normally enough.

-- IsaacMorland - 05 Nov 2008