Databases Query collection hierarchies Queries should be organised into a Query Collection Hierarchy Tables within the same collection can use an underscore to indicate their hierarchy Related tables should use an underscore to indicate their hierarchy Casing Tables should use PascalCase Columns should use camelCase Primary keys should be called id Naming Column names should be treated exactly as object properties are Foreign key column names do not need special identification Foreign key constraint names should reference both tables and columns uniquely
