sds.sql

oracle 数据库自动备份的窗口模式解压不会把原档案删除

'出院床位';

comment on column SDS.BY08CRYDJ.CYJBR is
'出院经办人';

comment on column SDS.BY08CRYDJ.RYJBSJ is
'入院经办时间';

comment on column SDS.BY08CRYDJ.CYJBSJ is
'出院经办时间';

comment on column SDS.BY08CRYDJ.BZ is
'备注';

comment on column SDS.BY08CRYDJ.SJZT is
'数据传输状态';

comment on column SDS.BY08CRYDJ.SWSXH is
'事务顺序号';

comment on column SDS.BY08CRYDJ.ZDYS is
'诊断医生';

comment on column SDS.BY08CRYDJ.ZFLB is
'支付类别';

comment on column SDS.BY08CRYDJ.ICNO is
'IC卡号';

/*==============================================================*/
/* Index: IDX_BY08CRYDJ_GRBM                                    */
/*==============================================================*/
create index IDX_BY08CRYDJ_GRBM on SDS.BY08CRYDJ (
   GRBM ASC
)
tablespace SDSIDX_TBS;

/*==============================================================*/
/* Index: IDX_BY08CRYDJ_YYBM                                    */
/*==============================================================*/
create index IDX_BY08CRYDJ_YYBM on SDS.BY08CRYDJ (
   YYBM ASC
)
tablespace SDSIDX_TBS;

