table.ddl

j2ee源码

   TMOT VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMBPMRFLW
  (OBJT NUMBER(22, 0) NOT NULL,
   CNDA VARCHAR2(254) NULL,
   CNDE NUMBER(22, 0) NULL,
   CRAC NUMBER(22, 0) NULL,
   DLAC NUMBER(22, 0) NULL,
   FTYP VARCHAR2(254) NULL,
   RDAC NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   UDEF NUMBER(22, 0) NULL,
   UPAC NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMBPMRSRC
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMBPMSTRT
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMBPMSYNC
  (OBJT NUMBER(22, 0) NOT NULL,
   ACTN NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   TMOT VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMBRNC
  (BRNC NUMBER(22, 0) NOT NULL,
   NAME VARCHAR2(254) NOT NULL,
   CODE VARCHAR2(254) NOT NULL,
   CMMT NUMBER(22, 0) NULL,
   BBRC NUMBER(22, 0) NULL,
   OCUS NUMBER(22, 0) NOT NULL,
   OCDT DATE NULL,
   OMUS NUMBER(22, 0) NULL,
   OMDT DATE NULL);

CREATE TABLE WKEXS.PMCDMASSC
  (OBJT NUMBER(22, 0) NOT NULL,
   GENE NUMBER(22, 0) NULL,
   NBRC FLOAT(126) NULL);

CREATE TABLE WKEXS.PMCDMENTT
  (OBJT NUMBER(22, 0) NOT NULL,
   GENE NUMBER(22, 0) NULL,
   NBRC FLOAT(126) NULL);

CREATE TABLE WKEXS.PMCDMINHR
  (OBJT NUMBER(22, 0) NOT NULL,
   EXCL NUMBER(22, 0) NULL,
   INHA NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMCDMLINK
  (OBJT NUMBER(22, 0) NOT NULL,
   CARD VARCHAR2(254) NULL,
   IDTF NUMBER(22, 0) NULL,
   RNAM VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMCDMPROP
  (OBJT NUMBER(22, 0) NOT NULL,
   DISP NUMBER(22, 0) NULL,
   MAND NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMCDMRLSH
  (OBJT NUMBER(22, 0) NOT NULL,
   CRDA VARCHAR2(254) NULL,
   CRDB VARCHAR2(254) NULL,
   DMNT VARCHAR2(1) NULL,
   GENE NUMBER(22, 0) NULL,
   NAMA VARCHAR2(254) NULL,
   NAMB VARCHAR2(254) NULL,
   RELT VARCHAR2(1) NULL);

CREATE TABLE WKEXS.PMCHCK
  (OBJT NUMBER(22, 0) NOT NULL,
   AVGL NUMBER(22, 0) NULL,
   CKCN VARCHAR2(254) NULL,
   COMP NUMBER(22, 0) NULL,
   CRUL NUMBER(22, 0) NULL,
   CTXT NUMBER(22, 0) NULL,
   DISP NUMBER(22, 0) NULL,
   DRVD NUMBER(22, 0) NULL,
   DSTV NUMBER(22, 0) NULL,
   DTTP VARCHAR2(254) NULL,
   DVAL VARCHAR2(254) NULL,
   FRMT VARCHAR2(254) NULL,
   FRZN VARCHAR2(1) NULL,
   HVAL VARCHAR2(254) NULL,
   IDNT NUMBER(22, 0) NULL,
   INIT NUMBER(22, 0) NULL,
   LOWR NUMBER(22, 0) NULL,
   LVAL VARCHAR2(254) NULL,
   MAND NUMBER(22, 0) NULL,
   MLEN NUMBER(22, 0) NULL,
   MULT VARCHAR2(254) NULL,
   NMDF NUMBER(22, 0) NULL,
   NULV NUMBER(22, 0) NULL,
   OPTS NUMBER(22, 0) NULL,
   PCGN VARCHAR2(1) NULL,
   PCOD VARCHAR2(254) NULL,
   PDTP VARCHAR2(254) NULL,
   PERS NUMBER(22, 0) NULL,
   PMLN NUMBER(22, 0) NULL,
   PPRC NUMBER(22, 0) NULL,
   PREC NUMBER(22, 0) NULL,
   SRUL NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   STTC NUMBER(22, 0) NULL,
   UNIT VARCHAR2(254) NULL,
   UPPR NUMBER(22, 0) NULL,
   VALS NUMBER(22, 0) NULL,
   VISI VARCHAR2(1) NULL,
   WDEF NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMCLSS
  (CLSS NUMBER(22, 0) NOT NULL,
   LIBR NUMBER(22, 0) NOT NULL,
   CLID CHAR(40) NOT NULL,
   PRNT NUMBER(22, 0) NULL,
   NAME VARCHAR2(254) NOT NULL,
   CODE VARCHAR2(254) NOT NULL,
   TNAM VARCHAR2(254) NULL,
   FLGS NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMCMAP
  (OBJT NUMBER(22, 0) NOT NULL,
   CRTR NUMBER(22, 0) NULL,
   DELT NUMBER(22, 0) NULL,
   INSR NUMBER(22, 0) NULL,
   SLCT NUMBER(22, 0) NULL,
   UPDT NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMCNFG
  (CNFG NUMBER(22, 0) NOT NULL,
   NAME VARCHAR2(254) NOT NULL,
   CODE VARCHAR2(254) NOT NULL,
   CMMT NUMBER(22, 0) NULL,
   OCUS NUMBER(22, 0) NOT NULL,
   OCDT DATE NULL,
   OMUS NUMBER(22, 0) NULL,
   OMDT DATE NULL);

CREATE TABLE WKEXS.PMCONT
  (OBJT NUMBER(22, 0) NOT NULL,
   OPTS NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMDEPD
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMDIAG
  (OBJT NUMBER(22, 0) NOT NULL,
   DFLG NUMBER(22, 0) NULL,
   DPRF NUMBER(22, 0) NULL,
   MTYP NUMBER(22, 0) NULL,
   PGMG VARCHAR2(64) NULL,
   PGOR NUMBER(22, 0) NULL,
   PGSC NUMBER(22, 0) NULL,
   PGSZ NUMBER(22, 0) NULL,
   PPSC NUMBER(22, 0) NULL,
   PPSZ VARCHAR2(32) NULL);

CREATE TABLE WKEXS.PMDTSC
  (OBJT NUMBER(22, 0) NOT NULL,
   DTSR VARCHAR2(254) NULL,
   LGIN VARCHAR2(254) NULL,
   PSWD VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMEMDL
  (OBJT NUMBER(22, 0) NOT NULL,
   TOID NUMBER(22, 0) NULL,
   ECLS CHAR(40) NULL,
   EMID CHAR(40) NULL,
   EURL NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMEOBJ
  (OBJT NUMBER(22, 0) NOT NULL,
   TOID NUMBER(22, 0) NULL,
   ECLS CHAR(40) NULL,
   EOID CHAR(40) NULL,
   GENE NUMBER(22, 0) NULL,
   GTYP NUMBER(22, 0) NULL,
   LOCT NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMEXAS
  (OBJT NUMBER(22, 0) NOT NULL,
   XLIB CHAR(40) NULL);

CREATE TABLE WKEXS.PMFILO
  (OBJT NUMBER(22, 0) NOT NULL,
   FCNT NUMBER(22, 0) NULL,
   GENE NUMBER(22, 0) NULL,
   URLC NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMFLDR
  (OBJT NUMBER(22, 0) NOT NULL,
   XNAM VARCHAR2(254) NULL,
   AUTH VARCHAR2(254) NULL,
   AVSN VARCHAR2(254) NULL,
   FOPT NUMBER(22, 0) NULL,
   MOPT NUMBER(22, 0) NULL,
   NMSP NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   VERS VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMGUSR
  (GRPE NUMBER(22, 0) NOT NULL,
   RUSR NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMLATT
  (LGID NUMBER(22, 0) NOT NULL,
   OBJT NUMBER(22, 0) NOT NULL,
   ISTX NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMLBIN
  (LBIN NUMBER(22, 0) NOT NULL,
   BDAT LONG RAW NULL);

CREATE TABLE WKEXS.PMLIBR
  (LIBR NUMBER(22, 0) NOT NULL,
   NAME VARCHAR2(254) NOT NULL,
   CODE VARCHAR2(254) NOT NULL,
   GOID CHAR(40) NOT NULL,
   VRSN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMLOCK
  (LCKO NUMBER(22, 0) NOT NULL,
   OBJT NUMBER(22, 0) NOT NULL,
   LTYP NUMBER(22, 0) NOT NULL,
   SESN NUMBER(22, 0) NULL,
   CMMT NUMBER(22, 0) NULL,
   WKSN VARCHAR2(254) NULL,
   OCUS NUMBER(22, 0) NOT NULL,
   OCDT DATE NULL,
   OMUS NUMBER(22, 0) NULL,
   OMDT DATE NULL);

CREATE TABLE WKEXS.PMOBJT
  (OBJT NUMBER(22, 0) NOT NULL,
   POID NUMBER(22, 0) NOT NULL,
   CLSS NUMBER(22, 0) NOT NULL,
   BRNC NUMBER(22, 0) NOT NULL,
   VRSN VARCHAR2(254) NULL,
   PVOB NUMBER(22, 0) NOT NULL,
   FRZN NUMBER(22, 0) NULL,
   LVRS NUMBER(22, 0) NULL,
   VCMT NUMBER(22, 0) NULL,
   GOID CHAR(40) NULL,
   OCUS NUMBER(22, 0) NOT NULL,
   OCDT DATE NULL,
   OMUS NUMBER(22, 0) NOT NULL,
   OMDT DATE NULL,
   NAME VARCHAR2(254) NULL,
   CODE VARCHAR2(254) NULL,
   CMMT NUMBER(22, 0) NULL,
   DSCR NUMBER(22, 0) NULL,
   ANNT NUMBER(22, 0) NULL,
   HIST NUMBER(22, 0) NULL,
   OEXA NUMBER(22, 0) NULL,
   BCOL NUMBER(22, 0) NULL,
   CUSR VARCHAR2(80) NULL,
   CDAT DATE NULL,
   MUSR VARCHAR2(80) NULL,
   MDAT DATE NULL);

CREATE TABLE WKEXS.PMOCNF
  (CNFG NUMBER(22, 0) NOT NULL,
   OBJT NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMOOMACTV
  (OBJT NUMBER(22, 0) NOT NULL,
   ACTN NUMBER(22, 0) NULL,
   ACTP VARCHAR2(254) NULL,
   DRTN VARCHAR2(254) NULL,
   FOPT NUMBER(22, 0) NULL,
   NMSP NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   TMOT VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMASSC
  (OBJT NUMBER(22, 0) NOT NULL,
   FRZA VARCHAR2(1) NULL,
   FRZB VARCHAR2(1) NULL,
   INDA VARCHAR2(1) NULL,
   INDB VARCHAR2(1) NULL,
   MULA VARCHAR2(254) NULL,
   MULB VARCHAR2(254) NULL,
   NAVA NUMBER(22, 0) NULL,
   NAVB NUMBER(22, 0) NULL,
   ORDA VARCHAR2(1) NULL,
   ORDB VARCHAR2(1) NULL,
   ROLA VARCHAR2(254) NULL,
   ROLB VARCHAR2(254) NULL,
   STRN VARCHAR2(254) NULL,
   VISA VARCHAR2(1) NULL,
   VISB VARCHAR2(1) NULL);

CREATE TABLE WKEXS.PMOOMCLNK
  (OBJT NUMBER(22, 0) NOT NULL,
   CNDA VARCHAR2(254) NULL,
   CNDE NUMBER(22, 0) NULL,
   FTYP VARCHAR2(254) NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMCOMP
  (OBJT NUMBER(22, 0) NOT NULL,
   CTYP VARCHAR2(3) NULL,
   STRN VARCHAR2(254) NULL,
   TRSP VARCHAR2(2) NULL);

CREATE TABLE WKEXS.PMOOMCSFR
  (OBJT NUMBER(22, 0) NOT NULL,
   ABST NUMBER(22, 0) NULL,
   CTYP VARCHAR2(1) NULL,
   EXTS NUMBER(22, 0) NULL,
   FINL NUMBER(22, 0) NULL,
   FOOT NUMBER(22, 0) NULL,
   GENE NUMBER(22, 0) NULL,
   HEAD NUMBER(22, 0) NULL,
   IMPT NUMBER(22, 0) NULL,
   MULT VARCHAR2(254) NULL,
   PADT NUMBER(22, 0) NULL,
   PCOD VARCHAR2(254) NULL,
   PERS VARCHAR2(1) NULL,
   PRCN NUMBER(22, 0) NULL,
   PSCN NUMBER(22, 0) NULL,
   STEP NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   THRW NUMBER(22, 0) NULL,
   VISI VARCHAR2(1) NULL);

CREATE TABLE WKEXS.PMOOMDCSN
  (OBJT NUMBER(22, 0) NOT NULL,
   EXPA VARCHAR2(254) NULL,
   EXPR NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMDEPD
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMDTSC
  (OBJT NUMBER(22, 0) NOT NULL,
   CNCT VARCHAR2(254) NULL,
   DTSR VARCHAR2(254) NULL,
   LGIN VARCHAR2(254) NULL,
   ODBC NUMBER(22, 0) NULL,
   PSWD VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMENDS
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMGNRL
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL,
   VISI VARCHAR2(1) NULL);

CREATE TABLE WKEXS.PMOOMMSSG
  (OBJT NUMBER(22, 0) NOT NULL,
   ACTN VARCHAR2(1) NULL,
   BTIM VARCHAR2(254) NULL,
   COND VARCHAR2(254) NULL,
   DLAY NUMBER(22, 0) NULL,
   ETIM VARCHAR2(254) NULL,
   MTYP VARCHAR2(1) NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMMTHD
  (OBJT NUMBER(22, 0) NOT NULL,
   ABST NUMBER(22, 0) NULL,
   ARAY NUMBER(22, 0) NULL,
   ATMT NUMBER(22, 0) NULL,
   BDYT NUMBER(22, 0) NULL,
   DISP NUMBER(22, 0) NULL,
   EVNT VARCHAR2(254) NULL,
   FINL NUMBER(22, 0) NULL,
   PRCN NUMBER(22, 0) NULL,
   PSCN NUMBER(22, 0) NULL,
   QURY NUMBER(22, 0) NULL,
   RTTP VARCHAR2(254) NULL,
   SPEC NUMBER(22, 0) NULL,
   STRN VARCHAR2(254) NULL,
   STTC NUMBER(22, 0) NULL,
   THRW NUMBER(22, 0) NULL,
   VISI VARCHAR2(1) NULL);

CREATE TABLE WKEXS.PMOOMOBJT
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMOBST
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMORGN
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMPARM
  (OBJT NUMBER(22, 0) NOT NULL,
   ARAY NUMBER(22, 0) NULL,
   DTTP VARCHAR2(254) NULL,
   PTTP VARCHAR2(10) NULL);

CREATE TABLE WKEXS.PMOOMRLZS
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMSTRT
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMOOMSYNC
  (OBJT NUMBER(22, 0) NOT NULL,
   STRN VARCHAR2(254) NULL,
   TMOT VARCHAR2(254) NULL);