Back-End Standard

Naming Conventions and Standards

1. 1 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"

1. 2 Numbered list item

Column Name should be clearly defined and meaningful Example : Employee_ID

1. 3 Numbered list item

Database Object name and Column name should not contain the Number and Special characters except "_" character

1. 4 Numbered list item

Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints