table.ddl

j2ee源码

ALTER TABLE WKEXS.FREIGHT_COST_IMPORT_TMP
  ADD CONSTRAINT FREIGHT_COST_IMPORT_TMP_PK PRIMARY KEY (COMPANY_ID, ITEM_ID, SHIP_LINE_ID, LOADING_PORT_ID, DISCHARGE_PORT_ID, VALIDITY_DATE_FROM, VALIDITY_DATE_TO, CONTAINER_SIZE, CURRENCY_ID);

CREATE TABLE WKEXS.INLAND_COST
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   YEAR NUMBER(4, 0) NOT NULL,
   MONTH NUMBER(2, 0) NOT NULL,
   LOADING_PORT_ID VARCHAR2(10) NOT NULL,
   CONTAINER_SIZE VARCHAR2(20) NOT NULL,
   SUPPLIER_ID NUMBER(8, 0) NOT NULL,
   DISTRICT_ID VARCHAR2(5) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   EIR NUMBER(13, 5) NULL,
   HAULAGE_CHARGE NUMBER(13, 5) NULL,
   AMS NUMBER(13, 5) NULL,
   THC NUMBER(13, 5) NULL,
   DOCUMENT_FEE NUMBER(13, 5) NULL,
   HANDLING_CHARGE NUMBER(13, 5) NULL,
   BOOKING_CHARGE NUMBER(13, 5) NULL,
   CUSTOMS_CLEAR_FREE NUMBER(13, 5) NULL,
   I_OTHER_CHARGE NUMBER(13, 5) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.INLAND_COST
  ADD CONSTRAINT INLAND_COST_PK PRIMARY KEY (COMPANY_ID, YEAR, MONTH, LOADING_PORT_ID, CONTAINER_SIZE, SUPPLIER_ID, DISTRICT_ID);

CREATE TABLE WKEXS.INLAND_COST_TEMP
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   YEAR NUMBER(4, 0) NOT NULL,
   MONTH NUMBER(2, 0) NOT NULL,
   LOADING_PORT_ID VARCHAR2(10) NOT NULL,
   CONTAINER_SIZE VARCHAR2(20) NOT NULL,
   SUPPLIER_ID NUMBER(8, 0) NOT NULL,
   DISTRICT_ID VARCHAR2(5) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   EIR NUMBER(13, 5) NULL,
   HAULAGE_CHARGE NUMBER(13, 5) NULL,
   AMS NUMBER(13, 5) NULL,
   THC NUMBER(13, 5) NULL,
   DOCUMENT_FEE NUMBER(13, 5) NULL,
   HANDLING_CHARGE NUMBER(13, 5) NULL,
   BOOKING_CHARGE NUMBER(13, 5) NULL,
   CUSTOMS_CLEAR_FREE NUMBER(13, 5) NULL,
   I_OTHER_CHARGE NUMBER(13, 5) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.INLAND_COST_TEMP
  ADD CONSTRAINT INLAND_COST_TEMP_PK PRIMARY KEY (COMPANY_ID, YEAR, MONTH, LOADING_PORT_ID, CONTAINER_SIZE, SUPPLIER_ID, DISTRICT_ID);

CREATE TABLE WKEXS.LC_SC_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   LC_NO VARCHAR2(30) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NOT NULL,
   SC_NO VARCHAR2(17) NULL,
   LATEST_SHIP_DATE DATE NULL,
   AMT NUMBER(12, 2) NULL,
   SHIP_RESV_AMT NUMBER(12, 2) NULL,
   SHIPPED_AMT NUMBER(12, 2) NULL,
   SC_AMT NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.LC_SC_DTL
  ADD CONSTRAINT LC_SC_DTL_PK PRIMARY KEY (COMPANY_ID, LC_NO, SC_TXN_NO);

CREATE TABLE WKEXS.LC_SC_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   LC_NO VARCHAR2(30) NOT NULL,
   BANK_ID VARCHAR2(50) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   APPLICANT VARCHAR2(200) NULL,
   ISSUE_DATE DATE NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   EXPIRY_DATE DATE NULL,
   AMT_TOLERANCE NUMBER(2, 0) NULL,
   AMOUNT NUMBER(12, 2) NULL,
   OS_AMT NUMBER(12, 2) NULL,
   ACTIVE VARCHAR2(1) NULL,
   PICT_UPLOAD VARCHAR2(1) NULL,
   LC_LATEST_SHIP_DATE DATE NULL,
   STATUS VARCHAR2(5) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   REMARKS VARCHAR2(4000) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   LC_TYPE VARCHAR2(1) NULL,
   PRESENTATION_DAY NUMBER(3, 0) NULL);

ALTER TABLE WKEXS.LC_SC_HDR
  ADD CONSTRAINT LC_SC_HDR_PK PRIMARY KEY (COMPANY_ID, LC_NO);

