sql2k_database.sql

江苏某小型医院使用的IC卡管理系统

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

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

CREATE TABLE [dbo].[ic_dw] (
	[dwbh] [char] (10) NOT NULL ,
	[dwmc] [char] (50) NULL ,
	[dwdz] [char] (100) NULL ,
	[dwdh] [char] (50) NULL ,
	[dwfz] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ic_ry] (
	[rybh] [char] (10) NOT NULL ,
	[rymc] [char] (10) NULL ,
	[rysf] [char] (10) NULL ,
	[sfzh] [char] (20) NULL ,
	[csrq] [datetime] NULL ,
	[xb] [char] (1) NULL ,
	[dwbh] [char] (10) NULL ,
	[gzsj] [datetime] NULL ,
	[ryzc] [char] (1) NULL ,
	[sngz] [numeric](14, 2) NULL ,
	[snjz] [numeric](14, 2) NULL ,
	[mqye] [numeric](14, 2) NULL ,
	[bsrq] [datetime] NULL ,
	[bsbz] [char] (100) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ic_dw] WITH NOCHECK ADD 
	CONSTRAINT [PK_ic_dw] PRIMARY KEY  NONCLUSTERED 
	(
		[dwbh]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ic_ry] WITH NOCHECK ADD 
	CONSTRAINT [PK_ic_ry] PRIMARY KEY  NONCLUSTERED 
	(
		[rybh]
	)  ON [PRIMARY] 
GO