CREATE TABLE "DB_TWODEVELOPMENTPRODUCTLOG" ( "SEQUENCEID" VARCHAR2(50), 
"SID" VARCHAR2(100), "NAME" VARCHAR2(100), 
"DESCR" VARCHAR2(4000), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "FILED1" VARCHAR2(400), 
"FILED2" VARCHAR2(400), "FILED3" VARCHAR2(400), 
"FILED4" VARCHAR2(400), "FILED5" VARCHAR2(400), 
"FILED6" VARCHAR2(4000), "FILED7" VARCHAR2(4000), 
"FILED8" NUMBER(8, 2), "FILED9" NUMBER(8, 2), 
"FILED10" NUMBER(8, 2), "CORPID" VARCHAR2(50), 
"OPENFLAG" VARCHAR2(10), "OPERTYPE" VARCHAR2(50), 
"CONTENT" VARCHAR2(4000), CONSTRAINT "PK_DB_TWODEVELOPMENTPRODUCTLOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING ;

----------------------------xiao 5 0415--------------------------------------------
CREATE TABLE "DB_PROTOCOL" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "SKU" VARCHAR2(50 byte), "NAME" VARCHAR2(1000
    byte), "URGENT" VARCHAR2(100 byte), "CREATEOPER" VARCHAR2(50 
    byte), "EXECUTOR" VARCHAR2(50 byte), "STATUS" VARCHAR2(100 
    byte), "CREATETIME" DATE, "STARTTIME" DATE, "BACKTIME" DATE, 
    "ENDTIME" DATE, "TITLE" VARCHAR2(1000 byte), "DESCR" 
    VARCHAR2(2000 byte), "PICTURE1" VARCHAR2(100 byte), 
    "PICTURE2" VARCHAR2(100 byte), "PICTURE3" VARCHAR2(100 byte),
    "BACKREASON" VARCHAR2(1000 byte), "NOTE" VARCHAR2(2000 byte),
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" NUMBER(10), 
    "RESERVE7" NUMBER(10), "RESERVE8" NUMBER(10, 4), "RESERVE9" 
    NUMBER(10, 4), "RESERVE10" DATE, "OPERTIME" DATE, "RESERVE11"
    DATE, "RESERVE12" DATE, "RESERVE13" DATE, "FLAG" VARCHAR2(50 
    byte), "CHECKOPER" VARCHAR2(50 byte), "CHECKNOTREASON" 
    VARCHAR2(2000 byte), "CHECKTIME" DATE, "REPEATTIME" DATE, 
    "OPER" VARCHAR2(50 byte), 
    CONSTRAINT "PK_SID_DB_PROTOCOL" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;
-------------------------------------------------------------------------
CREATE TABLE "DB_MODIFYLOCATION_TEMP" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "PRODUCTID" VARCHAR2(50 byte) NOT
    NULL, "LOCATIONNAME" VARCHAR2(50 byte) NOT NULL, "CREATEDATE"
    DATE, "FILED1" VARCHAR2(2000 byte), "FILED2" VARCHAR2(100 
    byte), "FILED3" VARCHAR2(100 byte), "FILED4" NUMBER(10, 4), 
    "FILED5" NUMBER(10, 4), "FILED6" DATE, "STORAGEID" 
    VARCHAR2(50 byte), "STORAGENAME" VARCHAR2(100 byte), 
    CONSTRAINT "PK_DB_MODIFYLOCATION_TEMP" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING;

---------------hp 20130219销售系数表及日志表----------------------
CREATE TABLE "DB_SALESCOEFFICIENT" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "RANK" VARCHAR2(10 byte),
    "RANGE1" NUMBER(8, 4), "RANGE2" NUMBER(8, 4), "OPER"
    VARCHAR2(20 byte), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10
    byte), "CORPID" VARCHAR2(10 byte), "FILED1" VARCHAR2(100
    byte), "FILED2" VARCHAR2(100 byte), "FILED3" NUMBER(8),
    "FILED4" NUMBER(8, 4), "FILED5" NUMBER(8, 4),
    CONSTRAINT "PK_DB_SALESCOEFFICIENT" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;



