Difference between revisions of "Back-End Standard"
Jump to navigation
Jump to search
(Created page with "== Naming Conventions and Standards == # Numbered list item Database Object Name (i.e. Table, Sequence, View, Index, Trigger, Package, Procedure, Function, Materialized View,...") |
|||
| Line 1: | Line 1: | ||
== Naming Conventions and Standards == | == Naming Conventions and Standards == | ||
| − | # Numbered list item | + | #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 | 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" | Example : Table Name "HRS_EMPLOYEE_PERSONNEL" | ||
| − | # Numbered list item | + | #2 Numbered list item |
Column Name should be clearly defined and meaningful | Column Name should be clearly defined and meaningful | ||
Example : Employee_ID | Example : Employee_ID | ||
| − | # Numbered list item | + | #3 Numbered list item |
Database Object name and Column name should not contain the Number and Special characters except "_" character | Database Object name and Column name should not contain the Number and Special characters except "_" character | ||
| − | # Numbered list item | + | #4 Numbered list item |
Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints | Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints | ||
Revision as of 09:23, 26 April 2015
Naming Conventions and Standards
- 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"
- 2 Numbered list item
Column Name should be clearly defined and meaningful Example : Employee_ID
- 3 Numbered list item
Database Object name and Column name should not contain the Number and Special characters except "_" character
- 4 Numbered list item
Constraints name should be clearly defined and must be used the prefix and suffix when creating the constraints
