Database and Fields Naming Regulations

The regulations are base on this document and slightly modified because I do not really enjoy the process of engineering a project, which means I do not have to take the rules too seriously.

Database naming regulations

• Usable characters: English letters ( case sensitive ), numbers ( 0 – 9 ) and underline ( ‘_’ ).

• Keep the name simple and explicit.

• Divide the words by underline ( ‘_’ )

• Always use the words in lower case.

• No keywords of database like name, time, datatime, password.

• Do not use the plural words. For example, use employee rather than employees.

• charset: utf8mb4; sort by: utf8mb4_general_ci

Fields naming regulations

• Usable characters: English letters ( case sensitive ), numbers ( 0 – 9 ) and underline ( ‘_’ ).

• Keep the name simple and explicit. Usually less than 3 words.

• Divide the words by underline ( ‘_’ )

• Always use the words in lower case.

• Do not repeat the name of the table. For example, do not name a filed "employee_lastname" in a table named "employee".

• Avoid the abbreviation.