xk.sql

软件功能：主要包括以下功能：血液入库、受血者基本信息、产生费用、输血返馈、申请血液、交叉配血、取血、退血、血液报废、以及各种信息查询等

if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_pxff]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_pxff]

GO



if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_rkd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_rkd]

GO



if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_sys]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_sys]

GO



if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_xylx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_xylx]

GO



if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_ybsfxx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_ybsfxx]

GO



if exists (select * from sysobjects where id = object_id(N'[dbo].[xk_ybxx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[xk_ybxx]

GO


CREATE TABLE [dbo].[xk_pxff] (

	[dh] [varchar] (10) NOT NULL ,

	[mc] [varchar] (40) NULL ,

	[sfdm] [varchar] (10) NULL ,

	[dj] [money] NULL ,

	[zdym] [varchar] (10) NULL ,

	[pym] [varchar] (10) NULL ,

	[wbm] [varchar] (10) NULL ,

	[lx] [char] (10) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[xk_rkd] (

	[xylx] [varchar] (10) NOT NULL ,

	[xdh] [varchar] (20) NOT NULL ,

	[rkrq] [datetime] NULL ,

	[xxy] [varchar] (10) NULL ,

	[abo] [char] (2) NULL ,

	[rh] [char] (2) NULL ,

	[xl] [numeric](18, 2) NULL ,

	[dj] [money] NULL ,

	[baozhuang] [varchar] (10) NULL ,

	[sfxj] [smallint] NULL ,

	[zbfs] [varchar] (10) NULL ,

	[zbrq] [datetime] NULL ,

	[dqrq] [datetime] NULL ,

	[rky] [varchar] (10) NULL ,

	[cky] [varchar] (10) NULL ,

	[ckbj] [char] (1) NULL ,

	[ckrq] [datetime] NULL ,

	[ybbh] [int] NULL ,

	[txrq] [datetime] NULL ,

	[txy] [varchar] (10) NULL ,

	[qcbxb] [char] (1) NULL ,

	[qcr] [varchar] (10) NULL ,

	[qcf] [money] NULL ,

	[bfrq] [datetime] NULL ,

	[bfr] [varchar] (10) NULL ,

	[bfyy] [varchar] (100) NULL ,

	[sfzt] [char] (1) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[xk_sys] (

	[id] [char] (10) NOT NULL ,

	[mc] [varchar] (50) NULL ,

	[dm] [varchar] (10) NULL ,

	[dj] [money] NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[xk_xylx] (

	[dh] [char] (10) NOT NULL ,

	[mc] [varchar] (40) NULL ,

	[baozhuang] [varchar] (20) NULL ,

	[xueliang] [numeric](18, 2) NULL ,

	[quexueliang] [numeric](18, 2) NULL ,

	[guishu] [varchar] (20) NULL ,

	[xuezhandh] [varchar] (20) NULL ,

	[cbj] [money] NULL ,

	[dj] [money] NULL ,

	[qcf] [money] NULL ,

	[bzq] [smallint] NULL ,

	[sfxj] [smallint] NULL ,

	[zdym] [varchar] (10) NULL ,

	[pym] [varchar] (10) NULL ,

	[wbm] [varchar] (10) NULL ,

	[sfdm] [varchar] (10) NULL 

) ON [PRIMARY]

GO



CREATE TABLE [dbo].[xk_ybsfxx] (

	[cdrq] [datetime] NOT NULL ,

	[ybbh] [int] NOT NULL ,

	[jymddh] [varchar] (10) NOT NULL ,

	[jymdmc] [varchar] (100) NULL ,

	[jymdsf] [money] NULL ,

	[sfzt] [varchar] (1) NULL ,

	[brlb] [varchar] (10) NULL 

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[xk_yymc] (

	[yymc] [varchar] (50) NOT NULL 

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[xk_brkb] (

	[dh] [varchar] (10) NOT NULL ,

	[mc] [varchar] (40) NULL ,

	[bh] [varchar] (10) NULL 

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[xk_ysb] (

	[dh] [varchar] (10) NOT NULL ,

	[mc] [varchar] (40) NULL ,

	[bh] [varchar] (10) NULL 

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[xk_brlb] (

	[dh] [varchar] (10) NOT NULL ,

	[mc] [varchar] (40) NULL ,

	[zdym] [varchar] (10) NULL ,

	[pym] [varchar] (10) NULL ,

	[wbm] [varchar] (10) NULL ,

	[lx] [varchar] (10) NULL ,

	[lbmc] [varchar] (16) NULL ,

	[bh] [varchar] (10) NULL 

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[xk_user] (

	[logid] [varchar] (10) NOT NULL ,

	[username] [varchar] (20) NULL ,

	[password] [varchar] (10) NULL ,

	[logwhere] [varchar] (10) NULL ,

	[power] [varchar] (10) NULL ,

	[status] [varchar] (1) NULL ,

	[userid] [varchar] (10) NULL 

) ON [PRIMARY]

GO




CREATE TABLE [dbo].[xk_ybxx] (

	[cdrq] [datetime] NOT NULL ,

	[ybbh] [int] NOT NULL ,

	[ybid] [varchar] (12) NULL ,

	[brlb] [varchar] (10) NULL ,

	[byh] [varchar] (30) NULL ,

	[brxm] [varchar] (20) NULL ,

	[brxb] [char] (1) NULL ,

	[brnl] [varchar] (10) NULL ,

	[brkb] [varchar] (10) NULL ,

	[brch] [varchar] (10) NULL ,

	[sjys] [varchar] (10) NULL ,

	[pxy1] [varchar] (10) NULL ,

	[pxy2] [varchar] (10) NULL ,

	[abo] [char] (2) NULL ,

	[rh] [char] (2) NULL ,

	[leixing] [varchar] (10) NULL ,

	[pxcs] [smallint] NULL ,

	[pxff] [varchar] (10) NULL ,

	[ktsx] [varchar] (10) NULL ,

	[ybsf] [money] NULL ,

	[jymdmc] [varchar] (100) NULL ,

	[jyys] [varchar] (10) NULL ,

	[ybzt] [char] (1) NULL ,

	[sfzt] [char] (1) NULL ,

	[lastmodify] [datetime] NULL ,

	[lczd] [varchar] (40) NULL ,

	[beizhu] [varchar] (100) NULL 

) ON [PRIMARY]

GO


ALTER TABLE [dbo].[xk_pxff] WITH NOCHECK ADD 

	CONSTRAINT [pk_xk_pxff] PRIMARY KEY  NONCLUSTERED 

	(

		[dh]

	)  ON [PRIMARY] 

GO



ALTER TABLE [dbo].[xk_rkd] WITH NOCHECK ADD 

	CONSTRAINT [pk_xk_rkd] PRIMARY KEY  NONCLUSTERED 

	(

		[xylx],

		[xdh]

	)  ON [PRIMARY] 

GO


ALTER TABLE [dbo].[xk_brkb] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_brkb] PRIMARY KEY  NONCLUSTERED 

	(

		[dh]

	)  ON [PRIMARY] 

GO


ALTER TABLE [dbo].[xk_brlb] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_brlb] PRIMARY KEY  NONCLUSTERED 

	(

		[dh]

	)  ON [PRIMARY] 

GO


ALTER TABLE [dbo].[xk_yymc] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_yymc] PRIMARY KEY  NONCLUSTERED 

	(

		[yymc]

	)  ON [PRIMARY] 

GO



ALTER TABLE [dbo].[xk_sys] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_sys] PRIMARY KEY  NONCLUSTERED 

	(

		[id]

	)  ON [PRIMARY] 

GO


ALTER TABLE [dbo].[xk_ysb] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_ysb] PRIMARY KEY  NONCLUSTERED 

	(

		[dh]

	)  ON [PRIMARY] 

GO



ALTER TABLE [dbo].[xk_xylx] WITH NOCHECK ADD 

	CONSTRAINT [pk_xk_xylx] PRIMARY KEY  NONCLUSTERED 

	(

		[dh]

	)  ON [PRIMARY] 

GO



ALTER TABLE [dbo].[xk_ybsfxx] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_ybsfxx] PRIMARY KEY  NONCLUSTERED 

	(

		[cdrq],

		[ybbh],

		[jymddh]

	)  ON [PRIMARY] 

GO



ALTER TABLE [dbo].[xk_ybxx] WITH NOCHECK ADD 

	CONSTRAINT [PK_xk_ybxx] PRIMARY KEY  NONCLUSTERED 

	(

		[cdrq],

		[ybbh]

	)  ON [PRIMARY] 

GO



CREATE  INDEX [i_xk_rkd_rkrq] ON [dbo].[xk_rkd]([rkrq]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybsfxx_cdrq] ON [dbo].[xk_ybsfxx]([cdrq]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybsfxx_ybbh] ON [dbo].[xk_ybsfxx]([ybbh]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybsfxx_jymdmc] ON [dbo].[xk_ybsfxx]([jymdmc]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybxx_cdrq] ON [dbo].[xk_ybxx]([cdrq]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybxx_ybbh] ON [dbo].[xk_ybxx]([ybbh]) ON [PRIMARY]

GO



 CREATE  INDEX [i_xk_ybxx_byh] ON [dbo].[xk_ybxx]([byh]) ON [PRIMARY]

GO


 CREATE  INDEX [i_xk_brkb_dh] ON [dbo].[xk_brkb]([dh]) ON [PRIMARY]

GO



CREATE  INDEX [i_xk_brlb_dh] ON [dbo].[xk_brlb]([dh]) ON [PRIMARY]

GO



CREATE  INDEX [i_xk_yymc_yymc] ON [dbo].[xk_yymc]([yymc]) ON [PRIMARY]

GO



CREATE  INDEX [i_xk_ysb_dh] ON [dbo].[xk_ysb]([dh]) ON [PRIMARY]

GO