Back-End Standard

Naming Conventions and Standards

1. 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"
2. Column Name should be clearly defined and meaningful. Example : Employee_ID
3. Database Object name and Column name should not contain the Number and Special characters except "_" character
4. Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints

Constraints Name

Constraints Name
Abbreviation	Description	Example
fk	References (Foreign Key)	hr_emp_empid_fk
uk	Unique Key	hr_emp_empid_uk
pk	Primary Key	hr_emp_empid_pk
ck	Check	hr_emp_empid_ck
nn	Not Null	hr_emp_empid_nn