
DROP TABLE JGGZ.A CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.A
(
  A  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.BML_LJINFO_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.BML_LJINFO_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.BML_XQBG_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.BML_XQBG_TMP
(
  XQBG_NO         VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  SPB_NO          VARCHAR2(32 BYTE),
  BD_TYPE         VARCHAR2(20 BYTE),
  JYJ_PZ_DATE     DATE,
  PJ_DATE         DATE,
  PJ_NO1          VARCHAR2(32 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJ_JG           VARCHAR2(50 BYTE),
  PJ_XZQH         VARCHAR2(32 BYTE),
  CD_FD           VARCHAR2(32 BYTE),
  BZ_NX           VARCHAR2(8 BYTE),
  XZ              VARCHAR2(20 BYTE),
  SJ_XQ           VARCHAR2(32 BYTE),
  YXQ             VARCHAR2(8 BYTE),
  YBZNX           VARCHAR2(8 BYTE),
  YXZ             VARCHAR2(20 BYTE),
  YXQ_START_DATE  DATE,
  YXQ_END_DATE    DATE,
  START_DATE      DATE,
  END_DATE        DATE,
  ZX_DATE         DATE,
  CD_SJ_QK        VARCHAR2(4000 BYTE),
  SPB_TYPE        CHAR(1 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  YPJ_NO1         VARCHAR2(32 BYTE),
  YPJ_NO2         VARCHAR2(32 BYTE),
  YPJ_JG          VARCHAR2(50 BYTE),
  YPJ_XZQH        VARCHAR2(32 BYTE),
  YPJ_DATE        DATE,
  C_USER          VARCHAR2(32 BYTE),
  SZ_DB           VARCHAR2(32 BYTE),
  CB_DATE         DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.BML_ZFLJ_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.BML_ZFLJ_TMP
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  LJ_TYPE         VARCHAR2(20 BYTE),
  LJ_DOC_NO       VARCHAR2(64 BYTE),
  LJ_ADDR_XZQH    VARCHAR2(16 BYTE),
  LJ_ADDR_DETAIL  VARCHAR2(256 BYTE),
  LJ_POL          VARCHAR2(32 BYTE),
  LJ_DATE         DATE,
  PJ_NO1          VARCHAR2(16 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJXZQH          VARCHAR2(32 BYTE),
  PJJG            VARCHAR2(32 BYTE),
  PJDATE          DATE,
  C_USER          VARCHAR2(64 BYTE),
  LJ_STATUS       CHAR(1 BYTE),
  SJ_DATE         DATE,
  DR_DATE         DATE,
  YDB             VARCHAR2(32 BYTE),
  MEMO            VARCHAR2(1000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.CRJ_JYJ_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.CRJ_JYJ_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.CRJ_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.CRJ_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.CXPT_MBTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.CXPT_MBTJ
(
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  MB_ID       VARCHAR2(32 BYTE),
  FIELD_ID    VARCHAR2(32 BYTE),
  XSZD_TITLE  VARCHAR2(100 BYTE),
  ORDERID     NUMBER(12),
  ISCHECKED   CHAR(1 BYTE),
  FIELD_CODE  VARCHAR2(500 BYTE),
  FIELD_NAME  VARCHAR2(100 BYTE),
  FIELD_SIZE  NUMBER(6),
  FIELD_TYPE  NUMBER,
  CODE_NAME   VARCHAR2(6 BYTE),
  TABLE_ID    VARCHAR2(32 BYTE)                 NOT NULL,
  TABLE_NAME  VARCHAR2(100 BYTE),
  TABLE_CODE  VARCHAR2(40 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.DBDD_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.DBDD_TMP
(
  ID        RAW(16),
  ZF_ID     VARCHAR2(12 BYTE),
  DD_DATE   DATE,
  DDQ_DB    CHAR(4 BYTE),
  DDH_DB    VARCHAR2(20 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.DZB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.DZB
(
  DANWEI   VARCHAR2(20 BYTE),
  LB       VARCHAR2(2 BYTE),
  BM       VARCHAR2(8 BYTE),
  MC       VARCHAR2(54 BYTE),
  NLB      VARCHAR2(2 BYTE),
  NBM      VARCHAR2(20 BYTE),
  NMC      VARCHAR2(54 BYTE),
  DELETED  CHAR(1 BYTE),
  STATUS   CHAR(20 BYTE),
  REMARK   VARCHAR2(1000 BYTE),
  LRM      VARCHAR2(28 BYTE),
  DWBM     VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.DZB_BM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.DZB_BM
(
  SM   VARCHAR2(255 BYTE),
  BM   VARCHAR2(255 BYTE),
  NSM  VARCHAR2(255 BYTE),
  NBM  VARCHAR2(255 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.DZB_JC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.DZB_JC
(
  DANWEI   VARCHAR2(20 BYTE),
  LB       VARCHAR2(2 BYTE),
  BM       VARCHAR2(8 BYTE),
  MC       VARCHAR2(54 BYTE),
  NLB      VARCHAR2(2 BYTE),
  NBM      VARCHAR2(20 BYTE),
  NMC      VARCHAR2(54 BYTE),
  DELETED  CHAR(1 BYTE),
  STATUS   CHAR(20 BYTE),
  REMARK   VARCHAR2(1000 BYTE),
  LRM      VARCHAR2(28 BYTE),
  DWBM     VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.KBH_TEMP_TABLE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.KBH_TEMP_TABLE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.KBH_TEMP_TABLE
(
  KFH   NUMBER,
  FLAG  VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.PLAN_TABLE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.PLAN_TABLE
(
  STATEMENT_ID     VARCHAR2(30 BYTE),
  TIMESTAMP        DATE,
  REMARKS          VARCHAR2(80 BYTE),
  OPERATION        VARCHAR2(30 BYTE),
  OPTIONS          VARCHAR2(30 BYTE),
  OBJECT_NODE      VARCHAR2(128 BYTE),
  OBJECT_OWNER     VARCHAR2(30 BYTE),
  OBJECT_NAME      VARCHAR2(30 BYTE),
  OBJECT_INSTANCE  INTEGER,
  OBJECT_TYPE      VARCHAR2(30 BYTE),
  OPTIMIZER        VARCHAR2(255 BYTE),
  SEARCH_COLUMNS   NUMBER,
  ID               INTEGER,
  PARENT_ID        INTEGER,
  POSITION         INTEGER,
  COST             INTEGER,
  CARDINALITY      INTEGER,
  BYTES            INTEGER,
  OTHER_TAG        VARCHAR2(255 BYTE),
  PARTITION_START  VARCHAR2(255 BYTE),
  PARTITION_STOP   VARCHAR2(255 BYTE),
  PARTITION_ID     INTEGER,
  OTHER            LONG,
  DISTRIBUTION     VARCHAR2(30 BYTE),
  CPU_COST         INTEGER,
  IO_COST          INTEGER,
  TEMP_SPACE       INTEGER
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.RJ_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.RJ_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.SGSZK_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.SGSZK_TMP
(
  ZF_ID    VARCHAR2(12 BYTE)                    NOT NULL,
  DR_DATE  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.SQLEXPERT_PLAN1 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.SQLEXPERT_PLAN1
(
  STATEMENT_ID     VARCHAR2(30 BYTE),
  TIMESTAMP        DATE,
  REMARKS          VARCHAR2(80 BYTE),
  OPERATION        VARCHAR2(30 BYTE),
  OPTIONS          VARCHAR2(30 BYTE),
  OBJECT_NODE      VARCHAR2(128 BYTE),
  OBJECT_OWNER     VARCHAR2(30 BYTE),
  OBJECT_NAME      VARCHAR2(30 BYTE),
  OBJECT_INSTANCE  NUMBER,
  OBJECT_TYPE      VARCHAR2(30 BYTE),
  OPTIMIZER        VARCHAR2(255 BYTE),
  SEARCH_COLUMNS   NUMBER,
  ID               NUMBER,
  PARENT_ID        NUMBER,
  POSITION         NUMBER,
  COST             NUMBER,
  CARDINALITY      NUMBER,
  BYTES            NUMBER,
  OTHER_TAG        VARCHAR2(255 BYTE),
  PARTITION_START  VARCHAR2(255 BYTE),
  PARTITION_STOP   VARCHAR2(255 BYTE),
  PARTITION_ID     NUMBER,
  OTHER            LONG
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.SYN_SQL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.SYN_SQL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.SYN_SQL
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  HOST     VARCHAR2(32 BYTE),
  OP_TYPE  VARCHAR2(16 BYTE)                    NOT NULL,
  SQL_TXT  VARCHAR2(4000 BYTE),
  OP_DATE  DATE                                 NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TEMP_KKK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TEMP_KKK
(
  ID     VARCHAR2(64 BYTE)                      NOT NULL,
  DEPID  VARCHAR2(30 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_AA CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_AA
(
  ZF_ID       VARCHAR2(32 BYTE),
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  XZ_ID       VARCHAR2(32 BYTE),
  SCOREVALUE  NUMBER(10,2),
  SCOREDATE   DATE,
  DEL_FLAG    CHAR(1 BYTE),
  C_DATE      DATE,
  U_DATE      DATE,
  OPERATOR    VARCHAR2(50 BYTE),
  JFGJ        VARCHAR2(50 BYTE),
  SPJ         VARCHAR2(20 BYTE),
  JYSS        VARCHAR2(200 BYTE),
  DL          VARCHAR2(50 BYTE),
  LB          VARCHAR2(2 BYTE),
  FLAG        VARCHAR2(3 BYTE),
  DEPID       VARCHAR2(30 BYTE),
  ACCORDING   VARCHAR2(300 BYTE),
  JFGJID      VARCHAR2(32 BYTE),
  NO          NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_JK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_JK
(
  ZF_ID           VARCHAR2(12 BYTE)             NOT NULL,
  ZF_FH           VARCHAR2(5 BYTE),
  ZF_NAME         VARCHAR2(80 BYTE),
  ZB_NAME         VARCHAR2(80 BYTE),
  ZF_GENDER       VARCHAR2(32 BYTE),
  ZF_BIRTH        DATE,
  ZF_MZ           VARCHAR2(32 BYTE),
  ZF_MARRIAGE     VARCHAR2(32 BYTE),
  PJ_NO1          VARCHAR2(50 BYTE),
  PJ_NO2          VARCHAR2(16 BYTE),
  ZM              VARCHAR2(32 BYTE),
  XZ              VARCHAR2(32 BYTE),
  XQ              VARCHAR2(8 BYTE),
  XQ_START_DATE   DATE,
  XQ_END_DATE     DATE,
  BZNX            VARCHAR2(8 BYTE),
  ZF_SOURCE       VARCHAR2(64 BYTE),
  FY_TYPE         VARCHAR2(32 BYTE),
  NYDW            VARCHAR2(32 BYTE),
  JY_FLAG         CHAR(1 BYTE),
  JYXQ            VARCHAR2(8 BYTE),
  JY_START_DATE   DATE,
  JY_END_DATE     DATE,
  SJ_TYPE         VARCHAR2(32 BYTE),
  SY_STATUS       VARCHAR2(32 BYTE),
  SC_CA           VARCHAR2(32 BYTE),
  HJ_ADDR_XZQH    VARCHAR2(32 BYTE),
  HJ_ADDR_DETAIL  VARCHAR2(64 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  FL_FLAG         CHAR(1 BYTE),
  C_USER          VARCHAR2(32 BYTE),
  DB              VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_JL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_JL
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  START_DATE      VARCHAR2(32 BYTE),
  END_DATE        VARCHAR2(32 BYTE),
  DW_ADDR_XZQH    VARCHAR2(32 BYTE),
  DW_ADDR_DETAIL  VARCHAR2(200 BYTE),
  DW_MC           VARCHAR2(200 BYTE),
  ZF_ZY           VARCHAR2(32 BYTE),
  ZF_ZW           VARCHAR2(32 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  HJ_XZQH         VARCHAR2(32 BYTE),
  HJ_DETAIL       VARCHAR2(64 BYTE),
  XH              VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_LBC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_LBC
(
  LBC_NO         VARCHAR2(32 BYTE)              NOT NULL,
  SP_ID          VARCHAR2(10 BYTE),
  ZF_ID          VARCHAR2(12 BYTE),
  LBCSP_NO       VARCHAR2(32 BYTE),
  LBC_TYPE       VARCHAR2(6 BYTE),
  SICK_HISTORY   VARCHAR2(4000 BYTE),
  BC_TYPE        VARCHAR2(6 BYTE),
  DJ_DATE        DATE,
  SC_INFO        VARCHAR2(2000 BYTE),
  BC_YJ          VARCHAR2(4000 BYTE),
  HOSPITAL_YJ    VARCHAR2(4000 BYTE),
  HOSPITAL_DATE  DATE,
  CXLBC_DATE     DATE,
  JD_YS1         VARCHAR2(20 BYTE),
  YS_ZW1         VARCHAR2(6 BYTE),
  YS_ZC1         VARCHAR2(6 BYTE),
  JD_YS2         VARCHAR2(20 BYTE),
  YS_ZW2         VARCHAR2(6 BYTE),
  YS_ZC2         VARCHAR2(6 BYTE),
  JD_YS3         VARCHAR2(20 BYTE),
  YS_ZW3         VARCHAR2(6 BYTE),
  YS_ZC3         VARCHAR2(6 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_SHGX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_SHGX
(
  ZF_ID            VARCHAR2(12 BYTE),
  SHGX_NO          VARCHAR2(32 BYTE)            NOT NULL,
  GX_NAME          VARCHAR2(100 BYTE),
  NAME             VARCHAR2(64 BYTE),
  AGE              VARCHAR2(12 BYTE),
  GENDER           VARCHAR2(64 BYTE),
  DW               VARCHAR2(64 BYTE),
  DW_ADDR_XZQH     VARCHAR2(64 BYTE),
  DW_ADDR_DETAIL   VARCHAR2(200 BYTE),
  ZW               VARCHAR2(64 BYTE),
  ZZD_ADDR_XZQH    VARCHAR2(64 BYTE),
  ZZD_ADDR_DETIAL  VARCHAR2(200 BYTE),
  ZZMM             VARCHAR2(64 BYTE),
  ZJ_TYPE          VARCHAR2(64 BYTE),
  ZJ_NO            VARCHAR2(36 BYTE),
  TELEPHONE        VARCHAR2(50 BYTE),
  C_DATE           DATE,
  U_DATE           DATE,
  DEL_FLAG         CHAR(1 BYTE),
  XH               VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_TC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_TC
(
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  TC_CODE   VARCHAR2(32 BYTE),
  TC        VARCHAR2(100 BYTE)                  NOT NULL,
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_TG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_TG
(
  ZF_ID  VARCHAR2(12 BYTE)                      NOT NULL,
  TGLB   VARCHAR2(20 BYTE)                      NOT NULL,
  XH     VARCHAR2(5 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_TMTZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_TMTZ
(
  ZF_ID         VARCHAR2(12 BYTE)               NOT NULL,
  HEIGHT        VARCHAR2(10 BYTE),
  BODY_TYPE     VARCHAR2(32 BYTE),
  BLOOD_TYPE    VARCHAR2(32 BYTE),
  FACE_TYPE     VARCHAR2(32 BYTE),
  ACCENT        VARCHAR2(50 BYTE),
  FOOT_LEN      VARCHAR2(10 BYTE),
  SKIN_FEATURE  VARCHAR2(1000 BYTE),
  CHARACTER     VARCHAR2(256 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_XQBG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_XQBG
(
  XQBG_NO         VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  SPB_NO          VARCHAR2(32 BYTE),
  BD_TYPE         VARCHAR2(20 BYTE),
  JYJ_PZ_DATE     DATE,
  PJ_DATE         DATE,
  PJ_NO1          VARCHAR2(32 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJ_JG           VARCHAR2(50 BYTE),
  PJ_XZQH         VARCHAR2(32 BYTE),
  CD_FD           VARCHAR2(32 BYTE),
  BZ_NX           VARCHAR2(8 BYTE),
  XZ              VARCHAR2(20 BYTE),
  SJ_XQ           VARCHAR2(32 BYTE),
  YXQ             VARCHAR2(8 BYTE),
  YBZNX           VARCHAR2(8 BYTE),
  YXZ             VARCHAR2(20 BYTE),
  YXQ_START_DATE  DATE,
  YXQ_END_DATE    DATE,
  START_DATE      DATE,
  END_DATE        DATE,
  ZX_DATE         DATE,
  CD_SJ_QK        VARCHAR2(4000 BYTE),
  SPB_TYPE        CHAR(1 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  YPJ_NO1         VARCHAR2(32 BYTE),
  YPJ_NO2         VARCHAR2(32 BYTE),
  YPJ_JG          VARCHAR2(50 BYTE),
  YPJ_XZQH        VARCHAR2(32 BYTE),
  YPJ_DATE        DATE,
  C_USER          VARCHAR2(32 BYTE),
  SZ_DB           VARCHAR2(32 BYTE),
  CB_DATE         DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_ZK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZK
(
  ZF_ID            VARCHAR2(12 BYTE)            NOT NULL,
  ZF_ADDR_XZQH     VARCHAR2(32 BYTE),
  ZF_ADDR_DETAIL   VARCHAR2(64 BYTE),
  FILE_NO          VARCHAR2(16 BYTE),
  RJ_DATE          DATE,
  DR_DATE          DATE,
  BH_NAME          VARCHAR2(64 BYTE),
  BQWH             VARCHAR2(32 BYTE),
  XWH              VARCHAR2(32 BYTE),
  BQZY             VARCHAR2(32 BYTE),
  BQMM             VARCHAR2(32 BYTE),
  ZF_NATION        VARCHAR2(32 BYTE),
  PCS              VARCHAR2(32 BYTE),
  JD               VARCHAR2(32 BYTE),
  SY_TYPE          VARCHAR2(32 BYTE),
  DBJG_XZQH        VARCHAR2(32 BYTE),
  DBJG_ZXJG        VARCHAR2(50 BYTE),
  DB_DATE          DATE,
  PJJG_XZQH        VARCHAR2(32 BYTE),
  PJJG_ZXJG        VARCHAR2(50 BYTE),
  PJ_DATE          DATE,
  YAF_TYPE         VARCHAR2(32 BYTE),
  XAF_TYPE         VARCHAR2(32 BYTE),
  YS_DEPT_XZQH     VARCHAR2(32 BYTE),
  YS_DEPT          VARCHAR2(32 BYTE),
  YS_NO1           VARCHAR2(32 BYTE),
  YS_NO2           VARCHAR2(32 BYTE),
  LJ_TIMES         VARCHAR2(4 BYTE),
  QK_TIMES         VARCHAR2(4 BYTE),
  LGF              VARCHAR2(32 BYTE),
  DB               VARCHAR2(32 BYTE),
  FG_LEVEL         VARCHAR2(32 BYTE),
  WORKER_LEVEL     VARCHAR2(32 BYTE),
  GZ               VARCHAR2(50 BYTE),
  NWFG             VARCHAR2(50 BYTE),
  ID_CARD          VARCHAR2(36 BYTE),
  HK_TYPE          VARCHAR2(32 BYTE),
  LC_TYPE          VARCHAR2(32 BYTE),
  JX_MEASURE       VARCHAR2(32 BYTE),
  LBC_FLAG         VARCHAR2(32 BYTE),
  CUR_START_DATE   DATE,
  CUR_END_DATE     DATE,
  CUR_BZNX         VARCHAR2(8 BYTE),
  CUR_XZ           VARCHAR2(32 BYTE),
  CURRENT_XQ       VARCHAR2(8 BYTE),
  LAST_START_DATE  DATE,
  LAST_END_DATE    DATE,
  LAST_FX_XZQH     VARCHAR2(32 BYTE),
  LAST_FX_JY       VARCHAR2(64 BYTE),
  JXHG_FLAG        CHAR(1 BYTE),
  SS_FLAG          CHAR(1 BYTE),
  TC               VARCHAR2(1000 BYTE),
  FJ               VARCHAR2(100 BYTE),
  C_DATE           DATE,
  U_DATE           DATE,
  DEL_FLAG         CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_ZM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZM
(
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  ZM_CODE   VARCHAR2(6 BYTE)                    NOT NULL,
  ZM_SEQ    NUMBER(2),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_T_YZ_ZF_ZMBK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZMBK
(
  XQBGNO  VARCHAR2(32 BYTE)                     NOT NULL,
  ZF_ID   VARCHAR2(12 BYTE)                     NOT NULL,
  XH      VARCHAR2(5 BYTE),
  ZM      VARCHAR2(20 BYTE)                     NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_ZC_ZF_ID CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_ZC_ZF_ID
(
  ZF_ID  VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_ZFLJ_3112_60 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_ZFLJ_3112_60
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  LJ_TYPE         VARCHAR2(20 BYTE),
  LJ_DOC_NO       VARCHAR2(64 BYTE),
  LJ_ADDR_XZQH    VARCHAR2(16 BYTE),
  LJ_ADDR_DETAIL  VARCHAR2(256 BYTE),
  LJ_POL          VARCHAR2(32 BYTE),
  LJ_DATE         DATE,
  PJ_NO1          VARCHAR2(16 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJXZQH          VARCHAR2(32 BYTE),
  PJJG            VARCHAR2(32 BYTE),
  PJDATE          DATE,
  C_USER          VARCHAR2(64 BYTE),
  LJ_STATUS       CHAR(1 BYTE),
  SJ_DATE         DATE,
  DR_DATE         DATE,
  YDB             VARCHAR2(32 BYTE),
  MEMO            VARCHAR2(1000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.TMP_ZFLJ_ID CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.TMP_ZFLJ_ID
(
  ID  VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_JXJS_BM_BL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_JXJS_BM_BL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_JXJS_BM_BL
(
  ID    VARCHAR2(200 BYTE),
  NAME  VARCHAR2(500 BYTE),
  MEMO  VARCHAR2(4000 BYTE),
  TYPE  VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_JXJS_FY_BM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_JXJS_FY_BM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_JXJS_FY_BM
(
  ID     VARCHAR2(32 BYTE),
  NAME   VARCHAR2(500 BYTE),
  BM_ID  VARCHAR2(500 BYTE),
  MEMO   VARCHAR2(4000 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_JXJS_JY_BM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_JXJS_JY_BM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_JXJS_JY_BM
(
  ID     VARCHAR2(32 BYTE),
  NAME   VARCHAR2(500 BYTE),
  BM_ID  VARCHAR2(500 BYTE),
  MEMO   VARCHAR2(4000 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_REPORT_DATA DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_REPORT_DATA CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_REPORT_DATA
(
  COL_NUM     NUMBER(5),
  ROW_NUM     NUMBER(5),
  VAL         VARCHAR2(512 BYTE),
  C_TIME      DATE,
  SESSION_ID  VARCHAR2(32 BYTE),
  PAGE_NUM    NUMBER(5),
  ID          VARCHAR2(32 BYTE)                 DEFAULT sys_guid()            NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_REPORT_PROCEDURE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_REPORT_PROCEDURE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_REPORT_PROCEDURE
(
  ID               VARCHAR2(32 BYTE),
  REPORT_NAME      VARCHAR2(50 BYTE),
  PROCEDURE_NAMES  VARCHAR2(1000 BYTE),
  CATEGORY_ID      VARCHAR2(2 BYTE),
  REPORT_DESC      VARCHAR2(50 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_SYS_JFKH_AUTOYJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_SYS_JFKH_AUTOYJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_SYS_JFKH_AUTOYJ
(
  JYBM       VARCHAR2(12 BYTE)                  NOT NULL,
  STARTDATE  VARCHAR2(2 BYTE)                   DEFAULT -1,
  AUTOFLAG   VARCHAR2(1 BYTE)                   DEFAULT 0,
  JFGJID     VARCHAR2(64 BYTE),
  U_DATE     DATE,
  OPUSER     VARCHAR2(64 BYTE),
  STARTTIME  NUMBER(2)                          DEFAULT 18,
  DELAYTIME  NUMBER                             DEFAULT 3600000
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_AUTHORITY_TEST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_AUTHORITY_TEST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_AUTHORITY_TEST
(
  AUTH_ID         VARCHAR2(32 BYTE)             DEFAULT sys_guid()            NOT NULL,
  PARENT_AUTH_ID  VARCHAR2(32 BYTE),
  AUTH_NAME       VARCHAR2(50 BYTE),
  AUTH_TYPE       VARCHAR2(6 BYTE),
  AUTH_URL        VARCHAR2(256 BYTE),
  RIGHT           CHAR(1 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  SXH             VARCHAR2(15 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_COL_COMMENTS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_COL_COMMENTS
(
  ID           VARCHAR2(32 BYTE)                DEFAULT sys_guid(),
  TABLE_NAME   VARCHAR2(30 BYTE),
  COLUMN_NAME  VARCHAR2(30 BYTE),
  COMMENTS     VARCHAR2(4000 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_DXKTJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_DXKTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_DXKTJ
(
  MBTJ_ID        VARCHAR2(32 BYTE)              NOT NULL,
  TJ_ITEM_NUM    NUMBER,
  TJ_ITEM_VALUE  VARCHAR2(100 BYTE),
  TJ_ITEM_TITLE  VARCHAR2(100 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_FXKTJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_FXKTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_FXKTJ
(
  MBTJ_ID        VARCHAR2(32 BYTE)              NOT NULL,
  TJ_ITEM_NUM    NUMBER,
  TJ_ITEM_VALUE  VARCHAR2(100 BYTE),
  TJ_ITEM_TITLE  VARCHAR2(100 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MB
(
  MB_ID       VARCHAR2(32 BYTE)                 NOT NULL,
  U_DATE      DATE,
  MB_NAME     VARCHAR2(100 BYTE),
  IS_JION     CHAR(1 BYTE),
  IS_SQL      CHAR(1 BYTE),
  SELECT_SQL  VARCHAR2(4000 BYTE),
  FROM_SQL    VARCHAR2(4000 BYTE),
  WHERE_SQL   VARCHAR2(4000 BYTE),
  GROUP_SQL   VARCHAR2(4000 BYTE),
  ORDER_SQL   VARCHAR2(4000 BYTE),
  ZF_URL      VARCHAR2(4000 BYTE),
  MOD_URL     VARCHAR2(4000 BYTE),
  MOD_ID      VARCHAR2(4000 BYTE),
  DEL_URL     VARCHAR2(4000 BYTE),
  IS_COUNT    CHAR(1 BYTE)                      DEFAULT '0',
  IS_KP       CHAR(1 BYTE),
  MB_TAB      VARCHAR2(64 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MBGL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MBGL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MBGL
(
  ID               NUMBER                       NOT NULL,
  MB_ID            NUMBER,
  FIRST_FIELD_ID   NUMBER,
  SECOND_FIELD_ID  NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MBPX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MBPX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MBPX
(
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  MB_ID       VARCHAR2(32 BYTE),
  FIELD_ID    VARCHAR2(32 BYTE),
  PX_CONTENT  NUMBER(10),
  PX_NAME     VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MBTJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MBTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MBTJ
(
  MBTJ_ID      VARCHAR2(32 BYTE)                NOT NULL,
  MB_ID        VARCHAR2(32 BYTE),
  FIELD_ID     VARCHAR2(32 BYTE),
  XS_TYPE      NUMBER,
  XS_TITLE     VARCHAR2(100 BYTE),
  ORDERID      NUMBER(12),
  FIELD_CODE   VARCHAR2(200 BYTE),
  FIELD_TYPE   VARCHAR2(200 BYTE),
  FIELD_SIZE   VARCHAR2(200 BYTE),
  FIELDNAME    VARCHAR2(200 BYTE),
  CODE_NAME    VARCHAR2(200 BYTE),
  IS_SQL       VARCHAR2(200 BYTE),
  ZH_FIELD     VARCHAR2(200 BYTE),
  TABLE_ID     VARCHAR2(200 BYTE),
  TABNAME      VARCHAR2(200 BYTE),
  TABCODE      VARCHAR2(200 BYTE),
  TEMP_SQL     VARCHAR2(4000 BYTE),
  APPEND_TYPE  VARCHAR2(100 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MBXGB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MBXGB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MBXGB
(
  MBXGB_ID  VARCHAR2(32 BYTE)                   NOT NULL,
  MB_ID     VARCHAR2(32 BYTE),
  TABLE_ID  VARCHAR2(32 BYTE),
  U_DATE    DATE
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_MBXSZD DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_MBXSZD CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_MBXSZD
(
  ID                VARCHAR2(32 BYTE)           NOT NULL,
  MB_ID             VARCHAR2(32 BYTE),
  FIELD_ID          VARCHAR2(32 BYTE),
  XSZD_TITLE        VARCHAR2(100 BYTE),
  ORDERID           NUMBER(12),
  ISCHECKED         CHAR(1 BYTE),
  FIELD_CODE        VARCHAR2(500 BYTE),
  FIELD_NAME        VARCHAR2(100 BYTE),
  FIELD_SIZE        NUMBER(6),
  FIELD_TYPE        NUMBER,
  CODE_NAME         VARCHAR2(6 BYTE),
  TABLE_ID          VARCHAR2(32 BYTE)           NOT NULL,
  TABLE_NAME        VARCHAR2(100 BYTE),
  TABLE_CODE        VARCHAR2(40 BYTE),
  ZH_FIELD          VARCHAR2(32 BYTE),
  GROUP_SYMBOL      VARCHAR2(32 BYTE),
  OBLIGATE_FIELD_1  VARCHAR2(100 BYTE),
  OBLIGATE_FIELD_2  VARCHAR2(100 BYTE),
  OBLIGATE_FIELD_3  VARCHAR2(100 BYTE),
  OBLIGATE_FIELD_4  VARCHAR2(100 BYTE),
  OBLIGATE_FIELD_5  VARCHAR2(100 BYTE),
  OBLIGATE_FIELD_6  VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  MB_ID     VARCHAR2(32 BYTE)                   NOT NULL,
  TABLE_ID  VARCHAR2(32 BYTE)                   NOT NULL,
  U_DATE    DATE                                NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_SYS_FIELD DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_SYS_FIELD CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_SYS_FIELD
(
  FIELD_ID        VARCHAR2(32 BYTE)             NOT NULL,
  TABLE_ID        VARCHAR2(32 BYTE),
  CN_NAME         VARCHAR2(100 BYTE),
  EN_NAME         VARCHAR2(500 BYTE),
  IS_KEY          NUMBER,
  TYPE            NUMBER,
  FIELD_SIZE      NUMBER(6),
  IS_CODE         NUMBER,
  CODE_NAME       VARCHAR2(6 BYTE),
  U_DATE          DATE,
  ZH_FIELD        VARCHAR2(32 BYTE),
  IS_SQL          CHAR(1 BYTE),
  TEMP_SQL        VARCHAR2(4000 BYTE),
  GROUP_FLAG      VARCHAR2(32 BYTE),
  EXTEND_FIELD_1  VARCHAR2(100 BYTE),
  EXTEND_FIELD_2  VARCHAR2(100 BYTE),
  EXTEND_FIELD_3  VARCHAR2(100 BYTE),
  EXTEND_FIELD_4  VARCHAR2(100 BYTE),
  EXTEND_FIELD_5  VARCHAR2(100 BYTE),
  EXTEND_FIELD_6  VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_SYS_TABLE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_SYS_TABLE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_SYS_TABLE
(
  TABLE_ID   VARCHAR2(32 BYTE)                  NOT NULL,
  CN_NAME    VARCHAR2(100 BYTE),
  EN_NAME    VARCHAR2(40 BYTE),
  U_DATE     DATE,
  TEMP_NAME  VARCHAR2(4000 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_CXPT_XSZDMR CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_XSZDMR
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  XSZD_ID  VARCHAR2(32 BYTE),
  MB_ID    VARCHAR2(32 BYTE),
  USER_ID  VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_CXPT_ZHXTJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_CXPT_ZHXTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_CXPT_ZHXTJ
(
  FIELD_ID  VARCHAR2(32 BYTE)                   NOT NULL,
  MBTJ_ID   VARCHAR2(32 BYTE)                   NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_DEPT_TEST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_DEPT_TEST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_DEPT_TEST
(
  DEPT_ID      VARCHAR2(100 BYTE)               NOT NULL,
  DEPT_SERIAL  VARCHAR2(100 BYTE),
  DEPT_NAME    VARCHAR2(100 BYTE),
  DEPT_DESC    VARCHAR2(200 BYTE),
  C_DATE       DATE,
  U_DATE       DATE,
  DEL_FLAG     CHAR(1 BYTE),
  DEPT_BM      VARCHAR2(16 BYTE)                NOT NULL,
  FILTER_CODE  VARCHAR2(512 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_DJG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_DJG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_DJG
(
  ID        VARCHAR2(64 BYTE),
  ZF_ID     VARCHAR2(12 BYTE),
  DJ        VARCHAR2(20 BYTE),
  LXID      VARCHAR2(64 BYTE),
  YEAR      VARCHAR2(4 BYTE),
  MONTH     VARCHAR2(2 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG
(
  JB    VARCHAR2(16 BYTE)                       NOT NULL,
  LJF   VARCHAR2(8 BYTE),
  YCKF  VARCHAR2(8 BYTE),
  LJKF  VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_FJQ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_FJQ
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  DEP_ID     VARCHAR2(32 BYTE),
  RJF        FLOAT(126)                         DEFAULT 5,
  FDF        FLOAT(126)                         DEFAULT 0,
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE),
  DEP_NAME   VARCHAR2(100 BYTE),
  PARENT_ID  VARCHAR2(50 BYTE),
  JZ_FLAG    VARCHAR2(10 BYTE)                  DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_JC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_JC
(
  ID         VARCHAR2(32 BYTE),
  ZF_ID      VARCHAR2(32 BYTE),
  JC         VARCHAR2(100 BYTE),
  JC_REASON  VARCHAR2(300 BYTE),
  JC_DATE    DATE,
  AUTO_FLAG  CHAR(1 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE),
  GJ         VARCHAR2(32 BYTE),
  OPERATOR   VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_JZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_JZ
(
  ID       VARCHAR2(30 BYTE)                    NOT NULL,
  JZ_NAME  VARCHAR2(100 BYTE),
  BZGJ     VARCHAR2(50 BYTE),
  ZFZZ     VARCHAR2(40 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_LXFZ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_LXFZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_LXFZ
(
  ID      VARCHAR2(64 BYTE),
  LXID    VARCHAR2(64 BYTE),
  FZTYPE  VARCHAR2(8 BYTE),
  FZDES   VARCHAR2(50 BYTE),
  LB      VARCHAR2(8 BYTE),
  FZ      NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP
(
  SESSIONID  VARCHAR2(64 BYTE)                  NOT NULL,
  ZFID       VARCHAR2(12 BYTE)                  NOT NULL,
  ZFFH       VARCHAR2(5 BYTE),
  ZFNAME     VARCHAR2(100 BYTE),
  DB         VARCHAR2(20 BYTE),
  LJF        NUMBER(10,2)                       DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_SCORE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE
(
  ZF_ID       VARCHAR2(32 BYTE),
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  XZ_ID       VARCHAR2(32 BYTE),
  SCOREVALUE  NUMBER(10,2),
  SCOREDATE   DATE,
  DEL_FLAG    CHAR(1 BYTE),
  C_DATE      DATE,
  U_DATE      DATE,
  OPERATOR    VARCHAR2(50 BYTE),
  JFGJ        VARCHAR2(50 BYTE),
  SPJ         VARCHAR2(20 BYTE),
  JYSS        VARCHAR2(200 BYTE),
  DL          VARCHAR2(50 BYTE),
  LB          VARCHAR2(2 BYTE),
  FLAG        VARCHAR2(3 BYTE)                  DEFAULT 2,
  DEPID       VARCHAR2(30 BYTE),
  ACCORDING   VARCHAR2(300 BYTE),
  JFGJID      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR
(
  ZF_ID      VARCHAR2(32 BYTE),
  REASON     VARCHAR2(2000 BYTE),
  SCORE      NUMBER(10,2),
  SCOREDATE  DATE,
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  DEL_FLAG   CHAR(1 BYTE),
  JFQR       DATE,
  JFGJ       VARCHAR2(32 BYTE),
  OPERATOR   VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY
(
  ZF_ID       VARCHAR2(32 BYTE),
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  XZ_ID       VARCHAR2(32 BYTE),
  SCOREVALUE  NUMBER(10,2),
  SCOREDATE   DATE,
  DEL_FLAG    CHAR(1 BYTE),
  C_DATE      DATE,
  U_DATE      DATE,
  OPERATOR    VARCHAR2(50 BYTE),
  JFGJ        VARCHAR2(50 BYTE),
  SPJ         VARCHAR2(20 BYTE),
  JYSS        VARCHAR2(200 BYTE),
  DL          VARCHAR2(50 BYTE),
  LB          VARCHAR2(2 BYTE),
  FLAG        VARCHAR2(3 BYTE)                  DEFAULT 2,
  DEPID       VARCHAR2(30 BYTE),
  ACCORDING   VARCHAR2(300 BYTE),
  JFGJID      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH
(
  ID             VARCHAR2(64 BYTE)              NOT NULL,
  ZF_ID          VARCHAR2(32 BYTE),
  REAL_SCORE     NUMBER(10,2)                   DEFAULT 0,
  BALANCE_SCORE  NUMBER(10,2)                   DEFAULT 0,
  AWARD_SCORE    NUMBER(10,2)                   DEFAULT 0,
  PUNISH_SCORE   NUMBER(10,2)                   DEFAULT 0,
  CLEAR_SCORE    NUMBER(10,2)                   DEFAULT 0,
  HALF_FLAG      CHAR(1 BYTE),
  YJ_FLAG        CHAR(1 BYTE)                   DEFAULT 0,
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE)                   DEFAULT 0,
  SUM_SCORE      NUMBER(10,2),
  DEPID          VARCHAR2(30 BYTE),
  YEAR           VARCHAR2(8 BYTE),
  MONTH          VARCHAR2(8 BYTE),
  JY             VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_0000 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_0000
(
  ZF_ID  VARCHAR2(32 BYTE),
  YM     VARCHAR2(6 BYTE),
  JF     NUMBER,
  KF     NUMBER,
  QXF    NUMBER,
  PHF    NUMBER,
  FKF    NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_1111 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_1111
(
  ID             VARCHAR2(64 BYTE)              NOT NULL,
  ZF_ID          VARCHAR2(32 BYTE),
  REAL_SCORE     NUMBER(10,2),
  BALANCE_SCORE  NUMBER(10,2),
  AWARD_SCORE    NUMBER(10,2),
  PUNISH_SCORE   NUMBER(10,2),
  CLEAR_SCORE    NUMBER(10,2),
  HALF_FLAG      CHAR(1 BYTE),
  YJ_FLAG        CHAR(1 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE),
  SUM_SCORE      NUMBER(10,2),
  DEPID          VARCHAR2(30 BYTE),
  YEAR           VARCHAR2(8 BYTE),
  MONTH          VARCHAR2(8 BYTE),
  JY             VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_TEMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_TEMP
(
  ID             VARCHAR2(64 BYTE)              NOT NULL,
  ZF_ID          VARCHAR2(32 BYTE),
  REAL_SCORE     NUMBER(10,2),
  BALANCE_SCORE  NUMBER(10,2),
  AWARD_SCORE    NUMBER(10,2),
  PUNISH_SCORE   NUMBER(10,2),
  CLEAR_SCORE    NUMBER(10,2),
  HALF_FLAG      CHAR(1 BYTE),
  YJ_FLAG        CHAR(1 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE),
  SUM_SCORE      NUMBER(10,2),
  DEPID          VARCHAR2(30 BYTE),
  YEAR           VARCHAR2(8 BYTE),
  MONTH          VARCHAR2(8 BYTE),
  JY             VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_SPJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_SPJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_SPJ
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  NAME     VARCHAR2(200 BYTE),
  JFLIMIT  VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_USER DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_USER CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_USER
(
  USER_ID   VARCHAR2(32 BYTE),
  JF_DEPT   VARCHAR2(20 BYTE),
  DEL_FLAG  CHAR(1 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  SPJ       VARCHAR2(32 BYTE),
  ID        VARCHAR2(32 BYTE)                   NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_XBF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_XBF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XBF
(
  ID        VARCHAR2(64 BYTE),
  XBDATE    DATE,
  XBDEP     VARCHAR2(64 BYTE),
  XBFS      NUMBER(10,2),
  JSDEP     VARCHAR2(64 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  OPERATOR  VARCHAR2(32 BYTE),
  XBREASON  VARCHAR2(200 BYTE),
  FLAG      CHAR(1 BYTE)                        DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DEPT DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_XBF_DEPT CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XBF_DEPT
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  PARENTID        VARCHAR2(32 BYTE),
  NAME            VARCHAR2(50 BYTE),
  BM              VARCHAR2(30 BYTE),
  CANADD          CHAR(1 BYTE)                  DEFAULT 0,
  USEFULLIFE      NUMBER(2)                     DEFAULT 0,
  USEFULLIFETYPE  CHAR(1 BYTE),
  LIMIT           CHAR(1 BYTE)                  DEFAULT 1,
  FZTYPE          CHAR(1 BYTE),
  BASEFZ          NUMBER(6,2)                   DEFAULT 0,
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE)                  DEFAULT 0,
  DEPTTYPE        CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  XBDATE    DATE,
  XBDEPT    VARCHAR2(30 BYTE),
  XBFS      NUMBER(10,2)                        DEFAULT 0,
  JSDEPT    VARCHAR2(30 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)                        DEFAULT 0,
  OPERATOR  VARCHAR2(32 BYTE),
  XBREASON  VARCHAR2(200 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_USER DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_XBF_USER CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XBF_USER
(
  USERID     VARCHAR2(32 BYTE)                  NOT NULL,
  XBFDEPTBM  VARCHAR2(30 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_XZ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_XZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XZ
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  CONTENT    VARCHAR2(4000 BYTE),
  ACCORDING  VARCHAR2(1000 BYTE),
  U_LIMIT    VARCHAR2(16 BYTE),
  L_LIMIT    VARCHAR2(16 BYTE),
  F_LIMIT    VARCHAR2(16 BYTE),
  O_LEVEL    VARCHAR2(16 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE),
  LRM        VARCHAR2(200 BYTE),
  JFLB       VARCHAR2(100 BYTE),
  DL         VARCHAR2(32 BYTE),
  JBF        VARCHAR2(10 BYTE),
  FLAG       VARCHAR2(32 BYTE)                  DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_XZL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_XZL
(
  ID    VARCHAR2(32 BYTE),
  NAME  VARCHAR2(200 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_YJ_DEPT DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_YJ_DEPT CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_YJ_DEPT
(
  DEPID        VARCHAR2(32 BYTE),
  ID           VARCHAR2(32 BYTE)                NOT NULL,
  LASTYJSDATE  DATE,
  LASTYJEDATE  DATE,
  DEL_FLAG     CHAR(1 BYTE)                     DEFAULT 0,
  YEAR         VARCHAR2(32 BYTE),
  MONTH        VARCHAR2(32 BYTE),
  RJF          NUMBER(10,2),
  FDF          NUMBER(10,2),
  KHRS         NUMBER(10),
  KYJF         NUMBER(10,2),
  PHF          NUMBER(10,2),
  ZYRS         NUMBER(10),
  SYJF         NUMBER(10,2),
  XBF          NUMBER(10,2),
  ZGDF         NUMBER(10,2)                     DEFAULT 0,
  ZDDF         NUMBER(10,2)                     DEFAULT 0,
  JQFKYF       NUMBER(10,2)                     DEFAULT 0,
  DDBF         NUMBER(10,2)                     DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JFKH_YJ_INFO CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_YJ_INFO
(
  ID    VARCHAR2(32 BYTE),
  JBF   NUMBER(10,2)                            DEFAULT 0,
  WHGR  NUMBER(10,2)                            DEFAULT 0,
  WMJZ  NUMBER(10,2)                            DEFAULT 0,
  PHF   NUMBER(10,2)                            DEFAULT 0,
  GJ    NUMBER(10,2)                            DEFAULT 0,
  FJQ   NUMBER(10,2)                            DEFAULT 0,
  JQ    NUMBER(10,2)                            DEFAULT 0,
  JY    NUMBER(10,2)                            DEFAULT 0,
  DJG   NUMBER(10,2)                            DEFAULT 0,
  ZJ    NUMBER(10,2)                            DEFAULT 0,
  FLAG  VARCHAR2(32 BYTE),
  YJID  VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_ZF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_ZF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_ZF
(
  ID             VARCHAR2(32 BYTE)              NOT NULL,
  ZF_ID          VARCHAR2(32 BYTE),
  C_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE),
  U_DATE         DATE,
  ZF_FH          VARCHAR2(20 BYTE),
  ZF_NAME        VARCHAR2(60 BYTE),
  ZF_DEPID       VARCHAR2(20 BYTE),
  BIRTHDAY       DATE,
  ZM             VARCHAR2(80 BYTE),
  XQ             VARCHAR2(20 BYTE),
  XQQR           DATE,
  XQZR           DATE,
  DR_DATE        DATE,
  FGDJ           VARCHAR2(60 BYTE),
  JGGJ           VARCHAR2(20 BYTE),
  ZY_FLAG        VARCHAR2(10 BYTE),
  LB             VARCHAR2(60 BYTE),
  LBC            VARCHAR2(60 BYTE),
  LH             VARCHAR2(100 BYTE),
  JFKS_DATE      DATE,
  CHK            VARCHAR2(10 BYTE),
  WCNF           VARCHAR2(10 BYTE),
  NOTSCORE_FLAG  VARCHAR2(10 BYTE),
  BRZ            VARCHAR2(1 BYTE),
  BJTS           VARCHAR2(30 BYTE),
  LXID           VARCHAR2(60 BYTE),
  BJREASON       VARCHAR2(100 BYTE),
  JQFFLAG        VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_ZFLX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_ZFLX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_ZFLX
(
  ID        VARCHAR2(64 BYTE),
  LXTYPE    VARCHAR2(8 BYTE),
  LXDES     VARCHAR2(50 BYTE),
  DEL_FLAG  VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY
(
  ZF_ID          VARCHAR2(12 BYTE)              NOT NULL,
  NOTSCORE_FLAG  VARCHAR2(1 BYTE),
  BRZ            VARCHAR2(1 BYTE),
  BJTS           VARCHAR2(8 BYTE),
  BJREASON       VARCHAR2(300 BYTE),
  JQFFLAG        VARCHAR2(1 BYTE),
  YEAR           VARCHAR2(4 BYTE),
  MONTH          VARCHAR2(2 BYTE),
  DB             VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_JXJS_ZF_XQBG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_JXJS_ZF_XQBG
(
  XQBG_NO       VARCHAR2(32 BYTE)               NOT NULL,
  BD_TYPE       VARCHAR2(20 BYTE),
  PJ_DATE       DATE,
  PJ_NO1        VARCHAR2(32 BYTE),
  PJ_NO2        VARCHAR2(8 BYTE),
  CD_FD         VARCHAR2(32 BYTE),
  ZX_DATE       DATE,
  MEMO          VARCHAR2(4000 BYTE),
  C_USER        VARCHAR2(32 BYTE),
  CB_DATE       DATE,
  ZF_NAME       VARCHAR2(100 BYTE),
  BQNDH         VARCHAR2(10 BYTE),
  BQAJZH        VARCHAR2(10 BYTE),
  BQAJBH        VARCHAR2(10 BYTE),
  IMPORT_FLAG   VARCHAR2(1 BYTE),
  ZF_XB         VARCHAR2(2 BYTE),
  ZF_NL         VARCHAR2(10 BYTE),
  DOWNLOAD_NUM  NUMBER,
  ZF_ID         VARCHAR2(32 BYTE),
  JY_ID         VARCHAR2(32 BYTE),
  JY_XQBG_NO    VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_LOGS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_LOGS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_LOGS
(
  TIME      DATE,
  USERID    VARCHAR2(32 BYTE),
  MODEL     VARCHAR2(255 BYTE),
  ACTION    VARCHAR2(255 BYTE),
  ZF_ID     VARCHAR2(500 BYTE),
  OPRESULT  VARCHAR2(255 BYTE),
  ID        VARCHAR2(32 BYTE)                   NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_MINGCE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_MINGCE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_MINGCE
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  PROCEDURE_NAME  VARCHAR2(32 BYTE),
  TITLE           VARCHAR2(200 BYTE),
  COLUMN_TITLE    VARCHAR2(500 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  C_USER          VARCHAR2(32 BYTE),
  U_USER          VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_PHOTO_ZFID CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_PHOTO_ZFID
(
  YH     VARCHAR2(32 BYTE),
  ZF_ID  VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_PROM_INFO DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_PROM_INFO CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_PROM_INFO
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  INFO       VARCHAR2(4000 BYTE),
  TITLE      VARCHAR2(500 BYTE),
  DELFLAG    VARCHAR2(1 BYTE)                   DEFAULT 0,
  AUTHORID   VARCHAR2(32 BYTE),
  STARTDATE  DATE,
  ENDDATE    DATE,
  SENDTO     VARCHAR2(64 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_RC_GZJS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_RC_GZJS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_RC_GZJS
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  JSDATE    DATE,
  JSTYPE    VARCHAR2(32 BYTE),
  SZDB      VARCHAR2(32 BYTE),
  MEMO      VARCHAR2(2000 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_RC_GZJS_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_RC_GZJS_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  JSDATE    DATE,
  JSTYPE    VARCHAR2(32 BYTE),
  SZDB      VARCHAR2(32 BYTE),
  MEMO      VARCHAR2(2000 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_RC_THDJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_RC_THDJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_RC_THDJ
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE)                  NOT NULL,
  THDATE     DATE,
  SHDATE     DATE,
  THYY       VARCHAR2(4000 BYTE),
  THDW_XZQH  VARCHAR2(255 BYTE),
  THDW_ARDD  VARCHAR2(2000 BYTE),
  THQX       VARCHAR2(8 BYTE),
  THRNAME    VARCHAR2(255 BYTE),
  THRDH      VARCHAR2(255 BYTE),
  SZDB       VARCHAR2(255 BYTE),
  COMMENTS   VARCHAR2(2000 BYTE),
  DEL_FLAG   VARCHAR2(1 BYTE),
  C_DATE     DATE,
  U_DATE     DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST
(
  AUTH_ID  VARCHAR2(32 BYTE)                    NOT NULL,
  ROLE_ID  VARCHAR2(32 BYTE)                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ROLE_TEST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ROLE_TEST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ROLE_TEST
(
  ROLE_ID    VARCHAR2(32 BYTE)                  NOT NULL,
  ROLE_NAME  VARCHAR2(50 BYTE),
  ROLE_DESC  VARCHAR2(200 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_SFWS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_SFWS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SFWS
(
  SFWSID     VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  SFWS_TYPE  VARCHAR2(32 BYTE),
  SFWS_NO1   VARCHAR2(64 BYTE),
  SFWS_NO2   VARCHAR2(64 BYTE),
  WS_NR      BLOB,
  C_DATE     DATE,
  U_DATE     DATE,
  DB         VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_SFWSNO DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_SFWSNO CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SFWSNO
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  SFWS_TYPE  VARCHAR2(4 BYTE),
  SFWS_NO    NUMBER(7),
  SFWS_ZNO   VARCHAR2(60 BYTE),
  DB         VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_SFWS_MR DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_SFWS_MR CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SFWS_MR
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  SFWSTYPE  VARCHAR2(4 BYTE),
  COL_NO    VARCHAR2(512 BYTE),
  ROW_NO    VARCHAR2(512 BYTE),
  PAGE_NO   VARCHAR2(512 BYTE),
  DEF_STR   VARCHAR2(4000 BYTE),
  DB        VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_SWDJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_SWDJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SWDJ
(
  ZF_ID       VARCHAR2(12 BYTE)                 NOT NULL,
  SWDATE      DATE                              NOT NULL,
  SWYYJG      VARCHAR2(1000 BYTE),
  CENSORIDEA  VARCHAR2(1000 BYTE),
  SCDATE      DATE,
  YYJD        VARCHAR2(1000 BYTE),
  YYJDDATE    DATE,
  YYNAME      VARCHAR2(200 BYTE),
  JCYRESULT   VARCHAR2(1000 BYTE),
  JCUNIT      VARCHAR2(10 BYTE),
  JCYJDDATE   DATE,
  STDEALTYPE  VARCHAR2(1 BYTE),
  STGHDEAL    VARCHAR2(1000 BYTE),
  SWTIME      VARCHAR2(20 BYTE)                 NOT NULL,
  PCS         VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_SWJD DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_SWJD CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SWJD
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  YY_JY           VARCHAR2(4000 BYTE),
  FY_NAME         VARCHAR2(32 BYTE),
  JDJG_NAME       VARCHAR2(64 BYTE),
  FY_JY           VARCHAR2(2000 BYTE),
  FY_DATE         DATE,
  JY_JY           VARCHAR2(2000 BYTE),
  JY_DATE         DATE,
  JCJG_ADDR_XZQH  VARCHAR2(12 BYTE),
  JCJG_RESULT     VARCHAR2(1000 BYTE),
  JCJG_DATE       DATE,
  STCL            VARCHAR2(2000 BYTE),
  STCLQK          VARCHAR2(2000 BYTE),
  QSDB            VARCHAR2(32 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  C_USER          VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_SYNC_REPORT CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_SYNC_REPORT
(
  ID           VARCHAR2(32 BYTE)                NOT NULL,
  DEPT         VARCHAR2(32 BYTE),
  SYNC_STATUS  VARCHAR2(1 BYTE),
  REPORT_TIME  DATE,
  CREATE_TIME  DATE,
  UPDATE_TIME  DATE,
  DEL_FLAG     VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_TAB_RELATION DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_TAB_RELATION CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_TAB_RELATION
(
  TAB_ID      VARCHAR2(32 BYTE)                 NOT NULL,
  M_TABNAME   VARCHAR2(255 BYTE)                NOT NULL,
  M_TABCNAME  VARCHAR2(255 BYTE),
  F_TABNAME   VARCHAR2(255 BYTE)                NOT NULL,
  F_TABCNAME  VARCHAR2(255 BYTE),
  COL_CNAME   VARCHAR2(255 BYTE)                NOT NULL,
  COL_NAME    VARCHAR2(255 BYTE)                NOT NULL,
  U_DATE      DATE
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_TGZF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_TGZF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_TGZF
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  TG_LB     VARCHAR2(240 BYTE),
  BQ_DW     VARCHAR2(100 BYTE),
  BQZC      VARCHAR2(100 BYTE),
  BQZW      VARCHAR2(100 BYTE),
  JKZK      VARCHAR2(1000 BYTE),
  HZ_NO     VARCHAR2(200 BYTE),
  HZ_QR     DATE,
  HZ_ZR     DATE,
  SF_NO     VARCHAR2(100 BYTE),
  GY_FS     VARCHAR2(255 BYTE),
  IS_ZY_ZF  VARCHAR2(255 BYTE),
  EN_NAME   VARCHAR2(200 BYTE),
  M_NAME    VARCHAR2(200 BYTE),
  EN_FNAME  VARCHAR2(200 BYTE),
  TBR       VARCHAR2(50 BYTE),
  SHR       VARCHAR2(50 BYTE),
  TBRQ      DATE,
  TG_CY_MJ  VARCHAR2(255 BYTE),
  MEMO      VARCHAR2(1000 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_THJH DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_THJH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_THJH
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  THJH_TYPE       VARCHAR2(6 BYTE),
  TH_TYPE         VARCHAR2(6 BYTE),
  TH_REASON       VARCHAR2(4000 BYTE),
  THR             VARCHAR2(32 BYTE),
  TH_DW           VARCHAR2(256 BYTE),
  DW_ADDR_XZQH    VARCHAR2(16 BYTE),
  DW_ADDR_DETAIL  VARCHAR2(256 BYTE),
  NY_ADDR_XZQH    VARCHAR2(16 BYTE),
  NY_ADDR_DETAIL  VARCHAR2(256 BYTE),
  TD_NO1          VARCHAR2(64 BYTE),
  TD_NO2          VARCHAR2(64 BYTE),
  LXR             VARCHAR2(128 BYTE),
  TEL             VARCHAR2(128 BYTE),
  SP_YJ           VARCHAR2(4000 BYTE),
  JBR             VARCHAR2(32 BYTE),
  TH_DATE         DATE,
  TH_RESULT       VARCHAR2(4000 BYTE),
  NSH_DATE        DATE,
  SH_DATE         DATE,
  C_USER          VARCHAR2(64 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  SZ_DB           VARCHAR2(6 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_USER_TEST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_USER_TEST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_USER_TEST
(
  USER_ID   VARCHAR2(10 BYTE)                   NOT NULL,
  ROLE_ID   VARCHAR2(32 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DEPT_ID   VARCHAR2(32 BYTE),
  JFQX      VARCHAR2(40 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_WSSP DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_WSSP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_WSSP
(
  ID               VARCHAR2(32 BYTE)            NOT NULL,
  ZF_ID            VARCHAR2(12 BYTE),
  SPB_TYPE         VARCHAR2(6 BYTE),
  CONTENT          BLOB,
  C_DATE           DATE,
  U_DATE           DATE,
  DEL_FLAG         CHAR(1 BYTE),
  DEPT_FILTERCODE  VARCHAR2(32 BYTE),
  PC_NO            VARCHAR2(6 BYTE),
  SORT_NO          VARCHAR2(16 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_WSSP_MR DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_WSSP_MR CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_WSSP_MR
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  SP_TYPE  VARCHAR2(32 BYTE),
  SP_COL   VARCHAR2(1024 BYTE),
  SP_ROW   VARCHAR2(1024 BYTE),
  SP_YM    VARCHAR2(1024 BYTE),
  MR_STR   VARCHAR2(4000 BYTE),
  DB       VARCHAR2(16 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_BM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_BM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_BM
(
  ID                VARCHAR2(255 BYTE)          NOT NULL,
  PARENTID          VARCHAR2(255 BYTE),
  SXH               NUMBER(10),
  SM                VARCHAR2(255 BYTE),
  LRM               VARCHAR2(255 BYTE),
  BM                VARCHAR2(255 BYTE),
  CREATETIME        DATE,
  LASTMODIFIEDTIME  DATE,
  REMOVEFLAG        VARCHAR2(255 BYTE),
  LBID              VARCHAR2(255 BYTE)          NOT NULL,
  CANBEMODIFY       VARCHAR2(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_XT_BML CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_BML
(
  ID           VARCHAR2(255 BYTE),
  NAME         VARCHAR2(255 BYTE),
  MEMO         VARCHAR2(2000 BYTE),
  TYPE         VARCHAR2(10 BYTE),
  CANBEMODIFY  CHAR(1 BYTE),
  ORDERNO      NUMBER(10)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_CHKITEMS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_CHKITEMS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_CHKITEMS
(
  ID        VARCHAR2(64 BYTE),
  PARENTID  VARCHAR2(64 BYTE),
  SELFIELD  VARCHAR2(100 BYTE),
  SELNOTES  VARCHAR2(100 BYTE),
  ERRMSG    VARCHAR2(100 BYTE),
  TABLES    VARCHAR2(100 BYTE),
  SQLWHERE  VARCHAR2(500 BYTE),
  CHKORDER  NUMBER,
  DEL_FALG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_CHKMODUL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_CHKMODUL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_CHKMODUL
(
  ID        VARCHAR2(64 BYTE),
  CHKORDER  NUMBER,
  CAP       VARCHAR2(100 BYTE),
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_XT_CHKR CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_CHKR
(
  SESSIONID  VARCHAR2(64 BYTE),
  ZF_ID      VARCHAR2(12 BYTE),
  ZF_FH      VARCHAR2(6 BYTE),
  ZFNAME     VARCHAR2(100 BYTE),
  DB         VARCHAR2(32 BYTE),
  MNAME      VARCHAR2(100 BYTE),
  MSG1       VARCHAR2(500 BYTE),
  MSG2       VARCHAR2(500 BYTE),
  SORDER     NUMBER,
  DEL_FLAG   CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_DIMEN DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_DIMEN CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_DIMEN
(
  ID           VARCHAR2(32 BYTE)                NOT NULL,
  TYPE         VARCHAR2(255 BYTE),
  FIELDID      VARCHAR2(255 BYTE),
  NAME         VARCHAR2(255 BYTE),
  SYSTEMDIMEN  VARCHAR2(1 BYTE),
  FLAGCODE     VARCHAR2(255 BYTE),
  DWTJUSE      VARCHAR2(1 BYTE),
  RAWID        VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_DIMENMEMBER DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_DIMENMEMBER CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_DIMENMEMBER
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  DIMENID    VARCHAR2(255 BYTE),
  TYPE       VARCHAR2(255 BYTE),
  PARENTID   VARCHAR2(32 BYTE),
  NAME       VARCHAR2(255 BYTE),
  ORDERCODE  NUMBER,
  CHECKED    VARCHAR2(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER
(
  ID     VARCHAR2(255 BYTE)                     NOT NULL,
  VALUE  VARCHAR2(2000 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE
(
  ID                        VARCHAR2(32 BYTE)   NOT NULL,
  XAXISDIMENID              VARCHAR2(32 BYTE),
  YAXISDIMENID              VARCHAR2(32 BYTE),
  AAXISDIMENID              VARCHAR2(2000 BYTE),
  AAXISDIMENMEMBERID        VARCHAR2(2000 BYTE),
  ISCONTRASTED              VARCHAR2(5 BYTE),
  STARTDATE                 DATE,
  ENDDATE                   DATE,
  TJLIMITS                  VARCHAR2(5 BYTE),
  DB                        VARCHAR2(32 BYTE),
  DBNAME                    VARCHAR2(255 BYTE),
  ZYJZ                      DATE,
  DBSTARTDATE               DATE,
  DBENDDATE                 DATE,
  DBJZ                      DATE,
  ADDEDCONDITIONEXPRESSION  VARCHAR2(2000 BYTE),
  SHOWEMPTYROW              VARCHAR2(5 BYTE),
  SHOWEMPTYCOL              VARCHAR2(5 BYTE),
  SHOWTOT                   VARCHAR2(5 BYTE),
  SHOWZJ                    VARCHAR2(5 BYTE),
  NAME                      VARCHAR2(255 BYTE),
  USERID                    VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_EDITBM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_EDITBM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_EDITBM
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  TABLEID  VARCHAR2(40 BYTE),
  FIELDID  VARCHAR2(40 BYTE),
  BMLB     VARCHAR2(5 BYTE),
  ORDERID  VARCHAR2(2 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_HOST DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_HOST CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_HOST
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  SM        VARCHAR2(100 BYTE),
  BM        VARCHAR2(20 BYTE),
  PATH      VARCHAR2(200 BYTE),
  HOSTADDR  VARCHAR2(50 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_XT_MRZ_ITEM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_MRZ_ITEM
(
  MIMODULEID  VARCHAR2(32 BYTE),
  MIID        VARCHAR2(32 BYTE),
  MICODE      VARCHAR2(255 BYTE),
  MINAME      VARCHAR2(255 BYTE),
  MIBML       VARCHAR2(255 BYTE),
  MIBMLTYPE   VARCHAR2(10 BYTE),
  MIBM        VARCHAR2(255 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_XT_MRZ_MODULE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_MRZ_MODULE
(
  MCID      VARCHAR2(32 BYTE),
  MCCODE    VARCHAR2(255 BYTE),
  MCNAME    VARCHAR2(255 BYTE),
  MCBITPOS  NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_MRZ_USED DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_MRZ_USED CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_MRZ_USED
(
  MUID    VARCHAR2(32 BYTE),
  MUUSED  CHAR(20 BYTE),
  ZF_ID   VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_PARA DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_PARA CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_PARA
(
  PARAID       VARCHAR2(255 BYTE)               NOT NULL,
  PARANAME     VARCHAR2(255 BYTE),
  PARACOMMENT  VARCHAR2(255 BYTE),
  PARAVALUE    VARCHAR2(2000 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_QUERYCONFIG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_QUERYCONFIG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_QUERYCONFIG
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  QCNAME        VARCHAR2(32 BYTE),
  SQL           VARCHAR2(4000 BYTE),
  COLUMN_TITLE  VARCHAR2(1000 BYTE),
  MEMO          VARCHAR2(500 BYTE),
  FIELD1        VARCHAR2(4000 BYTE),
  FIELD2        VARCHAR2(200 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  C_USER        VARCHAR2(32 BYTE),
  U_USER        VARCHAR2(32 BYTE),
  SQL_CLOB      CLOB
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER
(
  ID          VARCHAR2(255 BYTE)                NOT NULL,
  STARTPOINT  VARCHAR2(255 BYTE),
  ENDPOINT    VARCHAR2(255 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_XT_WEB_POPEDOM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_XT_WEB_POPEDOM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_WEB_POPEDOM
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  ROLE_ID       VARCHAR2(32 BYTE),
  WEB           VARCHAR2(40 BYTE),
  FIELDNAME     VARCHAR2(40 BYTE),
  FIELDPOPEDOM  CHAR(1 BYTE),
  RANGE         CHAR(1 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  FIELDDES      VARCHAR2(40 BYTE),
  WEBDES        VARCHAR2(40 BYTE),
  FIELDTYPE     CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_XT_ZH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_XT_ZH
(
  ZH_CN  VARCHAR2(2 BYTE),
  PY     VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZFKG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZFKG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZFKG
(
  ID           VARCHAR2(32 BYTE)                NOT NULL,
  ZF_ID        VARCHAR2(12 BYTE),
  KG_DATE      DATE,
  SJR          VARCHAR2(32 BYTE),
  LD_YJ        VARCHAR2(1000 BYTE),
  SJ_DEP       VARCHAR2(32 BYTE),
  ZDD_DEP      VARCHAR2(32 BYTE),
  ZD_DATE      DATE,
  ZDJSR        VARCHAR2(32 BYTE),
  KG_CONTENT   VARCHAR2(2000 BYTE),
  IS_VERIFIED  VARCHAR2(20 BYTE),
  RESULT       VARCHAR2(1000 BYTE),
  MEMO         VARCHAR2(1000 BYTE),
  C_DATE       DATE,
  U_DATE       DATE,
  DEL_FLAG     CHAR(1 BYTE),
  ZD_NO1       VARCHAR2(64 BYTE),
  ZD_NO2       VARCHAR2(64 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZFKG_MB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZFKG_MB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZFKG_MB
(
  KG_ID    VARCHAR2(32 BYTE)                    NOT NULL,
  ID       VARCHAR2(32 BYTE),
  KG_NAME  VARCHAR2(64 BYTE),
  KG_ZW    VARCHAR2(64 BYTE),
  KG_SF    VARCHAR2(64 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZFLJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZFLJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZFLJ
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  LJ_TYPE         VARCHAR2(20 BYTE),
  LJ_DOC_NO       VARCHAR2(64 BYTE),
  LJ_ADDR_XZQH    VARCHAR2(16 BYTE),
  LJ_ADDR_DETAIL  VARCHAR2(256 BYTE),
  LJ_POL          VARCHAR2(32 BYTE),
  LJ_DATE         DATE,
  PJ_NO1          VARCHAR2(16 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJXZQH          VARCHAR2(32 BYTE),
  PJJG            VARCHAR2(32 BYTE),
  PJDATE          DATE,
  C_USER          VARCHAR2(64 BYTE),
  LJ_STATUS       CHAR(1 BYTE),
  SJ_DATE         DATE,
  DR_DATE         DATE,
  YDB             VARCHAR2(32 BYTE),
  MEMO            VARCHAR2(1000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZFSS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZFSS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZFSS
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  ZF_DB      VARCHAR2(16 BYTE),
  SS_DATE    DATE,
  ZY_REASON  VARCHAR2(500 BYTE),
  SEND_DEP   VARCHAR2(64 BYTE),
  SEND_DATE  DATE,
  DF_DATE    DATE,
  FS_DW      VARCHAR2(64 BYTE),
  MEMO       VARCHAR2(1000 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE),
  SS_TYPE    VARCHAR2(6 BYTE),
  SS_RESULT  VARCHAR2(6 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZFSSXX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZFSSXX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZFSSXX
(
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  ZF_ID       VARCHAR2(12 BYTE),
  SP_ID       VARCHAR2(10 BYTE),
  SS_DW       VARCHAR2(100 BYTE),
  SS_PCS      VARCHAR2(6 BYTE),
  ZZ_LB       VARCHAR2(6 BYTE),
  SS_LB       VARCHAR2(6 BYTE),
  SS_QR       DATE,
  SS_ZR       DATE,
  PZ_DATE     DATE,
  ZX_DATE     DATE,
  LJ_DATE     DATE,
  HJ_DATE     DATE,
  SS_CONTENT  VARCHAR2(500 BYTE),
  MEMO        VARCHAR2(500 BYTE),
  C_DATE      DATE,
  U_DATE      DATE,
  DEL_FLAG    CHAR(1 BYTE),
  DW_XZQH     VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_BH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_BH
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  ZF_ID         VARCHAR2(12 BYTE)               NOT NULL,
  RUN_CASE_NO   VARCHAR2(20 BYTE),
  CATCH_DATE    DATE,
  CATCH_TYPE    VARCHAR2(6 BYTE),
  CATCH_COURSE  VARCHAR2(4000 BYTE),
  CRI_INFO      VARCHAR2(4000 BYTE),
  LESSON        VARCHAR2(4000 BYTE),
  CL_YJ         VARCHAR2(4000 BYTE),
  XWC_YJ        VARCHAR2(1000 BYTE),
  XWC_QPR       VARCHAR2(32 BYTE),
  XWC_QP_DATE   DATE,
  JAIL_YJ       VARCHAR2(1000 BYTE),
  JAIL_QPR      VARCHAR2(32 BYTE),
  JAIL_QP_DATE  DATE,
  MEMO          VARCHAR2(4000 BYTE),
  C_DATE        DATE                            NOT NULL,
  U_DATE        DATE                            NOT NULL,
  DEL_FLAG      CHAR(1 BYTE)                    NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_BSJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_BSJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_BSJ
(
  BSJ_NO        VARCHAR2(32 BYTE)               NOT NULL,
  ZF_ID         VARCHAR2(12 BYTE),
  TZS_NO1       VARCHAR2(8 BYTE),
  TZS_NO2       VARCHAR2(16 BYTE),
  PJ_DEPT       VARCHAR2(6 BYTE),
  PJ_JG         VARCHAR2(64 BYTE),
  XDZXTZS_DATE  DATE,
  YS_UNIT_AREA  VARCHAR2(6 BYTE),
  YS_UNIT_ADDR  VARCHAR2(64 BYTE),
  YSR           VARCHAR2(32 BYTE),
  SEND_DATE     DATE,
  JBR           VARCHAR2(32 BYTE),
  BSJ_TYPE      VARCHAR2(6 BYTE),
  BSJ_REASON    VARCHAR2(1024 BYTE),
  UNTREAD_DATE  DATE,
  SY_STATUS     VARCHAR2(6 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE),
  ZF_NAME       VARCHAR2(32 BYTE),
  XB            VARCHAR2(32 BYTE),
  CSRQ          VARCHAR2(32 BYTE),
  XQ            VARCHAR2(32 BYTE),
  ZM            VARCHAR2(60 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_BWXB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_BWXB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_BWXB
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  PZDATE     DATE,
  XBNX       VARCHAR2(8 BYTE),
  ENDDATE    DATE,
  SM         VARCHAR2(1000 BYTE),
  STARTDATE  DATE,
  DB         VARCHAR2(20 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   VARCHAR2(1 BYTE),
  JWBWID     VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_CRJ_INFO DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_CRJ_INFO CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_CRJ_INFO
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_DBDD DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_DBDD CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_DBDD
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  DD_DATE   DATE,
  DDQ_DB    VARCHAR2(32 BYTE),
  DDH_DB    VARCHAR2(32 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_DFBG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_DFBG
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  ZF_ID         VARCHAR2(12 BYTE),
  DD_DATE       VARCHAR2(20 BYTE),
  DDQ_DW        VARCHAR2(32 BYTE),
  DDH_DW        VARCHAR2(32 BYTE),
  RECEIVE_FLAG  CHAR(1 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE),
  ZF_NAME       VARCHAR2(32 BYTE),
  ZF_FH         VARCHAR2(32 BYTE),
  SYNC_FILE     VARCHAR2(64 BYTE),
  SYNC_SUCCESS  CHAR(1 BYTE),
  CZ_DATE       VARCHAR2(20 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_DSJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_DSJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_DSJ
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  JSDATE     DATE,
  JSTYPE     VARCHAR2(20 BYTE),
  JSCONTENT  VARCHAR2(1000 BYTE),
  JSJG       VARCHAR2(1000 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   VARCHAR2(1 BYTE),
  DB         VARCHAR2(20 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FGDJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FGDJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FGDJ
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  PZ_DATE   DATE,
  BDH_DJ    VARCHAR2(32 BYTE),
  BDQ_DJ    VARCHAR2(32 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DB        VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_FJXX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FJXX
(
  ZF_ID   VARCHAR2(12 BYTE),
  YPDYZM  VARCHAR2(255 BYTE),
  YPXQ    VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FK DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FK
(
  ZF_ID              VARCHAR2(12 BYTE)          NOT NULL,
  BQDW_ADDR_XZQH     VARCHAR2(32 BYTE),
  BQDW_ADDR_DETAIL   VARCHAR2(200 BYTE),
  BIRTH_ADDR_XZQH    VARCHAR2(32 BYTE),
  BIRTH_ADDR_DETAIL  VARCHAR2(200 BYTE),
  JS_NO              VARCHAR2(24 BYTE),
  CW_NO              VARCHAR2(24 BYTE),
  JGGJ               VARCHAR2(50 BYTE),
  DACY_MJ            VARCHAR2(64 BYTE),
  MEDIA_FILE_NO      VARCHAR2(32 BYTE),
  RJ_MEMO            VARCHAR2(4000 BYTE),
  PARTY_MEMO         VARCHAR2(4000 BYTE),
  FEEDBACK           VARCHAR2(4000 BYTE),
  C_DATE             DATE,
  U_DATE             DATE,
  DEL_FLAG           CHAR(1 BYTE),
  FZ_FACT            CLOB
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FLFA DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FLFA CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FLFA
(
  PLAN_NO       VARCHAR2(32 BYTE)               NOT NULL,
  PLAN_NAME     VARCHAR2(64 BYTE),
  FOUNDER       VARCHAR2(64 BYTE),
  CREATED_DATE  DATE,
  MODIFID_DATE  DATE,
  CONFIRM_DATE  DATE,
  QR_FLAG       CHAR(1 BYTE),
  START_DATE    DATE,
  END_DATE      DATE,
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FLFAMC DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FLFAMC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FLFAMC
(
  PLAN_NO   VARCHAR2(32 BYTE),
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  YDB       VARCHAR2(20 BYTE),
  JSDWID    VARCHAR2(32 BYTE),
  FLREASON  VARCHAR2(500 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FLSZ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FLSZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FLSZ
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  JSDW     VARCHAR2(100 BYTE),
  MAX      NUMBER                               DEFAULT 0,
  CURHAVE  NUMBER                               DEFAULT 0,
  YFLFLAG  VARCHAR2(1 BYTE)                     DEFAULT 1
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_FLTEMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FLTEMP
(
  SESSIONID   VARCHAR2(36 BYTE),
  JSDWID      VARCHAR2(32 BYTE),
  JSDW        VARCHAR2(100 BYTE),
  FLSTATUS    VARCHAR2(1 BYTE),
  ZFID        VARCHAR2(12 BYTE),
  ZFFH        VARCHAR2(5 BYTE),
  ZFNAME      VARCHAR2(32 BYTE),
  PJJGXZQH    VARCHAR2(32 BYTE),
  PJJGZXJG    VARCHAR2(50 BYTE),
  PJZ         VARCHAR2(50 BYTE),
  PJH         VARCHAR2(16 BYTE),
  ZFSOURCE    VARCHAR2(64 BYTE),
  DB          VARCHAR2(32 BYTE),
  DRDATE      DATE,
  GENDER      VARCHAR2(32 BYTE),
  BIRTH       DATE,
  XQ          VARCHAR2(8 BYTE),
  XQENDDATE   DATE,
  FYTYPE      VARCHAR2(32 BYTE),
  ZM          VARCHAR2(500 BYTE),
  HJXZQH      VARCHAR2(32 BYTE),
  HJADDR      VARCHAR2(64 BYTE),
  LBC         VARCHAR2(32 BYTE),
  SJTYPE      VARCHAR2(32 BYTE),
  TIAOJIANMS  VARCHAR2(500 BYTE),
  BQWH        VARCHAR2(32 BYTE),
  BQZY        VARCHAR2(32 BYTE),
  LGF         VARCHAR2(32 BYTE),
  LJ          VARCHAR2(4 BYTE),
  QK          VARCHAR2(4 BYTE),
  YX          VARCHAR2(8 BYTE),
  FLREASON    VARCHAR2(500 BYTE),
  THFLAG      VARCHAR2(1 BYTE)                  DEFAULT 0,
  XSCY        VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_FLTJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_FLTJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FLTJ
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  JSDWID        VARCHAR2(32 BYTE),
  SQL           VARCHAR2(2000 BYTE),
  TEXT          VARCHAR2(2000 BYTE),
  TIAOJIANTYPE  VARCHAR2(1 BYTE),
  SM            VARCHAR2(500 BYTE),
  ZDZF          VARCHAR2(2000 BYTE),
  RS            VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_FYLX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_FYLX
(
  ID    NUMBER(10)                              NOT NULL,
  LB    VARCHAR2(2 BYTE),
  BM    VARCHAR2(8 BYTE),
  FJXX  VARCHAR2(50 BYTE),
  LRSJ  DATE,
  XGSJ  RAW(8)                                  NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_HBKC DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_HBKC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_HBKC
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  HBKCTYPE  VARCHAR2(20 BYTE),
  HBKCDATE  DATE,
  HBKCNAME  VARCHAR2(20 BYTE),
  HBKCLX    VARCHAR2(20 BYTE),
  JMZF      VARCHAR2(20 BYTE),
  JMQS      VARCHAR2(20 BYTE),
  JMDDZF    VARCHAR2(20 BYTE),
  JMPCS     VARCHAR2(20 BYTE),
  QK        VARCHAR2(1000 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  VARCHAR2(1 BYTE),
  JWBWID    VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_JK DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_JK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JK
(
  ZF_ID           VARCHAR2(12 BYTE)             NOT NULL,
  ZF_FH           VARCHAR2(5 BYTE),
  ZF_NAME         VARCHAR2(80 BYTE),
  ZB_NAME         VARCHAR2(80 BYTE),
  ZF_GENDER       VARCHAR2(32 BYTE),
  ZF_BIRTH        DATE,
  ZF_MZ           VARCHAR2(32 BYTE),
  ZF_MARRIAGE     VARCHAR2(32 BYTE),
  PJ_NO1          VARCHAR2(50 BYTE),
  PJ_NO2          VARCHAR2(16 BYTE),
  ZM              VARCHAR2(100 BYTE),
  XZ              VARCHAR2(32 BYTE),
  XQ              VARCHAR2(8 BYTE),
  XQ_START_DATE   DATE,
  XQ_END_DATE     DATE,
  BZNX            VARCHAR2(8 BYTE),
  ZF_SOURCE       VARCHAR2(64 BYTE),
  FY_TYPE         VARCHAR2(32 BYTE),
  NYDW            VARCHAR2(32 BYTE),
  JY_FLAG         CHAR(1 BYTE),
  JYXQ            VARCHAR2(8 BYTE),
  JY_START_DATE   DATE,
  JY_END_DATE     DATE,
  SJ_TYPE         VARCHAR2(32 BYTE),
  SY_STATUS       VARCHAR2(32 BYTE),
  SC_CA           VARCHAR2(32 BYTE),
  HJ_ADDR_XZQH    VARCHAR2(32 BYTE),
  HJ_ADDR_DETAIL  VARCHAR2(64 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  FL_FLAG         CHAR(1 BYTE),
  C_USER          VARCHAR2(32 BYTE),
  DB              VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_JK_20060526184028 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JK_20060526184028
(
  ZF_ID           VARCHAR2(12 BYTE)             NOT NULL,
  ZF_FH           VARCHAR2(5 BYTE),
  ZF_NAME         VARCHAR2(80 BYTE),
  ZB_NAME         VARCHAR2(80 BYTE),
  ZF_GENDER       VARCHAR2(32 BYTE),
  ZF_BIRTH        DATE,
  ZF_MZ           VARCHAR2(32 BYTE),
  ZF_MARRIAGE     VARCHAR2(32 BYTE),
  PJ_NO1          VARCHAR2(50 BYTE),
  PJ_NO2          VARCHAR2(16 BYTE),
  ZM              VARCHAR2(32 BYTE),
  XZ              VARCHAR2(32 BYTE),
  XQ              VARCHAR2(8 BYTE),
  XQ_START_DATE   DATE,
  XQ_END_DATE     DATE,
  BZNX            VARCHAR2(8 BYTE),
  ZF_SOURCE       VARCHAR2(64 BYTE),
  FY_TYPE         VARCHAR2(32 BYTE),
  NYDW            VARCHAR2(32 BYTE),
  JY_FLAG         CHAR(1 BYTE),
  JYXQ            VARCHAR2(8 BYTE),
  JY_START_DATE   DATE,
  JY_END_DATE     DATE,
  SJ_TYPE         VARCHAR2(32 BYTE),
  SY_STATUS       VARCHAR2(32 BYTE),
  SC_CA           VARCHAR2(32 BYTE),
  HJ_ADDR_XZQH    VARCHAR2(32 BYTE),
  HJ_ADDR_DETAIL  VARCHAR2(64 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  FL_FLAG         CHAR(1 BYTE),
  C_USER          VARCHAR2(32 BYTE),
  DB              VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_JL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_JL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JL
(
  ID              VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  START_DATE      VARCHAR2(32 BYTE),
  END_DATE        VARCHAR2(32 BYTE),
  DW_ADDR_XZQH    VARCHAR2(32 BYTE),
  DW_ADDR_DETAIL  VARCHAR2(200 BYTE),
  DW_MC           VARCHAR2(200 BYTE),
  ZF_ZY           VARCHAR2(32 BYTE),
  ZF_ZW           VARCHAR2(32 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  HJ_XZQH         VARCHAR2(32 BYTE),
  HJ_DETAIL       VARCHAR2(64 BYTE),
  XH              VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_JLXX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_JLXX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JLXX
(
  JL_NO        VARCHAR2(32 BYTE)                NOT NULL,
  ZF_ID        VARCHAR2(12 BYTE),
  SPB_NO       VARCHAR2(32 BYTE),
  TYPE         VARCHAR2(20 BYTE),
  REASON       VARCHAR2(300 BYTE),
  DETAIL_DESC  VARCHAR2(4000 BYTE),
  MEMO         VARCHAR2(4000 BYTE),
  C_DATE       DATE,
  U_DATE       DATE,
  DEL_FLAG     CHAR(1 BYTE),
  C_USER       VARCHAR2(32 BYTE),
  TZS_NO1      VARCHAR2(32 BYTE),
  TZS_NO2      VARCHAR2(32 BYTE),
  TZ_DATE      DATE,
  TZR          VARCHAR2(32 BYTE),
  START_DATE   DATE,
  END_DATE     DATE,
  STATUS       CHAR(1 BYTE),
  DB           VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_JLXX_BAK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JLXX_BAK
(
  JL_NO        VARCHAR2(32 BYTE)                NOT NULL,
  ZF_ID        VARCHAR2(12 BYTE),
  SPB_NO       VARCHAR2(32 BYTE),
  TYPE         VARCHAR2(20 BYTE),
  REASON       VARCHAR2(300 BYTE),
  DETAIL_DESC  VARCHAR2(4000 BYTE),
  MEMO         VARCHAR2(4000 BYTE),
  C_DATE       DATE,
  U_DATE       DATE,
  DEL_FLAG     CHAR(1 BYTE),
  C_USER       VARCHAR2(32 BYTE),
  TZS_NO1      VARCHAR2(32 BYTE),
  TZS_NO2      VARCHAR2(32 BYTE),
  TZ_DATE      DATE,
  TZR          VARCHAR2(32 BYTE),
  START_DATE   DATE,
  END_DATE     DATE,
  STATUS       CHAR(1 BYTE),
  DB           VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_JWBW DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_JWBW CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_JWBW
(
  ID          VARCHAR2(32 BYTE)                 NOT NULL,
  ZF_ID       VARCHAR2(12 BYTE),
  ZXTYPE      VARCHAR2(20 BYTE),
  BRNAME      VARCHAR2(20 BYTE),
  BRRELATION  VARCHAR2(20 BYTE),
  BRADDRXZQH  VARCHAR2(20 BYTE),
  BRADDRESS   VARCHAR2(100 BYTE),
  BRDWXZQH    VARCHAR2(20 BYTE),
  BRDW        VARCHAR2(100 BYTE),
  BWADDRXZQH  VARCHAR2(20 BYTE),
  BWADDRESS   VARCHAR2(100 BYTE),
  POLICEXZQH  VARCHAR2(20 BYTE),
  POLICE      VARCHAR2(100 BYTE),
  OFFICER     VARCHAR2(20 BYTE),
  OFFICERTEL  VARCHAR2(20 BYTE),
  SJDATE      DATE,
  ZZTYPE      VARCHAR2(20 BYTE),
  DB          VARCHAR2(20 BYTE),
  MEMO        VARCHAR2(1000 BYTE),
  C_DATE      DATE,
  U_DATE      DATE,
  DEL_FLAG    VARCHAR2(1 BYTE),
  BRTEL       VARCHAR2(20 BYTE),
  HOSPITAL    VARCHAR2(100 BYTE),
  STARTDATE   DATE,
  SWREASON    VARCHAR2(1000 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_LBC DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_LBC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_LBC
(
  LBC_NO         VARCHAR2(32 BYTE)              NOT NULL,
  SP_ID          VARCHAR2(10 BYTE),
  ZF_ID          VARCHAR2(12 BYTE),
  LBCSP_NO       VARCHAR2(32 BYTE),
  LBC_TYPE       VARCHAR2(6 BYTE),
  SICK_HISTORY   VARCHAR2(4000 BYTE),
  BC_TYPE        VARCHAR2(6 BYTE),
  DJ_DATE        DATE,
  SC_INFO        VARCHAR2(2000 BYTE),
  BC_YJ          VARCHAR2(4000 BYTE),
  HOSPITAL_YJ    VARCHAR2(4000 BYTE),
  HOSPITAL_DATE  DATE,
  CXLBC_DATE     DATE,
  JD_YS1         VARCHAR2(20 BYTE),
  YS_ZW1         VARCHAR2(6 BYTE),
  YS_ZC1         VARCHAR2(6 BYTE),
  JD_YS2         VARCHAR2(20 BYTE),
  YS_ZW2         VARCHAR2(6 BYTE),
  YS_ZC2         VARCHAR2(6 BYTE),
  JD_YS3         VARCHAR2(20 BYTE),
  YS_ZW3         VARCHAR2(6 BYTE),
  YS_ZC3         VARCHAR2(6 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_LBC_FS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_LBC_FS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_LBC_FS
(
  LBC_ID    VARCHAR2(32 BYTE),
  ZF_ID     VARCHAR2(12 BYTE),
  LBC_TYPE  VARCHAR2(5 BYTE),
  PZ_DATE   DATE,
  FS_DATE   DATE,
  LBC_INFO  VARCHAR2(4000 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  ID        VARCHAR2(32 BYTE)                   NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_LBC_TMP1 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_LBC_TMP1
(
  LBC_NO         VARCHAR2(32 BYTE)              NOT NULL,
  SP_ID          VARCHAR2(10 BYTE),
  ZF_ID          VARCHAR2(12 BYTE),
  LBCSP_NO       VARCHAR2(32 BYTE),
  LBC_TYPE       VARCHAR2(6 BYTE),
  SICK_HISTORY   VARCHAR2(4000 BYTE),
  BC_TYPE        VARCHAR2(6 BYTE),
  DJ_DATE        DATE,
  SC_INFO        VARCHAR2(2000 BYTE),
  BC_YJ          VARCHAR2(4000 BYTE),
  HOSPITAL_YJ    VARCHAR2(4000 BYTE),
  HOSPITAL_DATE  DATE,
  CXLBC_DATE     DATE,
  JD_YS1         VARCHAR2(20 BYTE),
  YS_ZW1         VARCHAR2(6 BYTE),
  YS_ZC1         VARCHAR2(6 BYTE),
  JD_YS2         VARCHAR2(20 BYTE),
  YS_ZW2         VARCHAR2(6 BYTE),
  YS_ZC2         VARCHAR2(6 BYTE),
  JD_YS3         VARCHAR2(20 BYTE),
  YS_ZW3         VARCHAR2(6 BYTE),
  YS_ZC3         VARCHAR2(6 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE),
  NYDW           VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_LBC_TMP2 CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_LBC_TMP2
(
  LBC_NO         VARCHAR2(32 BYTE)              NOT NULL,
  SP_ID          VARCHAR2(10 BYTE),
  ZF_ID          VARCHAR2(12 BYTE),
  LBCSP_NO       VARCHAR2(32 BYTE),
  LBC_TYPE       VARCHAR2(6 BYTE),
  SICK_HISTORY   VARCHAR2(4000 BYTE),
  BC_TYPE        VARCHAR2(6 BYTE),
  DJ_DATE        DATE,
  SC_INFO        VARCHAR2(2000 BYTE),
  BC_YJ          VARCHAR2(4000 BYTE),
  HOSPITAL_YJ    VARCHAR2(4000 BYTE),
  HOSPITAL_DATE  DATE,
  CXLBC_DATE     DATE,
  JD_YS1         VARCHAR2(20 BYTE),
  YS_ZW1         VARCHAR2(6 BYTE),
  YS_ZC1         VARCHAR2(6 BYTE),
  JD_YS2         VARCHAR2(20 BYTE),
  YS_ZW2         VARCHAR2(6 BYTE),
  YS_ZC2         VARCHAR2(6 BYTE),
  JD_YS3         VARCHAR2(20 BYTE),
  YS_ZW3         VARCHAR2(6 BYTE),
  YS_ZC3         VARCHAR2(6 BYTE),
  C_DATE         DATE,
  U_DATE         DATE,
  DEL_FLAG       CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_MTXX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_MTXX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_MTXX
(
  MT_NO       VARCHAR2(32 BYTE)                 NOT NULL,
  ZF_ID       VARCHAR2(12 BYTE)                 NOT NULL,
  MT_TYPE     VARCHAR2(6 BYTE),
  MT_CONTENT  BLOB,
  C_DATE      DATE,
  U_DATE      DATE,
  DEL_FLAG    CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_MTXX_LOG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_MTXX_LOG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_MTXX_LOG
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  MT_TYPE    VARCHAR2(10 BYTE),
  OP_TYPE    VARCHAR2(1 BYTE),
  SYNC_FLAG  VARCHAR2(1 BYTE),
  C_DATE     DATE,
  U_DATE     DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_NFL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_NFL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_NFL
(
  PLAN_NO  VARCHAR2(32 BYTE)                    NOT NULL,
  JSDWID   VARCHAR2(32 BYTE)                    NOT NULL,
  AGE      NUMBER(4)                            DEFAULT 0,
  YX       NUMBER(4)                            DEFAULT 0,
  ZY       NUMBER(4)                            DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_NFL_TJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_NFL_TJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_NFL_TJ
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  JSDW      VARCHAR2(32 BYTE),
  COLTITLE  VARCHAR2(50 BYTE),
  TJTYPE    VARCHAR2(1 BYTE),
  SQL       VARCHAR2(4000 BYTE),
  TEXT      VARCHAR2(4000 BYTE),
  RS        NUMBER(4)                           DEFAULT 0,
  SCALE     NUMBER                              DEFAULT 0
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_NWFG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_NWFG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_NWFG
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  PZ_DATE    DATE,
  CH_REASON  VARCHAR2(3000 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   CHAR(1 BYTE),
  CX_DATE    DATE,
  SYQX       VARCHAR2(10 BYTE),
  FG         VARCHAR2(50 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_QJFJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_QJFJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_QJFJ
(
  ID                VARCHAR2(32 BYTE)           NOT NULL,
  SPB_NO            VARCHAR2(20 BYTE),
  ZF_ID             VARCHAR2(12 BYTE),
  JQ_START_DATE     DATE,
  JQ_END_DATE       DATE,
  LEAVE_DATE        DATE,
  BACK_DATE         DATE,
  BACK_TYPE         VARCHAR2(6 BYTE),
  LEAVE_TYPE        VARCHAR2(6 BYTE),
  LJ_JZD_ADDR_XZQH  VARCHAR2(6 BYTE),
  LJ_JZD_ADDR       VARCHAR2(100 BYTE),
  C_DATE            DATE,
  U_DATE            DATE,
  DEL_FLAG          CHAR(1 BYTE),
  PZJG              VARCHAR2(6 BYTE),
  PZ_DATE           DATE,
  QJ_TYPE           VARCHAR2(6 BYTE),
  QJ_REASON         VARCHAR2(500 BYTE),
  SZ_DB             VARCHAR2(20 BYTE),
  QJ_FJ_TYPE        VARCHAR2(6 BYTE),
  APPROVE_DATE      DATE,
  ZJ_TYPE           VARCHAR2(6 BYTE),
  MEMO              VARCHAR2(4000 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_QKLJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_QKLJ
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  QKLJ_LB    VARCHAR2(6 BYTE),
  LB         VARCHAR2(6 BYTE),
  QKLJTIMES  NUMBER                             DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_SFZF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_SFZF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_SFZF
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(30 BYTE),
  SFLB      VARCHAR2(100 BYTE),
  DEL_FLAG  VARCHAR2(1 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  SFLBALL   VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_SHGX DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_SHGX CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_SHGX
(
  ZF_ID            VARCHAR2(12 BYTE),
  SHGX_NO          VARCHAR2(32 BYTE)            NOT NULL,
  GX_NAME          VARCHAR2(100 BYTE),
  NAME             VARCHAR2(64 BYTE),
  AGE              VARCHAR2(12 BYTE),
  GENDER           VARCHAR2(64 BYTE),
  DW               VARCHAR2(64 BYTE),
  DW_ADDR_XZQH     VARCHAR2(64 BYTE),
  DW_ADDR_DETAIL   VARCHAR2(200 BYTE),
  ZW               VARCHAR2(64 BYTE),
  ZZD_ADDR_XZQH    VARCHAR2(64 BYTE),
  ZZD_ADDR_DETIAL  VARCHAR2(200 BYTE),
  ZZMM             VARCHAR2(64 BYTE),
  ZJ_TYPE          VARCHAR2(64 BYTE),
  ZJ_NO            VARCHAR2(36 BYTE),
  TELEPHONE        VARCHAR2(50 BYTE),
  C_DATE           DATE,
  U_DATE           DATE,
  DEL_FLAG         CHAR(1 BYTE),
  XH               VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_SJZF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_SJZF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_SJZF
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(30 BYTE),
  JNAME     VARCHAR2(1 BYTE),
  JADDRESS  VARCHAR2(1 BYTE),
  JDEGREE   VARCHAR2(1 BYTE),
  JSTORY    VARCHAR2(1 BYTE),
  DEL_FLAG  VARCHAR2(1 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  SJLB      VARCHAR2(10 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_SS DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_SS CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_SS
(
  SS_NO         VARCHAR2(32 BYTE)               NOT NULL,
  ZF_ID         VARCHAR2(12 BYTE),
  SS_DATE       DATE,
  CHECK_REASON  VARCHAR2(2048 BYTE),
  CHECK_DETAIL  VARCHAR2(2048 BYTE),
  CHECK_GJ      VARCHAR2(32 BYTE),
  CHECK_RESULT  VARCHAR2(2048 BYTE),
  CLGJ          VARCHAR2(32 BYTE),
  MEMO          VARCHAR2(4000 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_TAF DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_TAF CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TAF
(
  ZF_ID             VARCHAR2(12 BYTE),
  TAF_NO            VARCHAR2(32 BYTE)           NOT NULL,
  PJ_NO1            VARCHAR2(8 BYTE),
  PJ_NO2            VARCHAR2(16 BYTE),
  TAF_NAME          VARCHAR2(32 BYTE),
  TAF_GENDER        VARCHAR2(6 BYTE),
  BIRTH             DATE,
  CAREER            VARCHAR2(6 BYTE),
  ZM                VARCHAR2(64 BYTE),
  XZ                VARCHAR2(6 BYTE),
  XQ                VARCHAR2(8 BYTE),
  ZF_STATUS         VARCHAR2(6 BYTE),
  GYDW_ADDR_XZQH    VARCHAR2(6 BYTE),
  GYDW_ADDR_DETIAL  VARCHAR2(32 BYTE),
  HJ_ADDR_XZQH      VARCHAR2(6 BYTE),
  HJ_ADDR_DETAIL    VARCHAR2(32 BYTE),
  MEMO              VARCHAR2(4000 BYTE),
  C_DATE            DATE,
  U_DATE            DATE,
  DEL_FLAG          CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_TC DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_TC CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TC
(
  ZF_ID     VARCHAR2(12 BYTE),
  TC_CODE   VARCHAR2(32 BYTE),
  TC        VARCHAR2(100 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZF_TG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TG
(
  ZF_ID  VARCHAR2(12 BYTE)                      NOT NULL,
  TGLB   VARCHAR2(20 BYTE)                      NOT NULL,
  XH     VARCHAR2(5 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_TGSK DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_TGSK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TGSK
(
  ID         VARCHAR2(32 BYTE)                  NOT NULL,
  ZF_ID      VARCHAR2(12 BYTE),
  TYPE       VARCHAR2(1 BYTE),
  STARTDATE  DATE,
  ENDDATE    DATE,
  LHDATE     DATE,
  LHJGXZQH   VARCHAR2(20 BYTE),
  LHJG       VARCHAR2(20 BYTE),
  MEMO       VARCHAR2(1000 BYTE),
  C_DATE     DATE,
  U_DATE     DATE,
  DEL_FLAG   VARCHAR2(1 BYTE),
  JWBWID     VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_TMTZ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_TMTZ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TMTZ
(
  ZF_ID         VARCHAR2(12 BYTE)               NOT NULL,
  HEIGHT        VARCHAR2(10 BYTE),
  BODY_TYPE     VARCHAR2(32 BYTE),
  BLOOD_TYPE    VARCHAR2(32 BYTE),
  FACE_TYPE     VARCHAR2(32 BYTE),
  ACCENT        VARCHAR2(50 BYTE),
  FOOT_LEN      VARCHAR2(10 BYTE),
  SKIN_FEATURE  VARCHAR2(1000 BYTE),
  CHARACTER     VARCHAR2(256 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_TT DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_TT CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_TT
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  ZF_ID         VARCHAR2(12 BYTE)               NOT NULL,
  CASE_NO       VARCHAR2(20 BYTE),
  RUN_DATE      DATE,
  RUN_TYPE      VARCHAR2(6 BYTE),
  RUN_COURSE    VARCHAR2(4000 BYTE),
  MEASURE       VARCHAR2(4000 BYTE),
  XWC_YJ        VARCHAR2(1000 BYTE),
  XWC_QPR       VARCHAR2(32 BYTE),
  XWC_QP_DATE   DATE,
  JAIL_YJ       VARCHAR2(1000 BYTE),
  JAIL_QPR      VARCHAR2(32 BYTE),
  JAIL_QP_DATE  DATE,
  NOTICE_NO     VARCHAR2(40 BYTE),
  WANT_DATE     DATE,
  WANT_NO       VARCHAR2(40 BYTE),
  BH_STATUS     CHAR(1 BYTE),
  C_DATE        DATE,
  U_DATE        DATE,
  DEL_FLAG      CHAR(1 BYTE),
  RUN_ANALYSE   VARCHAR2(4000 BYTE),
  SZ_DB         VARCHAR2(20 BYTE),
  RUN_TIME      VARCHAR2(8 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH
(
  ID       VARCHAR2(32 BYTE)                    NOT NULL,
  STARTNO  NUMBER(8)                            NOT NULL,
  ENDNO    NUMBER(8)                            NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_XQBG DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_XQBG CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_XQBG
(
  XQBG_NO         VARCHAR2(32 BYTE)             NOT NULL,
  ZF_ID           VARCHAR2(12 BYTE),
  SPB_NO          VARCHAR2(32 BYTE),
  BD_TYPE         VARCHAR2(20 BYTE),
  JYJ_PZ_DATE     DATE,
  PJ_DATE         DATE,
  PJ_NO1          VARCHAR2(32 BYTE),
  PJ_NO2          VARCHAR2(32 BYTE),
  PJ_JG           VARCHAR2(50 BYTE),
  PJ_XZQH         VARCHAR2(32 BYTE),
  CD_FD           VARCHAR2(32 BYTE),
  BZ_NX           VARCHAR2(8 BYTE),
  XZ              VARCHAR2(20 BYTE),
  SJ_XQ           VARCHAR2(32 BYTE),
  YXQ             VARCHAR2(8 BYTE),
  YBZNX           VARCHAR2(8 BYTE),
  YXZ             VARCHAR2(20 BYTE),
  YXQ_START_DATE  DATE,
  YXQ_END_DATE    DATE,
  START_DATE      DATE,
  END_DATE        DATE,
  ZX_DATE         DATE,
  CD_SJ_QK        VARCHAR2(4000 BYTE),
  SPB_TYPE        CHAR(1 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE),
  YPJ_NO1         VARCHAR2(32 BYTE),
  YPJ_NO2         VARCHAR2(32 BYTE),
  YPJ_JG          VARCHAR2(50 BYTE),
  YPJ_XZQH        VARCHAR2(32 BYTE),
  YPJ_DATE        DATE,
  C_USER          VARCHAR2(32 BYTE),
  SZ_DB           VARCHAR2(32 BYTE),
  CB_DATE         DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_YJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_YJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_YJ
(
  ID              VARCHAR2(32 BYTE),
  ZF_ID           VARCHAR2(12 BYTE),
  DJ_DATE         DATE,
  SF_FLAG         CHAR(1 BYTE),
  MAIL_TYPE       VARCHAR2(6 BYTE),
  DF_NAME         VARCHAR2(64 BYTE),
  RELATION        VARCHAR2(50 BYTE),
  DF_ADDR_XZQH    VARCHAR2(32 BYTE),
  DF_ADDR_DETAIL  VARCHAR2(256 BYTE),
  DF_ZIP          VARCHAR2(64 BYTE),
  CONTENT         VARCHAR2(4000 BYTE),
  SEND_REASON     VARCHAR2(2048 BYTE),
  ZRGJ            VARCHAR2(32 BYTE),
  CLJG            VARCHAR2(2048 BYTE),
  MEMO            VARCHAR2(4000 BYTE),
  C_DATE          DATE,
  U_DATE          DATE,
  DEL_FLAG        CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_ZDFL DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_ZDFL CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_ZDFL
(
  ID      VARCHAR2(32 BYTE),
  FA_ID   VARCHAR2(32 BYTE),
  ZF_ID   VARCHAR2(12 BYTE),
  DXJY    VARCHAR2(100 BYTE),
  WTR     VARCHAR2(100 BYTE),
  WTRZW   VARCHAR2(100 BYTE),
  STR     VARCHAR2(100 BYTE),
  PZR     VARCHAR2(100 BYTE),
  FLDATE  DATE,
  MEMO    VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED
(
  ID            VARCHAR2(32 BYTE)               NOT NULL,
  ZFBH          NUMBER(8)                       NOT NULL,
  USER_ID       VARCHAR2(36 BYTE)               NOT NULL,
  SESSION_ID    VARCHAR2(36 BYTE)               NOT NULL,
  ALLOCATETIME  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_ZK DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_ZK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_ZK
(
  ZF_ID            VARCHAR2(12 BYTE)            NOT NULL,
  ZF_ADDR_XZQH     VARCHAR2(32 BYTE),
  ZF_ADDR_DETAIL   VARCHAR2(64 BYTE),
  FILE_NO          VARCHAR2(16 BYTE),
  RJ_DATE          DATE,
  DR_DATE          DATE,
  BH_NAME          VARCHAR2(64 BYTE),
  BQWH             VARCHAR2(32 BYTE),
  XWH              VARCHAR2(32 BYTE),
  BQZY             VARCHAR2(32 BYTE),
  BQMM             VARCHAR2(32 BYTE),
  ZF_NATION        VARCHAR2(32 BYTE),
  PCS              VARCHAR2(32 BYTE),
  JD               VARCHAR2(32 BYTE),
  SY_TYPE          VARCHAR2(32 BYTE),
  DBJG_XZQH        VARCHAR2(32 BYTE),
  DBJG_ZXJG        VARCHAR2(50 BYTE),
  DB_DATE          DATE,
  PJJG_XZQH        VARCHAR2(32 BYTE),
  PJJG_ZXJG        VARCHAR2(50 BYTE),
  PJ_DATE          DATE,
  YAF_TYPE         VARCHAR2(32 BYTE),
  XAF_TYPE         VARCHAR2(32 BYTE),
  YS_DEPT_XZQH     VARCHAR2(32 BYTE),
  YS_DEPT          VARCHAR2(32 BYTE),
  YS_NO1           VARCHAR2(32 BYTE),
  YS_NO2           VARCHAR2(32 BYTE),
  LJ_TIMES         VARCHAR2(4 BYTE),
  QK_TIMES         VARCHAR2(4 BYTE),
  LGF              VARCHAR2(32 BYTE),
  DB               VARCHAR2(32 BYTE),
  FG_LEVEL         VARCHAR2(32 BYTE),
  WORKER_LEVEL     VARCHAR2(32 BYTE),
  GZ               VARCHAR2(50 BYTE),
  NWFG             VARCHAR2(50 BYTE),
  ID_CARD          VARCHAR2(36 BYTE),
  HK_TYPE          VARCHAR2(32 BYTE),
  LC_TYPE          VARCHAR2(32 BYTE),
  JX_MEASURE       VARCHAR2(32 BYTE),
  LBC_FLAG         VARCHAR2(32 BYTE),
  CUR_START_DATE   DATE,
  CUR_END_DATE     DATE,
  CUR_BZNX         VARCHAR2(8 BYTE),
  CUR_XZ           VARCHAR2(32 BYTE),
  CURRENT_XQ       VARCHAR2(8 BYTE),
  LAST_START_DATE  DATE,
  LAST_END_DATE    DATE,
  LAST_FX_XZQH     VARCHAR2(32 BYTE),
  LAST_FX_JY       VARCHAR2(64 BYTE),
  JXHG_FLAG        CHAR(1 BYTE),
  SS_FLAG          CHAR(1 BYTE),
  TC               VARCHAR2(1000 BYTE),
  FJ               VARCHAR2(100 BYTE),
  C_DATE           DATE,
  U_DATE           DATE,
  DEL_FLAG         CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_ZM DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_ZM CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_ZM
(
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  ZM_CODE   VARCHAR2(6 BYTE)                    NOT NULL,
  ZM_SEQ    NUMBER(2),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZF_ZMBK DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZF_ZMBK CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZF_ZMBK
(
  XQBGNO  VARCHAR2(32 BYTE)                     NOT NULL,
  ZF_ID   VARCHAR2(12 BYTE),
  XH      VARCHAR2(5 BYTE),
  ZM      VARCHAR2(20 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_YZ_ZHTJ_FOR_TYPE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZHTJ_FOR_TYPE
(
  COL_1  VARCHAR2(100 BYTE),
  COL_2  VARCHAR2(100 BYTE),
  COL_3  NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZKBXDJ DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZKBXDJ CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZKBXDJ
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RQ        DATE,
  TH_QK     VARCHAR2(500 BYTE),
  LS_KZ_FF  VARCHAR2(500 BYTE),
  BX_QK     VARCHAR2(500 BYTE),
  MEMO      VARCHAR2(500 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  WWZK_ID   VARCHAR2(32 BYTE)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.T_YZ_ZKZFJB DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_YZ_ZKZFJB CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_YZ_ZKZFJB
(
  ID           VARCHAR2(32 BYTE)                NOT NULL,
  ZF_ID        VARCHAR2(12 BYTE),
  SZ_JY        VARCHAR2(6 BYTE),
  SP_ID        VARCHAR2(10 BYTE),
  ZK_PZ_RQ     DATE,
  LK_PZR       VARCHAR2(100 BYTE),
  ZK_TYPE      VARCHAR2(6 BYTE),
  JT_SY_1      VARCHAR2(500 BYTE),
  JT_SY_2      VARCHAR2(500 BYTE),
  JT_SY_3      VARCHAR2(500 BYTE),
  JT_SY_4      VARCHAR2(500 BYTE),
  ZK_REASON    VARCHAR2(6 BYTE),
  BJ_R_1       VARCHAR2(100 BYTE),
  BJ_R_2       VARCHAR2(100 BYTE),
  JG_GJ_1      VARCHAR2(100 BYTE),
  JG_GJ_2      VARCHAR2(100 BYTE),
  ZK_JB        VARCHAR2(6 BYTE),
  CK_PZ_RQ     DATE,
  MEMO         VARCHAR2(500 BYTE),
  C_DATE       DATE,
  U_DATE       DATE,
  DEL_FLAG     CHAR(1 BYTE),
  CBRQ         DATE,
  CXCBRQ       DATE,
  ZKXZ_1       VARCHAR2(6 BYTE),
  ZKXZ_2       VARCHAR2(6 BYTE),
  CXLY         VARCHAR2(500 BYTE),
  ZK_REASONSE  VARCHAR2(6 BYTE),
  CK_CBDATE    DATE
)
NOLOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.WLJ_ID_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.WLJ_ID_TMP
(
  ID  VARCHAR2(32 BYTE)                         NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.XSF_ZFID_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.XSF_ZFID_TMP
(
  ID        VARCHAR2(32 BYTE)                   NOT NULL,
  ZF_ID     VARCHAR2(12 BYTE),
  RJ_DATE   DATE,
  LJ_DATE   DATE,
  DB        VARCHAR2(32 BYTE),
  LJ_TYPE   VARCHAR2(12 BYTE),
  RJ_TYPE   VARCHAR2(12 BYTE),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE),
  DDFLAG    CHAR(1 BYTE),
  LJQX      VARCHAR2(20 BYTE),
  DRDB      VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZFID_JYJ_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZFID_JYJ_TMP
(
  ZF_ID  VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZFID_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZFID_TMP
(
  ZF_ID    VARCHAR2(12 BYTE),
  LJ_DATE  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZFID_XSF_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZFID_XSF_TMP
(
  ZF_ID  VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.ZF_BH DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.ZF_BH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZF_BH
(
  ID      VARCHAR2(32 BYTE)                     NOT NULL,
  ZF_BH   VARCHAR2(12 BYTE),
  STATUS  CHAR(1 BYTE),
  C_DATE  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.ZF_FH DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.ZF_FH CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZF_FH
(
  ID      VARCHAR2(32 BYTE)                     NOT NULL,
  ZF_FH   VARCHAR2(5 BYTE),
  STATUS  CHAR(1 BYTE),
  C_DATE  DATE,
  USERID  VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZF_ID_ID_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZF_ID_ID_TMP
(
  ZF_ID    VARCHAR2(12 BYTE),
  RJ_DATE  DATE
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZF_ID_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZF_ID_TMP
(
  ZF_ID  VARCHAR2(12 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZHL_T_SYS_USER_LONGINNAME_LIKE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZHL_T_SYS_USER_LONGINNAME_LIKE
(
  USER_ID          VARCHAR2(10 BYTE)            NOT NULL,
  USER_NAME        VARCHAR2(20 BYTE)            NOT NULL,
  LOGIN_NAME       VARCHAR2(20 BYTE)            NOT NULL,
  FLAG_EMP         VARCHAR2(1 BYTE)             NOT NULL,
  USER_CRYPTOGRAM  VARCHAR2(20 BYTE),
  FLAG_LOCK        VARCHAR2(1 BYTE)             NOT NULL,
  FLAG_DEFINE      VARCHAR2(1 BYTE)             NOT NULL,
  IC_NO            VARCHAR2(15 BYTE),
  CONN_NUM         NUMBER(3)                    NOT NULL,
  FLAG_CHECK       VARCHAR2(1 BYTE)             NOT NULL,
  FLAG_ACTIVE      VARCHAR2(1 BYTE)             NOT NULL,
  POSITION_X       NUMBER(5)                    NOT NULL,
  POSITION_Y       NUMBER(5)                    NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


ALTER TABLE JGGZ.ZHL_T_SYS_USER_TMP DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.ZHL_T_SYS_USER_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZHL_T_SYS_USER_TMP
(
  USER_ID          NUMBER(10)                   NOT NULL,
  USER_NAME        VARCHAR2(80 BYTE)            NOT NULL,
  LOGIN_NAME       VARCHAR2(80 BYTE)            NOT NULL,
  FLAG_EMP         VARCHAR2(1 BYTE)             DEFAULT '1'                   NOT NULL,
  USER_CRYPTOGRAM  VARCHAR2(32 BYTE),
  FLAG_LOCK        VARCHAR2(1 BYTE)             DEFAULT '0'                   NOT NULL,
  FLAG_DEFINE      VARCHAR2(1 BYTE)             DEFAULT '1'                   NOT NULL,
  IC_NO            VARCHAR2(15 BYTE),
  CONN_NUM         NUMBER(3)                    DEFAULT 1                     NOT NULL,
  FLAG_CHECK       VARCHAR2(1 BYTE)             DEFAULT '0'                   NOT NULL,
  FLAG_ACTIVE      VARCHAR2(1 BYTE)             DEFAULT '1'                   NOT NULL,
  FLAG_SA          VARCHAR2(1 BYTE),
  SHOW_ORDER       NUMBER(4),
  POSITION_X       NUMBER(5)                    DEFAULT 0                     NOT NULL,
  POSITION_Y       NUMBER(5)                    DEFAULT 0                     NOT NULL,
  TYPE             VARCHAR2(100 BYTE),
  USER_ID_YZ       NUMBER(10)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.ZM_TMP CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.ZM_TMP
(
  ZF_ID     VARCHAR2(12 BYTE)                   NOT NULL,
  ZM_CODE   VARCHAR2(6 BYTE)                    NOT NULL,
  ZM_SEQ    NUMBER(2),
  C_DATE    DATE,
  U_DATE    DATE,
  DEL_FLAG  CHAR(1 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE INDEX JGGZ.I_DZB_BM ON JGGZ.DZB
(BM)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_DZB_LB ON JGGZ.DZB
(LB)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_KBH_TEMP_TABLE ON JGGZ.KBH_TEMP_TABLE
(KFH, FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_JGGZ_SYNC_SQL ON JGGZ.SYN_SQL
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_JXJS_BM_BL_PK ON JGGZ.T_JXJS_BM_BL
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_PK_JXJS_FY_CODE ON JGGZ.T_JXJS_FY_BM
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_JXJS_JY_PK1_CODE ON JGGZ.T_JXJS_JY_BM
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_REPORT_DATA_PRIMARY_KEY ON JGGZ.T_REPORT_DATA
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_REPORT_PROCEDURE_ID ON JGGZ.T_REPORT_PROCEDURE
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_SYS_JFKH_AUTOYJ ON JGGZ.T_SYS_JFKH_AUTOYJ
(JYBM)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_AUTHORITY_TEST ON JGGZ.T_YZ_AUTHORITY_TEST
(AUTH_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_DXKTJ ON JGGZ.T_YZ_CXPT_DXKTJ
(MBTJ_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_FXKTJ ON JGGZ.T_YZ_CXPT_FXKTJ
(MBTJ_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MB ON JGGZ.T_YZ_CXPT_MB
(MB_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBGL ON JGGZ.T_YZ_CXPT_MBGL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBPX ON JGGZ.T_YZ_CXPT_MBPX
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBTJ ON JGGZ.T_YZ_CXPT_MBTJ
(MBTJ_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBXGB ON JGGZ.T_YZ_CXPT_MBXGB
(MBXGB_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_YZ_CXPT_MBXSZD_PK ON JGGZ.T_YZ_CXPT_MBXSZD
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_NOOUTLINKTAB_ID ON JGGZ.T_YZ_CXPT_NOOUTLINKTAB
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_SYS_FIELD ON JGGZ.T_YZ_CXPT_SYS_FIELD
(FIELD_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_SYS_TABLE ON JGGZ.T_YZ_CXPT_SYS_TABLE
(TABLE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_ZHXTJ ON JGGZ.T_YZ_CXPT_ZHXTJ
(MBTJ_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_DEPT_TEST ON JGGZ.T_YZ_DEPT_TEST
(DEPT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_DJG ON JGGZ.T_YZ_JFKH_DJG
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_JC_ZFID ON JGGZ.T_YZ_JFKH_JC
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_JC_DATE ON JGGZ.T_YZ_JFKH_JC
(JC_DATE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_JZ ON JGGZ.T_YZ_JFKH_JZ
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_LXFZ ON JGGZ.T_YZ_JFKH_LXFZ
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_REPORT_TEMP ON JGGZ.T_YZ_JFKH_REPORT_TEMP
(SESSIONID, ZFID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_REPORT_TEMP ON JGGZ.T_YZ_JFKH_REPORT_TEMP
(SESSIONID, DB)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHSCORELOG ON JGGZ.T_YZ_JFKH_SCORE
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_SCORE_ZFID ON JGGZ.T_YZ_JFKH_SCORE
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_SCORE_SCOREDATE ON JGGZ.T_YZ_JFKH_SCORE
(SCOREDATE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_DEP ON JGGZ.T_YZ_JFKH_SCORE
(DEPID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_JFGJ ON JGGZ.T_YZ_JFKH_SCORE
(JFGJ)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_DL ON JGGZ.T_YZ_JFKH_SCORE
(DL)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_JFKH_SCORE_1 ON JGGZ.T_YZ_JFKH_SCORE
(ZF_ID, SCOREDATE, DEL_FLAG, FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_JFKH_SCORE_2 ON JGGZ.T_YZ_JFKH_SCORE
(SCOREDATE, DEL_FLAG, FLAG, DEPID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHCLEARLOG ON JGGZ.T_YZ_JFKH_SCORE_CLEAR
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_DEP ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(DEPID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_DL ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(DL)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_JFGJ ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(JFGJ)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_SCORE_SCORE_HISTORYDATE ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(SCOREDATE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_SCORE_HISTORY_ZFID ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_JFKH_SCORE_HISTORY_1 ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(ZF_ID, SCOREDATE, DEL_FLAG, FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_JFKH_SCORE_HISTORY_2 ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(SCOREDATE, DEL_FLAG, FLAG, DEPID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_SCORE_HISTORY ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_YEAR ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(YEAR)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_MONTH ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(MONTH)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_ZFID ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_JFKH_SCORE_MONTH_3 ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(ZF_ID, YEAR, MONTH)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_SCORE_MONTH ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_JFKH_SCORE_MONTH_2 ON JGGZ.T_YZ_JFKH_SCORE_MONTH
(YEAR, MONTH)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHSPJ ON JGGZ.T_YZ_JFKH_SPJ
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_USER ON JGGZ.T_YZ_JFKH_USER
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_USER ON JGGZ.T_YZ_JFKH_USER
(USER_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF ON JGGZ.T_YZ_JFKH_XBF
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_DEPT ON JGGZ.T_YZ_JFKH_XBF_DEPT
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_DF ON JGGZ.T_YZ_JFKH_XBF_DEPT
(DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_DT ON JGGZ.T_YZ_JFKH_XBF_DEPT
(DEPTTYPE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_BM ON JGGZ.T_YZ_JFKH_XBF_DEPT
(BM)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_PI ON JGGZ.T_YZ_JFKH_XBF_DEPT
(PARENTID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_DETAIL ON JGGZ.T_YZ_JFKH_XBF_DETAIL
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_XD ON JGGZ.T_YZ_JFKH_XBF_DETAIL
(XBDATE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_XDT ON JGGZ.T_YZ_JFKH_XBF_DETAIL
(XBDEPT)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_JDT ON JGGZ.T_YZ_JFKH_XBF_DETAIL
(JSDEPT)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_DF ON JGGZ.T_YZ_JFKH_XBF_DETAIL
(DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_USER ON JGGZ.T_YZ_JFKH_XBF_USER
(USERID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_YZ_JFKHXZ_PK31079507316854 ON JGGZ.T_YZ_JFKH_XZ
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK ON JGGZ.T_YZ_JFKH_YJ_DEPT
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_ZF ON JGGZ.T_YZ_JFKH_ZF
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_ZFID ON JGGZ.T_YZ_JFKH_ZF
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.IDX_JFKH_ZF_DEPID ON JGGZ.T_YZ_JFKH_ZF
(ZF_DEPID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_JFKH_ZF_1 ON JGGZ.T_YZ_JFKH_ZF
(ZF_ID, ZF_DEPID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_ZFLX ON JGGZ.T_YZ_JFKH_ZFLX
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_JFKH_ZF_HISTORY ON JGGZ.T_YZ_JFKH_ZF_HISTORY
(ZF_ID, YEAR, MONTH)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_LOGS ON JGGZ.T_YZ_LOGS
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_LOGS_1 ON JGGZ.T_YZ_LOGS
(USERID, TIME)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_MINGCE ON JGGZ.T_YZ_MINGCE
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_PROM_INFO ON JGGZ.T_YZ_PROM_INFO
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_RC_GZJS ON JGGZ.T_YZ_RC_GZJS
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_RC_THDJ ON JGGZ.T_YZ_RC_THDJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_RC_THDJ_1 ON JGGZ.T_YZ_RC_THDJ
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ROLE_AUTHORITY_TEST ON JGGZ.T_YZ_ROLE_AUTHORITY_TEST
(AUTH_ID, ROLE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ROLE_TEST ON JGGZ.T_YZ_ROLE_TEST
(ROLE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWS ON JGGZ.T_YZ_SFWS
(SFWSID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWSNO ON JGGZ.T_YZ_SFWSNO
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWS_MR ON JGGZ.T_YZ_SFWS_MR
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SWDJ ON JGGZ.T_YZ_SWDJ
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SWJD ON JGGZ.T_YZ_SWJD
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_TAB_RELATION ON JGGZ.T_YZ_TAB_RELATION
(TAB_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_TGZF ON JGGZ.T_YZ_TGZF
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_THJH ON JGGZ.T_YZ_THJH
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_USER_TEST ON JGGZ.T_YZ_USER_TEST
(USER_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_WSSP ON JGGZ.T_YZ_WSSP
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_WSSP_MR ON JGGZ.T_YZ_WSSP_MR
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_YZ_XT_BM_PK ON JGGZ.T_YZ_XT_BM
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_XT_BM_1 ON JGGZ.T_YZ_XT_BM
(LBID, SM)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_XT_BM_2 ON JGGZ.T_YZ_XT_BM
(LBID, REMOVEFLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_XT_BM_3 ON JGGZ.T_YZ_XT_BM
(LBID, BM, REMOVEFLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_XT_BM_4 ON JGGZ.T_YZ_XT_BM
(LBID, LRM, REMOVEFLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_XT_BM_5 ON JGGZ.T_YZ_XT_BM
(LBID, SM, REMOVEFLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_CHKITEMS ON JGGZ.T_YZ_XT_CHKITEMS
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_XT_CHKITEMS ON JGGZ.T_YZ_XT_CHKITEMS
(PARENTID, DEL_FALG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_CHECKMODUL ON JGGZ.T_YZ_XT_CHKMODUL
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_XT_CHECKMODUL ON JGGZ.T_YZ_XT_CHKMODUL
(DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_XT_CHKR_1 ON JGGZ.T_YZ_XT_CHKR
(SESSIONID, DB)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DIMEN ON JGGZ.T_YZ_XT_DIMEN
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DIMENMEMBER ON JGGZ.T_YZ_XT_DIMENMEMBER
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DISDIMENMEMBER ON JGGZ.T_YZ_XT_DISDIMENMEMBER
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DWTJ_CUBEDEFINE ON JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_BM_ID ON JGGZ.T_YZ_XT_EDITBM
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_YZ_XT_HOST_PK ON JGGZ.T_YZ_XT_HOST
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_MRZ_USED ON JGGZ.T_YZ_XT_MRZ_USED
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_PARA ON JGGZ.T_YZ_XT_PARA
(PARAID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_QUERYCONFIG ON JGGZ.T_YZ_XT_QUERYCONFIG
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_SEQDIMENMEMBER ON JGGZ.T_YZ_XT_SEQDIMENMEMBER
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_WEB_POPEDOM ON JGGZ.T_YZ_XT_WEB_POPEDOM
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_XT_ZH_1 ON JGGZ.T_YZ_XT_ZH
(ZH_CN)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_XT_ZH_2 ON JGGZ.T_YZ_XT_ZH
(PY)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFKG ON JGGZ.T_YZ_ZFKG
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFKG_MB ON JGGZ.T_YZ_ZFKG_MB
(KG_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFLJ ON JGGZ.T_YZ_ZFLJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZFLJ_1 ON JGGZ.T_YZ_ZFLJ
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZFLJ_2 ON JGGZ.T_YZ_ZFLJ
(ZF_ID, C_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFSS ON JGGZ.T_YZ_ZFSS
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFSSXX ON JGGZ.T_YZ_ZFSSXX
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_BSJ ON JGGZ.T_YZ_ZF_BSJ
(BSJ_NO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_BWXB ON JGGZ.T_YZ_ZF_BWXB
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CRJ_INFO ON JGGZ.T_YZ_ZF_CRJ_INFO
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID, RJ_DATE, LJ_DATE, LJ_TYPE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_ZFID ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_1 ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_2 ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID, RJ_DATE, LJ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_3 ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID, RJ_TYPE, RJ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_4 ON JGGZ.T_YZ_ZF_CRJ_INFO
(ZF_ID, LJ_TYPE, LJ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_5 ON JGGZ.T_YZ_ZF_CRJ_INFO
(RJ_DATE, LJ_DATE)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_DBDD ON JGGZ.T_YZ_ZF_DBDD
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_DBDD ON JGGZ.T_YZ_ZF_DBDD
(ZF_ID, DDQ_DB, DD_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_DBDD_1 ON JGGZ.T_YZ_ZF_DBDD
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_DBDD_2 ON JGGZ.T_YZ_ZF_DBDD
(ZF_ID, DD_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_DBDD_3 ON JGGZ.T_YZ_ZF_DBDD
(ZF_ID, DD_DATE, DDQ_DB, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_DBDD_4 ON JGGZ.T_YZ_ZF_DBDD
(ZF_ID, DD_DATE, DDH_DB, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_DSJ ON JGGZ.T_YZ_ZF_DSJ
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FGDJ ON JGGZ.T_YZ_ZF_FGDJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_1 ON JGGZ.T_YZ_ZF_FGDJ
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_2 ON JGGZ.T_YZ_ZF_FGDJ
(ZF_ID, PZ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_3 ON JGGZ.T_YZ_ZF_FGDJ
(ZF_ID, PZ_DATE, BDQ_DJ, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_4 ON JGGZ.T_YZ_ZF_FGDJ
(ZF_ID, PZ_DATE, BDH_DJ, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.I_YZ_ZF_FJXX_ZFID ON JGGZ.T_YZ_ZF_FJXX
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FK_ZFID ON JGGZ.T_YZ_ZF_FK
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_FK_1 ON JGGZ.T_YZ_ZF_FK
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLFA ON JGGZ.T_YZ_ZF_FLFA
(PLAN_NO)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLFA ON JGGZ.T_YZ_ZF_FLFA
(PLAN_NAME, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLFAMC ON JGGZ.T_YZ_ZF_FLFAMC
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLFLMC ON JGGZ.T_YZ_ZF_FLFAMC
(PLAN_NO, FLREASON)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLSZ ON JGGZ.T_YZ_ZF_FLSZ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLSZ ON JGGZ.T_YZ_ZF_FLSZ
(JSDW)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_1 ON JGGZ.T_YZ_ZF_FLTEMP
(SESSIONID, JSDWID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_2 ON JGGZ.T_YZ_ZF_FLTEMP
(SESSIONID, FLSTATUS)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_3 ON JGGZ.T_YZ_ZF_FLTEMP
(SESSIONID, YX, FLSTATUS, BIRTH)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_4 ON JGGZ.T_YZ_ZF_FLTEMP
(SESSIONID, YX, FLSTATUS, BIRTH, JSDWID, 
FYTYPE, LBC)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLTJ ON JGGZ.T_YZ_ZF_FLTJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_FLTJ ON JGGZ.T_YZ_ZF_FLTJ
(JSDWID, TIAOJIANTYPE)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_HBKC ON JGGZ.T_YZ_ZF_HBKC
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JK ON JGGZ.T_YZ_ZF_JK
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK ON JGGZ.T_YZ_ZF_JK
(ZF_ID, SY_STATUS, NYDW, PJ_NO1, PJ_NO2)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK_2 ON JGGZ.T_YZ_ZF_JK
(ZF_FH, SY_STATUS, NYDW, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK_3 ON JGGZ.T_YZ_ZF_JK
(ZF_NAME, SY_STATUS, NYDW, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK_4 ON JGGZ.T_YZ_ZF_JK
(ZF_ID, SY_STATUS, NYDW, PJ_NO1, PJ_NO2, 
DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK_1 ON JGGZ.T_YZ_ZF_JK
(ZF_ID, NYDW, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JK_20060526184028 ON JGGZ.T_YZ_ZF_JK_20060526184028
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JL ON JGGZ.T_YZ_ZF_JL
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ."I_yz_zf_jl_zfid" ON JGGZ.T_YZ_ZF_JL
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JL_1 ON JGGZ.T_YZ_ZF_JL
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JL_2 ON JGGZ.T_YZ_ZF_JL
(ZF_ID, XH, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JLXX ON JGGZ.T_YZ_ZF_JLXX
(JL_NO)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JLXX_1 ON JGGZ.T_YZ_ZF_JLXX
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_JLXX_2 ON JGGZ.T_YZ_ZF_JLXX
(ZF_ID, TYPE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JWBW ON JGGZ.T_YZ_ZF_JWBW
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_LBC ON JGGZ.T_YZ_ZF_LBC
(LBC_NO)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_LBC_1 ON JGGZ.T_YZ_ZF_LBC
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_LBC_FS ON JGGZ.T_YZ_ZF_LBC_FS
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_MTXX ON JGGZ.T_YZ_ZF_MTXX
(MT_NO)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_MTXX_ZFID ON JGGZ.T_YZ_ZF_MTXX
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_MTXX_1 ON JGGZ.T_YZ_ZF_MTXX
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_MTXX_2 ON JGGZ.T_YZ_ZF_MTXX
(ZF_ID, MT_TYPE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_MTXX_LOG ON JGGZ.T_YZ_ZF_MTXX_LOG
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NFL ON JGGZ.T_YZ_ZF_NFL
(PLAN_NO, JSDWID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NFL_TJ ON JGGZ.T_YZ_ZF_NFL_TJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_NFL_TJ_1 ON JGGZ.T_YZ_ZF_NFL_TJ
(TJTYPE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_NFL_TJ_2 ON JGGZ.T_YZ_ZF_NFL_TJ
(JSDW, COLTITLE)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NWFG ON JGGZ.T_YZ_ZF_NWFG
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_NWFG_1 ON JGGZ.T_YZ_ZF_NWFG
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_NWFG_2 ON JGGZ.T_YZ_ZF_NWFG
(ZF_ID, PZ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_NWFG_3 ON JGGZ.T_YZ_ZF_NWFG
(ZF_ID, PZ_DATE, FG, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_QJFJ ON JGGZ.T_YZ_ZF_QJFJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_ZFID ON JGGZ.T_YZ_ZF_QKLJ
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_1 ON JGGZ.T_YZ_ZF_QKLJ
(ZF_ID, QKLJ_LB, LB)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_2 ON JGGZ.T_YZ_ZF_QKLJ
(ZF_ID, LB)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SF ON JGGZ.T_YZ_ZF_SFZF
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SHGX ON JGGZ.T_YZ_ZF_SHGX
(SHGX_NO)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_SHGX_ZFID ON JGGZ.T_YZ_ZF_SHGX
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_SHGX_1 ON JGGZ.T_YZ_ZF_SHGX
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_SHGX_2 ON JGGZ.T_YZ_ZF_SHGX
(ZF_ID, XH, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SJ ON JGGZ.T_YZ_ZF_SJZF
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SS ON JGGZ.T_YZ_ZF_SS
(SS_NO)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TAF ON JGGZ.T_YZ_ZF_TAF
(TAF_NO)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_TC ON JGGZ.T_YZ_ZF_TC
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_TC_1 ON JGGZ.T_YZ_ZF_TC
(ZF_ID, C_DATE)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TC ON JGGZ.T_YZ_ZF_TC
(ZF_ID, TC)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_TG_1 ON JGGZ.T_YZ_ZF_TG
(ZF_ID, XH)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TGSK ON JGGZ.T_YZ_ZF_TGSK
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_TMTZ_1 ON JGGZ.T_YZ_ZF_TMTZ
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TMTZ ON JGGZ.T_YZ_ZF_TMTZ
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TT ON JGGZ.T_YZ_ZF_TT
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_UNUSEDZFBH ON JGGZ.T_YZ_ZF_UNUSEDZFBH
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.I_UNUSEDZFBH_STARTNO ON JGGZ.T_YZ_ZF_UNUSEDZFBH
(STARTNO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_XQBG ON JGGZ.T_YZ_ZF_XQBG
(XQBG_NO)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_XQBG ON JGGZ.T_YZ_ZF_XQBG
(ZF_ID, PJ_DATE, SJ_XQ, END_DATE, ZX_DATE, 
START_DATE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_XQBG_1 ON JGGZ.T_YZ_ZF_XQBG
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_XQBG_2 ON JGGZ.T_YZ_ZF_XQBG
(ZF_ID, BD_TYPE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_XQBG_3 ON JGGZ.T_YZ_ZF_XQBG
(ZF_ID, ZX_DATE, PJ_DATE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.AK_KEY_1_T_YZ_ZF_ ON JGGZ.T_YZ_ZF_YJ
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_T_YZ_ZF_ZDFL ON JGGZ.T_YZ_ZF_ZDFL
(FA_ID, ZF_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZDFL ON JGGZ.T_YZ_ZF_ZDFL
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZFBHALLOCATED ON JGGZ.T_YZ_ZF_ZFBHALLOCATED
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZK ON JGGZ.T_YZ_ZF_ZK
(ZF_ID)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZK_1 ON JGGZ.T_YZ_ZF_ZK
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZK_2 ON JGGZ.T_YZ_ZF_ZK
(ZF_ID, FG_LEVEL, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZK_3 ON JGGZ.T_YZ_ZF_ZK
(ZF_ID, YS_NO1, YS_NO2, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZM ON JGGZ.T_YZ_ZF_ZM
(ZF_ID, ZM_CODE)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZM_2 ON JGGZ.T_YZ_ZF_ZM
(ZF_ID, ZM_CODE, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZMBK_2 ON JGGZ.T_YZ_ZF_ZMBK
(XQBGNO, XH)
LOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZF_ZMBK_1 ON JGGZ.T_YZ_ZF_ZMBK
(XQBGNO)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZMBK ON JGGZ.T_YZ_ZF_ZMBK
(XQBGNO, ZF_ID, ZM)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZKBXDJ ON JGGZ.T_YZ_ZKBXDJ
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZKZFJB ON JGGZ.T_YZ_ZKZFJB
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX JGGZ.I_YZ_ZKZFJB_1 ON JGGZ.T_YZ_ZKZFJB
(ZF_ID, DEL_FLAG)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_ZF_BH ON JGGZ.ZF_BH
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.PK_ZF_FH ON JGGZ.ZF_FH
(ID)
LOGGING
NOPARALLEL;


ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION DROP PRIMARY KEY CASCADE;
DROP TABLE JGGZ.T_JXJS_FY_JY_RELATION CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_JXJS_FY_JY_RELATION
(
  ID                VARCHAR2(32 BYTE),
  FY_ID             VARCHAR2(32 BYTE),
  JY_ID             VARCHAR2(32 BYTE),
  CODE_TYPE_TABLE   VARCHAR2(50 BYTE),
  TABLE_TYPE_TABLE  VARCHAR2(50 BYTE),
  MEMO              VARCHAR2(100 BYTE),
  XML_NAME          VARCHAR2(32 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_JY_FY_TABLE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_JY_FY_TABLE
(
  ID                    VARCHAR2(32 BYTE)       NOT NULL,
  TABLE_NAME            VARCHAR2(500 BYTE),
  TABLE_COLUME          VARCHAR2(500 BYTE),
  TABLE_COLUME_TYPE     VARCHAR2(100 BYTE),
  IS_DISPLAY            VARCHAR2(10 BYTE),
  TABLE_TYPE            VARCHAR2(10 BYTE),
  TABLE_REALATION_TYPE  VARCHAR2(10 BYTE),
  MEMO                  VARCHAR2(2000 BYTE),
  TABLE_COLUME_LENGTH   VARCHAR2(10 BYTE),
  TABLE_COLUME_NAME     VARCHAR2(100 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


DROP TABLE JGGZ.T_ZM_CODE_CHANGE CASCADE CONSTRAINTS;

CREATE TABLE JGGZ.T_ZM_CODE_CHANGE
(
  JY_SM         VARCHAR2(255 BYTE),
  JY_BM         VARCHAR2(255 BYTE),
  FY_BM         VARCHAR2(255 BYTE),
  FY_SM         VARCHAR2(255 BYTE),
  T_FLAG        VARCHAR2(10 BYTE),
  T_FY_JY_FLAG  VARCHAR2(2 BYTE)
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE UNIQUE INDEX JGGZ.T_JXJS_RELATION_ID_PK ON JGGZ.T_JXJS_FY_JY_RELATION
(ID)
LOGGING
NOPARALLEL;


ALTER TABLE JGGZ.KBH_TEMP_TABLE ADD (
  CONSTRAINT PK_KBH_TEMP_TABLE PRIMARY KEY (KFH, FLAG));


ALTER TABLE JGGZ.SYN_SQL ADD (
  CONSTRAINT PK_JGGZ_SYNC_SQL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_JXJS_BM_BL ADD (
  CONSTRAINT T_JXJS_BM_BL_PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_JXJS_FY_BM ADD (
  CONSTRAINT T_PK_JXJS_FY_CODE PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_JXJS_JY_BM ADD (
  CONSTRAINT T_JXJS_JY_PK1_CODE PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_REPORT_DATA ADD (
  CONSTRAINT T_REPORT_DATA_PRIMARY_KEY PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_REPORT_PROCEDURE ADD (
  CONSTRAINT PK_REPORT_PROCEDURE_ID PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_SYS_JFKH_AUTOYJ ADD (
  CONSTRAINT PK_T_SYS_JFKH_AUTOYJ PRIMARY KEY (JYBM));


ALTER TABLE JGGZ.T_YZ_AUTHORITY_TEST ADD (
  CONSTRAINT PK_T_YZ_AUTHORITY_TEST PRIMARY KEY (AUTH_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_DXKTJ ADD (
  CONSTRAINT PK_T_YZ_CXPT_DXKTJ PRIMARY KEY (MBTJ_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_FXKTJ ADD (
  CONSTRAINT PK_T_YZ_CXPT_FXKTJ PRIMARY KEY (MBTJ_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MB ADD (
  CONSTRAINT PK_T_YZ_CXPT_MB PRIMARY KEY (MB_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MBGL ADD (
  CONSTRAINT PK_T_YZ_CXPT_MBGL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MBPX ADD (
  CONSTRAINT PK_T_YZ_CXPT_MBPX PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MBTJ ADD (
  CONSTRAINT PK_T_YZ_CXPT_MBTJ PRIMARY KEY (MBTJ_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MBXGB ADD (
  CONSTRAINT PK_T_YZ_CXPT_MBXGB PRIMARY KEY (MBXGB_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_MBXSZD ADD (
  CONSTRAINT T_YZ_CXPT_MBXSZD_PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB ADD (
  CONSTRAINT PK_NOOUTLINKTAB_ID PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_CXPT_SYS_FIELD ADD (
  CONSTRAINT PK_T_YZ_CXPT_SYS_FIELD PRIMARY KEY (FIELD_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_SYS_TABLE ADD (
  CONSTRAINT PK_T_YZ_CXPT_SYS_TABLE PRIMARY KEY (TABLE_ID));


ALTER TABLE JGGZ.T_YZ_CXPT_ZHXTJ ADD (
  CONSTRAINT PK_T_YZ_CXPT_ZHXTJ PRIMARY KEY (MBTJ_ID));


ALTER TABLE JGGZ.T_YZ_DEPT_TEST ADD (
  CONSTRAINT PK_T_YZ_DEPT_TEST PRIMARY KEY (DEPT_ID));


ALTER TABLE JGGZ.T_YZ_JFKH_DJG ADD (
  CONSTRAINT PK_T_YZ_JFKH_DJG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG ADD (
  PRIMARY KEY (JB));


ALTER TABLE JGGZ.T_YZ_JFKH_LXFZ ADD (
  CONSTRAINT PK_T_YZ_JFKH_LXFZ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP ADD (
  CONSTRAINT PK_T_YZ_JFKH_REPORT_TEMP PRIMARY KEY (SESSIONID, ZFID));


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE ADD (
  CONSTRAINT PK_T_YZ_JFKHSCORELOG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR ADD (
  CONSTRAINT PK_T_YZ_JFKHCLEARLOG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY ADD (
  CONSTRAINT PK_T_YZ_JFKH_SCORE_HISTORY PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH ADD (
  CONSTRAINT PK_T_YZ_JFKH_SCORE_MONTH PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_SPJ ADD (
  CONSTRAINT PK_T_YZ_JFKHSPJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_USER ADD (
  CONSTRAINT PK_T_YZ_JFKH_USER PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_XBF ADD (
  CONSTRAINT PK_T_YZ_JFKH_XBF PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DEPT ADD (
  CONSTRAINT PK_T_YZ_JFKH_XBF_DEPT PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL ADD (
  CONSTRAINT PK_T_YZ_JFKH_XBF_DETAIL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_XBF_USER ADD (
  CONSTRAINT PK_T_YZ_JFKH_XBF_USER PRIMARY KEY (USERID));


ALTER TABLE JGGZ.T_YZ_JFKH_XZ ADD (
  CONSTRAINT T_YZ_JFKHXZ_PK31079507316854 PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_YJ_DEPT ADD (
  CONSTRAINT PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_ZF ADD (
  CONSTRAINT PK_T_YZ_JFKH_ZF PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_ZFLX ADD (
  CONSTRAINT PK_T_YZ_JFKH_ZFLX PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY ADD (
  CONSTRAINT PK_T_YZ_JFKH_ZF_HISTORY PRIMARY KEY (ZF_ID, YEAR, MONTH));


ALTER TABLE JGGZ.T_YZ_LOGS ADD (
  CONSTRAINT PK_T_YZ_LOGS PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_MINGCE ADD (
  CONSTRAINT PK_T_YZ_MINGCE PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_PROM_INFO ADD (
  CONSTRAINT PK_T_YZ_PROM_INFO PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_RC_GZJS ADD (
  CONSTRAINT PK_T_YZ_RC_GZJS PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_RC_THDJ ADD (
  CONSTRAINT PK_T_YZ_RC_THDJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST ADD (
  CONSTRAINT PK_T_YZ_ROLE_AUTHORITY_TEST PRIMARY KEY (AUTH_ID, ROLE_ID));


ALTER TABLE JGGZ.T_YZ_ROLE_TEST ADD (
  CONSTRAINT PK_T_YZ_ROLE_TEST PRIMARY KEY (ROLE_ID));


ALTER TABLE JGGZ.T_YZ_SFWS ADD (
  CONSTRAINT PK_T_YZ_SFWS PRIMARY KEY (SFWSID));


ALTER TABLE JGGZ.T_YZ_SFWSNO ADD (
  CONSTRAINT PK_T_YZ_SFWSNO PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_SFWS_MR ADD (
  CONSTRAINT PK_T_YZ_SFWS_MR PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_SWDJ ADD (
  CONSTRAINT PK_T_YZ_SWDJ PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_SWJD ADD (
  CONSTRAINT PK_T_YZ_SWJD PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_TAB_RELATION ADD (
  CONSTRAINT PK_T_YZ_TAB_RELATION PRIMARY KEY (TAB_ID));


ALTER TABLE JGGZ.T_YZ_TGZF ADD (
  CONSTRAINT PK_T_YZ_TGZF PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_THJH ADD (
  CONSTRAINT PK_T_YZ_THJH PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_USER_TEST ADD (
  CONSTRAINT PK_T_YZ_USER_TEST PRIMARY KEY (USER_ID));


ALTER TABLE JGGZ.T_YZ_WSSP ADD (
  CONSTRAINT PK_T_YZ_WSSP PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_WSSP_MR ADD (
  CONSTRAINT PK_T_YZ_WSSP_MR PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_BM ADD (
  CONSTRAINT T_YZ_XT_BM_PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_CHKITEMS ADD (
  CONSTRAINT PK_T_YZ_XT_CHKITEMS PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_CHKMODUL ADD (
  CONSTRAINT PK_T_YZ_XT_CHECKMODUL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_DIMEN ADD (
  CONSTRAINT PK_T_YZ_XT_DIMEN PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_DIMENMEMBER ADD (
  CONSTRAINT PK_T_YZ_XT_DIMENMEMBER PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER ADD (
  CONSTRAINT PK_T_YZ_XT_DISDIMENMEMBER PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE ADD (
  CONSTRAINT PK_T_YZ_XT_DWTJ_CUBEDEFINE PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_EDITBM ADD (
  CONSTRAINT PK_BM_ID PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_HOST ADD (
  CONSTRAINT T_YZ_XT_HOST_PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_MRZ_USED ADD (
  CONSTRAINT PK_T_YZ_XT_MRZ_USED PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_XT_PARA ADD (
  CONSTRAINT PK_T_YZ_XT_PARA PRIMARY KEY (PARAID));


ALTER TABLE JGGZ.T_YZ_XT_QUERYCONFIG ADD (
  CONSTRAINT PK_T_YZ_XT_QUERYCONFIG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER ADD (
  CONSTRAINT PK_T_YZ_XT_SEQDIMENMEMBER PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_XT_WEB_POPEDOM ADD (
  CONSTRAINT PK_T_YZ_XT_WEB_POPEDOM PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZFKG ADD (
  CONSTRAINT PK_T_YZ_ZFKG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZFKG_MB ADD (
  CONSTRAINT PK_T_YZ_ZFKG_MB PRIMARY KEY (KG_ID));


ALTER TABLE JGGZ.T_YZ_ZFLJ ADD (
  CONSTRAINT PK_T_YZ_ZFLJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZFSS ADD (
  CONSTRAINT PK_T_YZ_ZFSS PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZFSSXX ADD (
  CONSTRAINT PK_T_YZ_ZFSSXX PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_BSJ ADD (
  CONSTRAINT PK_T_YZ_ZF_BSJ PRIMARY KEY (BSJ_NO));


ALTER TABLE JGGZ.T_YZ_ZF_BWXB ADD (
  CONSTRAINT PK_T_YZ_ZF_BWXB PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_CRJ_INFO ADD (
  CONSTRAINT PK_T_YZ_CRJ_INFO PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_DBDD ADD (
  CONSTRAINT PK_T_YZ_ZF_DBDD PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_DSJ ADD (
  CONSTRAINT PK_T_YZ_ZF_DSJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_FGDJ ADD (
  CONSTRAINT PK_T_YZ_ZF_FGDJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_FK ADD (
  CONSTRAINT PK_T_YZ_ZF_FK PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_ZF_FLFA ADD (
  CONSTRAINT PK_T_YZ_ZF_FLFA PRIMARY KEY (PLAN_NO));


ALTER TABLE JGGZ.T_YZ_ZF_FLFAMC ADD (
  CONSTRAINT PK_T_YZ_ZF_FLFAMC PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_ZF_FLSZ ADD (
  CONSTRAINT PK_T_YZ_ZF_FLSZ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_FLTJ ADD (
  CONSTRAINT PK_T_YZ_ZF_FLTJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_HBKC ADD (
  CONSTRAINT PK_T_YZ_ZF_HBKC PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_JK ADD (
  CONSTRAINT PK_T_YZ_ZF_JK PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_ZF_JL ADD (
  CONSTRAINT PK_T_YZ_ZF_JL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_JLXX ADD (
  CONSTRAINT PK_T_YZ_ZF_JLXX PRIMARY KEY (JL_NO));


ALTER TABLE JGGZ.T_YZ_ZF_JWBW ADD (
  CONSTRAINT PK_T_YZ_ZF_JWBW PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_LBC ADD (
  CONSTRAINT PK_T_YZ_ZF_LBC PRIMARY KEY (LBC_NO));


ALTER TABLE JGGZ.T_YZ_ZF_LBC_FS ADD (
  CONSTRAINT PK_T_YZ_ZF_LBC_FS PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_MTXX ADD (
  CONSTRAINT PK_T_YZ_ZF_MTXX PRIMARY KEY (MT_NO));


ALTER TABLE JGGZ.T_YZ_ZF_MTXX_LOG ADD (
  CONSTRAINT PK_T_YZ_ZF_MTXX_LOG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_NFL ADD (
  CONSTRAINT PK_T_YZ_ZF_NFL PRIMARY KEY (PLAN_NO, JSDWID));


ALTER TABLE JGGZ.T_YZ_ZF_NFL_TJ ADD (
  CONSTRAINT PK_T_YZ_ZF_NFL_TJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_NWFG ADD (
  CONSTRAINT PK_T_YZ_ZF_NWFG PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_QJFJ ADD (
  CONSTRAINT PK_T_YZ_ZF_QJFJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_SFZF ADD (
  CONSTRAINT PK_T_YZ_ZF_SF PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_SHGX ADD (
  CONSTRAINT PK_T_YZ_ZF_SHGX PRIMARY KEY (SHGX_NO));


ALTER TABLE JGGZ.T_YZ_ZF_SJZF ADD (
  CONSTRAINT PK_T_YZ_ZF_SJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_SS ADD (
  CONSTRAINT PK_T_YZ_ZF_SS PRIMARY KEY (SS_NO));


ALTER TABLE JGGZ.T_YZ_ZF_TAF ADD (
  CONSTRAINT PK_T_YZ_ZF_TAF PRIMARY KEY (TAF_NO));


ALTER TABLE JGGZ.T_YZ_ZF_TC ADD (
  CONSTRAINT PK_T_YZ_ZF_TC PRIMARY KEY (ZF_ID, TC));


ALTER TABLE JGGZ.T_YZ_ZF_TGSK ADD (
  CONSTRAINT PK_T_YZ_ZF_TGSK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_TMTZ ADD (
  CONSTRAINT PK_T_YZ_ZF_TMTZ PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_ZF_TT ADD (
  CONSTRAINT PK_T_YZ_ZF_TT PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH ADD (
  CONSTRAINT PK_T_YZ_ZF_UNUSEDZFBH PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_XQBG ADD (
  CONSTRAINT PK_T_YZ_ZF_XQBG PRIMARY KEY (XQBG_NO));


ALTER TABLE JGGZ.T_YZ_ZF_YJ ADD (
  CONSTRAINT AK_KEY_1_T_YZ_ZF_ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_ZDFL ADD (
  CONSTRAINT PK_T_YZ_ZF_ZDFL PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED ADD (
  CONSTRAINT PK_T_YZ_ZF_ZFBHALLOCATED PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZF_ZK ADD (
  CONSTRAINT PK_T_YZ_ZF_ZK PRIMARY KEY (ZF_ID));


ALTER TABLE JGGZ.T_YZ_ZF_ZM ADD (
  CONSTRAINT PK_T_YZ_ZF_ZM PRIMARY KEY (ZF_ID, ZM_CODE));


ALTER TABLE JGGZ.T_YZ_ZF_ZMBK ADD (
  CONSTRAINT PK_T_YZ_ZF_ZMBK PRIMARY KEY (XQBGNO, ZF_ID, ZM));


ALTER TABLE JGGZ.T_YZ_ZKBXDJ ADD (
  CONSTRAINT PK_T_YZ_ZKBXDJ PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_YZ_ZKZFJB ADD (
  CONSTRAINT PK_T_YZ_ZKZFJB PRIMARY KEY (ID));


ALTER TABLE JGGZ.ZF_BH ADD (
  CONSTRAINT PK_ZF_BH PRIMARY KEY (ID));


ALTER TABLE JGGZ.ZF_FH ADD (
  CONSTRAINT PK_ZF_FH PRIMARY KEY (ID));


ALTER TABLE JGGZ.ZHL_T_SYS_USER_TMP ADD (
  CONSTRAINT PK_ZHL_T_SYS_USER_TMP PRIMARY KEY (USER_ID) DISABLE);


ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
  CONSTRAINT T_JXJS_RELATION_ID_PK PRIMARY KEY (ID));


ALTER TABLE JGGZ.T_JXJS_JY_BM ADD (
  CONSTRAINT T_JXJS_JY_FK FOREIGN KEY (BM_ID) 
    REFERENCES JGGZ.T_JXJS_BM_BL (ID));


ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
  CONSTRAINT T_JXJS_RELAGION_FY_FK FOREIGN KEY (FY_ID) 
    REFERENCES JGGZ.T_JXJS_FY_BM (ID));

ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
  CONSTRAINT T_JXJS_RELAGION_JY_FK FOREIGN KEY (JY_ID) 
    REFERENCES JGGZ.T_JXJS_JY_BM (ID));


ALTER TABLE JGGZ.T_JY_FY_TABLE ADD (
  CONSTRAINT T_JY_FY_FK FOREIGN KEY (TABLE_REALATION_TYPE) 
    REFERENCES JGGZ.T_JXJS_FY_JY_RELATION (ID));


ALTER TABLE JGGZ.T_ZM_CODE_CHANGE ADD (
  CONSTRAINT T_ZM_CODE_CHANGE_FK FOREIGN KEY (T_FY_JY_FLAG) 
    REFERENCES JGGZ.T_JXJS_FY_JY_RELATION (ID));
