sds.sql

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

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

comment on column SDS.BY10CYJSB.DBZIF2 is
'大病自付';

comment on column SDS.BY10CYJSB.SWSXH2 is
'事务顺序号';

comment on column SDS.BY10CYJSB.GWYTCZHF2 is
'公务员统筹补助';

comment on column SDS.BY10CYJSB.FZXSHBZ2 is
'分中心审核标志';

comment on column SDS.BY10CYJSB.TSGGZFBF2 is
'特殊挂钩自付';

comment on column SDS.BY10CYJSB.DWMC2 is
'单位名称';

comment on column SDS.BY10CYJSB.GWYCXBZ2 is
'公务员超限补助';

comment on column SDS.BY10CYJSB.XJZF2 is
'现金自付';

comment on column SDS.BY10CYJSB.KZF2 is
'卡支付';

comment on column SDS.BY10CYJSB.TGBZ2 is
'退干补助';

comment on column SDS.BY10CYJSB.FSSJ2 is
'发生时间';

comment on column SDS.BY10CYJSB.TXBZ2 is
'特项补助';

comment on column SDS.BY10CYJSB.RYSW2 is
'人员存活状态';

comment on column SDS.BY10CYJSB.SBJKC_SZ2 is
'社保局扣除事中';

comment on column SDS.BY10CYJSB.SBJKC_DB_SZ2 is
'社保局扣除大病事中';

comment on column SDS.BY10CYJSB.SBJKC_DB2 is
'社保局扣除大病';

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

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

