unitpaylist.sql

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

create table unitpaylist(
unitcode char(6) not null,
feedate smalldatetime not null,			//为哪个月份/年度的费用
personcode char(12) not null,
iccard char(10) null,					//卡号
name char(16) not null,						//姓名
wage numeric(8,2) not null,     			//该次缴纳的个人工资
persontype char(24) not null,				//个人类型
age tinyint not null,
personpay numeric(8,2) not null,
unitpay numeric(8,2) not null,
otherpay numeric(8,2) not null,
persondis numeric(8,2) not null,
unitdis numeric(8,2) not null,
otherdis numeric(8,2) not null,
accrual numeric(8,2) not null,
lastleave numeric(8,2) not null,
lastcheck numeric(8,2) not null,
thisadd numeric(8,2) not null,
thisleave numeric(8,2) not null,
sumclinic numeric(8,2) not null,
suminhos numeric(8,2) not null,
sumsick numeric(8,2) not null,
constraint p_upaylist primary key clustered (unitcode,feedate,personcode) on 'default');