The easiest way to help other people understand a database is to ensure that all the objects have a meaningful name.
What makes a name meaningful?
Take some time to reflect on your database to make sure you have a clear view of its purpose and main use cases. This is because all the items in this recipe describe certain naming choices that you need to consider carefully in view of your specific circumstances.
Here are the points you should consider when naming your database objects:
- The name follows the existing standards and practices in place. Inventing new standards isn't helpful; enforcing existing standards is.
- The name clearly describes the role or table contents.
- For major tables, use short, powerful names.
- Name lookup tables after the table to which they are linked, such as
account_status. - For associative or linked tables, use all the names of the major tables to which they relate, such as
customer_account. - Make sure that...