Database Review Guide
Database
Deletion is only allowed when there are no tables in the database, which can greatly avoid accidental deletion. Suggested error level: Error
System
The character set determines which characters can be stored in the table. Using the wrong character set may result in certain characters in the application being unable to be stored and displayed correctly, such as CJK and Emoji. Suggested error level: Error
Allow list: utf8mb4The collation determines the rules for character comparison and sorting. For example, when using a case-insensitive collation, "ABC" and "abc" will be treated as the same string in queries. Suggested error level: Error
Allow list: utf8mb4_0900_ai_ci- Maximum comment length: 64
Column
Some common columns are helpful for better application maintenance. For example, adding a business-independent "ID" column as the primary key avoids primary key conflicts caused by business changes (such as business mergers), and in some scenarios can also bring better data insertion performance. Suggested error level: Warning
Required column names: id, created_ts, updated_ts, creator_id, updater_idSome common columns are helpful for better application maintenance. For example, adding a business-independent "ID" column as the primary key avoids primary key conflicts caused by business changes (such as business mergers), and in some scenarios can also bring better data insertion performance. Suggested error level: Warning
Required column names: ID