dislist.sql

十分好的一个医院管理系统

create table dislist(
unitcode char(6) not null,
personcode char(12) not null,
name char(16) not null,
audityear smalldatetime not null,
bookindate smalldatetime not null,
thisadd numeric(8,2) not null,
m1 numeric(8,2) not null,
disdate1 smalldatetime not null,
m2 numeric(8,2) not null,
disdate2 smalldatetime not null,
m3 numeric(8,2) not null,
disdate3 smalldatetime not null,
m4 numeric(8,2) not null,
disdate4 smalldatetime not null,
m5 numeric(8,2) not null,
disdate5 smalldatetime not null,
m6 numeric(8,2) not null,
disdate6 smalldatetime not null,
m7 numeric(8,2) not null,
disdate7 smalldatetime not null,
m8 numeric(8,2) not null,
disdate8 smalldatetime not null,
m9 numeric(8,2) not null,
disdate9 smalldatetime not null,
m10 numeric(8,2) not null,
disdate10 smalldatetime not null,
m11 numeric(8,2) not null,
disdate11 smalldatetime not null,
m12 numeric(8,2) not null,
disdate12 smalldatetime not null,
pageno tinyint null,
seqno int null,
constraint p_dislist primary key nonclustered (personcode,audityear) on 'default');