sds.sql

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

/*==============================================================*/
/* DBMS name:      ORACLE Version 9i2                           */
/* Created on:     2005-8-25 11:04:41                           */
/*==============================================================*/


drop index IDX_BY07RYSPDA_GRBM;

drop index IDX_BY07RYSPDA_YYBM;

drop index IDX_BY08CRYDJ_GRBM;

drop index IDX_BY08CRYDJ_YYBM;

drop index IDX_BY09ZXWZHZF_GRBM;

drop index IDX_BY09ZYFYMX_SFDLBM;

drop index IDX_BY09ZYFYMX_YYBM;

drop index SDS.IDX_BY10CYJSB_GRBM;

drop index SDS.IDX_BY10CYJSB_YYBM;

drop table SDS.BG09YJJZFMX cascade constraints;

drop table SDS.BG10ZKSDJ cascade constraints;

drop table SDS.BG20RYDYBGB cascade constraints;

drop table SDS.BY07RYSPDA cascade constraints;

drop table SDS.BY08CRYDJ cascade constraints;

drop table SDS.BY09ZXWZHZF cascade constraints;

drop table SDS.BY09ZYFYMX cascade constraints;

drop table SDS.BY10CYJSB cascade constraints;

drop table SDS.BY10FDJSMXB cascade constraints;

drop table SDS.BY10YJSMXB cascade constraints;

drop table SDS.FUNCTION cascade constraints;

drop table SDS.LPJSB cascade constraints;

drop table SDS.ROLE cascade constraints;

drop table SDS.ROLE_FUNCTION_MAP cascade constraints;

drop table SDS.ROLE_PARA cascade constraints;

drop table SDS.UNIT_INFO cascade constraints;

drop table SDS.USER_INFO cascade constraints;