/*==============================================================*/
/* Table: BY09ZXWZHZF                                           */
/*==============================================================*/
create table SDS.BY09ZXWZHZF  (
   SXH                  VARCHAR2(15)                    not null,
   GRBM                 VARCHAR2(15)                    not null,
   YYBM                 VARCHAR2(8)                     not null,
   FYBM                 VARCHAR2(3),
   ZFSJ                 DATE                            not null,
   ZFLB                 VARCHAR2(3)                     not null,
   JBR                  VARCHAR2(8),
   ZFYY                 VARCHAR2(30),
   ZFE                  NUMBER(14,2),
   BS                   VARCHAR2(5),
   SJZT                 VARCHAR2(3),
   YAB060               VARCHAR2(4)                     not null,
   SWSXH                VARCHAR2(20),
   constraint PK_BY09ZXWZHZF primary key (SXH, ZFSJ, ZFLB)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY09ZXWZHZF is
'by09中心外帐户支付记录';

comment on column SDS.BY09ZXWZHZF.SXH is
'顺序号';

comment on column SDS.BY09ZXWZHZF.GRBM is
'个人编码';

comment on column SDS.BY09ZXWZHZF.YYBM is
'医院编码';

comment on column SDS.BY09ZXWZHZF.FYBM is
'分医院编码';

comment on column SDS.BY09ZXWZHZF.ZFSJ is
'支付时间';

comment on column SDS.BY09ZXWZHZF.ZFLB is
'支付类别';

comment on column SDS.BY09ZXWZHZF.JBR is
'经办人';

comment on column SDS.BY09ZXWZHZF.ZFYY is
'支付原因';

comment on column SDS.BY09ZXWZHZF.ZFE is
'支付额';

comment on column SDS.BY09ZXWZHZF.BS is
'标识';

comment on column SDS.BY09ZXWZHZF.SJZT is
'数据传输状态';

comment on column SDS.BY09ZXWZHZF.YAB060 is
'分中心编号';

comment on column SDS.BY09ZXWZHZF.SWSXH is
'事务顺序号';

/*==============================================================*/
/* Index: IDX_BY09ZXWZHZF_GRBM                                  */
/*==============================================================*/
create index IDX_BY09ZXWZHZF_GRBM on SDS.BY09ZXWZHZF (
   GRBM ASC
)
tablespace SDSIDX_TBS;

/*==============================================================*/
/* Table: BY09ZYFYMX                                            */
/*==============================================================*/
create table SDS.BY09ZYFYMX  (
   SXH                  VARCHAR2(15)                    not null,
   SFSJ                 DATE                            not null,
   YAB060               VARCHAR2(4)                     not null,
   YYBM                 VARCHAR2(8),
   SFDLBM               VARCHAR2(3),
   SFXMBM               VARCHAR2(12),
   SL                   NUMBER(8,2),
   SJJG                 NUMBER(14,3),
   CD                   VARCHAR2(30),
   GG                   VARCHAR2(30),
   YFYL                 VARCHAR2(30),
   FYZE                 NUMBER(14,2),
   ZFBL                 NUMBER(6,4),
   TXBZ                 VARCHAR2(3),
   BPBZ                 VARCHAR2(3),
   QZFBF                NUMBER(14,2),
   GGZFBF               NUMBER(14,2),
   YXBXBF               NUMBER(14,2),
   FYSHBZ               VARCHAR2(3),
   SFY                  VARCHAR2(8),
   BZ                   VARCHAR2(56),
   TJDM                 VARCHAR2(12),
   KSMC                 VARCHAR2(48),
   SFXMMC               VARCHAR2(48),
   DW                   VARCHAR2(16),
   JSBH                 VARCHAR2(18),
   ZFLB                 VARCHAR2(3)                     not null,
   ZFDD                 VARCHAR2(3),
   XH                   VARCHAR2(18)                    not null,
   SJZT                 VARCHAR2(3),
   SWSXH                VARCHAR2(20),
   FZXSHBZ              VARCHAR2(3),
   FZXSHYY              VARCHAR2(56),
   SHJBR                VARCHAR2(20),
   MXLB                 VARCHAR2(3),
   KDBXJE               NUMBER(14,2),
   BHLJE                NUMBER(14,2),
   JLSJ                 DATE,
   SZSHSHBZ             VARCHAR(3),
   BHLJE_SH             NUMBER(14,2),
   SZSHRQ               DATE,
   SHSHRQ               DATE,
   constraint PK_BY09ZYFYMX primary key (SXH, SFSJ, ZFLB, XH)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY09ZYFYMX is
'BY09ZYFYMX费用明细住院';

comment on column SDS.BY09ZYFYMX.SXH is
'顺序号（就诊登记号）';

comment on column SDS.BY09ZYFYMX.SFSJ is
'收费时间';

comment on column SDS.BY09ZYFYMX.YAB060 is
'分中心编号';

comment on column SDS.BY09ZYFYMX.YYBM is
'医院编码';

comment on column SDS.BY09ZYFYMX.SFDLBM is
'大类编码';

comment on column SDS.BY09ZYFYMX.SFXMBM is
'项目编码';

comment on column SDS.BY09ZYFYMX.SL is
'数量';

comment on column SDS.BY09ZYFYMX.SJJG is
'实际价格';

comment on column SDS.BY09ZYFYMX.CD is
'产地';

comment on column SDS.BY09ZYFYMX.GG is
'规格';

comment on column SDS.BY09ZYFYMX.YFYL is
'用法用量';

comment on column SDS.BY09ZYFYMX.FYZE is
'费用总额';

comment on column SDS.BY09ZYFYMX.ZFBL is
'自费比例';

comment on column SDS.BY09ZYFYMX.TXBZ is
'特项标志';

comment on column SDS.BY09ZYFYMX.BPBZ is
'报批标志';

comment on column SDS.BY09ZYFYMX.QZFBF is
'全自费部分';

comment on column SDS.BY09ZYFYMX.GGZFBF is
'挂钩自费部分';

comment on column SDS.BY09ZYFYMX.YXBXBF is
'允许报销部分';

comment on column SDS.BY09ZYFYMX.FYSHBZ is
'费用审核标志';

comment on column SDS.BY09ZYFYMX.SFY is
'收费员';

comment on column SDS.BY09ZYFYMX.BZ is
'备注';

comment on column SDS.BY09ZYFYMX.TJDM is
'统计编码';

comment on column SDS.BY09ZYFYMX.KSMC is
'科室名称';

comment on column SDS.BY09ZYFYMX.SFXMMC is
'收费项目名称';

comment on column SDS.BY09ZYFYMX.DW is
'计量单位';

comment on column SDS.BY09ZYFYMX.JSBH is
'结算编号';

comment on column SDS.BY09ZYFYMX.ZFLB is
'支付类别';

comment on column SDS.BY09ZYFYMX.ZFDD is
'支付地点';

comment on column SDS.BY09ZYFYMX.XH is
'序号';

comment on column SDS.BY09ZYFYMX.SJZT is
'数据传输状态';

comment on column SDS.BY09ZYFYMX.SWSXH is
'事务顺序号';

comment on column SDS.BY09ZYFYMX.FZXSHBZ is
'分中心审核标志';

comment on column SDS.BY09ZYFYMX.FZXSHYY is
'分中心审核原因';

comment on column SDS.BY09ZYFYMX.SHJBR is
'审核经办人';

comment on column SDS.BY09ZYFYMX.MXLB is
'明细类别';

comment on column SDS.BY09ZYFYMX.KDBXJE is
'跨段报销金额';

comment on column SDS.BY09ZYFYMX.BHLJE is
'事中不合理金额';

comment on column SDS.BY09ZYFYMX.JLSJ is
'录入时间';

comment on column SDS.BY09ZYFYMX.SZSHSHBZ is
'事中事后审核标志';

comment on column SDS.BY09ZYFYMX.BHLJE_SH is
'事后不合理金额';

comment on column SDS.BY09ZYFYMX.SZSHRQ is
'事中审核日期';

comment on column SDS.BY09ZYFYMX.SHSHRQ is
'事后审核日期';

/*==============================================================*/
/* Index: IDX_BY09ZYFYMX_SFDLBM                                 */
/*==============================================================*/
create index IDX_BY09ZYFYMX_SFDLBM on SDS.BY09ZYFYMX (
   SFDLBM ASC
)
tablespace SDSIDX_TBS;

/*==============================================================*/
/* Index: IDX_BY09ZYFYMX_YYBM                                   */
/*==============================================================*/
create index IDX_BY09ZYFYMX_YYBM on SDS.BY09ZYFYMX (
   YYBM ASC
)
tablespace SDSIDX_TBS;

/*==============================================================*/
/* Table: BY10CYJSB                                             */
/*==============================================================*/
create table SDS.BY10CYJSB  (
   SXH                  VARCHAR2(15)                    not null,
   DWBM                 VARCHAR2(12),
   GRBM                 VARCHAR2(20)                    not null,
   XM                   VARCHAR2(8),
   XB                   VARCHAR2(3),
   CSRQ                 DATE,
   RYZT                 VARCHAR2(3),
   XNL                  NUMBER,
   YYBM                 VARCHAR2(8)                     not null,
   FYBM                 VARCHAR2(3)                     not null,
   JFNX                 NUMBER(8,2),
   ZYJS                 NUMBER(10,2),
   FYZE                 NUMBER(14,2),
   QZFBF                NUMBER(14,2),
   GGZFBF               NUMBER(14,2),
   YXBXBF               NUMBER(14,2),
   JRJSBF               NUMBER(14,2),
   TCZIFBF              NUMBER(14,2),
   TCZHIFBF             NUMBER(14,2),
   YDCZGGZF             NUMBER(14,2),
   SBJKC                NUMBER(14,2),
   ZFSM                 VARCHAR2(255),
   JBSJ                 DATE                            not null,
   CWSXH                VARCHAR2(15),
   BZ                   VARCHAR2(56),
   SFY                  VARCHAR2(8),
   JSBH                 VARCHAR2(8),
   ZFLB                 VARCHAR2(3)                     not null,
   ZFDD                 VARCHAR2(3),
   BZBM                 VARCHAR2(8),
   BZXE                 NUMBER(14,2),
   BCZFXE               NUMBER(14,2),
   SFTD                 VARCHAR2(3),
   SJZT                 VARCHAR2(3),
   CXZFBF               NUMBER(14,2),
   TCZFBL               NUMBER(8,4),
   DBZC                 NUMBER(14,2),
   SHBZ                 VARCHAR2(3),
   KKYY                 VARCHAR2(255),
   YAB060               VARCHAR2(4)                     not null,
   DBZIF2               NUMBER(14,2),
   SWSXH2               VARCHAR2(20),
   GWYTCZHF2            NUMBER(14,2),
   FZXSHBZ2             VARCHAR2(3),
   TSGGZFBF2            NUMBER(14,2),
   DWMC2                VARCHAR2(20),
   GWYCXBZ2             NUMBER(14,2),
   XJZF2                NUMBER(14,2),
   KZF2                 NUMBER(14,2),
   TGBZ2                NUMBER(14,2),
   FSSJ2                DATE,
   TXBZ2                NUMBER(14,2),
   RYSW2                VARCHAR2(3),
   SBJKC_SZ2            NUMBER(14,2),
   SBJKC_DB_SZ2         NUMBER(14,2),
   SBJKC_DB2            NUMBER(14,2),
   constraint PK_BY10CYJSB primary key (SXH, GRBM, YYBM, ZFLB)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY10CYJSB is
'BY10CYJSB费用结算表';

comment on column SDS.BY10CYJSB.SXH is
'顺序号（就诊登记号）';

comment on column SDS.BY10CYJSB.DWBM is
'单位编码';

comment on column SDS.BY10CYJSB.GRBM is
'个人编码';

comment on column SDS.BY10CYJSB.XM is
'姓名';

comment on column SDS.BY10CYJSB.XB is
'性别';

comment on column SDS.BY10CYJSB.CSRQ is
'出生日期';

comment on column SDS.BY10CYJSB.RYZT is
'人员状态';

comment on column SDS.BY10CYJSB.XNL is
'现年龄';

comment on column SDS.BY10CYJSB.YYBM is
'医院编码';

comment on column SDS.BY10CYJSB.FYBM is
'分医院编码';

comment on column SDS.BY10CYJSB.JFNX is
'经费年限';

comment on column SDS.BY10CYJSB.ZYJS is
'住院基数';

comment on column SDS.BY10CYJSB.FYZE is
'费用总额';

comment on column SDS.BY10CYJSB.QZFBF is
'全自费部分';

comment on column SDS.BY10CYJSB.GGZFBF is
'挂钩自费部分';

comment on column SDS.BY10CYJSB.YXBXBF is
'允许报销部分';

comment on column SDS.BY10CYJSB.JRJSBF is
'进入基数部分';

comment on column SDS.BY10CYJSB.TCZIFBF is
'统筹自付部分';

comment on column SDS.BY10CYJSB.TCZHIFBF is
'统筹支付部分';

comment on column SDS.BY10CYJSB.YDCZGGZF is
'异地超支挂钩自付部分';

comment on column SDS.BY10CYJSB.SBJKC is
'社保局扣除';

comment on column SDS.BY10CYJSB.ZFSM is
'支付说明';

comment on column SDS.BY10CYJSB.JBSJ is
'经办时间';

comment on column SDS.BY10CYJSB.CWSXH is
'财务顺序号';

comment on column SDS.BY10CYJSB.BZ is
'备注';

comment on column SDS.BY10CYJSB.SFY is
'收费员';

comment on column SDS.BY10CYJSB.JSBH is
'结算编号';

comment on column SDS.BY10CYJSB.ZFLB is
'支付类别';

comment on column SDS.BY10CYJSB.ZFDD is
'支付地点';

comment on column SDS.BY10CYJSB.BZBM is
'病种编码';

comment on column SDS.BY10CYJSB.BZXE is
'病种限额';

comment on column SDS.BY10CYJSB.BCZFXE is
'本次支付限额';

comment on column SDS.BY10CYJSB.SFTD is
'是否退单';

comment on column SDS.BY10CYJSB.SJZT is
'数据传输状态';

comment on column SDS.BY10CYJSB.CXZFBF is
'超限自付部分';

comment on column SDS.BY10CYJSB.TCZFBL is
'统筹支付比例';

comment on column SDS.BY10CYJSB.DBZC is
'大病支出';

comment on column SDS.BY10CYJSB.SHBZ is
'审核标志';

comment on column SDS.BY10CYJSB.KKYY is
'扣款原因';