CREATE TABLE "DB_SALESCOEFFICIENTLOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "RANK" VARCHAR2(10 byte),
    "RANGE1" NUMBER(8, 4), "RANGE2" NUMBER(8, 4), "OPER"
    VARCHAR2(20 byte), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10
    byte), "CORPID" VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(10
    byte), "CONTENT" VARCHAR2(1000 byte), "FILED1" VARCHAR2(100
    byte), "FILED2" VARCHAR2(100 byte), "FILED3" NUMBER(8),
    "FILED4" NUMBER(8, 4), "FILED5" NUMBER(8, 4),
    CONSTRAINT "DB_SALESCOEFFICIENTLOG" PRIMARY KEY("SEQUENCEID")
    USING INDEX
    TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING;

CREATE TABLE DB_EXPRESSIDDATA 
(SID VARCHAR2(100
    byte) NOT NULL, 
Prefix VARCHAR2(500 byte), 
Suffix VARCHAR2(500 byte), 
EXPRESSIDBEGIN    NUMBER(12), 
EXPRESSIDEND NUMBER(12), 
USEEXPRESSID NUMBER(12), 
EXPRESSTYPEID
    VARCHAR2(500 byte),
EXPRESSTYPE VARCHAR2(50 byte),
operflag VARCHAR2(10 byte), 
OPER VARCHAR2(50 byte),
   
 OPERTIME DATE, 
CREATEOPER VARCHAR2(50 byte), 
CREATTIME
    DATE, CORPID VARCHAR2(10 byte),
   
 CONSTRAINT PK_DB_EXPRESSIDDATA PRIMARY KEY(SID));		
 
 

CREATE TABLE DB_EXPRESSIDDATALOG

(SEQUENCEID VARCHAR2(100
    byte) NOT NULL,

SID VARCHAR2(100
    byte),

Prefix VARCHAR2(500 byte),
Suffix VARCHAR2(500 byte),
EXPRESSIDBEGIN    NUMBER(12),
EXPRESSIDEND NUMBER(12),
USEEXPRESSID NUMBER(12),
EXPRESSTYPEID
    VARCHAR2(500 byte),

EXPRESSTYPE VARCHAR2(50 byte),

operflag VARCHAR2(10 byte),
OPER VARCHAR2(50 byte),

OPERTIME DATE,

CREATEOPER VARCHAR2(50 byte),

CREATTIME
    DATE,

OPENTYPE VARCHAR2(50 byte),

CONTENT VARCHAR2(4000 byte),

CORPID VARCHAR2(10 byte),
CONSTRAINT PK_DB_EXPRESSIDDATALOG PRIMARY KEY(SEQUENCEID));
---------------sl 20130204----------------------
CREATE TABLE "DB_PUBLISHPICTURE" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "PRODUCTID" VARCHAR2(50 byte), 
    "PICTUREURL" VARCHAR2(300 byte), "ATTRIBUTE" VARCHAR2(50 
    byte), "PLATFORMID" VARCHAR2(20 byte), "PLATFORMNAME" 
    VARCHAR2(50 byte), "FLAG" VARCHAR2(10 byte), "SHOPTYPEID" 
    VARCHAR2(10 byte), "SHOPTYPENAME" VARCHAR2(50 byte), "CORPID"
    VARCHAR2(10 byte), "OPERNFLAG" VARCHAR2(10 byte), "OPER" 
    VARCHAR2(50 byte), "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50 
    byte), "CREATETIME" DATE, 
    CONSTRAINT "PK_DB_PUBLISHPICTURE" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING  ;
   
