Architectural Principles PPDM DDL Components

Contents 1 Mandatory Components 2 Optional Components 3 Go to the next Section Architectural Principles Naming and Design Conventions 4 Back to Architectural Principles Index

Mandatory Components

• Table and column definitions – file extension is .tab
• Constraints (primary, foreign, check) – file extension is .con
  • Note that in PPDM 3.7, the use of constraints to the R_PPDM_ROW_QUALITY reference table was not mandatory. This rule has been altered in PPDM 3.8, making the use of the foreign key mandatory.

Optional Components

• Table comments – file extension is .tcm
• Column comments – file extension is .ccm
• Table synonyms – file extension is .syn
• UOM and OUOM constraints – file extension is .uom
  • Note that in PPDM 3.7, the use of constraints to the UNIT OF MEASURE support module was not mandatory. This rule has been carried forward
• GUID extensions – file extension is .guid
• Spatial extensions – created during implementation of the spatial enabling methods

Go to the next Section Architectural Principles Naming and Design Conventions

Back to Architectural Principles Index