/*==============================================================*/
/* Table: BY10FDJSMXB                                           */
/*==============================================================*/
create table SDS.BY10FDJSMXB  (
   SXH                  VARCHAR2(15)                    not null,
   XH                   VARCHAR2(3)                     not null,
   GRBM                 VARCHAR2(20)                    not null,
   FYZE                 NUMBER(14,2),
   QZFBF                NUMBER(14,2),
   GGZFBF               NUMBER(14,2),
   JRJSBF               NUMBER(14,2),
   TCZIFBF              NUMBER(14,2),
   TCZHIFBF             NUMBER(14,2),
   DBZC                 NUMBER(14,2),
   DBZIF                NUMBER(14,2),
   ZXBZZF               NUMBER(14,2),
   CXZFBF               NUMBER(14,2),
   JBSJ                 DATE                            not null,
   BZ                   VARCHAR2(56),
   FDBZ                 VARCHAR2(3),
   SFY                  VARCHAR2(8),
   ZFLB                 VARCHAR2(3)                     not null,
   ZFDD                 VARCHAR2(3),
   SJZT                 VARCHAR2(3),
   constraint PK_BY10FDJSMXB primary key (SXH, XH, GRBM, JBSJ, ZFLB)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.BY10FDJSMXB is
'BY10FDJSMXB分段结算明细表';

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

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

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

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

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

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

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

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

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

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

comment on column SDS.BY10FDJSMXB.DBZIF is
'大病自付';

comment on column SDS.BY10FDJSMXB.ZXBZZF is
'专项补助支付';

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

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

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

comment on column SDS.BY10FDJSMXB.FDBZ is
'分段标准';

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

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

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

comment on column SDS.BY10FDJSMXB.SJZT is
'数据状态';

/*==============================================================*/
/* Table: BY10YJSMXB                                            */
/*==============================================================*/
create table SDS.BY10YJSMXB  (
   SXH                  VARCHAR2(19)                    not null,
   GRBM                 VARCHAR2(20)                    not null,
   XM                   VARCHAR2(20),
   XB                   VARCHAR2(3),
   CSRQ                 DATE,
   RYZT                 VARCHAR2(3),
   XNL                  NUMBER(8),
   YYBM                 VARCHAR2(8)                     not null,
   FYBM                 VARCHAR2(3)                     not null,
   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),
   ZXBZKZF              NUMBER(14,2),
   GWYTCZHF             NUMBER(14,2),
   CXZFBF               NUMBER(14,2),
   DBZC                 NUMBER(14,2),
   DBZIF                NUMBER(14,2),
   JBSJ                 DATE                            not null,
   BZ                   VARCHAR2(56),
   SFY                  VARCHAR2(20),
   JSBH                 VARCHAR2(18)                    not null,
   ZFLB                 VARCHAR2(3)                     not null,
   ZFDD                 VARCHAR2(3),
   SFTD                 VARCHAR2(3),
   SJZT                 VARCHAR2(3),
   YAB060               VARCHAR2(4)                     not null,
   ACTUALSELFPAY        NUMBER(14,2),
   GWYDBBZ              NUMBER(14,2),
   TSGGZFBF             NUMBER(14,2),
   GWYCXBZ              NUMBER(14,2),
   constraint PK_BY10YJSMXB primary key (SXH, GRBM, YYBM, JSBH, ZFLB)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

/*==============================================================*/
/* Table: FUNCTION                                              */
/*==============================================================*/
create table SDS.FUNCTION  (
   ID                   VARCHAR2(10)                    not null,
   PID                  VARCHAR2(10),
   NAME                 VARCHAR2(50)                    not null,
   ACTION               VARCHAR2(100),
   URL                  VARCHAR2(100),
   TITLE                VARCHAR2(100),
   TYPE                 VARCHAR2(1)                     not null,
   TARGET               VARCHAR2(10),
   ICON                 VARCHAR2(20),
   ICONOPEN             VARCHAR2(20),
   OPENED               VARCHAR2(1),
   REMARK               VARCHAR2(10),
   constraint SYS_C002077 primary key (ID)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.FUNCTION is
'重特病系统功能表';

comment on column SDS.FUNCTION.ID is
'功能ID';

comment on column SDS.FUNCTION.PID is
'父功能ID';

comment on column SDS.FUNCTION.NAME is
'功能内部名';

comment on column SDS.FUNCTION.ACTION is
'功能对应Action';

comment on column SDS.FUNCTION.URL is
'功能部署连接地址';

comment on column SDS.FUNCTION.TITLE is
'功能显示名称';

comment on column SDS.FUNCTION.TYPE is
'功能类别';

comment on column SDS.FUNCTION.TARGET is
'网页Target';

comment on column SDS.FUNCTION.ICON is
'正常图标';

comment on column SDS.FUNCTION.ICONOPEN is
'展开图标';

comment on column SDS.FUNCTION.OPENED is
'展开标志';

comment on column SDS.FUNCTION.REMARK is
'备注';

/*==============================================================*/
/* Table: LPJSB                                                 */
/*==============================================================*/
create table SDS.LPJSB  (
   YYBM                 VARCHAR2(8)                     not null,
   JSYF                 VARCHAR2(8)                     not null,
   TCZF                 NUMBER(14,2),
   BHLJE_TC             number(14,2),
   FKJE_TC              NUMBER(14,0),
   DBZF                 NUMBER(14,2),
   BHLJE_DB             NUMBER(14,2),
   FKJE_DB              NUMBER(14,0),
   GWYBZ                NUMBER(14,2),
   ZHZF                 NUMBER(14,2),
   JBSJ                 DATE,
   JBR                  VARCHAR2(10),
   constraint PK_LPJSB primary key (YYBM, JSYF)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.LPJSB is
'理赔结算表--LPJSB';

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

comment on column SDS.LPJSB.JSYF is
'结算月份';

comment on column SDS.LPJSB.TCZF is
'统筹支付';

comment on column SDS.LPJSB.BHLJE_TC is
'统筹不合理金额';

comment on column SDS.LPJSB.FKJE_TC is
'统筹罚款金额';

comment on column SDS.LPJSB.DBZF is
'大病支付';

comment on column SDS.LPJSB.BHLJE_DB is
'大病不合理金额';

comment on column SDS.LPJSB.FKJE_DB is
'大病罚款金额';

comment on column SDS.LPJSB.GWYBZ is
'公务员补助';

comment on column SDS.LPJSB.ZHZF is
'帐户支付';

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

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

/*==============================================================*/
/* Table: ROLE                                                  */
/*==============================================================*/
create table SDS.ROLE  (
   ID                   VARCHAR2(10)                    not null,
   NAME                 VARCHAR2(50)                    not null,
   DISPLAY_NAME         VARCHAR2(100),
   TARGET_UNIT_TYPE     VARCHAR2(10)                    not null,
   REMARK               VARCHAR2(100),
   constraint SYS_C002061 primary key (ID)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.ROLE is
'角色表';

comment on column SDS.ROLE.ID is
'角色标志';

comment on column SDS.ROLE.NAME is
'角色在系统中的内部名';

comment on column SDS.ROLE.DISPLAY_NAME is
'角色的显示名称';

comment on column SDS.ROLE.TARGET_UNIT_TYPE is
'该角色对应的单位类型';

comment on column SDS.ROLE.REMARK is
'备注';

/*==============================================================*/
/* Table: ROLE_FUNCTION_MAP                                     */
/*==============================================================*/
create table SDS.ROLE_FUNCTION_MAP  (
   ROLE_ID1             VARCHAR2(10)                    not null,
   FUNCTION_ID1         VARCHAR2(10)                    not null
)
tablespace SDS_TBS;

comment on table SDS.ROLE_FUNCTION_MAP is
'角色对应功能的映射表';

comment on column SDS.ROLE_FUNCTION_MAP.ROLE_ID1 is
'角色ID';

comment on column SDS.ROLE_FUNCTION_MAP.FUNCTION_ID1 is
'该角色享有的功能ID';

/*==============================================================*/
/* Table: ROLE_PARA                                             */
/*==============================================================*/
create table SDS.ROLE_PARA  (
   ROLE_ID              VARCHAR2(10)                    not null,
   PARA_KEY             VARCHAR2(5)                     not null,
   PARA_VALUE           VARCHAR2(10)                    not null,
   REMARK               VARCHAR2(50)
)
tablespace SDS_TBS;

comment on table SDS.ROLE_PARA is
'角色相关参数表';

comment on column SDS.ROLE_PARA.ROLE_ID is
'角色ID';

comment on column SDS.ROLE_PARA.PARA_KEY is
'参数类型';

comment on column SDS.ROLE_PARA.PARA_VALUE is
'参数值';

comment on column SDS.ROLE_PARA.REMARK is
'备注';

/*==============================================================*/
/* Table: UNIT_INFO                                             */
/*==============================================================*/
create table SDS.UNIT_INFO  (
   ID                   VARCHAR2(10)                    not null,
   NAME                 VARCHAR2(100)                   not null,
   ADDRESS              VARCHAR2(100),
   TEL                  VARCHAR2(20),
   SUB_CENTER           VARCHAR2(10),
   REMARK               VARCHAR2(100),
   TYPE                 VARCHAR2(3)
)
tablespace SDS_TBS;

comment on table SDS.UNIT_INFO is
'重特病涉及单位信息表';

comment on column SDS.UNIT_INFO.ID is
'单位ID';

comment on column SDS.UNIT_INFO.NAME is
'单位真实名称';

comment on column SDS.UNIT_INFO.ADDRESS is
'地址';

comment on column SDS.UNIT_INFO.TEL is
'电话';

comment on column SDS.UNIT_INFO.SUB_CENTER is
'所属分中心';

comment on column SDS.UNIT_INFO.REMARK is
'备注';

comment on column SDS.UNIT_INFO.TYPE is
'单位类别';

/*==============================================================*/
/* Table: USER_INFO                                             */
/*==============================================================*/
create table SDS.USER_INFO  (
   ID                   VARCHAR2(10)                    not null,
   NAME                 VARCHAR2(100)                   not null,
   PASSWD               VARCHAR2(50)                    not null,
   ROLE_ID              VARCHAR2(10)                    not null,
   UNIT_ID              VARCHAR2(10),
   DISPLAY_NAME         VARCHAR2(100),
   TEL                  VARCHAR2(20),
   CREATOR_ID           VARCHAR2(10),
   CREATED_DATE         DATE,
   LOCK_TAG             VARCHAR2(2),
   REMARK               VARCHAR2(100),
   constraint PK_USER_ID primary key (ID)
         using index
       tablespace SDSIDX_TBS
)
tablespace SDS_TBS;

comment on table SDS.USER_INFO is
'用户信息表';

comment on column SDS.USER_INFO.ID is
'用户ID';

comment on column SDS.USER_INFO.NAME is
'用户登录名';

comment on column SDS.USER_INFO.PASSWD is
'用户密码';

comment on column SDS.USER_INFO.ROLE_ID is
'角色ID';

comment on column SDS.USER_INFO.UNIT_ID is
'单位ID';

comment on column SDS.USER_INFO.DISPLAY_NAME is
'用户真实姓名';

comment on column SDS.USER_INFO.TEL is
'电话';

comment on column SDS.USER_INFO.CREATOR_ID is
'本用户创建者的ID';

comment on column SDS.USER_INFO.CREATED_DATE is
'用户创建日期';

comment on column SDS.USER_INFO.LOCK_TAG is
'封锁标志';

comment on column SDS.USER_INFO.REMARK is
'备注';

commit;