CREATE TABLE WKEXS.LMRPT_COMMON_TYPE
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PROGRAM_ID VARCHAR2(20) NOT NULL,
   COMMON_TYPE VARCHAR2(20) NOT NULL,
   LANG_ID VARCHAR2(15) NOT NULL,
   FIELD_NAME VARCHAR2(40) NOT NULL,
   DESCRIPTION VARCHAR2(60) NULL,
   SEQ_NO NUMBER(2, 0) NULL,
   ACTIVATE CHAR(1) NULL);

ALTER TABLE WKEXS.LMRPT_COMMON_TYPE
  ADD CONSTRAINT PK_LMRPT_COMMON_TYPE PRIMARY KEY (COMPANY_ID, PROGRAM_ID, COMMON_TYPE, LANG_ID, FIELD_NAME);

CREATE TABLE WKEXS.OBJECT_TOKEN
  (COMPANY_ID VARCHAR2(80) NOT NULL,
   TABLE_NAME VARCHAR2(100) NOT NULL,
   RECORD_KEY VARCHAR2(2000) NOT NULL,
   PROGRAM_ID VARCHAR2(50) NULL,
   USER_ID VARCHAR2(120) NULL,
   SESSION_ID VARCHAR2(50) NULL,
   TOKEN_DATETIME DATE NULL,
   TABLE_LOCK VARCHAR2(1) NULL);

ALTER TABLE WKEXS.OBJECT_TOKEN
  ADD CONSTRAINT OBJECT_TOKEN_PK PRIMARY KEY (COMPANY_ID, TABLE_NAME, RECORD_KEY);

CREATE TABLE WKEXS.ORAMAN_PLAN_TABLE
  (STATEMENT_ID VARCHAR2(30) NULL,
   TIMESTAMP DATE NULL,
   REMARKS VARCHAR2(80) NULL,
   OPERATION VARCHAR2(30) NULL,
   OPTIONS VARCHAR2(255) NULL,
   OBJECT_NODE VARCHAR2(128) NULL,
   OBJECT_OWNER VARCHAR2(30) NULL,
   OBJECT_NAME VARCHAR2(30) NULL,
   OBJECT_INSTANCE NUMBER(22, 0) NULL,
   OBJECT_TYPE VARCHAR2(30) NULL,
   OPTIMIZER VARCHAR2(255) NULL,
   SEARCH_COLUMNS NUMBER(22) NULL,
   ID NUMBER(22, 0) NULL,
   PARENT_ID NUMBER(22, 0) NULL,
   POSITION NUMBER(22, 0) NULL,
   COST NUMBER(22, 0) NULL,
   CARDINALITY NUMBER(22, 0) NULL,
   BYTES NUMBER(22, 0) NULL,
   OTHER_TAG VARCHAR2(255) NULL,
   PARTITION_START VARCHAR2(255) NULL,
   PARTITION_STOP VARCHAR2(255) NULL,
   PARTITION_ID NUMBER(22, 0) NULL,
   OTHER LONG NULL,
   DISTRIBUTION VARCHAR2(30) NULL,
   CPU_COST NUMBER(22, 0) NULL,
   IO_COST NUMBER(22, 0) NULL,
   TEMP_SPACE NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PAPER_CATEGORY
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PAPER_CAT_ID VARCHAR2(15) NOT NULL,
   DESCRIPTION VARCHAR2(200) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   DESCRIPTION_CHT VARCHAR2(200) NULL,
   DESCRIPTION_CHS VARCHAR2(200) NULL);

ALTER TABLE WKEXS.PAPER_CATEGORY
  ADD CONSTRAINT PAPER_CATEGORY_PK PRIMARY KEY (COMPANY_ID, PAPER_CAT_ID);

CREATE TABLE WKEXS.PAPER_CATEGORY_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SUPPLIER_ID NUMBER(8, 0) NOT NULL,
   PAPER_CAT_ID VARCHAR2(15) NOT NULL,
   SDMS_UNIT_PRICE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.PAPER_CATEGORY_DTL
  ADD CONSTRAINT PAPER_CATEGORY_DTL_PK PRIMARY KEY (COMPANY_ID, SUPPLIER_ID, PAPER_CAT_ID);

CREATE TABLE WKEXS.PAPER_SIZE
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PAPER_SIZE_ID NUMBER(11, 2) NOT NULL,
   SIZE_TYPE VARCHAR2(1) NULL,
   UOM VARCHAR2(2) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.PAPER_SIZE
  ADD CONSTRAINT PAPER_SIZE_PK PRIMARY KEY (COMPANY_ID, PAPER_SIZE_ID);

