Detail tables (Master-Detail)

If records of a detail-table always (!) belong to exactly one record of a master-table (1:n relation), you can already show the relation between master-table and details-table in the name of the detail-table so that every developer who can see the tablename already knows the relation to the master table.

use singular of master-table, then underscore _, then plural of details-table.

master_details

Examples:

  • car_notes
  • CarNotes
  • Notes
  • cars_notes
  • cars_note