- Table names should be prefixed with application/component identifier.
- Primary key id column should be prefixed with table name (without application prefix) and followed by _GID.
- Underscore to separate words.
- Foreign key column is concatenation of role name and primary key column name of target table, except when role and table have the same name.
Naming conventions are important for software quality. Supporting the conventions with a tool is the best way to make sure that they are applied in a consistent way.