住院_住院登记表

CREATE TABLE [dbo].[住院_住院登记表](
[住院状态] [char](1) NOT NULL,
[门诊号] [varchar](10) NULL,
[病案号] [varchar](9) NULL,
[住院号] [varchar](9) NOT NULL,
[住院次数] [tinyint] NOT NULL,
[姓名] [varchar](30) NOT NULL,
[性别] [char](1) NOT NULL,
[出生日期] [dbo].[FGDate] NOT NULL,
[记帐代码] [char](2) NOT NULL,
[病人标识] [dbo].[FGManID] NOT NULL,
[所属病区] [dbo].[FGGroup] NULL,
[所属科室] [dbo].[FGGroup] NULL,
[房间号码] [char](4) NULL,
[床位号] [dbo].[FGCWH] NULL,
[床位等级] [dbo].[FGFee] NULL,
[护理等级] [dbo].[FGFee] NULL,
[饮食类型] [dbo].[FGFee] NULL,
[陪客标识] [char](1) NULL,
[病情状态] [char](1) NULL,
[入院日期] [dbo].[FGDate] NULL,
[入院时间] [dbo].[FGTime] NULL,
[入院途径] [char](1) NULL,
[转出医院] [varchar](30) NULL,
[转诊单号] [varchar](10) NULL,
[入院病情] [char](1) NULL,
[结帐标志] [char](1) NOT NULL,
[门诊医师] [varchar](5) NULL,
[床位医师] [varchar](5) NULL,
[主治医师] [varchar](5) NULL,
[责任医师] [varchar](5) NULL,
[责任护士] [varchar](5) NULL,
[药物反应] [varchar](11) NULL,
[出院日期] [dbo].[FGDate] NULL,
[出院时间] [dbo].[FGTime] NULL,
[出院方式] [char](10) NULL,
[出院诊断] [varchar](15) NULL,
[出院情况] [char](1) NULL,
[起付金额] [money] NULL,
[累计定额] [money] NULL,
[累计记帐] [money] NULL,
[产婴人数] [tinyint] NULL,
[产婴标志] [char](1) NOT NULL,
[住院标识] [varchar](20) NULL,
[登记工号] [varchar](5) NULL,
[登记日期] [dbo].[FGDate] NOT NULL,
[登记时间] [dbo].[FGTime] NOT NULL,
[担保信息] [varchar](128) NULL,
[出生时间] [numeric](4, 2) NULL,
[审核工号] [varchar](5) NULL,
[审核日期] [varchar](8) NULL,
[入院体重] [varchar](50) NULL,
[病种代码] [varchar](20) NULL,
[入院诊断] [varchar](30) NULL,
[sl_bz] [varchar](1) NULL,
[治疗状态] [char](1) NULL,
 CONSTRAINT [PK_住院_住院登记表] PRIMARY KEY CLUSTERED 
(
[住院号] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


GO