SQL Review Guide
An online tool for DBA to generate the SQL review / DDL guideline.
Database Review Guide
Enforce the required columns in each table.
-
Required column names:
id created_ts updated_ts creator_id updater_id
MySQL and TiDB support checking whether the schema change is backward compatible.
Only tables named with specific patterns can be deleted. The requires users to do a rename before dropping the table. The table name must have "_del" suffix by default.
- Table name format (regex): _del$
Disallow leading '%' in LIKE, e.g. LIKE foo = '%x' is not allowed.
Enforce the table name format and length limit. Default snake_lower_case with 63 characters.
- Table name format (regex): ^[a-z]+(_[a-z]+)*$
- Length limit: 63
Enforce the column name format and length limit. Default snake_lower_case with 63 characters.
- Column name format (regex): ^[a-z]+(_[a-z]+)*$
- Length limit: 63
Enforce the unique key name format and length limit. Default uk_<table_name>_<column_list> or empty within 63 characters.
- Unique key name format: ^$|^uk_{{table}}_{{column_list}}$
- Length limit: 63
Enforce the primary key name format and length limit. Default pk_<table_name>_<column_list> or empty within 63 characters.
- Primary key name format: ^$|^pk_{{table}}_{{column_list}}$
- Length limit: 63
Enforce the index name format and length limit. Default idx_<table_name>_<column_list> or empty within 63 characters.
- Index name format: ^$|^idx_{{table}}_{{column_list}}$
- Length limit: 63
Enforce the foreign key name format and length limit. Default fk_<referencing_table>_<referencing_column>_<referenced_table>_<referenced_column> or empty within 63 characters.
- Foreign key name format: ^$|^fk_{{referencing_table}}_{{referencing_column}}_{{referenced_table}}_{{referenced_column}}$
- Length limit: 63
at 2022-10-06