Theory and practice of database design < three > physical design

I. Physical design core tasks and key details

Second, the physical design experience

1. Data type design: Suggested field data type definitions are combined with the following points (for example, MySQL)

1) does not use image, and uses varbinary, etc.

2) do not use text and ntext, and use varchar or nvarchar

3) do not use money and small, and use decimal

4) Use bit instead of char (1) to denote male/female, or Yes/no Boolean values

5) Self-increment primary key Select int or bigint,guid using unique identifier instead of varchar (N) according to expected range

"References"

1. Wu Yaihua. Database application System development process, technology and case study. Renmin University Press

Theory and practice of database design < three > physical design