Architectural Principles Naming Conventions
The Association has developed procedures that will modify the names assigned by the CASE tool to conform to the naming conventions in this document.
Contents |
Guidelines
1. Constraint name may not be the same as a table name.
2. All constraint names must be unique.
3. Constraint name equals the short name (Synonym) of the host table and the short name of the source table concatenated with a key type designation (i.e. BA_R_SRC_FK for a foreign key).
4. Foreign key constraint names should indicate the relationship and end in _FK, where n is a sequence number assigned to the foreign constraint with a table in the case where more than one relationship with the parent table exists.
5. Primary key constraint names should be named as SYNONYM _PK. They can be a maximum of 30 characters long.
6. Unique index constraint names should be named as % _UK.
7. Check constraint names should be named as %_CK
Go to
- Architectural Principles Primary Key Constraints
- Architectural Principles Foreign Key Constraints
- Architectural Principles Check Constraints
- Architectural Principles Indexes
- Architectural Principles Arcs
- Architectural Principles Recursive Relationships
- Architectural Principles Naming Conventions
