Back-End Standard
Jump to navigation
Jump to search
Naming Conventions and Standards
- Numbered list item
Database Object Name (i.e. Table, Sequence, View, Index, Trigger, Package, Procedure, Function, Materialized View, Job, Type, Directory, Constraints, Synonyms and Tablespace ) should be meaningful Example : Table Name "HRS_EMPLOYEE_PERSONNEL"
- Numbered list item
Column Name should be clearly defined and meaningful Example : Employee_ID
- Numbered list item
Database Object name and Column name should not contain the Number and Special characters except "_" character
- Numbered list item
Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints
