创建表

Create table HumanAffire
(
ID int IDENTITY(1,1)
,Persinal nvarchar(10) primary key
,HumanName nvarchar(20) Not Null
,Shop int 
,Position nvarchar(10) 
,Sex nvarchar(2) check(Sex='男' or Sex='女')
,Age int check(Age>0 and Age<180)
,WorkingAge int check(WorkingAge>=0 and WorkingAge<80)
,TimeOfEnterCompany date
,Salary decimal check(Salary>0)
,MD5 nvarchar(32) Not Null
)