Back-End Standard

From SmartHCM Wiki
Revision as of 09:26, 26 April 2015 by Usman (talk | contribs)
Jump to navigation Jump to search

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


    1. abc
    2. def
    3. ghi


  1. abc
  2. def
  3. ghi