CREATE TABLE "DB_ANTISTOP" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "ANTISTOP" VARCHAR2(500 byte), "DESCR" 
    VARCHAR2(4000 byte), "PARENTID" VARCHAR2(50 byte), 
    "PARENTFLAG" VARCHAR2(10 byte), "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50 byte), "CREATTIME" 
    DATE, "CORPID" VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 
    byte), 
    CONSTRAINT "PK_DB_OPENFLAG" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ; 
----------------hp 采购流程  20130122----
CREATE TABLE "DB_PURCHASEFLOW" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "OPER" VARCHAR2(50 byte), "OPENFLAG" 
    VARCHAR2(10 byte), "OPERTIME" DATE, "CORPID" VARCHAR2(50 
    byte), "ARRIVEDATE" DATE, "POSITION" VARCHAR2(1000 byte), 
    "FOLLOWUPOPER" VARCHAR2(50 byte), "POORDERFLAG" VARCHAR2(10 
    byte), "COMPANY" VARCHAR2(1000 byte), "PRODUCTID" VARCHAR2(50
    byte), "PRODUCTNAME" VARCHAR2(1000 byte), "PAYMENT" 
    VARCHAR2(200 byte), "ALLMONEY" NUMBER(10, 2), "DEPOSIT" 
    NUMBER(10, 2), "STATUS" VARCHAR2(10 byte), "DOLLAR" NUMBER(10,
    2), "POSURE" VARCHAR2(100 byte), "CONTENT" VARCHAR2(4000 
    byte), "PHOTOQCDATE" DATE, "NOTE" VARCHAR2(4000 byte), 
    "SAMPLENUM" NUMBER(8), "SAMPLEARRIVEDATE" DATE, "FTCBM" 
    NUMBER(10, 4), "DELIVERYDATE" DATE, "FINISHORDERDATE" DATE, 
    "DRAWBACKDATE" DATE, "CITY" VARCHAR2(500 byte), "EXPRESSDATE"
    DATE, "CKY" VARCHAR2(100 byte), "FPX" VARCHAR2(100 byte), 
    "EXPRESSID" VARCHAR2(50 byte), "PONUM" VARCHAR2(50 byte), 
    "LOADDATE" DATE, "ETAHARBOURDATE" DATE, "ETAARRIVEDATE" DATE,
    "ARRIVESTOREDATE" DATE, "CONTAINERNOTE" VARCHAR2(2000 byte), 
    "AUGARNEREDDATE" DATE, "PACKINGLIST" VARCHAR2(2000 byte), 
    "BILLOFLADING" VARCHAR2(100 byte), "SHIPMENTUPDATEINVENTORY" 
    VARCHAR2(1000 byte), "GARNEREDUPDATEINVENTORY" VARCHAR2(1000 
    byte), "CLOSEDATE" DATE, "GROUPID" VARCHAR2(50 byte), 
    "DEPOSITDATE" DATE, "EXPRESSTYPE" VARCHAR2(50 byte), 
    "CREATEOPER" VARCHAR2(50 byte), "CREATEDATE" DATE, 
    "DRAWBACKFLAG" VARCHAR2(50 byte), "SHIPMENTDATE" DATE, 
    "ARRIVALDATE" DATE, "FINALDATE" DATE, "SHIPMENTMONEY" 
    NUMBER(10, 2), "ARRIVALMONEY" NUMBER(10, 2), "FINALMONEY" 
    NUMBER(10, 2), "URGENT" VARCHAR2(50 byte), "MONEYNOTE" 
    VARCHAR2(4000 byte), "PICTURE1" VARCHAR2(500 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" DATE, "RESERVE7" 
    DATE, "RESERVE8" DATE, "RESERVE9" NUMBER(8), "RESERVE10" 
    NUMBER(8), "RESERVE11" NUMBER(8), "RESERVE12" NUMBER(8, 4), 
    "RESERVE13" NUMBER(8, 2), "RESERVE14" NUMBER(8, 2), 
    "OUTERLENGTH" NUMBER(8, 2), "OUTERWIDTH" NUMBER(8, 2), 
    "OUTERHIGH" NUMBER(8, 2), "OUTERVOLUME" NUMBER(8, 2), 
    "OUTERGROSSWEIGHT" NUMBER(8, 2), "OUTERNETWEIGHT" NUMBER(8, 
    2), "OUTERNORMS" VARCHAR2(1000 byte), "OUTERLEVEL" 
    VARCHAR2(500 byte), "GROSSWEIGHT" NUMBER(8, 2), "LENGTH" 
    NUMBER(8, 2), "WIDTH" NUMBER(8, 2), "HIGH" NUMBER(8, 2), 
    "VOLUME" NUMBER(8, 2), 
    CONSTRAINT "PK_DBPURCHASEFLOW" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
----------------sl 出口易表----
CREATE TABLE "DB_DEPARTMENTAPI" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "DEPARTMENT" VARCHAR2(100 byte),
    "USERNAME" VARCHAR2(100 byte), "USERKEY" VARCHAR2(100 byte), 
    "TOKEN" VARCHAR2(200 byte), "PASSWORD" VARCHAR2(50 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(100 byte), "RESERVE4" NUMBER(10, 3), 
    "RESERVE5" NUMBER(10, 3), "OPER" VARCHAR2(400 byte), 
    "OPERTIME" DATE, 
    CONSTRAINT "PK_DEPARTMENT_SEQUENCEID" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;  
---------------sl 20130111 财务表----------------
CREATE TABLE "DB_FINANCIAL" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "SOURCE" VARCHAR2(500 byte), "NAME" 
    VARCHAR2(500 byte), "GROUPID" VARCHAR2(100 byte), "CATEGORY" 
    VARCHAR2(100 byte), "PAYTYPE" VARCHAR2(100 byte), "STATUS" 
    VARCHAR2(50 byte), "STARPAYTIME" DATE, "LASTPAYTIME" DATE, 
    "PAYTIME" DATE, "DEPARMENT" VARCHAR2(100 byte), "YINGFUMOMEY"
    NUMBER(8, 2), "FINALMONEY" NUMBER(8, 2), "MONEYTYPE" 
    VARCHAR2(100 byte), "PAYOPER" VARCHAR2(100 byte), 
    "SHENHEIOPER" VARCHAR2(100 byte), "SHENHEITIME" DATE, "DESCR"
    VARCHAR2(2000 byte), "OPER" VARCHAR2(100 byte), "OPERTIME" 
    DATE, "OPENFLAG" VARCHAR2(10 byte), "CORPID" VARCHAR2(10 
    byte), "REMARK" VARCHAR2(4000 byte), "RESERVE1" VARCHAR2(500 
    byte), "RESERVE2" VARCHAR2(1000 byte), "RESERVE3" 
    VARCHAR2(1000 byte), "RESERVE4" NUMBER(10, 2), "RESERVE5" 
    NUMBER(10, 2), 
    CONSTRAINT "PK_DB_FINANCIAL_SEQUENCEID" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
--------------------sl 采购主表---------------------------------------
CREATE TABLE "DB_PURCHASEDEVELOP" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "GROUPID" VARCHAR2(100 byte), 
    "MANUFACTUREID" VARCHAR2(100 byte), "MANUFACTURENAME" 
    VARCHAR2(500 byte), "PAYTYPE" VARCHAR2(100 byte), "FREIGHT" 
    NUMBER(8, 2), "OPER" VARCHAR2(100 byte), "OPERTIME" DATE, 
    "CREATOPER" VARCHAR2(100 byte), "CREATOPERTIME" DATE, 
    "CORPID" VARCHAR2(100 byte), "OPENFLAG" VARCHAR2(10 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" NUMBER(10), 
    "RESERVE5" NUMBER(8, 2), 
    CONSTRAINT "PK_DBPURCHASEDEVELOP" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
----------------hp 采购流程  20130122----
CREATE TABLE "DB_PURCHASEFLOW" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "OPER" VARCHAR2(50 byte), "OPENFLAG" 
    VARCHAR2(10 byte), "OPERTIME" DATE, "CORPID" VARCHAR2(50 
    byte), "ARRIVEDATE" DATE, "POSITION" VARCHAR2(1000 byte), 
    "FOLLOWUPOPER" VARCHAR2(50 byte), "POORDERFLAG" VARCHAR2(10 
    byte), "COMPANY" VARCHAR2(1000 byte), "PRODUCTID" VARCHAR2(50
    byte), "PRODUCTNAME" VARCHAR2(1000 byte), "PAYMENT" 
    VARCHAR2(200 byte), "ALLMONEY" NUMBER(10, 2), "DEPOSIT" 
    NUMBER(10, 2), "STATUS" VARCHAR2(10 byte), "DOLLAR" NUMBER(10,
    2), "POSURE" VARCHAR2(100 byte), "CONTENT" VARCHAR2(4000 
    byte), "PHOTOQCDATE" DATE, "NOTE" VARCHAR2(4000 byte), 
    "SAMPLENUM" NUMBER(8), "SAMPLEARRIVEDATE" DATE, "FTCBM" 
    NUMBER(10, 4), "DELIVERYDATE" DATE, "FINISHORDERDATE" DATE, 
    "DRAWBACKDATE" DATE, "CITY" VARCHAR2(500 byte), "EXPRESSDATE"
    DATE, "CKY" VARCHAR2(100 byte), "FPX" VARCHAR2(100 byte), 
    "EXPRESSID" VARCHAR2(50 byte), "PONUM" VARCHAR2(50 byte), 
    "LOADDATE" DATE, "ETAHARBOURDATE" DATE, "ETAARRIVEDATE" DATE,
    "ARRIVESTOREDATE" DATE, "CONTAINERNOTE" VARCHAR2(2000 byte), 
    "AUGARNEREDDATE" DATE, "PACKINGLIST" VARCHAR2(2000 byte), 
    "BILLOFLADING" VARCHAR2(100 byte), "SHIPMENTUPDATEINVENTORY" 
    VARCHAR2(1000 byte), "GARNEREDUPDATEINVENTORY" VARCHAR2(1000 
    byte), "CLOSEDATE" DATE, "GROUPID" VARCHAR2(50 byte), 
    "DEPOSITDATE" DATE, "EXPRESSTYPE" VARCHAR2(50 byte), 
    "CREATEOPER" VARCHAR2(50 byte), "CREATEDATE" DATE, 
    "DRAWBACKFLAG" VARCHAR2(50 byte), "SHIPMENTDATE" DATE, 
    "ARRIVALDATE" DATE, "FINALDATE" DATE, "SHIPMENTMONEY" 
    NUMBER(10, 2), "ARRIVALMONEY" NUMBER(10, 2), "FINALMONEY" 
    NUMBER(10, 2), "URGENT" VARCHAR2(50 byte), "MONEYNOTE" 
    VARCHAR2(4000 byte), "PICTURE1" VARCHAR2(500 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" DATE, "RESERVE7" 
    DATE, "RESERVE8" DATE, "RESERVE9" NUMBER(8), "RESERVE10" 
    NUMBER(8), "RESERVE11" NUMBER(8), "RESERVE12" NUMBER(8, 4), 
    "RESERVE13" NUMBER(8, 2), "RESERVE14" NUMBER(8, 2), 
    "OUTERLENGTH" NUMBER(8, 2), "OUTERWIDTH" NUMBER(8, 2), 
    "OUTERHIGH" NUMBER(8, 2), "OUTERVOLUME" NUMBER(8, 2), 
    "OUTERGROSSWEIGHT" NUMBER(8, 2), "OUTERNETWEIGHT" NUMBER(8, 
    2), "OUTERNORMS" VARCHAR2(1000 byte), "OUTERLEVEL" 
    VARCHAR2(500 byte), "GROSSWEIGHT" NUMBER(8, 2), "LENGTH" 
    NUMBER(8, 2), "WIDTH" NUMBER(8, 2), "HIGH" NUMBER(8, 2), 
    "VOLUME" NUMBER(8, 2), 
    CONSTRAINT "PK_DBPURCHASEFLOW" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
----------------sl 出口易表----
CREATE TABLE "DB_DEPARTMENTAPI" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "DEPARTMENT" VARCHAR2(100 byte),
    "USERNAME" VARCHAR2(100 byte), "USERKEY" VARCHAR2(100 byte), 
    "TOKEN" VARCHAR2(200 byte), "PASSWORD" VARCHAR2(50 byte), 
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(100 byte), "RESERVE4" NUMBER(10, 3), 
    "RESERVE5" NUMBER(10, 3), "OPER" VARCHAR2(400 byte), 
    "OPERTIME" DATE, 
    CONSTRAINT "PK_DEPARTMENT_SEQUENCEID" PRIMARY 
    KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;  
    
------------------------20121211 hp 销售流程---------------------------------------

CREATE TABLE "DB_PROTOCOL" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "SKU" VARCHAR2(50 byte), "NAME" VARCHAR2(1000
    byte), "URGENT" VARCHAR2(100 byte), "CREATEOPER" VARCHAR2(50 
    byte), "EXECUTOR" VARCHAR2(50 byte), "STATUS" VARCHAR2(100 
    byte), "CREATETIME" DATE, "STARTTIME" DATE, "BACKTIME" DATE, 
    "ENDTIME" DATE, "TITLE" VARCHAR2(1000 byte), "DESCR" 
    VARCHAR2(2000 byte), "PICTURE1" VARCHAR2(100 byte), 
    "PICTURE2" VARCHAR2(100 byte), "PICTURE3" VARCHAR2(100 byte),
    "BACKREASON" VARCHAR2(1000 byte), "NOTE" VARCHAR2(2000 byte),
    "RESERVE1" VARCHAR2(500 byte), "RESERVE2" VARCHAR2(500 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" VARCHAR2(500 byte), "RESERVE6" NUMBER(10), 
    "RESERVE7" NUMBER(10), "RESERVE8" NUMBER(10, 4), "RESERVE9" 
    NUMBER(10, 4), "RESERVE10" DATE, "OPERTIME" DATE, "RESERVE11"
    DATE, "RESERVE12" DATE, "RESERVE13" DATE, "FLAG" VARCHAR2(50 
    byte), "CHECKOPER" VARCHAR2(50 byte), "CHECKNOTREASON" 
    VARCHAR2(2000 byte), "CHECKTIME" DATE, "REPEATTIME" DATE, 
    "OPER" VARCHAR2(50 byte), 
    CONSTRAINT "PK_SID_DB_PROTOCOL" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
    
    
    
------------------------20121128 xb---------------------------------------
create table DB_BANPRODUCT  (
   SID                  VARCHAR2(50)                    not null,
   PRODUCTID            VARCHAR2(100),
   SHOPID               VARCHAR2(100),
   COPERID              VARCHAR2(50),
   OPER                 VARCHAR2(400),
   OPERTIME             DATE,
   FILED1               VARCHAR2(400),
   FILED2               VARCHAR2(400),
   FILED3               VARCHAR2(400),
   FILED4               VARCHAR2(400),
   FILED5               VARCHAR2(4000),
   FILED6               VARCHAR2(4000),
   FILED7               NUMBER(8,2),
   FILED8               NUMBER(8,2),
   FILED9               NUMBER(8,2),
   OPENFLAG             VARCHAR2(10),
   constraint PK_DB_BANPRODUCT primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on column DB_BANPRODUCT.OPENFLAG is
'0表示关闭
1表示开通';

------------------------20121128 xb---------------------------------------
create table DB_BANPRODUCT  (
   SID                  VARCHAR2(50)                    not null,
   NAME                 VARCHAR2(100),
   DESCR                VARCHAR2(4000),
   COPERID              VARCHAR2(50),
   OPER                 VARCHAR2(400),
   OPERTIME             DATE,
   FILED1               VARCHAR2(400),
   FILED2               VARCHAR2(400),
   FILED3               VARCHAR2(400),
   FILED4               VARCHAR2(400),
   FILED5               VARCHAR2(4000),
   FILED6               VARCHAR2(4000),
   FILED7               NUMBER(8,2),
   FILED8               NUMBER(8,2),
   FILED9               NUMBER(8,2),
   OPENFLAG             VARCHAR2(10),
   constraint PK_DB_BANPRODUCT primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on column DB_BANPRODUCT.OPENFLAG is
'0表示关闭
1表示开通';

--------------------------------------------消息群发相关----------------------------
 CREATE TABLE "DB_SENDLIST" ( "SEQUENCEID" VARCHAR2(100), "ORDERID" VARCHAR2(100), "GROUPID" VARCHAR2(100), "UPDATEFLAG" VARCHAR2(100), "DESCR" VARCHAR2(500), "OPER" VARCHAR2(50), "OPERTIME" DATE, "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), "RESERVE5" NUMBER(10), "RESERVE6" NUMBER(10), "RESERVE7" NUMBER(10, 6), "RESERVE8" NUMBER(10, 6), "SELLUSER" VARCHAR2(100), "EXPRESSID" VARCHAR2(50), "SKUS" VARCHAR2(500), "EBAYITEMIDS" VARCHAR2(500), CONSTRAINT "PK_DB_SENDLIST" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 768K BUFFER_POOL DEFAULT) LOGGING; 
   
-------------------------20121026 lxd------------------------------
CREATE TABLE "DB_SENDLIST" ("SEQUENCEID" VARCHAR2(100 
    byte) NOT NULL, "ORDERID" VARCHAR2(100 byte), "GROUPID" 
    VARCHAR2(100 byte), "UPDATEFLAG" VARCHAR2(1 byte), "DESCR" 
    VARCHAR2(500 byte), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE,
    "RESERVE1" VARCHAR2(100 byte), "RESERVE2" VARCHAR2(100 byte),
    "RESERVE3" VARCHAR2(500 byte), "RESERVE4" VARCHAR2(500 byte),
    "RESERVE5" NUMBER(10), "RESERVE6" NUMBER(10), "RESERVE7" 
    NUMBER(10, 6), "RESERVE8" NUMBER(10, 6), 
    CONSTRAINT "PK_DB_SENDLIST" PRIMARY KEY("SEQUENCEID") 
    USING INDEX  
    TABLESPACE "ZHRGPT" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
     
    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING ;
---------------------------lxd 20130327 ----菜单临时表-------------------------------------

alter table db_sendlist add selluser varchar2(100);--卖家账号
alter table db_sendlist add selluser varchar2(100);--买家编号
alter table db_sendlist add expressid varchar2(50); --货运单号
alter table db_sendlist add skus varchar2(500);  --SKU
alter table db_sendlist add ebayitemids varchar2(500); --ebayitemid
ALTER TABLE DB_SENDLIST RENAME COLUMN SELLUSERID TO SELLUSER;
CREATE TABLE "DB_SENDMESSAGE" ( "SEQUENCEID" VARCHAR2(100), "TITLE" VARCHAR2(4000), "GROUPID" VARCHAR2(100), "CREATETIME" DATE, "CREATEOPER" VARCHAR2(50), "STATUS" VARCHAR2(50), "CHECKOPER" VARCHAR2(50), "CHECKTIME" DATE, "RECORDENUM" NUMBER(10), "SUCCESSNUM" NUMBER(10), "ERRORNUM" NUMBER(10), "SENDTIME" DATE, "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7" NUMBER(10, 6), "RESERVE8" NUMBER(10, 6), "RETURNID" NUMBER(18), CONSTRAINT "PK_DB_SENDMESSAGE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 640K BUFFER_POOL DEFAULT) LOGGING;    
    