/*==============================================================*/
/* Table: BG09YJJZFMX                                           */
/*==============================================================*/
create table SDS.BG09YJJZFMX  (
   SXH                  VARCHAR2(15)                    not null,
   ZFSJ                 DATE                            not null,
   SBJ                  VARCHAR2(12)                    not null,
   PCNO                 VARCHAR2(8)                     not null,
   GRBM                 VARCHAR2(20)                    not null,
   DWBM                 VARCHAR2(12),
   YYBM                 VARCHAR2(8)                     not null,
   RYSJ                 DATE,
   ZYZT                 VARCHAR2(3),
   BLH                  VARCHAR2(12),
   ZYH                  VARCHAR2(12),
   ZFJE                 NUMBER(10,2),
   JBR                  VARCHAR2(8),
   SFY                  VARCHAR2(8),
   SKJE                 NUMBER(10,2),
   SZYY                 VARCHAR2(30),
   BZ                   VARCHAR2(30),
   SZFS                 VARCHAR2(3),
   SJZT                 VARCHAR2(3),
   TSSJ                 DATE,
   FSZT                 VARCHAR2(3),
   SJH                  VARCHAR2(18),
   JYSXH                VARCHAR2(15),
   constraint PK_BG09YJJZFMX primary key (SXH, ZFSJ, PCNO, GRBM, YYBM)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BG09YJJZFMX is
'预缴金收支明细';

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

comment on column SDS.BG09YJJZFMX.ZFSJ is
'收支时间';

comment on column SDS.BG09YJJZFMX.SBJ is
'社保局';

comment on column SDS.BG09YJJZFMX.PCNO is
'客户机编码';

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

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

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

comment on column SDS.BG09YJJZFMX.RYSJ is
'入院时间';

comment on column SDS.BG09YJJZFMX.ZYZT is
'住院状态';

comment on column SDS.BG09YJJZFMX.BLH is
'病例号';

comment on column SDS.BG09YJJZFMX.ZYH is
'住院号';

comment on column SDS.BG09YJJZFMX.ZFJE is
'支出金额';

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

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

comment on column SDS.BG09YJJZFMX.SKJE is
'收款金额';

comment on column SDS.BG09YJJZFMX.SZYY is
'收支原因';

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

comment on column SDS.BG09YJJZFMX.SZFS is
'收支方式（现金或帐户划拨）';

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

comment on column SDS.BG09YJJZFMX.TSSJ is
'传输时间';

comment on column SDS.BG09YJJZFMX.FSZT is
'封锁状态';

comment on column SDS.BG09YJJZFMX.SJH is
'收据号';

comment on column SDS.BG09YJJZFMX.JYSXH is
'交易顺序号';

/*==============================================================*/
/* Table: BG10ZKSDJ                                             */
/*==============================================================*/
create table SDS.BG10ZKSDJ  (
   GRBM                 VARCHAR2(20)                    not null,
   ZRSJ                 DATE                            not null,
   SXH                  VARCHAR2(19)                    not null,
   DWBM                 VARCHAR2(12),
   SBJ                  VARCHAR2(24),
   YYBM                 VARCHAR2(8),
   RYSJ                 DATE,
   ZYZT                 VARCHAR2(3),
   BLH                  VARCHAR2(12),
   ZYH                  VARCHAR2(12),
   DQKS                 VARCHAR2(50),
   DQCWH                VARCHAR2(12),
   ZRKS                 VARCHAR2(50),
   ZRCWH                VARCHAR2(12),
   BZ                   VARCHAR2(56),
   JBR                  VARCHAR2(20),
   JYSXH                VARCHAR2(19),
   constraint PK_BG10ZKSDJ primary key (SXH, GRBM, ZRSJ)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

/*==============================================================*/
/* Table: BG20RYDYBGB                                           */
/*==============================================================*/
create table SDS.BG20RYDYBGB  (
   GRBM                 VARCHAR2(20)                    not null,
   BGSJ                 DATE                            not null,
   BGLB                 VARCHAR2(3),
   JBR                  VARCHAR2(20),
   BZ                   VARCHAR2(100),
   XH                   NUMBER(5),
   constraint PK_BG20RYDYBGB primary key (GRBM, BGSJ)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

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

comment on column SDS.BG20RYDYBGB.BGSJ is
'变更时间';

comment on column SDS.BG20RYDYBGB.BGLB is
'变更类别';

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

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

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

/*==============================================================*/
/* Table: BY07RYSPDA                                            */
/*==============================================================*/
create table SDS.BY07RYSPDA  (
   SXH                  VARCHAR2(15)                    not null,
   YAB060               VARCHAR2(4)                     not null,
   GRBM                 VARCHAR2(20)                    not null,
   RYZT                 VARCHAR2(3)                     not null,
   YYBM                 VARCHAR2(8),
   SPBZ                 VARCHAR2(3)                     not null,
   ZYZT                 VARCHAR2(3),
   SPDW                 VARCHAR2(56),
   SPRQ                 DATE,
   SFTZB                VARCHAR2(3),
   TZBBXBL              NUMBER(6,4),
   BZ                   VARCHAR2(56),
   ZYJS                 NUMBER(14,2),
   JBR                  VARCHAR2(8),
   JFNX                 NUMBER(8,2),
   YBZC                 VARCHAR2(3),
   BZBM                 VARCHAR2(8),
   BZXE                 NUMBER(14,2),
   DCZFXE               NUMBER(14,2),
   SPLB                 VARCHAR2(3),
   JZSJ                 DATE                            not null,
   ZZYYBM               VARCHAR2(8),
   SJZT                 VARCHAR2(3),
   YYLB                 VARCHAR2(3),
   TCLJ                 NUMBER(14,2),
   DBXE                 NUMBER(14,2),
   DBBL                 NUMBER(6,4),
   SPYXBZ               VARCHAR2(3),
   JSBZ                 NUMBER(14,2),
   SZNL                 NUMBER(3,0),
   SWSXH                VARCHAR2(20),
   QFXYXBZ              VARCHAR2(3),
   JRJSBF               NUMBER(10,2),
   SFZY                 VARCHAR2(3),
   SFTD                 VARCHAR2(3),
   constraint PK_BY07RYSPDA primary key (SXH)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY07RYSPDA is
'BY07RYSPDA入院审批档案';

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

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

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

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

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

comment on column SDS.BY07RYSPDA.SPBZ is
'审批标志';

comment on column SDS.BY07RYSPDA.ZYZT is
'住院状态';

comment on column SDS.BY07RYSPDA.SPDW is
'审批单位';

comment on column SDS.BY07RYSPDA.SPRQ is
'审批日期';

comment on column SDS.BY07RYSPDA.SFTZB is
'是否特种病';

comment on column SDS.BY07RYSPDA.TZBBXBL is
'特种病报销比例';

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

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

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

comment on column SDS.BY07RYSPDA.JFNX is
'缴费年限';

comment on column SDS.BY07RYSPDA.YBZC is
'医保政策';

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

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

comment on column SDS.BY07RYSPDA.DCZFXE is
'单次支付限额';

comment on column SDS.BY07RYSPDA.SPLB is
'审批类别';

comment on column SDS.BY07RYSPDA.JZSJ is
'有效截止时间';

comment on column SDS.BY07RYSPDA.ZZYYBM is
'转诊医院编码';

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

comment on column SDS.BY07RYSPDA.YYLB is
'医院类别';

comment on column SDS.BY07RYSPDA.TCLJ is
'本年进入统筹累计';

comment on column SDS.BY07RYSPDA.DBXE is
'大病限额';

comment on column SDS.BY07RYSPDA.DBBL is
'大病比例';

comment on column SDS.BY07RYSPDA.SPYXBZ is
'审批有效标志';

comment on column SDS.BY07RYSPDA.JSBZ is
'基数标准';

comment on column SDS.BY07RYSPDA.SZNL is
'实际年龄';

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

comment on column SDS.BY07RYSPDA.QFXYXBZ is
'起付有效标志';

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

comment on column SDS.BY07RYSPDA.SFZY is
'是否转院';

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

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

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

/*==============================================================*/
/* Table: BY08CRYDJ                                             */
/*==============================================================*/
create table SDS.BY08CRYDJ  (
   SXH                  VARCHAR2(15)                    not null,
   YAB060               VARCHAR2(4)                     not null,
   DWBM                 VARCHAR2(12),
   DWMC                 VARCHAR2(56),
   GRBM                 VARCHAR2(20)                    not null,
   XM                   VARCHAR2(20),
   XB                   VARCHAR2(3),
   CSRQ                 DATE,
   YYBM                 VARCHAR2(8)                     not null,
   ZYZT                 VARCHAR2(3),
   RYSJ                 DATE,
   RYZD                 VARCHAR2(100),
   RYKS                 VARCHAR2(8),
   RYCW                 VARCHAR2(12),
   RYJBR                VARCHAR2(8),
   BLH                  VARCHAR2(12),
   ZYH                  VARCHAR2(12),
   CYYY                 VARCHAR2(10),
   CYSJ                 DATE,
   CYZD                 VARCHAR2(200),
   CYKS                 VARCHAR2(8),
   CYCW                 VARCHAR2(12),
   CYJBR                VARCHAR2(8),
   RYJBSJ               DATE,
   CYJBSJ               DATE,
   BZ                   VARCHAR2(56),
   SJZT                 VARCHAR2(3),
   SWSXH                VARCHAR2(20),
   ZDYS                 VARCHAR2(20),
   ZFLB                 VARCHAR2(3),
   ICNO                 VARCHAR(11),
   constraint PK_BY08CRYDJ primary key (SXH)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY08CRYDJ is
'BY08CRYDJ出入院登记表';

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

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

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

comment on column SDS.BY08CRYDJ.DWMC is
'单位名称';

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

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

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

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

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

comment on column SDS.BY08CRYDJ.ZYZT is
'住院状态';

comment on column SDS.BY08CRYDJ.RYSJ is
'入院时间';

comment on column SDS.BY08CRYDJ.RYZD is
'入院诊断';

comment on column SDS.BY08CRYDJ.RYKS is
'入院科室';

comment on column SDS.BY08CRYDJ.RYCW is
'入院床位';

comment on column SDS.BY08CRYDJ.RYJBR is
'入院经办人';

comment on column SDS.BY08CRYDJ.BLH is
'病例号';

comment on column SDS.BY08CRYDJ.ZYH is
'住院号';

comment on column SDS.BY08CRYDJ.CYYY is
'出院原因';

comment on column SDS.BY08CRYDJ.CYSJ is
'出院时间';

comment on column SDS.BY08CRYDJ.CYZD is
'出院诊断';

comment on column SDS.BY08CRYDJ.CYKS is
'出院科室';

comment on column SDS.BY08CRYDJ.CYCW is