The team develops database object naming cases for multiple business systems and database Cases

The team develops database object naming cases for multiple business systems and database Cases

Database NamePascal rules, project + business name + DB, such

Table NameThe Pascal rule is named "Database Name abbreviation (Meal) _ business function" to avoid abbreviations.

FieldThe Pascal rule is named after "pure business attributes" and abbreviated as follows:

ViewNamed after "vw_table name", as shown in figure

Stored Procedure Named after "sp _ TABLE name_operation function"

The trigger is named "tr _ operation function ".

The primary key is named "pk _ TABLE name_column name ".

The foreign key is named "fk _ slave table name_table name_master table name ".

The constraint is named after "ck _ TABLE name_column name ".

The index name is "idx _ TABLE name_column name ".