Coding Standards & Examples - Tables

TABLE NAMES

All table names throughout the system will be in singular and uppercase.

TABLE OCCURENCES

All table names throughout the system will be in singular and uppercase.

There are four primary formats for a Table Occurrence:

1. Stand alone table (Utils) denoted by an underscore at the beginning and then the Table name in Uppercase.
Local tables are coloured black and remote tables are coloured light grey.
2. If a Table Occurrence relates to the same table as the primary TO then it appears in uppercase with the function name at the end, i.e. Search.
Occurrences for the same primary table all have the same colour.
3. If a Table Occurrence is not the same as the primary TO then it appears in uppercase after the primary TO in Title case.
Occurrences for the same primary function all have the same colour.

Example TO names:

1. _INTERFACE
1. _JOB
2. JOB
2. JOB_Search
3. Job_LOCATION

Sample Table Occurance Groups (TOG):