Page Comparison

...

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

Terminology

Table

...

Data Descriptions

• Staging (SPre): Tables that directly reflect the source (or "raw") data, with only minimal formatting changes.defined: Definitions provided out of the box, may be added to by local deployment
• Instantiated: Definitions added by local deployment
• Standardized: Normalized data transformed from SOR specific format to common format
• Raw: Untouched data from SOR
• Calculated: Data calculated by transformation on raw, standardized, or calculated data

Table Types

• Calculated (C): Tables that are the result of business rule execution.Supporting (X): Tables that relate to the management of the system, and that are generally only modified by the administratorholding calculated data. May also include Standardized data.
• Dictionary (D): Support tables that hold (pre)defined definitions external to the Registry. Example: A list of countries.
• Original (O): Tables that hold data original to/originated by the Registry.Dictionary
• Raw (DR): Support tables that hold definitions external to the Registry. Example: A list of countriesTables that directly reflect the source (or "raw") data, with only minimal formatting changes.
• View (V): A database view, constructed of underlying tables.

Table Data Descriptions

• (Pre)defined: Definitions provided out of the box, may be added to by local deployment
• Instantiated: Definitions added by local deployment
• Standardized: Normalized data transformed from SOR specific format to common format
• Raw: Untouched data from SOR
• Calculated: Data calculated by transformation on raw, standardized, or calculated dataStandardized (S): Tables holding standardized data.
• Supporting (X): Tables that relate to the management of the system, and that are generally only instantiated or modified by the system or an administrator.