Page Comparison

Data Model ERDs

(revised March 2009April 2011)

Currently Being Revised

• Full Data Model (old)
• Full Data Model (revised April 2011)
• Full Data Model (revised Feb 2012)
• Common Tables
• Groups
• Persons

...

1. Table names are prefixed CCT_ where CC indicates the responsible component and T indicates the type of table as enumerated above.
2. Table and column names are all lowercase, with underscores ({_}) to separate words/fragments. StudlyCaps are not used.
3. Natural english is preferred over major/minor. So start_date, not date_start.
4. Column names should avoid incorporating the table name.
5. The column name id indicates a row identifier.
6. The suffix _t indicates a type identifier, as defined in ctx_data_types.

...