DB Design in project development

DB Design in project development

0. Analyze the origin of data and the relationship between data based on prototype (entity relationship);

1. Extract the field, through the PowerDesigner design table;

2. First, the first one-way correlation on the data is established, and the two-way association or intermediate table is established when necessary;
3. You can also establish a foreign key relationship, and finally delete the foreign key relationship; (easy to view the relationship of the table);
4. Fields that are typically supplemented for entity objects:
ID PRIMARY Key
Entity related entities/own
isdelete varchar (1) Null #是否删除
createempid varchar (+) Null #创建人ID
createdate DATETIME Null #创建时间
lastempid varchar (+) Null #修改人
lastdate DATETIME Null #修改时间
Special fields:
Status:
Seniority:
      ...

5. Conform to the three paradigms

DB Design in project development