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;