department.sql

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

create table department
(hoscode char(4) not null,
code	char(2) not null,
name char(20) not null,
pycode char(5) null,
wbcode char(5) null,
effectflag tinyint not null,
updateflag tinyint not null,
constraint p_dep primary key nonclustered (hoscode,code) on 'default');