Database Naming Standards - DEV Community
snake_casefor columns- plurals for table names
- full names for id columns (
mail_idinstead ofid) - avoid ambiguous names (
fahrenheitinstead oftemperature)- foreign key constraints should use the same column name as PK in the connected table
- prefix with context id needed (
source_warehouse_idanddestination_warehouse_id)