2025-04-16

Database Naming Standards - DEV Community

• snake_case for columns
• plurals for table names
• full names for id columns (mail_id instead of id)
• avoid ambiguous names (fahrenheit instead of temperature)
  • foreign key constraints should use the same column name as PK in the connected table
  • prefix with context id needed (source_warehouse_id and destination_warehouse_id)