Database design database, data table and field naming summary

Database naming rules:

Named according to the actual meaning of the project.

Data table naming rules:

1. The names of the data tables are mostly in the plural form of nouns and are lowercase;

2. Use the prefix "Table_" as far as possible;

3. If the table name of the data table is made up of multiple words, try to connect it with an underscore, but do not exceed 30 characters, and if more than 30 characters are used, shorten the name of the table by using an abbreviation;

Field naming rules:

1. First name the field as far as possible lowercase, and the use of meaningful words;

2. Use the prefix, the prefix as far as possible with the table "the first four letters + underscore composition";

3. If the field name consists of multiple words, use an underscore to connect and, once more than 30 characters, shorten the length of the field name with an abbreviation;

View naming rules:

1. Use the prefix "View_" as far as possible;

2. If you create a view that involves more than one data table, you must list all the table names and, if they are longer than 30 characters, simplify the table names and connect them with underscores;

Primary key naming rules:

1. The primary key begins with "Pk_", followed by the name of the table where the primary key is located;

2. No more than 30 characters, try to use lowercase English words;

Database design database, data table and field naming summary