?? sds.sql

?? oracle 數據庫自動備份的窗口模式解壓不會把原檔案刪除
?? SQL
?? 第 1 頁 / 共 3 頁
字號:
12 3 下一頁
/*==============================================================*/
/* 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
12 3 下一頁
?? 文件大小 61 K
?? 上傳用戶 liyusheng1983
?? 所屬分類 Oracle數據庫
??? 相關標簽

#oracle #數據庫 #刪除 #自動備份
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? sds.sql

?? 快捷鍵說明
