Back-End Standard

From SmartHCM Wiki
Jump to navigation Jump to search

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
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