April 10th, 2009
Naming Standards (Part 4 of 4)
Posted by
admin in
O. Database Objects
Here is another sample naming standard:This naming standard uses shorter object names appropriate for a small database on a PC computer. We are using the template SSSEEEOM where:
SSS identifies the application system. Here CUS is for CUSTOMER.
EEE shows the entity within the application such as MST for MASTER, ORD for ORDERS, etc.
O reflects the type of object, such as:
D = Database
S = Schema
T = Table
V = View
X = Index
C = Constraint
M is for multiple occurences.
The CUStomer ORDers Table is CUSORDT.
The CUStomer ORDers inDeXes are CUSORDX1 and CUSORDX2.
Comments Off
