invoice.sql

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

create table invoice(
flowcode char(12) not null,				//流水号
orders smallint not null,					//顺序号
unitcode char(6) not null,			//单位编号
feedate smalldatetime not null,	//缴费期限
unitpaydate smalldatetime not null,	//交费日期
paymonth tinyint not null,			//缴纳月数
paymode tinyint not null,			//交费方式：1-现金；2-支票；3-转帐
sumfee numeric(10,2) not null,
latedate smallint not null,		//滞纳天数
latefee numeric(8,2) not null,
z_employs smallint not null,
z_sumwage numeric(10,2) not null,
t_employs smallint not null,
t_sumwage numeric(10,2) not null,
l_employs smallint not null,
l_sumwage numeric(10,2) not null,
upay_percent numeric(8,2) not null,
ppay_percent numeric(8,2) not null,
zdis_percent numeric(8,2) not null,
tdis_percent numeric(8,2) not null,
upay_ys numeric(10,2) not null,
fpay_ys numeric(10,2) not null,
ppay_ys numeric(10,2) not null,
upay numeric(10,2) not null,
fpay numeric(10,2) not null,
ppay numeric(10,2) not null,
zdis numeric(10,2) not null,
tdis numeric(10,2) not null,
addpay numeric(10,2) not null,		//补交缴纳
outdis numeric(10,2) not null,  //退款
sypay_percent numeric(8,2) not null,
sypay_ys numeric(10,2) not null,
sypay numeric(10,2) not null,
gspay_percent numeric(8,2) not null,
gspay_ys numeric(10,2) not null,
gspay numeric(10,2) not null,
notes varchar(255) null,
operator char(10) null,				//操作员名字
stateflag tinyint not null,		//状态标志。1-已支付；0-未支付
cwzg char(10) null,
skr char(10) null,
constraint p_invoice primary key nonclustered (flowcode,orders) on 'default');