Database Design
The design of database objects is an important aspect of the database architecture and development process. It involves creating and managing the structures necessary for storing, organizing, and retrieving data, and it describes the static information of the database. Database object design is the foundation for ensuring the efficient, secure, and reliable operation of a database system. It impacts various aspects such as data integrity, consistency, accuracy, maintainability, and performance. A well-designed and optimized database object structure is crucial for any organization that relies on data storage and retrieval.
The auditing rules for database design include following categories:
📄️ 1. Naming Conventions
Adopting unified naming conventions for database objects is of great significance, as it brings a series of advantages and conveniences to database development, maintenance, management, and optimization:
📄️ 2. Table Definition
Must Use INNODB Storage Engine
📄️ 3. Column Definition
Auto-increment columns must not use signed integers
📄️ 4. Indexes
Duplicate columns should not be included in an index
📄️ 5. Constraints
Number of columns in primary key must not exceed the threshold
📄️ 6. Character Set / Collation
Disallow Character Set Specification on Table Definition
📄️ 7. Comments
RuleCode: CommentsOnTableRequired