Column naming conventions
The database uses the following naming conventions in the database tables.
|
Column name |
Column data type |
Description |
|---|---|---|
|
Key |
GUID |
Fields that contain the word Key in the column name represent Global Unique Identifiers used to distinguish objects. Keys are internally used fields. |
|
ID |
Character (nnn) |
Fields that contain the word ID in the column name represent external unique identifiers used to distinguish objects. IDs are externally used fields. For column data type Character, the tables include the character length. |
|
Number |
Character (nnn) |
Fields that contain the word Number in the column name represent external identifiers. Numbers are not necessarily unique. Refer to the table to determine if the Number is required to be unique. For column data type Character, the tables include the character length. |