Choosing good names for database objects
The easiest way to help other people understand a database is to make sure that all the objects have a meaningful name.
What makes a meaningful name?
- The name follows the existing standards and practices in place. Inventing new standards isn't helpful; enforcing existing ones is.
- The name clearly describes the role or table contents.
- For major tables use short, powerful names.
- For lookup tables, name them after the table to which they are linked, such as account_status.
- For associative or linked tables, use all of the names of the major tables to which they relate, such as customer_account.
- Make sure that the name is clearly distinct from other similar names.
- Use consistent abbreviations.
- Use underscores. ...