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
CarNotesNotescars_notescars_note
Do you like it?
We can only get better if you give us constructive suggestions for improvement. Just voting "No" without giving reasons or suggestions is not helpful and cannot lead to changes.
If you have been searching for a completely different solution than the subject says, this article can not be and will not be helpful for you. In these cases you should consider not to vote.
This is website feedback, only. This voting is not a support form nor ticket system.