Database Table design summary

This is a classic summary of a cool man in my msngroup. Let's take a look at it first.

Database Table Design:

1. First, plan the basic structure of the table based on the relevant business requirements (mainly referring to the output input conditions ).
2. Design status fields according to business rules
3. Set other fields according to the general rules of the company or department (such as the recorder, creation time, modification time, and deletion mark ).
4. Estimate the data volume of related tables for Capacity Planning
5. Determine the primary key and unique index, and determine the partition based on the capacity planning results if necessary.
6. design data tables according to the third paradigm
7. Collect developers' query, deletion, and update habits and statements
8. Modify the data structure based on the analysis of related processing statements.
9. Index and foreign key settings based on analysis of related processing statements