CREATE TABLE WKEXS.PAPER_TYPE
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   DESCRIPTION VARCHAR2(200) NULL,
   PAPER_GRADE VARCHAR2(15) NULL,
   PAPER_CAT_ID VARCHAR2(15) NULL,
   BASE_WEIGHT NUMBER(12, 4) NULL,
   LENGTH NUMBER(12, 0) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.PAPER_TYPE
  ADD CONSTRAINT PAPER_TYPE_PK PRIMARY KEY (COMPANY_ID, PAPER_TYPE_ID);

CREATE TABLE WKEXS.PAPER_TYPE_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   SUPPLIER_ID NUMBER(8, 0) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   DIAMETER NUMBER(10, 0) NOT NULL,
   LEN NUMBER(12, 0) NULL);

ALTER TABLE WKEXS.PAPER_TYPE_DTL
  ADD CONSTRAINT PAPER_TYPE_DTL_PK PRIMARY KEY (COMPANY_ID, SUPPLIER_ID, PAPER_TYPE_ID, DIAMETER);

CREATE TABLE WKEXS.PARD
  (DECOMP VARCHAR2(20) NOT NULL,
   DEODPX VARCHAR2(1) NULL,
   INVDTE DATE NULL,
   ARCPO VARCHAR2(20) NOT NULL,
   DEDNO VARCHAR2(17) NOT NULL,
   DEDNL VARCHAR2(20) NULL,
   DETYP VARCHAR2(15) NOT NULL,
   DEDES VARCHAR2(200) NULL,
   DEWT NUMBER(12, 3) NULL,
   DEUPR NUMBER(16, 5) NULL,
   DCUSPO VARCHAR2(70) NULL);

ALTER TABLE WKEXS.PARD
  ADD CONSTRAINT PARD_PK PRIMARY KEY (DECOMP, ARCPO, DEDNO, DETYP);

CREATE TABLE WKEXS.PAY_TERMS_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PAY_TERMS_ID VARCHAR2(8) NOT NULL,
   PAY_DTL_ID VARCHAR2(8) NOT NULL,
   DESCRIPTION VARCHAR2(400) NULL,
   DESCRIPTION_CHT VARCHAR2(400) NULL,
   DESCRIPTION_CHS VARCHAR2(400) NULL,
   CREDIT_DAYS NUMBER(3, 0) NULL);

ALTER TABLE WKEXS.PAY_TERMS_DTL
  ADD CONSTRAINT PAY_TERMS_DTL_PK PRIMARY KEY (COMPANY_ID, PAY_TERMS_ID, PAY_DTL_ID);

CREATE TABLE WKEXS.PAY_TERMS_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PAY_TERMS_ID VARCHAR2(8) NOT NULL,
   DESCRIPTION VARCHAR2(400) NULL,
   TERMS_TYPE VARCHAR2(5) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL);

ALTER TABLE WKEXS.PAY_TERMS_HDR
  ADD CONSTRAINT PAY_TERMS_HDR_PK PRIMARY KEY (COMPANY_ID, PAY_TERMS_ID);

