Page Comparison

Data Model ERDs

(revised February March 2009)

Currently Being Revised

...

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 suffix _column name id indicates a row identifier.
6. The suffix _t indicates a type identifier, as defined in ctx_data_types.

...