Skip to content

Latest commit

 

History

History
27 lines (19 loc) · 884 Bytes

File metadata and controls

27 lines (19 loc) · 884 Bytes

Constraints Rules

CS1 : Constraints naming pattern

Constraint Type CSPrefix Pattern exemple
Primary key PK_ <CSPrefix>_<TableFullName> PK_D_MAT_Material
Foreign key FK_ <CSPrefix>_<TableFullName>_<ParentTableName> FK_D_MAT_Material_MaterialGroup
Unique key UK_ <CSPrefix>_<TableFullName> UK_D_MAT_Material
Check key CK_ <CSPrefix>_<TableFullName>_<Column> CK_F_FIN_COPA_Year
Default DF_ <CSPrefix>_<TableFullName>_<Column> DF_D_PRO_Product_LUD

CS2 : Constraints prefixes

2 letters uppercase depending the constraint's type. Constraints prefixes will be in the following list :

Constraint Type CSPrefix
Primary key PK_
Foreign key FK_
Unique key UK_
Check key CK_
Default DF_