CREATE TABLE WKEXS.PBCATCOL
  (PBC_TNAM VARCHAR2(30) NOT NULL,
   PBC_TID NUMBER(22, 0) NULL,
   PBC_OWNR VARCHAR2(30) NOT NULL,
   PBC_CNAM VARCHAR2(30) NOT NULL,
   PBC_CID NUMBER(22, 0) NULL,
   PBC_LABL VARCHAR2(254) NULL,
   PBC_LPOS NUMBER(22, 0) NULL,
   PBC_HDR VARCHAR2(254) NULL,
   PBC_HPOS NUMBER(22, 0) NULL,
   PBC_JTFY NUMBER(22, 0) NULL,
   PBC_MASK VARCHAR2(31) NULL,
   PBC_CASE NUMBER(22, 0) NULL,
   PBC_HGHT NUMBER(22, 0) NULL,
   PBC_WDTH NUMBER(22, 0) NULL,
   PBC_PTRN VARCHAR2(31) NULL,
   PBC_BMAP CHAR(1) NULL,
   PBC_INIT VARCHAR2(254) NULL,
   PBC_CMNT VARCHAR2(254) NULL,
   PBC_EDIT VARCHAR2(31) NULL,
   PBC_TAG VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PBCATEDT
  (PBE_NAME VARCHAR2(30) NULL,
   PBE_EDIT VARCHAR2(254) NULL,
   PBE_TYPE NUMBER(22, 0) NULL,
   PBE_CNTR NUMBER(22, 0) NULL,
   PBE_SEQN NUMBER(22, 0) NULL,
   PBE_FLAG NUMBER(22, 0) NULL,
   PBE_WORK VARCHAR2(32) NULL);

CREATE TABLE WKEXS.PBCATFMT
  (PBF_NAME VARCHAR2(30) NULL,
   PBF_FRMT VARCHAR2(254) NULL,
   PBF_TYPE NUMBER(22, 0) NOT NULL,
   PBF_CNTR NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PBCATTBL
  (PBT_TNAM VARCHAR2(30) NOT NULL,
   PBT_TID NUMBER(22, 0) NULL,
   PBT_OWNR VARCHAR2(30) NOT NULL,
   PBD_FHGT NUMBER(22, 0) NULL,
   PBD_FWGT NUMBER(22, 0) NULL,
   PBD_FITL CHAR(1) NULL,
   PBD_FUNL CHAR(1) NULL,
   PBD_FCHR NUMBER(22, 0) NULL,
   PBD_FPTC NUMBER(22, 0) NULL,
   PBD_FFCE VARCHAR2(18) NULL,
   PBH_FHGT NUMBER(22, 0) NULL,
   PBH_FWGT NUMBER(22, 0) NULL,
   PBH_FITL CHAR(1) NULL,
   PBH_FUNL CHAR(1) NULL,
   PBH_FCHR NUMBER(22, 0) NULL,
   PBH_FPTC NUMBER(22, 0) NULL,
   PBH_FFCE VARCHAR2(18) NULL,
   PBL_FHGT NUMBER(22, 0) NULL,
   PBL_FWGT NUMBER(22, 0) NULL,
   PBL_FITL CHAR(1) NULL,
   PBL_FUNL CHAR(1) NULL,
   PBL_FCHR NUMBER(22, 0) NULL,
   PBL_FPTC NUMBER(22, 0) NULL,
   PBL_FFCE VARCHAR2(18) NULL,
   PBT_CMNT VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PBCATVLD
  (PBV_NAME VARCHAR2(30) NULL,
   PBV_VALD VARCHAR2(254) NULL,
   PBV_TYPE NUMBER(22, 0) NULL,
   PBV_CNTR NUMBER(22, 0) NULL,
   PBV_MSG VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PLAN_TABLE
  (STATEMENT_ID VARCHAR2(30) NULL,
   TIMESTAMP DATE NULL,
   REMARKS VARCHAR2(80) NULL,
   OPERATION VARCHAR2(30) NULL,
   OPTIONS VARCHAR2(30) NULL,
   OBJECT_NODE VARCHAR2(128) NULL,
   OBJECT_OWNER VARCHAR2(30) NULL,
   OBJECT_NAME VARCHAR2(30) NULL,
   OBJECT_INSTANCE NUMBER(22) NULL,
   OBJECT_TYPE VARCHAR2(30) NULL,
   OPTIMIZER VARCHAR2(255) NULL,
   SEARCH_COLUMNS NUMBER(22) NULL,
   ID NUMBER(22) NULL,
   PARENT_ID NUMBER(22) NULL,
   POSITION NUMBER(22) NULL,
   COST NUMBER(22) NULL,
   CARDINALITY NUMBER(22) NULL,
   BYTES NUMBER(22) NULL,
   OTHER_TAG VARCHAR2(255) NULL,
   PARTITION_START VARCHAR2(255) NULL,
   PARTITION_STOP VARCHAR2(255) NULL,
   PARTITION_ID NUMBER(22) NULL,
   OTHER LONG NULL,
   DISTRIBUTION VARCHAR2(30) NULL);

CREATE TABLE WKEXS.PMAMAP
  (OBJT NUMBER(22, 0) NOT NULL,
   CRTR NUMBER(22, 0) NULL,
   DELA NUMBER(22, 0) NULL,
   DELB NUMBER(22, 0) NULL,
   INSA NUMBER(22, 0) NULL,
   INSB NUMBER(22, 0) NULL,
   SELA NUMBER(22, 0) NULL,
   SELB NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMATTR
  (ATTR NUMBER(22, 0) NOT NULL,
   CLSS NUMBER(22, 0) NOT NULL,
   DSID NUMBER(22, 0) NOT NULL,
   NAME VARCHAR2(254) NOT NULL,
   CODE VARCHAR2(254) NOT NULL,
   CTYP NUMBER(22, 0) NOT NULL,
   FLGS NUMBER(22, 0) NOT NULL,
   TNAM VARCHAR2(254) NULL,
   CNAM VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMBMAP
  (OBJT NUMBER(22, 0) NOT NULL,
   CRTR NUMBER(22, 0) NULL,
   QURY NUMBER(22, 0) NULL);

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

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

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

CREATE TABLE WKEXS.PMBPMFRMT
  (OBJT NUMBER(22, 0) NOT NULL,
   DEFN NUMBER(22, 0) NULL,
   DURL NUMBER(22, 0) NULL,
   FMTT VARCHAR2(254) NULL,
   STRN VARCHAR2(254) NULL);

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

CREATE TABLE WKEXS.PMBPMPROC
  (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,