Building Applications with Spring 5 and Vue.js 2

The naming convention

The naming convention of the physical data model has some differences with the naming convention of the logical data model:

• We will use lowercase for tables, columns, and indexes, for example, the user table. And we will use underscore to connect multiple words, for example, the card_list table.
• For foreign key definition, the key's name starts with fk_. The naming convention of the foreign keys is fk_<referencing table name>_<referenced table name>_<referencing field name>. For example, the foreign key of the user_id field in the activity table is fk_activity_user_user_id.
• For index definition, the index name will end with _idx, or _uidx if it is a unique index.

The reason we use lowercase is that MySQL is case-sensitive ...