table.ddl

j2ee源码

CREATE TABLE WKEXS.PMPDMABDT
  (OBJT NUMBER(22, 0) NOT NULL,
   DTTP VARCHAR2(254) NULL,
   MLEN NUMBER(22, 0) NULL,
   OFIL NUMBER(22, 0) NULL,
   OSIZ NUMBER(22, 0) NULL,
   OTYP VARCHAR2(254) NULL,
   PREC NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMCIDX
  (OBJT NUMBER(22, 0) NOT NULL,
   ASCD NUMBER(22, 0) NULL,
   EXPR NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMDTBS
  (OBJT NUMBER(22, 0) NOT NULL,
   FOOT NUMBER(22, 0) NULL,
   HEAD NUMBER(22, 0) NULL,
   OPTS NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMINDX
  (OBJT NUMBER(22, 0) NOT NULL,
   OPTS NUMBER(22, 0) NULL,
   OTYP VARCHAR2(40) NULL,
   UNIQ NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMJIDX
  (OBJT NUMBER(22, 0) NOT NULL,
   FOOT NUMBER(22, 0) NULL,
   HEAD NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMMEAS
  (OBJT NUMBER(22, 0) NOT NULL,
   FRML NUMBER(22, 0) NULL,
   IFRM NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMPROC
  (OBJT NUMBER(22, 0) NOT NULL,
   PCDT NUMBER(22, 0) NULL,
   TXTV NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMPROF
  (OBJT NUMBER(22, 0) NOT NULL,
   CHAL NUMBER(22, 0) NULL,
   CHCS NUMBER(22, 0) NULL,
   CHFM VARCHAR2(254) NULL,
   CHFU NUMBER(22, 0) NULL,
   CHIV VARCHAR2(254) NULL,
   CHLN NUMBER(22, 0) NULL,
   CHNA NUMBER(22, 0) NULL,
   CHRF NUMBER(22, 0) NULL,
   CHRL NUMBER(22, 0) NULL,
   CHVL VARCHAR2(254) NULL,
   CHXL NUMBER(22, 0) NULL,
   CLSS NUMBER(22, 0) NULL,
   COLN VARCHAR2(254) NULL,
   DFDY NUMBER(22, 0) NULL,
   DFHR NUMBER(22, 0) NULL,
   DFMI NUMBER(22, 0) NULL,
   DFMO NUMBER(22, 0) NULL,
   DFSC NUMBER(22, 0) NULL,
   DFYR NUMBER(22, 0) NULL,
   DLDY NUMBER(22, 0) NULL,
   DLHR NUMBER(22, 0) NULL,
   DLMI NUMBER(22, 0) NULL,
   DLMO NUMBER(22, 0) NULL,
   DLSC NUMBER(22, 0) NULL,
   DLYR NUMBER(22, 0) NULL,
   DSDY NUMBER(22, 0) NULL,
   DSHR NUMBER(22, 0) NULL,
   DSMI NUMBER(22, 0) NULL,
   DSMO NUMBER(22, 0) NULL,
   DSSC NUMBER(22, 0) NULL,
   DSYR NUMBER(22, 0) NULL,
   HQRY NUMBER(22, 0) NULL,
   NBDC NUMBER(22, 0) NULL,
   NBDG NUMBER(22, 0) NULL,
   NBHV FLOAT(126) NULL,
   NBLV FLOAT(126) NULL,
   NBST FLOAT(126) NULL,
   ODSL VARCHAR2(254) NULL,
   ODSN VARCHAR2(254) NULL,
   ODSP VARCHAR2(254) NULL,
   OFIL VARCHAR2(254) NULL,
   SEQU NUMBER(22, 0) NULL,
   TABL VARCHAR2(254) NULL,
   VALS NUMBER(22, 0) NULL,
   VSRC NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMREFR
  (OBJT NUMBER(22, 0) NOT NULL,
   CARD VARCHAR2(10) NULL,
   CMMT NUMBER(22, 0) NULL,
   CPRT NUMBER(22, 0) NULL,
   DRUL NUMBER(22, 0) NULL,
   FKCN VARCHAR2(254) NULL,
   GENE NUMBER(22, 0) NULL,
   IMPL VARCHAR2(2) NULL,
   SRTJ NUMBER(22, 0) NULL,
   URUL NUMBER(22, 0) NULL);

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

CREATE TABLE WKEXS.PMPDMTABL
  (OBJT NUMBER(22, 0) NOT NULL,
   CKCN VARCHAR2(254) NULL,
   CRUL NUMBER(22, 0) NULL,
   FOOT NUMBER(22, 0) NULL,
   GENE NUMBER(22, 0) NULL,
   HEAD NUMBER(22, 0) NULL,
   NBRC FLOAT(126) NULL,
   OPTS NUMBER(22, 0) NULL,
   OTYP NUMBER(22, 0) NULL,
   SRUL NUMBER(22, 0) NULL,
   TSTD NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMTKEY
  (OBJT NUMBER(22, 0) NOT NULL,
   CNST VARCHAR2(254) NULL,
   OPTS NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMTRGI
  (OBJT NUMBER(22, 0) NOT NULL,
   DECL NUMBER(22, 0) NULL,
   TXTV NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMTRGR
  (OBJT NUMBER(22, 0) NOT NULL,
   GENE NUMBER(22, 0) NULL,
   OTYP VARCHAR2(3) NULL,
   TXTV NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMTRGT
  (OBJT NUMBER(22, 0) NOT NULL,
   OTYP VARCHAR2(3) NULL,
   TNAM VARCHAR2(254) NULL,
   TXTV NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMPDMVIEW
  (OBJT NUMBER(22, 0) NOT NULL,
   FOOT NUMBER(22, 0) NULL,
   GENE NUMBER(22, 0) NULL,
   HEAD NUMBER(22, 0) NULL,
   OPTS NUMBER(22, 0) NULL,
   TSQL NUMBER(22, 0) NULL,
   USAG NUMBER(22, 0) NULL,
   USQL NUMBER(22, 0) NULL,
   VSQL NUMBER(22, 0) NULL);

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

CREATE TABLE WKEXS.PMPERM
  (POID NUMBER(22, 0) NOT NULL,
   RUSR NUMBER(22, 0) NOT NULL,
   OPRM NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMRLSH
  (RTYP NUMBER(22, 0) NOT NULL,
   SRCE NUMBER(22, 0) NOT NULL,
   TRGT NUMBER(22, 0) NOT NULL,
   PRNT NUMBER(22, 0) NOT NULL,
   NUMR NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMRLTN
  (RLTN NUMBER(22, 0) NOT NULL,
   LIBR 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,
   FLGS NUMBER(22, 0) NOT NULL,
   PRNT NUMBER(22, 0) NOT NULL,
   NFND NUMBER(22, 0) NOT NULL,
   SEQN NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMRPRT
  (OBJT NUMBER(22, 0) NOT NULL,
   FPAU NUMBER(22, 0) NULL,
   FPDT NUMBER(22, 0) NULL,
   FPTT NUMBER(22, 0) NULL,
   FPVS NUMBER(22, 0) NULL,
   HFAU NUMBER(22, 0) NULL,
   HFDT NUMBER(22, 0) NULL,
   HFPG NUMBER(22, 0) NULL,
   HFSM NUMBER(22, 0) NULL,
   HFTT NUMBER(22, 0) NULL,
   HFVS NUMBER(22, 0) NULL,
   RPSM NUMBER(22, 0) NULL,
   SNUM NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMRULE
  (OBJT NUMBER(22, 0) NOT NULL,
   CEXP NUMBER(22, 0) NULL,
   FLAG NUMBER(22, 0) NULL,
   RTYP NUMBER(22, 0) NULL,
   SEXP NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMSEQN
  (NAME VARCHAR2(80) NOT NULL,
   VALE NUMBER(22, 0) NOT NULL);

CREATE TABLE WKEXS.PMSMAP
  (OBJT NUMBER(22, 0) NOT NULL,
   ALIA VARCHAR2(254) NULL,
   EXPR NUMBER(22, 0) NULL);

CREATE TABLE WKEXS.PMTEMP
  (SESS NUMBER(22, 0) NOT NULL,
   INT1 NUMBER(22, 0) NULL,
   INT2 NUMBER(22, 0) NULL,
   STR1 VARCHAR2(254) NULL,
   STR2 VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PMTEXT
  (TXID NUMBER(22, 0) NOT NULL,
   NUMR NUMBER(22, 0) NOT NULL,
   TDAT VARCHAR2(2000) NOT NULL);

CREATE TABLE WKEXS.PMUSER
  (RUSR NUMBER(22, 0) NOT NULL,
   NAME VARCHAR2(254) NULL,
   CODE VARCHAR2(254) NOT NULL,
   SYST NUMBER(22, 0) NOT NULL,
   RGHT NUMBER(22, 0) NULL,
   CMMT NUMBER(22, 0) NULL,
   EMAD VARCHAR2(254) NULL,
   ISGR NUMBER(22, 0) NOT NULL,
   PSWD VARCHAR2(254) NULL,
   OCUS NUMBER(22, 0) NULL,
   OCDT DATE NULL,
   OMUS NUMBER(22, 0) NULL,
   OMDT DATE NULL);

CREATE TABLE WKEXS.PMXFIL
  (OBJT NUMBER(22, 0) NOT NULL,
   CNTT LONG RAW NULL,
   XNAM VARCHAR2(254) NULL);

CREATE TABLE WKEXS.PN_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PN_NO VARCHAR2(17) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   PAPER_SIZE_ID NUMBER(11, 2) NOT NULL,
   SC_TXN_NO VARCHAR2(17) NULL,
   DESCRIPTION VARCHAR2(200) NULL,
   UOM VARCHAR2(2) NULL,
   SC_UNIT_PRICE NUMBER(16, 5) NULL,
   UNIT_PRICE NUMBER(16, 5) NULL,
   ORDER_QTY NUMBER(10, 0) NULL,
   EST_ORDER_WEIGHT NUMBER(12, 3) NULL,
   EX_FACTORY_PRICE NUMBER(13, 5) NULL,
   PROFIT_RATE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.PN_DTL
  ADD CONSTRAINT PN_DTL_PK PRIMARY KEY (COMPANY_ID, PN_NO, PAPER_TYPE_ID, PAPER_SIZE_ID);

CREATE TABLE WKEXS.PN_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PN_NO VARCHAR2(17) NOT NULL,
   STATUS VARCHAR2(5) NULL,
   SC_TXN_NO VARCHAR2(17) NULL,
   SC_NO VARCHAR2(17) NULL,
   QUOTATION_TXN_NO VARCHAR2(16) NULL,
   QUOTATION_NO VARCHAR2(16) NULL,
   PN_DATE DATE NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   TRADE_TERMS_ID VARCHAR2(5) NULL,
   SUPPLIER_SO_NO VARCHAR2(30) NULL,
   SHIP_LINE_ID VARCHAR2(20) NULL,
   VESSEL_NAME VARCHAR2(200) NULL,
   LOADING_PORT_ID VARCHAR2(10) NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NULL,
   COMMISSION_RATE NUMBER(12, 2) NULL,
   CONTAINER_SIZE VARCHAR2(20) NULL,
   CONTAINER_QTY NUMBER(10, 0) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   SUPPLIER_ID NUMBER(8, 0) NULL,
   AGENT_ID NUMBER(8, 0) NULL,
   LOADING_PLACE VARCHAR2(800) NULL,
   ETD DATE NULL,
   QTY_TOLERANCE_PERCENT NUMBER(5, 2) NULL,
   LATEST_PROD_DATE DATE NULL,
   PACKING_REQ VARCHAR2(2000) NULL,
   REMARK VARCHAR2(2000) NULL,
   DOCUMENT_FEE NUMBER(13, 5) NULL,
   TON_PER_CONTAINER NUMBER(12, 3) NULL,
   TTL_ORDER_QTY NUMBER(10, 0) NULL,
   TTL_EST_ORDER_WEIGHT NUMBER(12, 3) NULL,
   CREATE_DTTM DATE NULL,
   CREATE_BY VARCHAR2(15) NULL,
   VOID_DTTM DATE NULL,
   VOID_BY VARCHAR2(15) NULL,
   POST_DTTM DATE NULL,
   POST_BY VARCHAR2(15) NULL,
   LAST_MODIFY_DTTM DATE NULL,
   LAST_MODIFY_BY VARCHAR2(15) NULL,
   VERSION_NO NUMBER(2, 0) NULL,
   UNPOST_DTTM DATE NULL,
   UNPOST_BY VARCHAR2(15) NULL,
   INSURANCE_RATE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.PN_HDR
  ADD CONSTRAINT PN_HDR_PK PRIMARY KEY (COMPANY_ID, PN_NO);

CREATE TABLE WKEXS.PN_UPRI_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PN_NO VARCHAR2(17) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   STD_PRICE_CURRENCY_ID VARCHAR2(3) NULL,
   STD_PRICE_EXCHG_RATE NUMBER(13, 7) NULL,
   STD_PRICE_PER_TON NUMBER(13, 5) NULL,
   INLAND_CURRENCY_ID VARCHAR2(3) NULL,
   INLAND_EXCHG_RATE NUMBER(13, 7) NULL,
   EIR NUMBER(13, 5) NULL,
   HAULAGE_CHARGE NUMBER(13, 5) NULL,
   AMS NUMBER(13, 5) NULL,
   THC 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,
   FREIGHT_CURRENCY_ID VARCHAR2(3) NULL,
   FREIGHT_EXCHG_RATE NUMBER(13, 7) NULL,
   OCEAN_FREIGHT NUMBER(13, 5) NULL,
   BAF NUMBER(13, 5) NULL,
   CAF NUMBER(13, 5) NULL,
   FAF NUMBER(13, 5) NULL,
   GRI NUMBER(13, 5) NULL,
   PSS NUMBER(13, 5) NULL,
   WRS NUMBER(13, 5) NULL,
   ISPS NUMBER(13, 5) NULL,
   F_OTHER_CHARGE NUMBER(13, 5) NULL);

ALTER TABLE WKEXS.PN_UPRI_DTL
  ADD CONSTRAINT PN_UPRI_DTL_PK PRIMARY KEY (COMPANY_ID, PN_NO, PAPER_TYPE_ID);

CREATE TABLE WKEXS.PORT
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   PORT_ID VARCHAR2(10) NOT NULL,
   DESCRIPTION_ENG VARCHAR2(800) NULL,
   DESCRIPTION_CHT VARCHAR2(800) NULL,
   DESCRIPTION_CHS VARCHAR2(800) NULL,
   DISTRICT_ID 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.PORT
  ADD CONSTRAINT PORT_PK PRIMARY KEY (COMPANY_ID, PORT_ID);

CREATE TABLE WKEXS.PRAR
  (RCOMPS VARCHAR2(20) NOT NULL,
   RSEQID VARCHAR2(15) NOT NULL,
   RCURR VARCHAR2(3) NULL,
   RCUST NUMBER(8, 0) NULL,
   DEPT_ID VARCHAR2(2) NULL,
   RMODE VARCHAR2(1) NULL,
   RAMT NUMBER(12, 2) NULL,
   RIDATE DATE NULL,
   ARODPX VARCHAR2(1) NULL,
   ARCPO VARCHAR2(20) NULL,
   RDDTE DATE NULL,
   RREF VARCHAR2(20) NULL,
   RDNO VARCHAR2(20) NULL,
   RCONT VARCHAR2(20) NULL,
   RDESC VARCHAR2(20) NULL,
   BPCS_TSF VARCHAR2(1) NULL,
   BPCS_TSF_DATE DATE NULL,
   TTL_AMT NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.PRAR
  ADD CONSTRAINT PRAR_PK PRIMARY KEY (RCOMPS, RSEQID);

CREATE TABLE WKEXS.PRIVILEGE
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   MODULE VARCHAR2(400) NULL,
   LANG_ID VARCHAR2(4) NOT NULL,
   PROGRAM_ID VARCHAR2(20) NOT NULL,
   PROGRAM_NAME VARCHAR2(400) NULL,
   PRIV_ID NUMBER(10, 0) NOT NULL,
   PRIV_DESC VARCHAR2(400) NULL);

ALTER TABLE WKEXS.PRIVILEGE
  ADD CONSTRAINT PRIVILEGE_PK PRIMARY KEY (COMPANY_ID, LANG_ID, PROGRAM_ID, PRIV_ID);

CREATE TABLE WKEXS.QUOTATION_DTL
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   QUOTATION_TXN_NO VARCHAR2(16) NOT NULL,
   PAPER_TYPE_ID VARCHAR2(15) NOT NULL,
   DESCRIPTION VARCHAR2(400) NULL,
   UNIT_PRICE NUMBER(16, 5) NULL,
   EX_FACTORY_PRICE NUMBER(13, 5) NULL,
   PROFIT_RATE NUMBER(12, 2) NULL);

ALTER TABLE WKEXS.QUOTATION_DTL
  ADD CONSTRAINT QUOTATION_DTL_PK PRIMARY KEY (COMPANY_ID, QUOTATION_TXN_NO, PAPER_TYPE_ID);

CREATE TABLE WKEXS.QUOTATION_HDR
  (COMPANY_ID VARCHAR2(20) NOT NULL,
   QUOTATION_NO VARCHAR2(16) NULL,
   QUOTATION_TXN_NO VARCHAR2(16) NOT NULL,
   QUOTATION_DATE DATE NULL,
   STATUS VARCHAR2(5) NULL,
   CUSTOMER_ID NUMBER(8, 0) NULL,
   CURRENCY_ID VARCHAR2(3) NULL,
   TRADE_TERMS_ID VARCHAR2(5) NULL,
   TRADE_TERMS_REMARK VARCHAR2(400) NULL,
   PAY_TERMS_ID VARCHAR2(8) NULL,
   PAY_DTL_ID VARCHAR2(8) NULL,
   SHIP_LINE_ID VARCHAR2(20) NULL,
   LOADING_PORT_ID VARCHAR2(10) NULL,
   DISCHARGE_PORT_ID VARCHAR2(10) NULL,
   SUPPLIER_ID NUMBER(8, 0) NULL,
   AGENT_ID NUMBER(8, 0) NULL,