Naming Conventions

Table

Type	Structure	Comments
Relationship	{Table 1}#{Table 2}	In alphabetical order of table names e.g. COUNTRY#LANGUAGE instead of LANGUAGE#COUNTRY. The reversed form can be aliased by synonyms for convenience.
All other table names		Name of the objects in the table is in singular to shorten the table names e.g. COMPANY instead of COMPANIES. This also prevents complications from multiple spellings of the plural form e.g. VIRUS->VIRII, VIRUSES

Column

Type	Structure	Comments
Foreign key	{[Optional qualifier][$]}[referenced TABLE_NAME]_[referenced COLUMN_NAME]	In alphabetical order of table names e.g. COUNTRY#LANGUAGE instead of LANGUAGE#COUNTRY. The reversed form can be aliased by synonyms for convenience.
All other column names	Words in order of descriptiveness for correct column order in table	e.g. SHARESNUMBER instead of NUMBERSHARES so that all SHARES attributes live in a single visual block in column ordering

Column Positions

Order	Type	Comments
1	Primary key	By order of access if multiple-column, else alphabetical
2	Self-referencing foreign key
3	Foreign keys	In alphabetical order
4	Mandatory columns	In alphabetical order
5	Not mandatory columns	In alphabetical order
6	Valid time start
7	Valid time end
8	Transaction time start
9	Transaction time end
10	COMMENTS column