﻿
CREATE TABLE "DB_PROJECTCOLLABORATIVE" ( "SEQUENCEID" NUMBER(8), "PROJECTID" NUMBER(8),"COPER" VARCHAR2(50), 
		CONSTRAINT "PK_DB_PROJECTCOLLABORATIVE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
		TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
		STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
------------------------------------------------------------------------------
CREATE TABLE "DB_USPSSELLER" ("SID" VARCHAR2(50 byte) NOT
    NULL, "USERID" VARCHAR2(100 byte) NOT NULL, "USERNAME"
    VARCHAR2(50 byte), "PASSWORD" VARCHAR2(50 byte), "FIRSTNAME"
    VARCHAR2(50 byte), "LASTNAME" VARCHAR2(50 byte), "EMAIL"
    VARCHAR2(100 byte), "ADDRESS1" VARCHAR2(200 byte), "ADDRESS2"
    VARCHAR2(200 byte), "CITY" VARCHAR2(50 byte), "STATE"
    VARCHAR2(50 byte), "ZIP5" VARCHAR2(5 byte), "ZIP4" VARCHAR2(4
    byte), "PHONE" VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(2 byte),
    "OPER" VARCHAR2(50 byte), "OPERTIME" DATE, "CORPID"
    VARCHAR2(50 byte), "RESERVE1" VARCHAR2(100 byte), "RESERVE2"
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    VARCHAR2(100 byte), "RESERVE5" VARCHAR2(100 byte),
    CONSTRAINT "PK_USPSSELLER_ID" PRIMARY KEY("SID")
    )

    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_MANYSTORAGEBIN" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "PRODUCTID" VARCHAR2(50 byte),
    "STORAGEID" VARCHAR2(50 byte), "CREATETIME" DATE,
    "CREATEOPER" VARCHAR2(50 byte), "OPERTIME" DATE, "OPER"
    VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte), "CORPID"
    VARCHAR2(50 byte), "PRODUCTNAME" VARCHAR2(500 byte),
    "STORAGENAME" VARCHAR2(2000 byte), "DESCR" VARCHAR2(1000
    byte), "NAME" VARCHAR2(200 byte), "STORAGEBINFLAG"
    VARCHAR2(50 byte), "MAINSKU" VARCHAR2(50 byte),
    CONSTRAINT "PK_MANYSTORAGEBINID" PRIMARY KEY("SEQUENCEID")
    )

    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;


CREATE TABLE "DB_MANYSTORAGEBINLOG" ("SEQUENCEID"
    VARCHAR2(50 byte) NOT NULL, "PRODUCTID" VARCHAR2(50 byte),
    "STORAGEID" VARCHAR2(2000 byte), "OPERTIME" DATE, "OPER"
    VARCHAR2(50 byte), "OPENFLAG" VARCHAR2(10 byte), "CORPID"
    VARCHAR2(50 byte), "PRODUCTNAME" VARCHAR2(500 byte),
    "STORAGENAME" VARCHAR2(2000 byte), "DESCR" VARCHAR2(1000
    byte), "NAME" VARCHAR2(200 byte), "OPERTYPE" VARCHAR2(20
    byte), "CONTENT" VARCHAR2(4000 byte), "RESERVE1" VARCHAR2(200
    byte), "RESERVE2" VARCHAR2(200 byte), "RESERVE3" VARCHAR2(200
    byte), "STORAGEBINFLAG" VARCHAR2(50 byte), "MAINSKU"
    VARCHAR2(50 byte),
    CONSTRAINT "PK_MANYSTORAGEBINLOGID" PRIMARY KEY("SEQUENCEID")
    )

    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_ALIFEEDBACKORDER" ("TRADEID" VARCHAR2(30
    byte) NOT NULL, "FEEDBACKTIME" DATE, "FLAG" VARCHAR2(1 byte),
    "DESCR" VARCHAR2(1000 byte), "SHOPID" VARCHAR2(10 byte), 
    "UPDATEFLAG" VARCHAR2(1 byte), 
    CONSTRAINT "PK_DB_ALIFEEDBACKORDER" PRIMARY KEY("TRADEID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_ALINEWPRODUCT" ("ALIITEMID" VARCHAR2(50 
    byte) NOT NULL, "PRODUCTID" VARCHAR2(100 byte), "FLAG" 
    VARCHAR2(1 byte), "DOWNTIME" DATE, "UPDATETIME" DATE, 
    "SHOPID" VARCHAR2(10 byte), "GROUPID" VARCHAR2(50 byte), 
    CONSTRAINT "PK_DB_ALINEWPRODUCT" PRIMARY KEY("ALIITEMID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_ALIORDERINFO" ("SEQUENCEID" VARCHAR2(100
    byte) NOT NULL, "ORDERID" VARCHAR2(100 byte), "CORPID" 
    VARCHAR2(100 byte), "TRADEID" VARCHAR2(100 byte), 
    "MAINTRADEID" VARCHAR2(100 byte), "GROUPID" VARCHAR2(100 
    byte), "CUSTOMERID" VARCHAR2(200 byte), "CUSTOMERNAME" 
    VARCHAR2(1000 byte), "CUSTOMERFIRSTNAME" VARCHAR2(500 byte), 
    "CUSTOMERLASTNAME" VARCHAR2(500 byte), "CUSTOMERTYPE" 
    VARCHAR2(1000 byte), "CUSTOMERTEL1" VARCHAR2(400 byte), 
    "CUSTOMERTEL2" VARCHAR2(400 byte), "CUSTOMEREMAIL" 
    VARCHAR2(400 byte), "CUSTOMERCOUNTRY" VARCHAR2(1000 byte), 
    "CUSTOMERCOUNTRYCN" VARCHAR2(100 byte), "CUSTOMERCOUNTRY2" 
    VARCHAR2(100 byte), "CUSTOMERPROVINCE" VARCHAR2(1000 byte), 
    "CUSTOMERCITY" VARCHAR2(1000 byte), "CUSTOMERADDRESS" 
    VARCHAR2(4000 byte), "CUSTOMERZIPCODE" VARCHAR2(200 byte), 
    "CUSTOMERRESERVE1" VARCHAR2(3000 byte), "CUSTOMERRESERVE2" 
    VARCHAR2(3000 byte), "CUSTOMERRESERVE3" VARCHAR2(3000 byte), 
    "CUSTOMERRESERVE4" VARCHAR2(3000 byte), "CUSTOMERRESERVE5" 
    NUMBER(20), "CUSTOMERRESERVE6" NUMBER(15, 2), 
    "CUSTOMERRESERVE7" NUMBER(15, 2), "CUSTOMERRESERVE8" 
    NUMBER(15, 2), "SHOPTYPEID" VARCHAR2(100 byte), "SHOPTYPE" 
    VARCHAR2(200 byte), "MONEYTYPE" VARCHAR2(200 byte), 
    "MONEYASK" NUMBER(12, 4), "MONEYACTION" NUMBER(12, 4), 
    "MONEYEXPRESSASK" NUMBER(12, 4), "ORDERTIME" DATE, 
    "UPLOADTIME" DATE, "PAYTIME" DATE, "EXPRESSWEIGHT" NUMBER(12,
    4), "OPER" VARCHAR2(100 byte), "STATUS" VARCHAR2(200 byte), 
    "FINALVALUEFEE" NUMBER(12, 4), "TRANSACTIONID" VARCHAR2(200 
    byte), "SKU" VARCHAR2(100 byte), "PRODUCTNAME" VARCHAR2(4000 
    byte), "ORDERNUM" NUMBER(15), "COSTPRICE" NUMBER(12, 4), 
    "SELLPRICE" NUMBER(12, 4), "AMOUNT" NUMBER(12, 4), "DESCR2" 
    VARCHAR2(4000 byte), "ORIGINSELLPRICE" NUMBER(12, 4), 
    "ORIGINEXPRESS" NUMBER(12, 4), "ORIGININSURANCE" NUMBER(12, 
    4), "INSURANCE" NUMBER(12, 4), "SHIPPINGSERVICE" 
    VARCHAR2(4000 byte), "NOTETOYOURSELF" VARCHAR2(4000 byte), 
    "EBAYITEMID" VARCHAR2(100 byte), "PAYPALEMAIL" VARCHAR2(200 
    byte), "PAYPALID" VARCHAR2(100 byte), "ORDERRESERVE1" 
    VARCHAR2(1000 byte), "ORDERRESERVE2" VARCHAR2(1000 byte), 
    "ORDERRESERVE3" VARCHAR2(1000 byte), "ORDERRESERVE4" 
    NUMBER(10), "ORDERRESERVE5" NUMBER(10), "ORDERRESERVE6" 
    NUMBER(12, 4), "ORDERRESERVE7" NUMBER(12, 4), "RESERVE1" 
    VARCHAR2(1000 byte), "RESERVE2" VARCHAR2(1000 byte), 
    "RESERVE3" VARCHAR2(1000 byte), "RESERVE4" VARCHAR2(1000 
    byte), "RESERVE5" VARCHAR2(1000 byte), "RESERVE6" NUMBER(10),
    "RESERVE7" NUMBER(10), "RESERVE8" NUMBER(12, 4), "RESERVE9" 
    NUMBER(12, 4), "ERRORFLAG" VARCHAR2(10 byte), "ERRORINFO" 
    VARCHAR2(4000 byte), "OPERTIME" DATE, "RECORDNUM" NUMBER(10),
    "MONEYRATE" NUMBER(6, 2), "ORIGINORDERMONEY" NUMBER(10, 2), 
    "ORIGINEXPRESSMONEY" NUMBER(10, 2), "ORIGININSURANCE1" 
    NUMBER(10, 2), "ORIGINFINALVALUEFEE" NUMBER(10, 2), 
    "EBAYCUSTOMERADDRESS" VARCHAR2(4000 byte), 
    CONSTRAINT "PK_DB_ALIORDERINFO" PRIMARY KEY("SEQUENCEID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_ALLOCATE_TEMP" ("SEQUENCEID" 
    VARCHAR2(100 byte) NOT NULL, "PRODUCTID" VARCHAR2(100 byte), 
    "INPORTTIME" DATE, "TITLE" VARCHAR2(1000 byte), "ORPER" 
    VARCHAR2(100 byte), "OPERTIME" DATE, "RESERVE1" VARCHAR2(200 
    byte), "RESERVE2" VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100
    byte), "RESERVE4" VARCHAR2(100 byte), "RESERVE5" VARCHAR2(100
    byte), "ALLOCATENUM" NUMBER(10), "SONALLOCATENUM" NUMBER(10),
    "WEIGHT" NUMBER(10), "QUESTIONSID" VARCHAR2(200 byte), 
    CONSTRAINT "PK_DB_ALLOCATE_TEMP" PRIMARY KEY("SEQUENCEID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_AMAZONEXPRESSTYPE" (
    "SID" NUMBER(3) NOT NULL, 
    "NAME" VARCHAR2(4000 byte), 
    "OPER" VARCHAR2(50 byte), 
    "OPERTIME" DATE, 
    "OPENFLAG" VARCHAR2(50 byte), 
    "RESERVE1" VARCHAR2(1000 byte), 
    "RESERVE2" VARCHAR2(1000 byte), 
    CONSTRAINT "PK_AMAZONEXPRESSTYPE_SID" PRIMARY KEY("SID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_AMAZONORDER" ("ORDERID" VARCHAR2(50 
    byte) NOT NULL, "CORPID" VARCHAR2(50 byte), "GROUPID" 
    VARCHAR2(50 byte), "CUSTOMERID" VARCHAR2(500 byte), 
    "CUSTOMERNAME" VARCHAR2(500 byte), "CUSTOMERTEL1" VARCHAR2(50
    byte), "CUSTOMERTEL2" VARCHAR2(50 byte), "CUSTOMEREMAIL" 
    VARCHAR2(100 byte), "CUSTOMERQQ" VARCHAR2(100 byte), 
    "CUSTOMERMSN" VARCHAR2(100 byte), "CUSTOMERCOUNTRY" 
    VARCHAR2(1000 byte), "CUSTOMERPROVINCE" VARCHAR2(1000 byte), 
    "CUSTOMERCITY" VARCHAR2(1000 byte), "CUSTOMERADDRESS" 
    VARCHAR2(4000 byte), "CUSTOMERADDRESS1" VARCHAR2(4000 byte), 
    "CUSTOMERADDRESS2" VARCHAR2(4000 byte), "CUSTOMERADDRESS3" 
    VARCHAR2(4000 byte), "CUSTOMERADDRESSALL" VARCHAR2(4000 byte),
    "CUSTOMERZIPCODE" VARCHAR2(100 byte), "CUSTOMERFAX" 
    VARCHAR2(100 byte), "SHOPTYPEID" VARCHAR2(100 byte), 
    "SHOPTYPE" VARCHAR2(100 byte), "SALESOURCE" VARCHAR2(100 
    byte), "MONEYTYPE" VARCHAR2(100 byte), "MONEYORIGIN" 
    NUMBER(10, 2), "ORIGINMONEYTOTAL" NUMBER(10, 2), "MONEYTOTAL"
    NUMBER(10, 2), "ORDERNUM" NUMBER(10), "ORDERTIME" DATE, 
    "UPLOADTIME" DATE, "PAYTIME" DATE, "EXPRESSTYPE" VARCHAR2(100
    byte), "TRANSACTIONID" VARCHAR2(100 byte), "MONEYEXPRESS" 
    NUMBER(10, 2), "ORIGINMONEYEXPRE" NUMBER(10, 2), 
    "EXPRESSMONEYTYPE" VARCHAR2(100 byte), "STATUS" VARCHAR2(100 
    byte), "ORIGINFINALVALUEFEE" NUMBER(10, 2), "FINALVALUEFEE" 
    NUMBER(10, 2), "FINALVALUEFEEMONEYTYPE" VARCHAR2(100 byte), 
    CONSTRAINT "PK_DB_AMAZONORDER" PRIMARY KEY("ORDERID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;
COMMENT ON TABLE "DB_AMAZONORDER" IS 'aaaaaaaa';

CREATE TABLE "DB_AMAZONSELL" ("SID" VARCHAR2(50 byte) NOT
    NULL, "CORPID" VARCHAR2(200 byte), "ORDERID" VARCHAR2(200 
    byte), "PRODUCTID" VARCHAR2(200 byte), "PRODUCTNAME" 
    VARCHAR2(200 byte), "ORDERNUM" NUMBER(5), "COSTPRICE" 
    NUMBER(12, 4), "SELLPRICE" NUMBER(12, 4), "AMOUNT" NUMBER(12,
    4), "CUSTOMERID" VARCHAR2(100 byte), "ORDERTIME" DATE, 
    "STORAGEID" VARCHAR2(100 byte), "STORAGE" VARCHAR2(100 byte),
    "LOCATIONID" VARCHAR2(100 byte), "LOCATION" VARCHAR2(100 
    byte), "ALERTFLAG" VARCHAR2(100 byte), "SHOPTYPE" 
    VARCHAR2(100 byte), "UPDATEFLAG" VARCHAR2(100 byte), "OPER" 
    VARCHAR2(100 byte), "OPERTIME" DATE, "FLAG" VARCHAR2(100 
    byte), "DESCR1" VARCHAR2(2000 byte), "DESCR2" VARCHAR2(2000 
    byte), "DESCR3" VARCHAR2(2000 byte), "RESERVE1" VARCHAR2(100 
    byte), "RESERVE2" VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100
    byte), "RESERVE4" VARCHAR2(100 byte), "RESERVE5" VARCHAR2(100
    byte), "RESERVE6" VARCHAR2(100 byte), "RESERVE7" VARCHAR2(100
    byte), "RESERVE8" VARCHAR2(100 byte), "RESERVE9" VARCHAR2(100
    byte), "RESERVE10" VARCHAR2(100 byte), "PRODUCTSAVENUM" 
    NUMBER(6), "PRODUCTORDERNUM" NUMBER(6), "PRODUCTALERTNUM" 
    NUMBER(6), "PRODUCTPIC1" VARCHAR2(100 byte), "TRADEID" 
    VARCHAR2(100 byte), "TRANSACTIONID" VARCHAR2(100 byte), 
    "ORIGINSELLPRICE" NUMBER(12, 4), "MONEYTYPE" VARCHAR2(100 
    byte), "GROUPID" VARCHAR2(100 byte), "WEIGHT" NUMBER(10, 2), 
    "WEIGHTAMOUNT" NUMBER(10, 2), "SHOPTYPEID" VARCHAR2(400 byte),
    "EBAYITEMID" VARCHAR2(400 byte), "FINALVALUEFEE" NUMBER(10, 
    2), "ENGLISHNAME" VARCHAR2(400 byte), "ORIGINSELLMONEY" 
    NUMBER(10, 2), "ORIGINEXPRESSMONEY" NUMBER(10, 2), 
    "ORIGINFINALVALUEFEE" NUMBER(10, 2), "ORIGINGIFTMONEY" 
    NUMBER(10, 2), 
    CONSTRAINT "PK_DB_AMAZONSELL" PRIMARY KEY("SID") 
    )     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;
COMMENT ON TABLE "DB_AMAZONSELL" IS 'bbbbbbbb';


CREATE TABLE "ESHOP"."DB_SMTMESSAGE" ( "SID" VARCHAR2(50), "SENDERNAME" VARCHAR2(100), "SENDERLOGINID" VARCHAR2(100), "PRODUCTURL" VARCHAR2(1000), 
"READ" VARCHAR2(50), "RECEIVENAME" VARCHAR2(100), "RECEIVELOGINID" VARCHAR2(50), "CREATEDATE" DATE, "RECEIVEDATE" DATE, "MESSAGETYPE" VARCHAR2(100), 
"HAVEFILE" VARCHAR2(50), "FILEURL" VARCHAR2(500), "ORDERURL" VARCHAR2(500), "ITEMID" VARCHAR2(50), "PRODUCTID" VARCHAR2(200), "PRODUCTNAME" VARCHAR2(1000), 
"ORDERID" VARCHAR2(50), "RELATIONID" VARCHAR2(50), "SMTTYPEID" VARCHAR2(50), "CONTENT" VARCHAR2(4000), "DESCR" VARCHAR2(4000), "SHOPTYPEID" VARCHAR2(100), 
"SHOPTYPENAME" VARCHAR2(100), "CATEGORYID" VARCHAR2(100), "CATEGORYNAME" VARCHAR2(200), "STATUS" VARCHAR2(10), "APPLYOPER" VARCHAR2(50), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "ANSWER" VARCHAR2(4000), "ASSIGNOPER" VARCHAR2(100), "ASSIGNOPERTIME" DATE, "UPDATEFLAG" VARCHAR2(10), "UPDATETIME" DATE, 
"UPDATEDESCR" VARCHAR2(1000), "OPENFLAG" VARCHAR2(100), "CUSTOMERTYPEID" NUMBER(6), "CUSTOMERTYPE" VARCHAR2(100), "TYPEID" VARCHAR2(100), 
"TYPENAME" VARCHAR2(100), "TYPECOLOR" VARCHAR2(100), "RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200), "RESERVE3" VARCHAR2(200), "RESERVE4" VARCHAR2(200), 
"RESERVE5" VARCHAR2(200), "RESERVE6" VARCHAR2(200), CONSTRAINT "PK_SMTMESSAGE_SID" PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "ESHOP"."DB_SMTMESSAGELOG" ( "SEQUENCEID" VARCHAR2(50), "SID" VARCHAR2(50), "SENDERNAME" VARCHAR2(100), "SENDERLOGINID" VARCHAR2(100), 
"RECEIVENAME" VARCHAR2(100), "RECEIVELOGINID" VARCHAR2(50), "OPER" VARCHAR2(50), "OPERTIME" DATE, "OPERTYPE" VARCHAR2(100), "ANSWER" VARCHAR2(4000), 
"DESCR" VARCHAR2(1000), "RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200), "RESERVE3" VARCHAR2(200), 
CONSTRAINT "PK_SMTMESSAGELOG_SID" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "ESHOP"."DB_PICTUREPROJECT" ( "SEQUENCEID" VARCHAR2(20), "NAME" VARCHAR2(50), "PICTURE" VARCHAR2(200), "DESCR" VARCHAR2(500), 
"OPER" VARCHAR2(20), "OPERTIME" DATE, "CREATETIME" DATE, "FLAG" VARCHAR2(10), "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "PICTUREID" VARCHAR2(50), 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "ESHOP"."DB_UNITEPURCHASE" ( "SEQUENCEID" NUMBER(10), "SKU" VARCHAR2(50), "MAINSKU" VARCHAR2(50), "GROUPID" VARCHAR2(50), 
"FLAG" VARCHAR2(1), "ORDERNUM" NUMBER(10), "COSTPRICE" NUMBER(10, 2), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATETIME" DATE, "RESERVE1" VARCHAR2(100), 
"RESERVE2" VARCHAR2(100), "RESERVE3" NUMBER(10), "RESERVE4" NUMBER(10, 2), "RESERVE5" DATE, CONSTRAINT "PK_DB_UNITEPURCHASE" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "ESHOP"."DB_SMTNEWORDER" ( "ORDERID" VARCHAR2(50), "CORPID" VARCHAR2(50), "TRADEID" VARCHAR2(50), "GROUPID" VARCHAR2(50), 
"BUYERID" VARCHAR2(100), "CUSTOMERID" VARCHAR2(100), "CUSTOMERNAME" VARCHAR2(300), "CUSTOMERTEL1" VARCHAR2(100), "CUSTOMERTEL2" VARCHAR2(100), 
"CUSTOMEREMAIL" VARCHAR2(100), "CUSTOMERCOUNTRY" VARCHAR2(200), "CUSTOMERCOUNTRYCN" VARCHAR2(100), "CUSTOMERCOUNTRYJC" VARCHAR2(50), 
"CUSTOMERPROVINCE" VARCHAR2(200), "CUSTOMERCITY" VARCHAR2(200), "CUSTOMERADDRESS" VARCHAR2(500), "CUSTOMERZIPCODE" VARCHAR2(100), 
"CUSTOMERRESERVE1" VARCHAR2(100), "CUSTOMERRESERVE2" VARCHAR2(100), "CUSTOMERRESERVE3" VARCHAR2(100), "CUSTOMERRESERVE4" NUMBER(8), 
"CUSTOMERRESERVE5" NUMBER(8, 2), "SHOPTYPEID" VARCHAR2(50), "SHOPTYPE" VARCHAR2(100), "MONEYTYPE" VARCHAR2(50), "MONEYRATE" NUMBER(10, 4), 
"ORIGINORDERMONEY" NUMBER(10, 4), "ORDERMONEY" NUMBER(10, 4), "COSTMONEY" NUMBER(10, 4), "ORIGINEXPRESSMONEY" NUMBER(10, 4), "EXPRESSMONEY" NUMBER(10, 4), 
"STATUS" VARCHAR2(50), "POSTAGESERVICE" VARCHAR2(100), "ORDERTIME" DATE, "CREATETIME" DATE, "OPER" VARCHAR2(50), "OPERTIME" DATE, "SELLOPER" VARCHAR2(200), 
"SKU" VARCHAR2(1000), "PRODUCT" VARCHAR2(4000), "CONTENT" VARCHAR2(2000), "NOTEINFO" VARCHAR2(2000), "OPENFLAG" VARCHAR2(50), "MESSAGECOUNT" NUMBER(6), 
"MESSAGECONTENT" VARCHAR2(2000), "UPDATEFLAG" NUMBER(6), "UPDATEDESCR" VARCHAR2(1000), "UPDATETIME" DATE, "FLAG" VARCHAR2(50), "FLAGDESCR" VARCHAR2(200), 
"RESERVE1" VARCHAR2(200), "RESERVE2" VARCHAR2(200), "RESERVE3" VARCHAR2(200), "RESERVE4" VARCHAR2(200), CONSTRAINT "PK_SMTNEWORDER" 
PRIMARY KEY ("ORDERID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_DOWNEUBSELLER" ( "SID" VARCHAR2(50), "NAME" VARCHAR2(100), "TOKENTYPE" VARCHAR2(10), "TOKENID" VARCHAR2(100), "COMPANY" VARCHAR2(200), 
"COMPANYEN" VARCHAR2(200), "CONTACT" VARCHAR2(200), "CONTACTEN" VARCHAR2(200), "STREET" VARCHAR2(200), "STREETEN" VARCHAR2(200), "PROVINCE" VARCHAR2(50), 
"PROVINCEEN" VARCHAR2(100), "PROVINCEID" VARCHAR2(50), "CITY" VARCHAR2(50), "CITYEN" VARCHAR2(100), "CITYID" VARCHAR2(50), "DISTRICT" VARCHAR2(200), 
"DISTRICTEN" VARCHAR2(200), "DISTRICTID" VARCHAR2(200), "COUNTRYID" VARCHAR2(50), "COUNTRY" VARCHAR2(100), "COUNTRYEN" VARCHAR2(200), "POSTCODE" VARCHAR2(20), 
"POSTCODE2" VARCHAR2(20), "MOBILE" VARCHAR2(50), "PHONE" VARCHAR2(50), "EMAIL" VARCHAR2(50), "OPENFLAG" VARCHAR2(2), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
"RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "RESERVE4" VARCHAR2(100), CONSTRAINT "PK_DOWNEUBSELLER_ID" 
PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_ITEMSCONTENT" ("SID" VARCHAR2(20 byte)
    NOT NULL, "CLOBCONTENT" CLOB, "FLAG" VARCHAR2(10 byte),
    CONSTRAINT "PK_DB_ITEMSCONTENT" PRIMARY KEY("SID")
    )

    TABLESPACE "ZHRGPT" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    unlimited PCTINCREASE 0)
    LOGGING LOB("CLOBCONTENT") STORE AS ( TABLESPACE "ZHRGPT"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    unlimited PCTINCREASE 0)
    ENABLE
    STORAGE IN ROW
    NOCACHE CHUNK 8192 PCTVERSION 10) ;
COMMENT ON TABLE "DB_ITEMSCONTENT" IS 'xxxxx';
-----------------------DB_MULTI_WAREHOUSE------------------
CREATE TABLE "DB_MULTI_WAREHOUSE" ( "SEQUENCEID" VARCHAR2(50), "MAINSKU" VARCHAR2(50), "PRODUCTID" VARCHAR2(50), 
"STORAGEID" VARCHAR2(50), "STORAGENAME" VARCHAR2(100), "COUNTRYJC" VARCHAR2(2000), CONSTRAINT "DB_MULTI_WAREHOUSE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
---------------------DB_PRODUCT_HISTORY-----------------------
CREATE TABLE "DB_PRODUCT_HISTORY" ( "SEQUENCEID" NUMBER(10), "PRODUCTID" VARCHAR2(50), "HISTPROFIT" NUMBER(10, 4) DEFAULT 0 , 
"PROFITT" NUMBER(10, 4) DEFAULT 0 , "PROFITS" NUMBER(10, 4) DEFAULT 0 , "ALLORDERNUM" NUMBER(9) DEFAULT 0 , "TODAYORDERNUM" NUMBER(9) DEFAULT 0 , 
"ONPASSAGEPURCHASE" NUMBER(9) DEFAULT 0 , "OOSLEVEL" NUMBER(6, 4) DEFAULT 0 , "RATEOFPIN" NUMBER(6, 4) DEFAULT 0 , "SAVENUM" NUMBER(9) DEFAULT 0 , 
"COSTPRICE" NUMBER(9, 4) DEFAULT 0 , "ALERTDAY" NUMBER(9) DEFAULT 0 , "ALERTNUM" NUMBER(9) DEFAULT 0 , "WEIGHT" NUMBER(9, 6) DEFAULT 0 , 
"TODAYSAVENUM" NUMBER(9) DEFAULT 0 , "SINGLEDAYSALES" NUMBER(9, 4) DEFAULT 0 , "DIELIBRARYCOEFFICIENT" NUMBER(9, 4) DEFAULT 0 , 
"TODAYOUTSAVENUM" NUMBER(9) DEFAULT 0 , "MINPURCHASENUM" NUMBER(9) DEFAULT 0 , "LOCATIONID" VARCHAR2(50), "LOCATION" VARCHAR2(50), 
"STORNGID" VARCHAR2(50), "STRONG" VARCHAR2(50), "PRODUCTNAME" VARCHAR2(200), "OPER1" VARCHAR2(50), "OPER2" VARCHAR2(50), "OPER3" VARCHAR2(50), 
"OPER4" VARCHAR2(50), "OPER5" VARCHAR2(50), "MENUFUNCTORYID" VARCHAR2(50), "MENUFUNCTORY" VARCHAR2(200), "STATUS" VARCHAR2(20), "CORPID" VARCHAR2(10), 
"CREATETIME" DATE, "HISTPAVGROFIT" NUMBER(8, 6) DEFAULT 0 , 
CONSTRAINT "PK_DB_PRODUCT_HISTORY" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
---------------- Create table-----------------------------------------
create table DB_PRODUCE_NEW
(
  SEQUENCEID     VARCHAR2(50) not null,
  PRODUCTID      VARCHAR2(30),
  GSTPRICE       NUMBER(10,4) default 0,
  OCEANSHIPPRICE NUMBER(10,4) default 0,
  EXPRESSPRICE   NUMBER(10,4) default 0,
  PROFIT         NUMBER(10,4) default 0,
  STORERENT      NUMBER(10,4) default 0,
  DHNUMBER       NUMBER(4) default 0,
  COUNTRY        VARCHAR2(50),
  RATE           NUMBER(6,2) default 0
)
tablespace ZHRGPT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column DB_PRODUCE_NEW.GSTPRICE
  is 'GST+关税';
comment on column DB_PRODUCE_NEW.OCEANSHIPPRICE
  is '海运费';
comment on column DB_PRODUCE_NEW.EXPRESSPRICE
  is '物流费';
comment on column DB_PRODUCE_NEW.PROFIT
  is '利润百分比';
comment on column DB_PRODUCE_NEW.STORERENT
  is '仓库立方租金';
comment on column DB_PRODUCE_NEW.DHNUMBER
  is '断货库存';
comment on column DB_PRODUCE_NEW.COUNTRY
  is '国家';
comment on column DB_PRODUCE_NEW.RATE
  is '汇率';
-- Create/Recreate primary, unique and foreign key constraints 
alter table DB_PRODUCE_NEW
  add constraint PK_DB_PRODUCE_NEW primary key (SEQUENCEID)
  using index 
  tablespace ZHRGPT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
------------------------db_produce_new表格的序列--------------------------------------------
  -- Create sequence 
create sequence PRODUCENEW_SEQ_ID
minvalue 1
maxvalue 9999999999999999999999999999
start with 61
increment by 1
cache 20;
-------------------------------DB_SELLSKUFORSHOP-------------------------
CREATE TABLE "DB_SELLSKUFORSHOP" ( "SEQUENCEID" NUMBER(10), "SELLSKU" VARCHAR2(50), "SHOPID" VARCHAR2(50), "SHOPNAME" 
VARCHAR2(50), "SHOPUSERID" VARCHAR2(50), "NUMFORUS" NUMBER(10), "NUMFORAU" NUMBER(10), "NUMFORUK" NUMBER(10), "NUMFORCA" 
NUMBER(10), "NUMFORDE" NUMBER(10), "TEMPORARY" VARCHAR2(1000), "TOTAL" NUMBER(10), "RESERVE1" VARCHAR2(100), "RESERVE2" 
VARCHAR2(500), "RESERVE3" NUMBER(10), "RESERVE4" NUMBER(10), "RESERVE5" NUMBER(10), "CORPID" VARCHAR2(50), "OPER" 
VARCHAR2(50), "OPENFLAG" VARCHAR2(50), "OPERIME" DATE, "CREATETIME" DATE, CONSTRAINT "PK_DB_SELLSKUFORSHOP" PRIMARY KEY 
("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;  
---------------------------------DB_PRODUCTFORDESCR-------------------------
CREATE TABLE "DB_PRODUCTFORDESCR" ( "SEQUENCEID" NUMBER(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" 
VARCHAR2(50), "CREATETIME" DATE, "SELLSKU" VARCHAR2(50), "LANGUAGE" VARCHAR2(20), "DESCR" CLOB, "RESERVE1" VARCHAR2(1000), 
CONSTRAINT "PK_DB_PRODUCTFORDESCR" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 
255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING LOB ("DESCR") STORE AS ( TABLESPACE "ZHRGPT" CHUNK 8192 STORAGE ( 
INITIAL 64K BUFFER_POOL DEFAULT) NOCACHE LOGGING );
------------DB_PURCHASEFLOWDEVELOP-----------
CREATE TABLE "DB_PURCHASEFLOWDEVELOP" ( 
"SEQUENCEID" NUMBER(18), "ORDERSTIME" DATE, "FOLLOW" VARCHAR2(50), "GROUPID" VARCHAR2(100), "MANUFACTUREID" VARCHAR2(100), 
"MANUFACTURE" VARCHAR2(200), "PAYMENTTYPE" VARCHAR2(200), "AMOUNTRMB" NUMBER(12, 4), "DEPOSITS" NUMBER(12, 4), "AMOUNTUSD" NUMBER(12, 4), 
"STATUS" NUMBER(10), "FTCBM" NUMBER(12, 4), "DELIVERY" NUMBER(10), "ARRIVALPERIOD" NUMBER(10), "SENDTIME" DATE, "PORTCITY" VARCHAR2(2000), 
"ACTUALSENDTIME" DATE, "LCLTIME" DATE, "OUTPORTTIME" DATE, "TOPORTTIME" DATE, "TOWAREHOUSETIME" DATE, "INWAREHOUSETIME" DATE, "CREATEDATE" DATE, 
"CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, "OPER" VARCHAR2(50), "OPENFLAG" NUMBER(10), "POSITION" VARCHAR2(10), "WITHASINGLE" VARCHAR2(2000), 
"PHOTOQC" VARCHAR2(200), "COMPLETETIME" DATE, "RECEIPT" VARCHAR2(200), "DRAWBACK" NUMBER(10), "EXPRESSTYPE" VARCHAR2(20), "EXPRESSTYPEID" VARCHAR2(50), 
"DEPOSITSTIME" DATE, "RONUMBER" VARCHAR2(50), "CUTOFFTIME" DATE, "CONTAINERINFO" VARCHAR2(2000), "PACKAGEINGLIST" VARCHAR2(200), "BILLOFLADING" VARCHAR2(200), 
"TRANSPORTFARE" NUMBER(12, 4), "SENDMONEY" NUMBER(12, 4), "SENDPAYTIME" DATE, "TOPORTMONEY" NUMBER(12, 4), "TOPORTPAYTIME" DATE, "FINALMONEY" NUMBER(12, 4), 
"FINALPAYTIME" DATE, "FOLLOWDESCR" VARCHAR2(2000), "EXPRESSID" VARCHAR2(200), "DEPOSITSFLAG" NUMBER(10), "SENDMONEYFLAG" NUMBER(10), "TOPORTMONEYFLAG" NUMBER(10), 
"FINALMONEYFLAG" NUMBER(10), "STOCKOPER" VARCHAR2(50), "URGENT" NUMBER(10), "ARRIVEDATE" DATE, "SAMPLENUM" NUMBER(10), "AMOUNTRMBFLAG" NUMBER(10), 
"POCONFIRM" NUMBER(10), "CHECKTIME" DATE, "VERIFYTIME" DATE, "TOPURPOSEPORTTIME" DATE, "BOXNUM" number(10), 
CONSTRAINT "PK_DB_PURCHASEFLOWDEVELOP" PRIMARY KEY ("SEQUENCEID") VALIDATE 
) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;
-------------DB_PURCHASEFLOWDEVELOP_LOG-----------
CREATE TABLE "DB_PURCHASEFLOWDEVELOP_LOG" ( "SEQUENCEID" NUMBER(18), "ORDERSTIME" DATE, "FOLLOW" VARCHAR2(50), "GROUPID" VARCHAR2(100), "MANUFACTUREID" VARCHAR2(100), 
"MANUFACTURE" VARCHAR2(200), "PAYMENTTYPE" VARCHAR2(200), "AMOUNTRMB" NUMBER(12, 4), "DEPOSITS" NUMBER(12, 4), "AMOUNTUSD" NUMBER(12, 4), "STATUS" NUMBER(10), 
"FTCBM" NUMBER(12, 4), "DELIVERY" NUMBER(10), "ARRIVALPERIOD" NUMBER(10), "SENDTIME" DATE, "PORTCITY" VARCHAR2(2000), "ACTUALSENDTIME" DATE, "LCLTIME" DATE, 
"OUTPORTTIME" DATE, "TOPORTTIME" DATE, "TOWAREHOUSETIME" DATE, "INWAREHOUSETIME" DATE, "CREATEDATE" DATE, "CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, 
"OPER" VARCHAR2(50), "OPENFLAG" NUMBER(10), "POSITION" VARCHAR2(10), "WITHASINGLE" VARCHAR2(2000), "PHOTOQC" VARCHAR2(200), "COMPLETETIME" DATE, 
"RECEIPT" VARCHAR2(200), "DRAWBACK" NUMBER(10), "EXPRESSTYPE" VARCHAR2(20), "EXPRESSTYPEID" VARCHAR2(50), "DEPOSITSTIME" DATE, "RONUMBER" VARCHAR2(50), 
"CUTOFFTIME" DATE, "CONTAINERINFO" VARCHAR2(2000), "PACKAGEINGLIST" VARCHAR2(200), "BILLOFLADING" VARCHAR2(200), "TRANSPORTFARE" NUMBER(12, 4), 
"SENDMONEY" NUMBER(12, 4), "SENDPAYTIME" DATE, "TOPORTMONEY" NUMBER(12, 4), "TOPORTPAYTIME" DATE, "FINALMONEY" NUMBER(12, 4), "FINALPAYTIME" DATE, 
"FOLLOWDESCR" VARCHAR2(2000), "EXPRESSID" VARCHAR2(200), "DEPOSITSFLAG" NUMBER(10), "SENDMONEYFLAG" NUMBER(10), "TOPORTMONEYFLAG" NUMBER(10), 
"FINALMONEYFLAG" NUMBER(10), "STOCKOPER" VARCHAR2(50), "URGENT" NUMBER(10), "ARRIVEDATE" DATE, "SAMPLENUM" NUMBER(10), "CONTENT" VARCHAR2(2000), 
"OPERTYPE" NUMBER(10), "DEVELOPSID" NUMBER(18), "POCONFIRM" NUMBER(10), "CHECKTIME" DATE, "VERIFYTIME" DATE, "TOPURPOSEPORTTIME" DATE, 
CONSTRAINT "PK_DB_PURCHASEFLOWDEVELOP_LOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;
-------------DB_PURCHASEFLOW------------
CREATE TABLE "DB_PURCHASEFLOW" ( "SEQUENCEID" NUMBER(18), "DEVELOPSID" NUMBER(18), "PRODUCTID" VARCHAR2(100), "ORDERNUM" NUMBER(10), "STOCKPRICE" NUMBER(12, 4), 
"CREATEDATE" DATE, "CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, "OPER" VARCHAR2(50), "OPENFLAG" NUMBER(10), "GROUPID" VARCHAR2(100), "LENGTH" NUMBER(8, 2), 
"WIDTH" NUMBER(8, 2), "HIGH" NUMBER(8, 2), "VOLUME" NUMBER(8, 2), "OUTERLENGTH" NUMBER(8, 2), "OUTERWIDTH" NUMBER(8, 2), "OUTERHIGH" NUMBER(8, 2), 
"OUTERVOLUME" NUMBER(8, 2), "OUTERGROSSWEIGHT" NUMBER(8, 2), "OUTERLEVEL" VARCHAR2(500), "GROSSWEIGHT" NUMBER(8, 2), "OUTERNETWEIGHT" NUMBER(8, 2), 
"OUTERNORMS" VARCHAR2(1000), "QUANTITIES" VARCHAR2(100), "PICTURE1" VARCHAR2(200), "PICTURE2" VARCHAR2(200), "PICTURE3" VARCHAR2(200), "PICTURE4" VARCHAR2(200), 
"PRODUCTNAME" VARCHAR2(500), "COSTPRICE" NUMBER(12, 4), "SEVEN" NUMBER(10), "THIRTY" NUMBER(10), "NINETY" NUMBER(10), "AVERAGEDAILYSALES" VARCHAR2(100), 
"OEMNO" VARCHAR2(100), "PRODUCTSTATUS" VARCHAR2(100), "SAVENUM" NUMBER(10), "SELLPRICE" NUMBER(12, 4), "STATUS" NUMBER(10), "SAMPLENUM" NUMBER(10), 
"DELAY" NUMBER(10), CONSTRAINT "PK_DBPURCHASEFLOW" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) 
LOGGING;
-------------DB_EXPRESSTYPERULE-----------------------
CREATE TABLE "DB_EXPRESSTYPERULE" ( "SID" NUMBER(10), "LENGTH" NUMBER(8, 4), 
"WIDTH" NUMBER(8, 4), "HEIGHT" NUMBER(8, 4), "WEIGHT" NUMBER(8, 4), 
"VOLUMEWEIGHT" NUMBER(8, 4), "VOLUME" NUMBER(8, 4), "BOTTOMPERIMETER" NUMBER(8, 4), 
"ADDITIONALCHARGE" NUMBER(8, 4), "SQLFILTER" VARCHAR2(4000), "EXPRESSTYPEID" VARCHAR2(10), 
CONSTRAINT "PK_DB_EXPRESSTYPERULE" PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
---------------------db_FPXPRINTLABEL-----------------
CREATE TABLE db_FPXPRINTLABEL
(orderid VARCHAR2(100 byte) NOT NULL,
OPER VARCHAR2(50 byte),
OPERTIME DATE,
CREATTIME DATE,
CORPID VARCHAR2(10 byte),
CompanyCode VARCHAR2(50 byte),
ReturnAddress VARCHAR2(1000 byte),
ConsigneeName VARCHAR2(50 byte),
ConsigneeAddress1 VARCHAR2(1000 byte),
ConsigneeAddress2 VARCHAR2(1000 byte),
ConsigneeAddress3 VARCHAR2(1000 byte),
ConsigneeTelephone VARCHAR2(50 byte),
PostCode VARCHAR2(100 byte),
InsuranceSign VARCHAR2(50 byte),
Zone VARCHAR2(50 byte),
CountryCode VARCHAR2(50 byte),
CountryName VARCHAR2(50 byte),
CustomerService VARCHAR2(50 byte),
Sales VARCHAR2(50 byte),
ProductCode VARCHAR2(50 byte),
ProductShortName VARCHAR2(50 byte),
ProductCName VARCHAR2(200 byte),
ProductEName VARCHAR2(200 byte),
ReturnSign VARCHAR2(50 byte),
HighInsureSign VARCHAR2(50 byte),
DiEName VARCHAR2(200 byte),
DiCName VARCHAR2(200 byte),
DiPcs VARCHAR2(50 byte),
DiNote VARCHAR2(200 byte),
CargoType VARCHAR2(50 byte),
DiName  VARCHAR2(500 byte),
TotalWeight VARCHAR2(50 byte),
TotalValue VARCHAR2(50 byte),
CONSTRAINT PK_db_FPXPRINTLEBAL PRIMARY KEY(orderid));
---------------------------DB_PRODUCTFORTITLE-----------------------------	
CREATE TABLE "DB_PRODUCTFORTITLE" ( "SEQUENCEID" NUMBER(10),
 "SELLSKU" VARCHAR2(50), "LANGUAGE" VARCHAR2(20),
"ONLINENUM" NUMBER(10), "SELLNUM" NUMBER(10),
"OPER" VARCHAR2(50), "OPERTIME" DATE,
"CREATETIME" DATE, "CORPID" VARCHAR2(50),
"OPERFLAG" VARCHAR2(10) DEFAULT 0 , 
"TITLE" VARCHAR2(80), "RESERVE1" VARCHAR2(1000), 
"RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), 
"RESERVE4" VARCHAR2(100), "RESERVE5" NUMBER(10),
"RESERVE6" NUMBER(10), "RESERVE7" NUMBER(10), 
"RESERVE8" NUMBER(10), "RESERVE9" NUMBER(8, 2),
CONSTRAINT "PK_DB_PRODUCTFORTITLE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
--------------------------------db_itemListing---------------------------------------
CREATE TABLE db_itemListing
(ITEMID VARCHAR2(500 byte) NOT NULL,
Listing VARCHAR2(500 byte),
CONSTRAINT PK_DB_itemListing PRIMARY KEY(ITEMID));
---------------------------------DB_SELLSHOPFORDESCR--------------------------
CREATE TABLE "DB_SELLSHOPFORDESCR" ( "SEQUENCEID" NUMBER(10),
"DESCR" CLOB, CONSTRAINT "PK_DB_SELLSHOPFORDESCR" PRIMARY KEY ("SEQUENCEID") VALIDATE )
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
LOGGING LOB ("DESCR") STORE AS ( TABLESPACE "ZHRGPT" CHUNK 8192 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT)
NOCACHE LOGGING );
------------------------------DB_SELLSHOPDESCR---------------------------
CREATE TABLE "DB_SELLSHOPDESCR" ( "SEQUENCEID" NUMBER(10), "SELLSKU" VARCHAR2(50),
"SHOPUSERID" VARCHAR2(50), "SELLSHOPDESCRID" NUMBER(10),
CONSTRAINT "PK_DB_SELLSHOPDESCR" PRIMARY KEY ("SEQUENCEID") VALIDATE )
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;   
-------------------------------DB_STATUS---------------------------
CREATE TABLE "DB_STATUS" ( "SID" NUMBER(10), "NAME" VARCHAR2(50), "OPER" VARCHAR2(50), 
"CORPID" VARCHAR2(50), "CREATETIME" DATE, "FLAG" NUMBER(10), "SORT" NUMBER(10), 
CONSTRAINT "PK_DB_STATUS" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 
INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
-------------------------------DB_STATUSCONFIG---------------------------
CREATE TABLE "DB_STATUSCONFIG" ( "SID" NUMBER(10), "STATUSID" NUMBER(10), "NAME" 
VARCHAR2(50), "FLAG" NUMBER(10), "FOLLOWOPER" VARCHAR2(50), "FOLLOWTIME" DATE, 
CONSTRAINT "PK_DB_STATUSCONFIG" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
-----------------------------------------DB_WYTUSER----------------------------------
create table DB_WYTEXPRESS  (
   DELIVERYWAYID        VARCHAR2(50)                    not null,--编号
   NAME                 VARCHAR2(200), --名称
   CATEGORYID           VARCHAR2(50), --仓库的编号
   constraint PK_DB_WYTEXPRESS primary key (DELIVERYWAYID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_WYTEXPRESS is
'万邑通最后一公里派送方式';

create table DB_WYTINSURANCETYPE  (
   INSURANCETYPE        VARCHAR2(50)                    not null,
   NAME                 VARCHAR2(200),
   CATEGORYID           VARCHAR2(50), --仓库的编号
   constraint PK_DB_WYTINSURANCETYPE primary key (INSURANCETYPE)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace  ZHRGPT
logging
noparallel;
comment on table  DB_WYTINSURANCETYPE is
'万邑通最后一公里派送方式保险类型';
create table  DB_WYTUSER  (
   SID                  VARCHAR2(50)                    not null,
   USERID               VARCHAR2(100),
   PASSWORD             VARCHAR2(500),
   FLAG                 NUMBER(3),
   OPER                 VARCHAR2(50),
   OPERTIME             DATE,
   constraint PK_DB_WYTUSER primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table  DB_WYTUSER is
'万邑通海外仓库信息';

create table  DB_WYTPRODUCT  (
   SID                  VARCHAR2(50)                    not null,
   NAME                 VARCHAR2(100),
   MWAREHOUSEID         VARCHAR2(50),
   QTYONHAND            NUMBER(8),
   QTYORDERED           NUMBER(8),
   SPECIFICATION        VARCHAR2(500),
   QTYAVAILABLE         NUMBER(8),
   QTYSELL              NUMBER(8),
   MABANGSKU            VARCHAR2(50),
   WYTSKU               VARCHAR2(50),
   constraint PK_DB_WYTPRODUCT primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
Tablespace  ZHRGPT
logging
noparallel;

comment on table  DB_WYTPRODUCT is
'万邑通海外仓商品表';

create table DB_WYTCATEGORYDETAIL  (
   MWAREHOUSEID         VARCHAR2(50)                not null, --海外仓仓库ID   
   NAME                 VARCHAR2(100),-- 海外仓库名称
   MWAREHOUSEADDRESS    VARCHAR2(500),-- 海外仓库所在地址
   COSTOMERID           VARCHAR2(50),-- DB_WYTUSER里面的sid
   FLAG                  NUMBER(2),--标志
   constraint PK_DB_WYTCATEGORYDETAIL primary key (MWAREHOUSEID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_WYTCATEGORYDETAIL is
'万邑通海外仓库信息';
create table DB_OUTCATEGORYORDER  (
   EBAYORDERID          VARCHAR2(50)                    not null,
   DELIVERYWAYID        VARCHAR2(50),
   DELIVERYINSURANCETYPEID VARCHAR2(50),
   WAREHOUSEID          VARCHAR2(50),
   SELLERORDERNO        VARCHAR2(50),
   RECORDID             VARCHAR2(50),
   NAME                 VARCHAR2(300),
   PHONE                VARCHAR2(16),
   POSTAL               VARCHAR2(12),
   EMAIL                VARCHAR2(50),
   COUNTRYNAME          VARCHAR2(100),
   REGIONNAME           VARCHAR2(500),
   ADDRESS1             VARCHAR2(500),
   ADDRESS2             VARCHAR2(500),
   CITY                 VARCHAR2(500),
   FLAG                 NUMBER(2),
   TRACKINGNUM          VARCHAR2(50),
   CREATETIME           DATE,
   OPERTIME             DATE,
   OPER                 VARCHAR2(50),
   UPDATETIME           DATE,
   ERROR                VARCHAR2(500),
   constraint PK_DB_OUTCATEGORYORDER primary key (EBAYORDERID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_OUTCATEGORYORDER is
'海外苍的订单';

create table DB_OUTCATEGORYSELL  (
   SID                  VARCHAR2(50)                    not null,
   WAREHOUSEID          VARCHAR2(50),
   PRODUCTID            VARCHAR2(50),
   SPECIFICATION        VARCHAR2(100),
   EBAYTRANSACTIONID    VARCHAR2(50),
   EBAYITEMID           VARCHAR2(50),
   QUANTITY             NUMBER(8),
   EBAYORDERID          VARCHAR2(50),
   FLAG                 NUMBER(2),
   CATETIME             DATE,
   OPER                 VARCHAR2(50),
   OEPRTIME             DATE,
   UPDATETIME           DATE,
   ERROR                VARCHAR2(500),
   constraint PK_DB_OUTCATEGORYSELL primary key (SID)
)
pctfree 10
initrans 1
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
)
tablespace ZHRGPT
logging
noparallel;

comment on table DB_OUTCATEGORYSELL is
'海外仓订单详情';

----------------------------------DB_FPXCONFIG----------------------------
CREATE TABLE "DB_FPXCONFIG" ( "SID" VARCHAR2(20), "TOKEN" VARCHAR2(200), 
"SHIPPERNAME" VARCHAR2(100), "SHIPPERCOMPANYNAME" VARCHAR2(200), "SHIPPERADDRESS" 
VARCHAR2(200), "SHIPPERPOSTCODE" VARCHAR2(50), "SHIPPERTELEPHONE" VARCHAR2(50), 
"SHIPPERFAX" VARCHAR2(50), "INSURTYPE" VARCHAR2(50), "CARGOCODE" VARCHAR2(50), 
"PAYMENTCODE" VARCHAR2(50), "INITIALCOUNTRYCODE" VARCHAR2(50), "PRODUCTCODE" VARCHAR2(50), 
"RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "OPENFLAG" VARCHAR2(10),
 CONSTRAINT "PK_FPXCONFIG_SID" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 
MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING ;

CREATE TABLE "DB_FPXCOUNTRY" ( "SID" VARCHAR2(20), "COUNTRYCN" VARCHAR2(100), 
"COUNTRYEN" VARCHAR2(100), "OPENFLAG" VARCHAR2(50), CONSTRAINT "PK_FPXCOUNTRY_SID" PRIMARY KEY 
("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING; 

CREATE TABLE "DB_FPXEXPRESSTYPE" ( "SID" VARCHAR2(20), "NAME" VARCHAR2(100),
"NAMEEN" VARCHAR2(100), "OPENFLAG" VARCHAR2(50), CONSTRAINT "PK_FPXEXPRESSTYPE_SID" 
PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_FPXORIGINAREA" ( "SID" VARCHAR2(20), 
"NAME" VARCHAR2(100), "OPENFLAG" VARCHAR2(50), CONSTRAINT "PK_FPXORIGINAREA_SID" 
PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING; 

CREATE TABLE "DB_PRODUCTSEARCH" ( "SEQUENCEID" VARCHAR2(50), "NAME" VARCHAR2(100), "DESCR" VARCHAR2(2000), 
"OPER" VARCHAR2(100), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(50), "SQLFILTER1" VARCHAR2(4000), "SQLFILTER2" VARCHAR2(4000), 
"FILED1" NUMBER(6), "FILED2" NUMBER(6), "FILED3" VARCHAR2(500), "FILED4" VARCHAR2(500), "FILED5" VARCHAR2(500), 
"FILED6" VARCHAR2(500), "FILED7" VARCHAR2(500), "FILED8" VARCHAR2(500), "FILED9" VARCHAR2(500), "FILED10" VARCHAR2(500), 
"FILED11" VARCHAR2(500), "FILED12" VARCHAR2(500), "FILED13" VARCHAR2(500), "FILED14" VARCHAR2(500), "FILED15" VARCHAR2(500),
 "FILED16" VARCHAR2(500), "FILED17" VARCHAR2(500), "FILED18" VARCHAR2(500), "FILED19" VARCHAR2(500), "FILED20" VARCHAR2(500), 
"FLAG1" VARCHAR2(50), "FLAG2" VARCHAR2(50), "FLAG3" VARCHAR2(50), "FLAG4" VARCHAR2(50), "FLAG5" VARCHAR2(50), "FLAG6" VARCHAR2(50),
 "FLAG7" VARCHAR2(50), "FLAG8" VARCHAR2(50), "FLAG9" VARCHAR2(50), "FLAG10" VARCHAR2(50), "FLAG11" VARCHAR2(50), "FLAG12" VARCHAR2(50),
 "FLAG13" VARCHAR2(50), "FLAG14" VARCHAR2(50), "FLAG15" VARCHAR2(50), "FLAG16" VARCHAR2(50), "FLAG17" VARCHAR2(50), 
"FLAG18" VARCHAR2(50), "FLAG19" VARCHAR2(50), "FLAG20" VARCHAR2(50),
 CONSTRAINT "PK_DB_PRODUCTSEARCH" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
 
CREATE TABLE "DB_PRODUCTDEVELOP" ( "SEQUENCEID" VARCHAR2(50), "PRODUCTSOURCE" VARCHAR2(500),
 "PRODUCTID" VARCHAR2(50), "GOALACCOUNT" VARCHAR2(500), "PHOTOURL" VARCHAR2(500), "PRODUCTTITLE" VARCHAR2(100), 
"NAMECHN" VARCHAR2(100), "URL" VARCHAR2(500), "GOALSELL" NUMBER(8, 4), "EXPRESSTYPE" NUMBER(8, 4), "ESTIMATEWEIGHT" NUMBER(8, 4),
 "GOALADRESS" VARCHAR2(500), "ANTISTOP" VARCHAR2(100), "NOTE" VARCHAR2(4000), "CREATEOPER" VARCHAR2(50), 
"CREATETIME" DATE, "CHECKOPER" VARCHAR2(50), "CREATECHECKTIME" DATE, "MARKETOPER" VARCHAR2(50), "FORECASTGROSS" VARCHAR2(10),
 "FORECASTSELLNUM" NUMBER(8), "QUALITY" VARCHAR2(10), "SECULAR" VARCHAR2(10), "COUNTRY" VARCHAR2(50), "IFOLDSKU" VARCHAR2(10),
 "URGENT" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10), "CORPID" VARCHAR2(10), "PRODUCTNUM" NUMBER(8),
 "STATUS" VARCHAR2(10), "PICTURE" VARCHAR2(500), "PURCHASEFLOWOPER" VARCHAR2(50), "CONTENT" VARCHAR2(4000), "CHECKPURCHASETIME" DATE, 
"CHECKSIMPLETIME" DATE, "FINISHTIME" DATE, "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" NUMBER(8, 4), 
"RESERVE4" NUMBER(8, 4), "RESERVE5" NUMBER(8), "RESERVE6" DATE, "CATEGORYID" VARCHAR2(50), "CATEGORYNAME" VARCHAR2(50),
 "FINIDHTIME" DATE, "RESERVE7" VARCHAR2(50), "RESERVE8" VARCHAR2(50), "RESERVE9" VARCHAR2(50), "RESERVE10" VARCHAR2(50),
 "PRODUCTNOTE" VARCHAR2(2000), "RESERVE11" VARCHAR2(100), "RESERVE12" VARCHAR2(100), "RESERVE13" VARCHAR2(100), 
"RESERVE14" VARCHAR2(100), "RESERVE15" VARCHAR2(100), "RESERVE16" VARCHAR2(100), "RESERVE17" VARCHAR2(100),
 "RESERVE18" VARCHAR2(100), "LENGTHNUM" NUMBER(8, 2), "WIDTHNUM" NUMBER(8, 2), "HEIGHTNUM" NUMBER(8, 2), 
"DELIVERYTIME" DATE, "TOTALASSESS" NUMBER(10), "YIELDLY" VARCHAR2(50),
 CONSTRAINT "PK_DB_PRODUCTDEVELOP" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 2048K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS; 
 
 
CREATE TABLE "DB_LCL" ( "SEQUENCEID" NUMBER(18), 
"CONTAINERNUMBER" VARCHAR2(200), "FTCBM" NUMBER(10), "ARRIVALPERIOD" NUMBER(10), 
"LCLTIME" DATE, "OUTPORTTIME" DATE, "TOWAREHOUSETIME" DATE, "INWAREHOUSETIME" DATE,
 "CREATEDATE" DATE, "CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, "OPER" VARCHAR2(50), 
"CONTAINERINFO" VARCHAR2(2000), "PACKAGEINGLIST" VARCHAR2(200), "EXPRESSID" VARCHAR2(200), 
"CHECKTIME" DATE, "TOPURPOSEPORTTIME" DATE, "RECEIPT" VARCHAR2(200), "EXPRESSTYPE" VARCHAR2(20), 
"TRANSPORTFARE" NUMBER(12, 4), "POSITION" VARCHAR2(10), "STATUS" NUMBER(10), "TOPORTTIME" DATE, 
CONSTRAINT "PK_DB_LCL" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS ;

CREATE TABLE "DB_LCLLOG" ( "SEQUENCEID" NUMBER(18), "CONTAINERNUMBER" VARCHAR2(200), "FTCBM" NUMBER(10), 
"ARRIVALPERIOD" NUMBER(10), "LCLTIME" DATE, "OUTPORTTIME" DATE, "TOWAREHOUSETIME" DATE, "INWAREHOUSETIME" DATE, 
"CREATEDATE" DATE, "CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, "OPER" VARCHAR2(50), "CONTAINERINFO" VARCHAR2(2000), 
"PACKAGEINGLIST" VARCHAR2(200), "EXPRESSID" VARCHAR2(200), "CHECKTIME" DATE, "TOPURPOSEPORTTIME" DATE, "RECEIPT" VARCHAR2(200), 
"EXPRESSTYPE" VARCHAR2(20), "TRANSPORTFARE" NUMBER(12, 4), "POSITION" VARCHAR2(10), "CONTENT" VARCHAR2(200), "OPERTYPE" NUMBER(10),
 CONSTRAINT "PK_DB_LCLLOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_ANALYSETYPE" ( "SEQUENCEID" VARCHAR2(10), "NAME" VARCHAR2(100), 
"FLAG" NUMBER(5), "CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
"DESCRIPTION" VARCHAR2(500), CONSTRAINT "PK_DB_ANALYSETYPE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS ;

CREATE TABLE "DB_WORKREPORT" ( "SEQUENCEID" NUMBER(10), "TITLE" VARCHAR2(500), "WORKATTRIBUTEID" NUMBER(10), "WORKMOULDID" NUMBER(10), 
"WORKMOULD" VARCHAR2(4000), "CREATEOPER" VARCHAR2(100), "CREATETIME" DATE, "WORK1" VARCHAR2(4000), "WORK2" VARCHAR2(4000), "WORK3" VARCHAR2(4000), 
"WORK4" VARCHAR2(4000), "WORK5" VARCHAR2(4000), "WORK6" VARCHAR2(4000), "OPERTIME" DATE, "WARMOPER" VARCHAR2(4000), "FLAG" NUMBER(8), "CORPID" VARCHAR2(10), 
"OPENFLAG" NUMBER(8), "OPER" VARCHAR2(100), "CONTENT" VARCHAR2(4000), "STATUS" NUMBER(10), "PROTOCOLTIME1" VARCHAR2(50), "PROTOCOLTIME2" VARCHAR2(50), 
"UPDATEFLAG" VARCHAR2(2000), "ALERTFLAG" NUMBER(4), "FILEURL" VARCHAR2(200), CONSTRAINT "PK_DB_WORKREPORT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 2048K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "DB_WORKREPORTLOG" ( "SEQUENCEID" VARCHAR2(50), "TITLE" VARCHAR2(500), "WORKATTRIBUTEID" NUMBER(10),
 "WORKMOULDID" NUMBER(10), "WORKMOULD" VARCHAR2(4000), "CREATEOPER" VARCHAR2(100), "CREATETIME" DATE, "WORK1" VARCHAR2(4000), 
"WORK2" VARCHAR2(4000), "WORK3" VARCHAR2(4000), "WORK4" VARCHAR2(4000), "WORK5" VARCHAR2(4000), "WORK6" VARCHAR2(4000), 
"OPERTIME" DATE, "WARMOPER" VARCHAR2(4000), "FLAG" NUMBER(8), "CORPID" VARCHAR2(10), "OPENFLAG" NUMBER(8), "OPER" VARCHAR2(100), 
"CONTENT" VARCHAR2(4000), "STATUS" NUMBER(10), "PROTOCOLTIME1" VARCHAR2(50), "PROTOCOLTIME2" VARCHAR2(50), "UPDATEFLAG" VARCHAR2(2000),
 "SID" NUMBER(10), CONSTRAINT "PK_DB_WORKREPORTLOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
 ( INITIAL 2048K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PROJECTBBS" ( "SEQUENCEID" NUMBER(8), "PROJECTNAME" VARCHAR2(500), "LIMITTIME" NUMBER(5), 
"PRINCIPALOPER" VARCHAR2(50), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50), "CREATETIME" DATE, 
"CORPID" VARCHAR2(10), "OPERNFLAG" VARCHAR2(10), "PERCENTAGE" NUMBER(5, 4), "CLIPARTFLAG" NUMBER(5), "SALESFLAG" NUMBER(5), 
"CHECKFLAG" NUMBER(5), "ESTIMATEDSTARTTIME" DATE, "ESTIMATEDENDTIME" DATE, "STARTTIME" DATE, "ENDTIME" DATE, "STATUS" NUMBER(8, 2), 
CONSTRAINT "PK_DB_PROJECTBBS" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
 ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_EBAYIDMANAGE" ( "SEQUENCEID" NUMBER(17), "NAME" VARCHAR2(150), "SHOPTYPEID" VARCHAR2(50),
 "OPERTIME" DATE, "OPENFLAG" NUMBER(2), "OPER" VARCHAR2(100), "CORPID" NUMBER(2), "BBEREALITY" VARCHAR2(100), 
"BBEREALITY1" VARCHAR2(100), "BBEREALITY2" VARCHAR2(100), "BBENUM" VARCHAR2(100), "BBENUM1" VARCHAR2(100), 
"BBENUM2" VARCHAR2(100), "BBEBB" VARCHAR2(100), "BBEBB1" VARCHAR2(100), "BBEBB2" VARCHAR2(100), "BBENUMB" NUMBER(10, 4),
 "BBENUMB1" NUMBER(10, 4), "BBENUMB2" NUMBER(10, 4), "CHAE" NUMBER(10, 4), "CHAE1" NUMBER(10, 4), "CHAE2" NUMBER(10, 4),
 "BBESNUM" NUMBER(10, 4), "BBESNUM1" NUMBER(10, 4), "BBESNUM2" NUMBER(10, 4), "ACTUALSHOPNAME" VARCHAR2(200), "ACTUALSHOPID" VARCHAR2(200),
 CONSTRAINT "PK_DB_EBAYIDMANAGE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE
 ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_EBAYIDMANAGEHTMLSOURCE" ( "SEQUENCEID" NUMBER(8), "EBAYIDMANAGEID" NUMBER(8), 
"DESCR" VARCHAR2(4000), "SORT" NUMBER(8), CONSTRAINT "PK_DB_EBAYIDMANAGEHTMLSOURCE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_CALPRICE" ( "SEQUENCEID" NUMBER(15), "PRODUCTID" VARCHAR2(50), "PRICE" NUMBER(10, 4), 
"TOCOUNTRY" VARCHAR2(50), "CREATETIME" DATE, "CORPID" NUMBER(5), "OPENFLAG" NUMBER(5), "PRICERMB" NUMBER(10, 4), 
"MONERYRATE" VARCHAR2(10), "CALCULATEALLID" VARCHAR2(6), "CALCULATEALL" VARCHAR2(50), "PLATFROMID" NUMBER(5), 
"EXPRESSTYPEID" NUMBER(5), "PLATFROMNAME" VARCHAR2(50), "EXPRESSTYPE" VARCHAR2(50), CONSTRAINT "PK_DB_CALPRICE"
 PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 81920K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_CAIWU" ( "SEQUENCEID" VARCHAR2(50), "SOURCE" VARCHAR2(100), "SOURCEID" VARCHAR2(50), "MONEYRATE" VARCHAR2(10), 
"MONEY" NUMBER(10, 4), "GROUPID" VARCHAR2(50), "REMARK" VARCHAR2(4000), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500),
 "RESERVE3" VARCHAR2(500), "RESERVE4" NUMBER(10, 4), "RESERVE5" NUMBER(10, 4), "CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), 
"STATUS" VARCHAR2(50), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATEOPER" VARCHAR2(50), "CREATETIME" DATE, "OPER1" VARCHAR2(100),
 "FLAG" NUMBER(8), "COUNTRY" VARCHAR2(50), "PONUMBER" VARCHAR2(50), "MENUFUNCTER" VARCHAR2(50), "MENUFUNCTERID" VARCHAR2(10), 
"PAYMENTTYPE" VARCHAR2(50), "SENDTIME" DATE, "TOPORTTIME" DATE, "DEPOSITSTIME" DATE, "SENDPAYTIME" DATE, "TOPORTPAYTIME" DATE,
 "FINALPAYTIME" DATE, "AMOUNTRMB" NUMBER(15, 4), "AMOUNTUSD" NUMBER(15, 4), "DEPOSITS" NUMBER(15, 4), "PAYMENTMONEY" NUMBER(15, 4),
 "NOPAYMENYMONEY" NUMBER(15, 4), "SENDMONEY" NUMBER(15, 4), "TOPORTMONEY" NUMBER(15, 4), "FINALMONEY" NUMBER(15, 4), "PRODUCTID" VARCHAR2(50),
 "AMOUNTRMBFLAG" NUMBER(10), "DEPOSITSFLAG" NUMBER(10), "SENDMONEYFLAG" NUMBER(10), "TOPORTMONEYFLAG" NUMBER(10), "FINALMONEYFLAG" NUMBER(10), 
"ACCOUNTMONEY" NUMBER(15, 4), "NONPAYMENTMONEY" NUMBER(15, 4), CONSTRAINT "PK_DB_CAIWU" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 6144K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_CAIWUDEPLOY" ( "SEQUENCEID" VARCHAR2(10), "NAME" VARCHAR2(50) NOT NULL , "CORPID" VARCHAR2(10) NOT NULL , 
"OPENFLAG" VARCHAR2(10) NOT NULL , CONSTRAINT "PK_DB_CAIWUDEPLOY" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_CAIWULOG" ( "SEQUENCEID" VARCHAR2(50), "SOURCE" VARCHAR2(100), "SOURCEID" VARCHAR2(50), 
"MONEYRATE" VARCHAR2(10), "MONEY" NUMBER(10, 4), "GROUPID" VARCHAR2(50), "REMARK" VARCHAR2(4000), "RESERVE1" VARCHAR2(500), 
"RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), "RESERVE4" NUMBER(10, 5), "RESERVE5" NUMBER(10, 4), "CORPID" VARCHAR2(10), 
"OPENFLAG" VARCHAR2(10), "STATUS" VARCHAR2(50), "DESCR" VARCHAR2(4000), "OPER" VARCHAR2(50), "OPERTIME" DATE, CONSTRAINT 
"PK_DB_CAIWULOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 6144K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_GIFT" ( "SEQUENCEID" VARCHAR2(50), "PRODUCTID" VARCHAR2(100), "PRODUCTNAME" VARCHAR2(500), 
"PRODUCTNAMEEN" VARCHAR2(500), "WEIGHT" NUMBER(8, 4), "COSTPRICE" NUMBER(8, 4), "SELLPRICE" NUMBER(8, 4), "SAVENUM" NUMBER(10), 
"OPER1" VARCHAR2(50), "OPER2" VARCHAR2(50), "SHOPTYPE" VARCHAR2(100), "SHOPTYPEID" VARCHAR2(50), "PICTUREURL" VARCHAR2(500), 
"EBAYITEMID" VARCHAR2(100), "EBAYSITE" VARCHAR2(50), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), 
"RESERVE4" NUMBER(10, 4), "RESERVE5" NUMBER(10, 4), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), 
"CATEGORYID" VARCHAR2(50), "CATEGORY" VARCHAR2(200), "CREATEOPER" VARCHAR2(50), "CREATETIME" DATE, CONSTRAINT "PK_DB_GIFT" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PERFORMANCE" ( "SEQUENCEID" NUMBER(10), "OPER" VARCHAR2(50), "POINT" NUMBER(5), 
"CREATETIME" DATE, "DESCR" VARCHAR2(4000), "CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), "STATUS" NUMBER(4), 
"OPERID" NUMBER(6), "POINTDESCR" VARCHAR2(500), "GROUPID" VARCHAR2(10), "CREATEOPER" VARCHAR2(50), "OPERTIME" DATE, 
"ALERTFLAG" NUMBER(2), CONSTRAINT "PK_DB_PERFORMANCE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT"
 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_NEWITEMRESULT" ( "SID" VARCHAR2(50), "PRODUCTINDEX" VARCHAR2(20), "ITEMID" VARCHAR2(20), 
"EBAYBUYITNEWPRICE" NUMBER(8, 2), "EBAYBUYITNEWPRICEMONEYTYPE" VARCHAR2(20), "EBAYCOUNTRY" VARCHAR2(50), 
"EBAYDESCRIPTION" VARCHAR2(4000), "EBAYHITCOUNT" NUMBER(8), "EBAYITEMID" VARCHAR2(20), "EBAYSTARTTIME" DATE, "EBAYENDTIME" DATE, 
"EBAYHASRESERVEPRICE" VARCHAR2(20), "EBAYITEMURL" VARCHAR2(200), "EBAYLISTDURATION" VARCHAR2(50), "EBAYLOCATION" VARCHAR2(100), 
"EBAYGALLERYTYPE" VARCHAR2(50), "EBAYGALLERYURL" VARCHAR2(200), "EBAYPHOTODISPLAY" VARCHAR2(50), "EBAYPICTURESOURCE" VARCHAR2(50), 
"EBAYCATEGORYID" VARCHAR2(20), "EBAYCATEGORYNAME" VARCHAR2(200), "EBAYQUANTITY" NUMBER(8), "EBAYQUANTITYSOLD" NUMBER(8),
 "EBAYFEEDBACKTATINGSTAR" VARCHAR2(2000), "EBAYFEEDBACKSCORE" NUMBER(8), "EBAYPOSITIVEFEEDBACKPERCENT" NUMBER(5, 2), 
"EBAYSELLERBUSINESSTYPE" VARCHAR2(200), "EBAYSTOREFRONT" VARCHAR2(20), "EBAYSTOREURL" VARCHAR2(200), "EBAYSITE" VARCHAR2(50), 
"EBAYSTATUS" VARCHAR2(20), "EBAYUSERID" VARCHAR2(200), "EBAYUSERIDCHANGED" VARCHAR2(20), "EBAYSKU" VARCHAR2(200), 
"EBAYSTARTPRICE" NUMBER(8, 2), "EBAYDDLEFT" NUMBER(8), "EBAYHHLEFT" NUMBER(8), "EBAYMMLEFT" NUMBER(8), "EBAYTITLE" VARCHAR2(500), 
"FLAG" NUMBER(2), "CORPID" VARCHAR2(50), "OPER" VARCHAR2(100), "OPERTIME" DATE, "UPDATETIME" DATE, "CREATETIME" DATE, 
"PRICEFLAG" NUMBER(1), "TITLEFLAG" NUMBER(1), "PICTRUEFLAG" NUMBER(1), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), 
"RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7" NUMBER(8), 
"RESERVE8" NUMBER(8, 2), "RESERVE9" NUMBER(8, 2), "RESERVE10" NUMBER(8, 2), "RESERVE11" DATE, "RESERVE12" DATE, "RESERVE13" DATE, 
"RESERVE14" NUMBER(8), "RESERVE15" NUMBER(8), "RESERVE16" NUMBER(8, 2), "SHOWFLAG" NUMBER(2), "SELLNUMBERAVGONEDAY" NUMBER(10, 3), 
"SELLNUMBERDAY" NUMBER(8), "SELLNUMBERWEEK" NUMBER(8), "SELLNUMBERMONTH" NUMBER(8), "SELLNUMBERTOTAL" NUMBER(8), "SELLNUMBERAVG" NUMBER(8), 
"SELLNUMBERSITE" NUMBER(8), "DOWNCOUNT" NUMBER(8), "ENMITYID" VARCHAR2(50), "THREEDAYSNUM" NUMBER(8), "EXPRESSMONEYTYPE1" VARCHAR2(50),
 "EXPRESSMONEYTYPE2" VARCHAR2(50), "EXPRESSMONEYTYPE3" VARCHAR2(50), "EXPRESSMONEYTYPE4" VARCHAR2(50), "INTERNATIONALEXPRESS1" NUMBER(6, 2), 
"INTERNATIONALEXPRESS2" NUMBER(6, 2), "EXPRESS1" NUMBER(6, 2), "EXPRESS2" NUMBER(6, 2), "WEEKHITCOUNTER" NUMBER(8), "MONTHHITCOUNTER" NUMBER(8), 
"HITCOUNTERALL" NUMBER(8), "WEEKTRANSFORMRATE" NUMBER(8, 2), "MONTHTRANSFORMRATE" NUMBER(8, 2), "TOTALTTRANSFORMRATE" NUMBER(8, 2),
 "EXPRESSFLAG1" NUMBER(2), "EXPRESSFLAG2" NUMBER(2), "EXPRESSFLAG3" NUMBER(2), "EXPRESSFLAG4" NUMBER(2), "CREATEOPER" VARCHAR2(200), 
"CALCULATEFLAG" VARCHAR2(10), CONSTRAINT "PK_DB_NEWITEMRESULT" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1
 MAXTRANS 255 STORAGE ( INITIAL 75776K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_COMPETITORSEARCH" ( "SEQUENCEID" NUMBER(6), "NAME" VARCHAR2(100), "DESCR" VARCHAR2(2000), "OPER" VARCHAR2(100),
 "OPERTIME" DATE, "SQLFILTER" VARCHAR2(3000), "DAYSELLNUM" NUMBER(6), "TRANSLATRATE" NUMBER(4, 2), "PUBLISHTIME" DATE, "SELLPRICESTART" NUMBER(8, 2),
 "SELLPRICEEND" NUMBER(8, 2), "ROVERLAPENUM" NUMBER(8), "OPENFLAG" VARCHAR2(50), "CORPID" NUMBER(2), "DAYSELLNUM2" NUMBER(6), "TRANSLATRATE2" NUMBER(4, 2),
 "PUBLISHTIME2" DATE, "ROVERLAPENUM2" NUMBER(8), "JSONSTR" VARCHAR2(4000), CONSTRAINT "PK_DB_DB_COMPETITORSEARCH" PRIMARY KEY ("SEQUENCEID") VALIDATE )
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PICTUREATTRIBUTE" ( "SEQUENCEID" VARCHAR2(50), "NAME" VARCHAR2(200), "UPLOADFLAG" VARCHAR2(10), 
"THISURL" VARCHAR2(300), "FTPIP" VARCHAR2(50), "FTPUSERNAME" VARCHAR2(100), "FTPPASSWORD" VARCHAR2(100), "FTPURL" VARCHAR2(300), 
"RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "RESERVE4" NUMBER(10, 4), "RESERVE5" NUMBER(10, 4), 
"CORPID" VARCHAR2(10), "OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, "ATTRIBUTEID" VARCHAR2(50), CONSTRAINT "PK_DB_ICTUREATTRIBUTE" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_ALIEXPRESSTYPE" ( "SID" NUMBER(4), "NAME" VARCHAR2(200), "SHOWNAME" VARCHAR2(200), "SERVICENAME" VARCHAR2(200),
 "OPER" VARCHAR2(50), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(100), "ALIID" VARCHAR2(100), "DESCR" VARCHAR2(200), "RESERVE1" VARCHAR2(200),
 "RESERVE2" VARCHAR2(200), "RESERVE3" VARCHAR2(200), CONSTRAINT "PK_DB_ALIEXPRESSTYPE" PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT"
 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PRODUCTANDMANUFACTURE" ( "SEQUENCEID" VARCHAR2(50), "INDEXID" VARCHAR2(15), "MANUFACTUREID" VARCHAR2(50),
 "MANUFACTURENAME" VARCHAR2(100), "QUOTE" NUMBER(12, 4), "OPER" VARCHAR2(100), "CORPID" VARCHAR2(100), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(100),
 "ADDRESS" VARCHAR2(100), "TEL" VARCHAR2(100), "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" NUMBER(8, 4), "RESERVE4" NUMBER(8, 4),
 "WANGWANG" VARCHAR2(1000), "QQ" VARCHAR2(20), "CREATETIME" DATE, "TYPE" VARCHAR2(2), "PRODUCTID" VARCHAR2(50), "MINNUM" NUMBER(10), "NOTE" VARCHAR2(1000), 
"INFORMATION" VARCHAR2(500), "STYLE" VARCHAR2(500), "REPAIRRATE" VARCHAR2(20), "ATTESTATION" VARCHAR2(500), "PACKAGING" VARCHAR2(200), "IMPORTRIGHT" VARCHAR2(100),
 "SERVE" VARCHAR2(50), "EVALUATION" VARCHAR2(50), "MANAGEPRODUCT" VARCHAR2(500), "LINKMAN" VARCHAR2(50), "SURVEYTABLE" VARCHAR2(500), "PERSONNUM" NUMBER(10), 
"MAINMARKET" VARCHAR2(500), "PROFESSIONAL" VARCHAR2(10), "PRICEFIXING" VARCHAR2(10), "RESTS" VARCHAR2(500), "MANUFACTUREURL" VARCHAR2(500), "RESERVE5" VARCHAR2(200),
 "RESERVE6" VARCHAR2(200), "RESERVE7" VARCHAR2(200), "RESERVE8" VARCHAR2(200), CONSTRAINT "PK_DB_BRANDPRODUCT" PRIMARY KEY ("SEQUENCEID") VALIDATE )
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_COMPETITIONSKU" ( "SEQUENCEID" NUMBER(6), "SKU" VARCHAR2(100), "XSKU" VARCHAR2(100), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "CORPID" VARCHAR2(10), CONSTRAINT "PK_DB_COMPETITIONSKU" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 
INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "DB_PRODUCTANDITEMID" ( "SEQUENCEID" VARCHAR2(50), "PRODUCTINDEXID" VARCHAR2(100), "ITEMID" VARCHAR2(100), "ENMITYID" VARCHAR2(50),
 CONSTRAINT "PK_DB_PRODUCTANDITEMID" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
 ( INITIAL 256K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;




CREATE TABLE "DB_MATECATEGORY" ( "SID" NUMBER(12), "CATEGROYID" VARCHAR2(50), "CATEGROYNAME" VARCHAR2(200), "EBAYCATEGORYID" VARCHAR2(50), 
"EBAYCATEGORYNAME" VARCHAR2(200), "TEMPLETID" VARCHAR2(50), "FLAG" NUMBER(2), "SITE" VARCHAR2(200), CONSTRAINT "PK_DB_MATECATEGORY" 
PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_BACKNOTE" ( "SEQUENCEID" VARCHAR2(10), "NAME" VARCHAR2(200), "OPER" VARCHAR2(50), "OPERTIME" DATE, CONSTRAINT "PK_DB_BACKNOTE" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "DB_WORKMODLE" ( "SEQUENCEID" NUMBER(8), "TITLE" VARCHAR2(500), "CONTENT" VARCHAR2(4000), "OPER" VARCHAR2(100), "OPERTIME" DATE, "CORPID" VARCHAR2(10), 
"OPENFLAG" NUMBER(8), CONSTRAINT "PK_DB_WORKMODLE" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "DB_PRODUCTFORSELL" ( "SEQUENCEID" VARCHAR2(20), "SELLSKU" VARCHAR2(50), "NAME" VARCHAR2(1000), "ENNAME" VARCHAR2(1000), "TITLE" VARCHAR2(500), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10), "CORPID" VARCHAR2(10), "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(1000), 
"RESERVE4" NUMBER(8), "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(10, 4), "RESERVE7" NUMBER(10, 4), "RESERVE8" DATE, "CREATETIME" DATE, "STATUS" VARCHAR2(10), 
"CATEGORYID" VARCHAR2(50), "CATEGORYNAME" VARCHAR2(500), "SELLOPER" VARCHAR2(50), "PURCHASEOPER" VARCHAR2(50), "NUMFORSKU" NUMBER(8), "NUMFORONLINEITEM" NUMBER(8), 
"SODEFORONLINEITEM" NUMBER(8), "NUMFORONLINESHOP" NUMBER(8), "NUMFORSHOP" NUMBER(8), "NUMFORDESCR" NUMBER(8), "ONEWEEKNUM" NUMBER(10), "TWOWEEKNUM" NUMBER(10), 
"THREEWEEKNUM" NUMBER(10), "FOURWEEKNUM" NUMBER(10), "US" VARCHAR2(50), "AU" VARCHAR2(50), "UK" VARCHAR2(50), "CA" VARCHAR2(50), "DE" VARCHAR2(50), "DESCRFLAG" VARCHAR2(1), 
"PHOTOFLAG" VARCHAR2(1), "STATUS1" VARCHAR2(1), "ATTRIBUTE" VARCHAR2(1), "ONESTAGE" VARCHAR2(1), "TWOSTAGE" VARCHAR2(1), "AVGNUM" NUMBER(10, 2), "ONEMONTH" VARCHAR2(1), 
"NEWSALL" NUMBER(10), "NEWS" NUMBER(10), "TASKNUM" NUMBER(10), "SEASONFLAG" VARCHAR2(1), "RESERVE12" NUMBER(10, 2), "RESERVE9" NUMBER(10, 4), "RESERVE10" NUMBER(10, 4), 
"RESERVE11" NUMBER(10, 4), "EXPRESSTYPE1" VARCHAR2(100), "EXPRESSTYPE2" VARCHAR2(100), "EXPRESSTYPE3" VARCHAR2(100), "EXPRESSTYPE4" VARCHAR2(100), 
"EXPRESSTYPE5" VARCHAR2(100), "MAOLI" NUMBER(10, 2), "RESERVE13" NUMBER(10, 2), "RESERVE14" NUMBER(10, 2), "GROSSPROFIT" NUMBER(10, 4), "RATEOFMARGIN" NUMBER(10, 4), 
CONSTRAINT "PK_DB_PRODUCTFORSELL" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 832K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PRODUCTANDSELL" ( "SEQUENCEID" VARCHAR2(50), "SKU" VARCHAR2(50), "FLAG" VARCHAR2(10), CONSTRAINT "PK_DB_PRODUCTANDSELL" 
PRIMARY KEY ("SEQUENCEID", "SKU") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 320K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PRODUCTFORTEMPLET" ( "SEQUENCEID" NUMBER(9), "CORPID" VARCHAR2(50), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATETIME" DATE, 
"LANGUAGE" VARCHAR2(50), "CATEGORYID" VARCHAR2(50), "CATEGORYNAME" VARCHAR2(100), "DSECR" VARCHAR2(50), "RESERVE1" NUMBER(9), "RESERVE2" NUMBER(9), 
"RESERVE3" VARCHAR2(500), "RESERVE4" DATE, "RESERVE5" NUMBER(9, 4), "RESERVE6" NUMBER(9), "NOTE" VARCHAR2(1000), CONSTRAINT "PK_DB_PRODUCTFORTEMPLET" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


--------------------------------------DB_SELLFORSHOP------------------------------------------

CREATE TABLE "DB_SELLFORSHOP" ( "SEQUENCEID" NUMBER(10), "SELLSKU" VARCHAR2(50), "SHOPID" VARCHAR2(50), "SHOPNAME" VARCHAR2(100), "OPENFLAG" VARCHAR2(2), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" VARCHAR2(50), "SELLUSERID" VARCHAR2(50), "EBAYSHOPID" VARCHAR2(100), "EBAYSHOPNAME" VARCHAR2(100), 
"SORT" NUMBER(3), CONSTRAINT "PK_DB_SELLFORSHOP" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;
----------------------------------------DB_PRODUCTDEVELOPFORSON-----------------------------------------
CREATE TABLE "DB_PRODUCTDEVELOPFORSON" ( "SEQUENCEID" NUMBER(9), "FATHINDEXID" VARCHAR2(50), "PRODUCTID" VARCHAR2(50), "NAME" VARCHAR2(500), "ENNAME" VARCHAR2(500), 
"SAVENUM" NUMBER(8), "SELLPRICE" NUMBER(8, 2), "COSTPRICE" NUMBER(8, 2), "WEIGHT" NUMBER(8), "CATEGORYID" VARCHAR2(50), "CATEGORYNAME" VARCHAR2(50), 
"MANUFACTUREID" VARCHAR2(50), "MANUFACTURENAME" VARCHAR2(50), "QUOTE" NUMBER(8, 2), "MINNUM" NUMBER(8), "PHOTOURL" VARCHAR2(500), "CHASEOPER" VARCHAR2(20), 
"RESERVE1" VARCHAR2(1000), "RESERVE2" VARCHAR2(500), "RESERVE3" NUMBER(8), "RESERVE4" NUMBER(8, 2), "TITLE" VARCHAR2(500), "OPENFLAG" VARCHAR2(2), 
"FLAG" VARCHAR2(2), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" VARCHAR2(50), "MONEYTYPE" VARCHAR2(50), "RESERVE5" VARCHAR2(100), "RESERVE6" VARCHAR2(100), 
"RESERVE7" VARCHAR2(100), "RESERVE8" VARCHAR2(100), CONSTRAINT "PK_DB_PRODUCTDEVELOPFORSON" PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

-----------------------------DB_EXPSTORE--------------------------------------
CREATE TABLE "DB_EXPSTORE" ( "SEQUENCEID" NUMBER(12), "GROUPID" VARCHAR2(100), "CUSTOMERID" VARCHAR2(100), "CONTENT" VARCHAR2(4000), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "CORPID" VARCHAR2(50), "OPENFLAG" VARCHAR2(10), "UPDATEFLAG" NUMBER(5), CONSTRAINT "PK_DB_EXPSTORE" PRIMARY KEY ("SEQUENCEID") VALIDATE )
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

-----------------------------------DB_EXPSTOREITEM--------------------------------------
CREATE TABLE "DB_EXPSTOREITEM" ( "SEQUENCEID" NUMBER(12), "EXPSTOREID" NUMBER(12), "SKU" VARCHAR2(100), "ORDERNUM" NUMBER(12), "PRICE" NUMBER(10, 4), 
"SAVELOG" VARCHAR2(4000), CONSTRAINT "PK_DB_EXPSTOREITEM" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE 
( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_RETURNMANAGERMENT" ( "SEQUENCEID" NUMBER(18), "NAME" VARCHAR2(200), "REPLAYSTATUS" NUMBER(6), "OPENFLAG" NUMBER(6), 
"CREATOPER" VARCHAR2(50), "CREATTIME" DATE, "OPER" VARCHAR2(50), "OPERTIME" DATE, "CONTENTID" NUMBER(18), "ORDERID" VARCHAR2(50), 
"MESSAGEID" VARCHAR2(50), "SHOPTYPEID" NUMBER(10), "CUSTOMERNAME" VARCHAR2(600), "CUSTOMERCOUNTRY" VARCHAR2(1000), "SHOPTYPE" VARCHAR2(100), 
"ORDERSTATUS" VARCHAR2(100), "ORDERSOURCE" VARCHAR2(50), "ORDERTIME" NUMBER(10), "CUSTOMERCOUNTRYID" VARCHAR2(50), "CUSTOMERCOUNTRYEN" VARCHAR2(50), 
"CONTENT" VARCHAR2(1000), "DISPOSEFLAG" NUMBER(6), "RETURNPROSTATUS" NUMBER(6), "RETURNMONEYSTATUS" NUMBER(6), "REPLAYORDERID" VARCHAR2(300), 
"RETURNDESCR" VARCHAR2(1000), "RETURNFLAG" NUMBER(6), "ACTUALSAVENUM" NUMBER(10), "KEYWORDS" VARCHAR2(50), 
CONSTRAINT "PK_DB_RETURNMANAGERMENT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;


CREATE TABLE "DB_RETURNMANAGERMENT_LOG" ( "SEQUENCEID" NUMBER(18), "RETURNID" NUMBER(18), "NAME" VARCHAR2(200), "REPLAYSTATUS" NUMBER(6), "OPENFLAG" NUMBER(6), 
"CREATOPER" VARCHAR2(50), "CREATTIME" DATE, "OPER" VARCHAR2(50), "OPERTIME" DATE, "CONTENTID" NUMBER(18), "ORDERID" VARCHAR2(50), "MESSAGEID" VARCHAR2(50), 
"SHOPTYPEID" NUMBER(10), "CUSTOMERNAME" VARCHAR2(600), "CUSTOMERCOUNTRY" VARCHAR2(1000), "SHOPTYPE" VARCHAR2(100), "ORDERSTATUS" VARCHAR2(100), 
"ORDERSOURCE" VARCHAR2(50), "ORDERTIME" NUMBER(10), "OPERTYPE" NUMBER(6), "CUSTOMERCOUNTRYID" VARCHAR2(50), "CUSTOMERCOUNTRYEN" VARCHAR2(50), 
"DESCR" VARCHAR2(4000), "DISPOSEFLAG" NUMBER(6), "RETURNPROSTATUS" NUMBER(6), "RETURNMONEYSTATUS" NUMBER(6), CONSTRAINT "PK_DB_RETURNMANAGERMENT_LOG" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING;



CREATE TABLE "DB_PROJECTSKU" ( "SEQUENCEID" NUMBER(8), "PROJECTID" NUMBER(8), "SKU" VARCHAR2(50), "SKUTYPE" NUMBER(8), "SID" VARCHAR2(200), 
"IMGURL" VARCHAR2(500), "CHECKTIME" DATE, "CHECKFLAG" NUMBER(10), CONSTRAINT "PK_DB_PROJECTSKU" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 128K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_FPXPRINTLEBAL" ( "SEQUENCEID" NUMBER(12), "ORDERID" VARCHAR2(100), "OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATTIME" DATE, 
"CORPID" VARCHAR2(10), "COMPANYCODE" VARCHAR2(50), "RETURNADDRESS" VARCHAR2(1000), "CONSIGNEENAME" VARCHAR2(50), "CONSIGNEEADDRESS1" VARCHAR2(1000), 
"CONSIGNEEADDRESS2" VARCHAR2(1000), "CONSIGNEEADDRESS3" VARCHAR2(1000), "CONSIGNEETELEPHONE" VARCHAR2(50), "POSTCODE" VARCHAR2(100), 
"INSURANCESIGN" VARCHAR2(50), "ZONE" VARCHAR2(50), "COUNTRYCODE" VARCHAR2(50), "COUNTRYNAME" VARCHAR2(50), "CUSTOMERSERVICE" VARCHAR2(50), 
"SALES" VARCHAR2(50), "PRODUCTCODE" VARCHAR2(50), "PRODUCTSHORTNAME" VARCHAR2(50), "PRODUCTCNAME" VARCHAR2(200), "PRODUCTENAME" VARCHAR2(200), 
"RETURNSIGN" VARCHAR2(50), "HIGHINSURESIGN" VARCHAR2(50), "DIENAME" VARCHAR2(200), "DICNAME" VARCHAR2(200), "DIPCS" VARCHAR2(50), "DINOTE" VARCHAR2(200), 
"CARGOTYPE" VARCHAR2(50), "DINAME" VARCHAR2(500), "TOTALWEIGHT" VARCHAR2(50), "TOTALVALUE" VARCHAR2(50), "DIUNITPRICE" VARCHAR2(50), 
CONSTRAINT "PK_DB_FPXPRINTLEBAL" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;


CREATE TABLE "DB_TASKITEMID" ( "SID" VARCHAR2(50), "SKU" VARCHAR2(50), "ITEMID" VARCHAR2(20), "FLAG" NUMBER(2), "OPENFLAG" NUMBER(2), "OPER" VARCHAR2(50), 
"OPERTIME" DATE, "CREATETIME" DATE, "CORPID" VARCHAR2(10), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), 
"RESERVE4" VARCHAR2(500), "RESERVE5" NUMBER(8, 2), "RESERVE6" NUMBER(8, 2), "RESERVE7" NUMBER(8, 2), "RESERVE8" NUMBER(6), "RESERVE9" NUMBER(6), 
"RESERVE10" NUMBER(6), "DOWNLOADDAYS" NUMBER(8), "DOWNLOADFLAG" NUMBER(8), "ENMITYID" VARCHAR2(50), 
CONSTRAINT "PK_DB_TASKITEMID" PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 7168K BUFFER_POOL DEFAULT) LOGGING;

------------------------------------fst 2013-09-04-----------------------------------
alter table DB_PRODUCTFORSELL modify RESERVE1 VARCHAR2(2000);
---------------------------------fst 2013-9-3 ----------------销售模块 在线商品转化率报表---------
CREATE TABLE "DB_SHOPMESSAGEREPORTFORMS" ( "SEQUENCEID" NUMBER(10), "SHOPID" VARCHAR2(100), 
"SHOPNAME" VARCHAR2(100), "ITEMID" VARCHAR2(100), "PHOTOURL" VARCHAR2(500), "TITLE" VARCHAR2(500), 
"PRICE" VARCHAR2(10), "SHIPPINGCOST" VARCHAR2(10), "TOTALQUANTITY" NUMBER(10), "QUANTITYAVAILABLE" VARCHAR2(10), 
"LISTINGSTART" DATE, "LISTINGEND" DATE, "FORMAT" VARCHAR2(200), "CATEGORYNUMBER" VARCHAR2(50), 
"CATEGORYNAME" VARCHAR2(100), "IMPRESSIONS" NUMBER(10), "CLICKS" NUMBER(10), "CLICKTHROUGH" VARCHAR2(100), 
"SOLDITEMS" NUMBER(10), "SELLTHROUGH" VARCHAR2(100), "IMPRESSIONSTHROUGH" VARCHAR2(100), 
"WATCHERS" VARCHAR2(50), "SALES" VARCHAR2(10), "VIEWITEM" VARCHAR2(500), "CREATETIME" DATE, 
"OPER" VARCHAR2(100), "OPERID" VARCHAR2(50), "NOTE" VARCHAR2(2000), "OPENFLAG" VARCHAR2(10), 
"SITEID" VARCHAR2(100), "SITENAME" VARCHAR2(100), "EBAYSKU" VARCHAR2(500), "SELLOPER" VARCHAR2(100), 
"WATCHERTHROUGH" VARCHAR2(10), "REFUND" NUMBER(10, 2), "REFUNDRATE" VARCHAR2(10), "GROSSPROFIT" NUMBER(10, 2), 
"FLOATS" NUMBER(2), PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 
INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING ;
---转化率历史表
CREATE TABLE "DB_SHOPMESSAGEHISTORY" ( "SEQUENCEID" NUMBER(10), "SHOPID" VARCHAR2(100), "SHOPNAME" VARCHAR2(100), 
"ITEMID" VARCHAR2(50), "IMPRESSIONS" NUMBER(10), "CLICKS" NUMBER(10), "CLICKTHROUGH" VARCHAR2(100), 
"SOLDITEMS" NUMBER(10), "SELLTHROUGH" VARCHAR2(100), "IMPRESSIONTHROUGH" VARCHAR2(100), 
"CREATETIME" DATE, "OPENFLAG" VARCHAR2(10), "OPER" VARCHAR2(50), "OPERID" VARCHAR2(10), 
"VIEWITEM" VARCHAR2(500), "SITEID" VARCHAR2(100), "SITENAME" VARCHAR2(200), "LISTINGSTART" DATE, 
"LISTINGEND" DATE, "EBAYSKU" VARCHAR2(500), "SELLOPER" VARCHAR2(100), "WATCHERTHROUGH" VARCHAR2(10), 
"REFUND" NUMBER(10, 2), "REFUNDRATE" VARCHAR2(10), "GROSSPROFIT" NUMBER(10, 2), "STATUS" VARCHAR2(2), 
"WATCHERS" VARCHAR2(10), "SALES" VARCHAR2(10), PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" 
PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

------------------------yc 2013-09-05--------------------------------
create table db_faqquestion(
	sequenceid number(8) primary key not null,
	question varchar2(500),
	answer varchar2(4000),
	oper varchar2(100),
	opertime varchar2(100)
);
------------------------fst 2013-09-10--------------------------------
CREATE TABLE "DB_NEWITEMRESULT" ( "SID" VARCHAR2(50), "PRODUCTINDEX" VARCHAR2(20), "ITEMID" VARCHAR2(20), "EBAYBUYITNEWPRICE" NUMBER(8, 2), 
"EBAYBUYITNEWPRICEMONEYTYPE" VARCHAR2(20), "EBAYCOUNTRY" VARCHAR2(50), "EBAYDESCRIPTION" VARCHAR2(4000), "EBAYHITCOUNT" NUMBER(8), "EBAYITEMID" VARCHAR2(20), 
"EBAYSTARTTIME" DATE, "EBAYENDTIME" DATE, "EBAYHASRESERVEPRICE" VARCHAR2(20), "EBAYITEMURL" VARCHAR2(200), "EBAYLISTDURATION" VARCHAR2(50), 
"EBAYLOCATION" VARCHAR2(100), "EBAYGALLERYTYPE" VARCHAR2(50), "EBAYGALLERYURL" VARCHAR2(200), "EBAYPHOTODISPLAY" VARCHAR2(50), "EBAYPICTURESOURCE" VARCHAR2(50), 
"EBAYCATEGORYID" VARCHAR2(20), "EBAYCATEGORYNAME" VARCHAR2(200), "EBAYQUANTITY" NUMBER(8), "EBAYQUANTITYSOLD" NUMBER(8), "EBAYFEEDBACKTATINGSTAR" VARCHAR2(2000),
 "EBAYFEEDBACKSCORE" NUMBER(8), "EBAYPOSITIVEFEEDBACKPERCENT" NUMBER(5, 2), "EBAYSELLERBUSINESSTYPE" VARCHAR2(200), "EBAYSTOREFRONT" VARCHAR2(20), 
 "EBAYSTOREURL" VARCHAR2(200), "EBAYSITE" VARCHAR2(50), "EBAYSTATUS" VARCHAR2(20), "EBAYUSERID" VARCHAR2(200), "EBAYUSERIDCHANGED" VARCHAR2(20), 
 "EBAYSKU" VARCHAR2(200), "EBAYSTARTPRICE" NUMBER(8, 2), "EBAYDDLEFT" NUMBER(8), "EBAYHHLEFT" NUMBER(8), "EBAYMMLEFT" NUMBER(8), "EBAYTITLE" VARCHAR2(500), 
 "FLAG" NUMBER(2), "CORPID" VARCHAR2(50), "OPER" VARCHAR2(100), "OPERTIME" DATE, "UPDATETIME" DATE, "CREATETIME" DATE, "PRICEFLAG" NUMBER(1), 
 "TITLEFLAG" NUMBER(1), "PICTRUEFLAG" NUMBER(1), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), 
 "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7" NUMBER(8), "RESERVE8" NUMBER(8, 2), "RESERVE9" NUMBER(8, 2), "RESERVE10" NUMBER(8, 2), "RESERVE11" DATE, 
 "RESERVE12" DATE, "RESERVE13" DATE, "RESERVE14" NUMBER(8), "RESERVE15" NUMBER(8), "RESERVE16" NUMBER(8, 2), "SHOWFLAG" NUMBER(2), 
 "SELLNUMBERAVGONEDAY" NUMBER(10, 3), "SELLNUMBERDAY" NUMBER(8), "SELLNUMBERWEEK" NUMBER(8), "SELLNUMBERMONTH" NUMBER(8), "SELLNUMBERTOTAL" NUMBER(8), 
 "SELLNUMBERAVG" NUMBER(8), "SELLNUMBERSITE" NUMBER(8), "DOWNCOUNT" NUMBER(8), "ENMITYID" VARCHAR2(50), "THREEDAYSNUM" NUMBER(8), 
 "EXPRESSMONEYTYPE1" VARCHAR2(50), "EXPRESSMONEYTYPE2" VARCHAR2(50), "EXPRESSMONEYTYPE3" VARCHAR2(50), "EXPRESSMONEYTYPE4" VARCHAR2(50), 
 "INTERNATIONALEXPRESS1" NUMBER(6, 2), "INTERNATIONALEXPRESS2" NUMBER(6, 2), "EXPRESS1" NUMBER(6, 2), "EXPRESS2" NUMBER(6, 2), "WEEKHITCOUNTER" NUMBER(8), 
 "MONTHHITCOUNTER" NUMBER(8), "HITCOUNTERALL" NUMBER(8), "WEEKTRANSFORMRATE" NUMBER(8, 2), "MONTHTRANSFORMRATE" NUMBER(8, 2), "TOTALTTRANSFORMRATE" NUMBER(8, 2),
 "EXPRESSFLAG1" NUMBER(2), "EXPRESSFLAG2" NUMBER(2), "EXPRESSFLAG3" NUMBER(2), "EXPRESSFLAG4" NUMBER(2), "CREATEOPER" VARCHAR2(200), 
 "CALCULATEFLAG" VARCHAR2(10), CONSTRAINT "PK_DB_NEWITEMRESULT" PRIMARY KEY ("SID") VALIDATE ) 
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 75776K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE  "DB_ITEMRESULT" ( "SID" VARCHAR2(50), "PRODUCTINDEX" VARCHAR2(20), "ITEMID" VARCHAR2(20), "EBAYBUYITNEWPRICE" NUMBER(8, 2), 
"EBAYBUYITNEWPRICEMONEYTYPE" VARCHAR2(20), "EBAYCOUNTRY" VARCHAR2(50), "EBAYDESCRIPTION" VARCHAR2(4000), "EBAYHITCOUNT" NUMBER(8), "EBAYITEMID" VARCHAR2(20), 
"EBAYSTARTTIME" DATE, "EBAYENDTIME" DATE, "EBAYHASRESERVEPRICE" VARCHAR2(20), "EBAYITEMURL" VARCHAR2(200), "EBAYLISTDURATION" VARCHAR2(50), 
"EBAYLOCATION" VARCHAR2(100), "EBAYGALLERYTYPE" VARCHAR2(50), "EBAYGALLERYURL" VARCHAR2(200), "EBAYPHOTODISPLAY" VARCHAR2(50), "EBAYPICTURESOURCE" VARCHAR2(50), 
"EBAYCATEGORYID" VARCHAR2(20), "EBAYCATEGORYNAME" VARCHAR2(200), "EBAYQUANTITY" NUMBER(8), "EBAYQUANTITYSOLD" NUMBER(8), "EBAYFEEDBACKTATINGSTAR" VARCHAR2(2000),
 "EBAYFEEDBACKSCORE" NUMBER(8), "EBAYPOSITIVEFEEDBACKPERCENT" NUMBER(5, 2), "EBAYSELLERBUSINESSTYPE" VARCHAR2(200), "EBAYSTOREFRONT" VARCHAR2(20), 
 "EBAYSTOREURL" VARCHAR2(200), "EBAYSITE" VARCHAR2(50), "EBAYSTATUS" VARCHAR2(20), "EBAYUSERID" VARCHAR2(200), "EBAYUSERIDCHANGED" VARCHAR2(20), 
 "EBAYSKU" VARCHAR2(200), "EBAYSTARTPRICE" NUMBER(8, 2), "EBAYDDLEFT" NUMBER(8), "EBAYHHLEFT" NUMBER(8), "EBAYMMLEFT" NUMBER(8), "EBAYTITLE" VARCHAR2(500), 
 "FLAG" NUMBER(2), "CORPID" VARCHAR2(50), "OPER" VARCHAR2(100), "OPERTIME" DATE, "UPDATETIME" DATE, "CREATETIME" DATE, "PRICEFLAG" NUMBER(1), 
 "TITLEFLAG" NUMBER(1), "PICTRUEFLAG" NUMBER(1), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), 
 "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7" NUMBER(8), "RESERVE8" NUMBER(8, 2), "RESERVE9" NUMBER(8, 2), "RESERVE10" NUMBER(8, 2), "RESERVE11" DATE, 
 "RESERVE12" DATE, "RESERVE13" DATE, "SHOWFLAG" NUMBER(2), "SELLNUMBERAVGONEDAY" NUMBER(10, 3), "SELLNUMBERDAY" NUMBER(8), "SELLNUMBERWEEK" NUMBER(8), 
 "SELLNUMBERMONTH" NUMBER(8), "SELLNUMBERTOTAL" NUMBER(8), "SELLNUMBERAVG" NUMBER(8), "SELLNUMBERSITE" NUMBER(8), "DOWNCOUNT" NUMBER(8), "ENMITYID" VARCHAR2(50),
 "EXPRESSMONEYTYPE2" VARCHAR2(50), "EXPRESSMONEYTYPE3" VARCHAR2(50), "EXPRESSMONEYTYPE4" VARCHAR2(50), "INTERNATIONALEXPRESS1" NUMBER(6, 2), 
 "INTERNATIONALEXPRESS2" NUMBER(6, 2), "EXPRESS1" NUMBER(6, 2), "EXPRESS2" NUMBER(6, 2), "WEEKHITCOUNTER" NUMBER(8), "MONTHHITCOUNTER" NUMBER(8), 
 "HITCOUNTERALL" NUMBER(8), "WEEKTRANSFORMRATE" NUMBER(8, 2), "MONTHTRANSFORMRATE" NUMBER(8, 2), "TOTALTTRANSFORMRATE" NUMBER(8, 2), "EXPRESSFLAG1" NUMBER(2), 
 "EXPRESSFLAG2" NUMBER(2), "EXPRESSFLAG3" NUMBER(2), "EXPRESSFLAG4" NUMBER(2), "THREEDAYSNUM" NUMBER(8), "EXPRESSMONEYTYPE1" VARCHAR2(50), "RESERVE14" NUMBER(8),
 "RESERVE16" NUMBER(8, 2), "RESERVE15" NUMBER(8), "CREATEOPER" VARCHAR2(200), "CALCULATEFLAG" VARCHAR2(10), CONSTRAINT "PK_DB_ITEMRESULT" 
 PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1316864K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;


CREATE TABLE "DB_SHIPTOLOCATION" ( "SID" VARCHAR2(200), "EBAYITEMID" VARCHAR2(20), "EBAYSHIPTO" VARCHAR2(200), "FLAG" VARCHAR2(10), CONSTRAINT 
"PK_DB_SHIPTOLOCATION" PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 7168K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

----------------fst   db_taskitemid  
爬虫  CREATE TABLE "DB_TASKITEMID" ( "SID" VARCHAR2(50), "SKU" VARCHAR2(50), "ITEMID" VARCHAR2(20), "FLAG" NUMBER(2), "OPENFLAG" NUMBER(2), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CREATETIME" DATE, "CORPID" VARCHAR2(10), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), 
"RESERVE4" VARCHAR2(500), "RESERVE5" NUMBER(8, 2), "RESERVE6" NUMBER(8, 2), "RESERVE7" NUMBER(8, 2), "RESERVE8" NUMBER(6), "RESERVE9" NUMBER(6), 
"RESERVE10" NUMBER(6), "DOWNLOADDAYS" NUMBER(8), "DOWNLOADFLAG" NUMBER(8), "ENMITYID" VARCHAR2(50), 
CONSTRAINT "PK_DB_TASKITEMID" PRIMARY KEY ("SID") VALIDATE ) ;

-----------------yc 2013-09-17--------商品售后服务-----
create table db_sell_result(
	sequenceid varchar2(10) primary key not null,  --主键
	orderid varchar2(100),       --db_order 表的orderid
	refundtype varchar2(100),         --退款类型
	refundnum varchar2(100),         --退款次数
	refundmoney varchar2(100),          --退款金额
	refundtime varchar2(20),         --退款日期
	oper1 varchar2(100),         --操作客服
	oper2 varchar2(100),           --操作客服
	retrytype varchar2(100),         --重发类型
	retrynum varchar2(100),          --重发产品个数
	retrytradeid varchar2(100),         --重发产品物流追踪号
	retrytime varchar2(20),         --重发日期
	retrycause varchar2(100),           --原因
	oper3 varchar2(100)           --操作客服
);

CREATE TABLE "DB_ITEMRESULT" ( "SID" VARCHAR2(50), "PRODUCTINDEX" VARCHAR2(20), "ITEMID" VARCHAR2(20), "EBAYBUYITNEWPRICE" NUMBER(8, 2), 
"EBAYBUYITNEWPRICEMONEYTYPE" VARCHAR2(20), "EBAYCOUNTRY" VARCHAR2(50), "EBAYDESCRIPTION" VARCHAR2(4000), "EBAYHITCOUNT" NUMBER(8), "EBAYITEMID" VARCHAR2(20), 
"EBAYSTARTTIME" DATE, "EBAYENDTIME" DATE, "EBAYHASRESERVEPRICE" VARCHAR2(20), "EBAYITEMURL" VARCHAR2(200), "EBAYLISTDURATION" VARCHAR2(50), 
"EBAYLOCATION" VARCHAR2(100), "EBAYGALLERYTYPE" VARCHAR2(50), "EBAYGALLERYURL" VARCHAR2(200), "EBAYPHOTODISPLAY" VARCHAR2(50), "EBAYPICTURESOURCE" VARCHAR2(50), 
"EBAYCATEGORYID" VARCHAR2(20), "EBAYCATEGORYNAME" VARCHAR2(200), "EBAYQUANTITY" NUMBER(8), "EBAYQUANTITYSOLD" NUMBER(8), "EBAYFEEDBACKTATINGSTAR" VARCHAR2(2000),
 "EBAYFEEDBACKSCORE" NUMBER(8), "EBAYPOSITIVEFEEDBACKPERCENT" NUMBER(5, 2), "EBAYSELLERBUSINESSTYPE" VARCHAR2(200), "EBAYSTOREFRONT" VARCHAR2(20), 
 "EBAYSTOREURL" VARCHAR2(200), "EBAYSITE" VARCHAR2(50), "EBAYSTATUS" VARCHAR2(20), "EBAYUSERID" VARCHAR2(200), "EBAYUSERIDCHANGED" VARCHAR2(20), 
 "EBAYSKU" VARCHAR2(200), "EBAYSTARTPRICE" NUMBER(8, 2), "EBAYDDLEFT" NUMBER(8), "EBAYHHLEFT" NUMBER(8), "EBAYMMLEFT" NUMBER(8), "EBAYTITLE" VARCHAR2(500), 
 "FLAG" NUMBER(2), "CORPID" VARCHAR2(50), "OPER" VARCHAR2(100), "OPERTIME" DATE, "UPDATETIME" DATE, "CREATETIME" DATE, "PRICEFLAG" NUMBER(1), 
 "TITLEFLAG" NUMBER(1), "PICTRUEFLAG" NUMBER(1), "RESERVE1" VARCHAR2(500), "RESERVE2" VARCHAR2(500), "RESERVE3" VARCHAR2(500), "RESERVE4" VARCHAR2(500), 
 "RESERVE5" NUMBER(8), "RESERVE6" NUMBER(8), "RESERVE7" NUMBER(8), "RESERVE8" NUMBER(8, 2), "RESERVE9" NUMBER(8, 2), "RESERVE10" NUMBER(8, 2), "RESERVE11" DATE, 
 "RESERVE12" DATE, "RESERVE13" DATE, "SHOWFLAG" NUMBER(2), "SELLNUMBERAVGONEDAY" NUMBER(10, 3), "SELLNUMBERDAY" NUMBER(8), "SELLNUMBERWEEK" NUMBER(8), 
 "SELLNUMBERMONTH" NUMBER(8), "SELLNUMBERTOTAL" NUMBER(8), "SELLNUMBERAVG" NUMBER(8), "SELLNUMBERSITE" NUMBER(8), "DOWNCOUNT" NUMBER(8), "ENMITYID" VARCHAR2(50),
 "EXPRESSMONEYTYPE2" VARCHAR2(50), "EXPRESSMONEYTYPE3" VARCHAR2(50), "EXPRESSMONEYTYPE4" VARCHAR2(50), "INTERNATIONALEXPRESS1" NUMBER(6, 2), 
 "INTERNATIONALEXPRESS2" NUMBER(6, 2), "EXPRESS1" NUMBER(6, 2), "EXPRESS2" NUMBER(6, 2), "WEEKHITCOUNTER" NUMBER(8), "MONTHHITCOUNTER" NUMBER(8), 
 "HITCOUNTERALL" NUMBER(8), "WEEKTRANSFORMRATE" NUMBER(8, 2), "MONTHTRANSFORMRATE" NUMBER(8, 2), "TOTALTTRANSFORMRATE" NUMBER(8, 2), "EXPRESSFLAG1" NUMBER(2), 
 "EXPRESSFLAG2" NUMBER(2), "EXPRESSFLAG3" NUMBER(2), "EXPRESSFLAG4" NUMBER(2), "THREEDAYSNUM" NUMBER(8), "EXPRESSMONEYTYPE1" VARCHAR2(50), "RESERVE14" NUMBER(8),
 "RESERVE16" NUMBER(8, 2), "RESERVE15" NUMBER(8), "CREATEOPER" VARCHAR2(200), "CALCULATEFLAG" VARCHAR2(10), CONSTRAINT "PK_DB_ITEMRESULT" 
 PRIMARY KEY ("SID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1316864K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_PRODUCT_HISTORY2" ( "SEQUENCEID" VARCHAR2(50), "PRODUCTID" VARCHAR2(50), "PUROPER" VARCHAR2(50), "SELLOPER" VARCHAR2(50), 
"DAILYMEANSALES" NUMBER(9, 4), "ALLSAVENUM" NUMBER(9), "ALLSAVENUMDAY" NUMBER(9, 4), "SAVENUM" NUMBER(9), "SAVENUMDAY" NUMBER(9, 4), "PURCHASENUM" NUMBER(9), 
"PURCHASENUMDAY" NUMBER(9, 4), "ALLOTNUM" NUMBER(9), "ALLOTNUMDAY" NUMBER(9, 4), "PRODUCTIONNUM" NUMBER(9), "PRODUCTIONNUMDAY" NUMBER(9, 4), 
"MONTHSAVENUM" NUMBER(9), "NEEDORDER" NUMBER(9), "SAVENUMCIF" NUMBER(10, 4), "SAVENUMCBM" NUMBER(10, 4), "FIXPRICE" NUMBER(9, 4), "PROFITPERCENT" NUMBER(9, 4), 
"PURPRICE" NUMBER(9, 4), "SELLPRICE" NUMBER(9, 4), "CATEGORYID" VARCHAR2(50), "CATEGORY" VARCHAR2(200), "MANUFACTUREID" VARCHAR2(50), 
"MANUFACTURE" VARCHAR2(200), "STATUS" VARCHAR2(50), "COSTPRICE" NUMBER(10, 4), "OUTERLEVEL" VARCHAR2(50), "NDAYSALES" NUMBER(10, 4), 
"SIXDAYSALES" NUMBER(10, 4), "OLDORDERNUM" NUMBER(10), "MONTHBIDNUM" NUMBER(10), "TODAYORDERNUM" NUMBER(10), "HISTORYSAVENUM" NUMBER(10), 
"HISTORYCIFPRICE" NUMBER(20, 4), "HISTORYPROFITAMOUNT" NUMBER(20, 4), "CLASSPROFIT" NUMBER(12, 4), "PRODUCTCONTRIBUTIONS" NUMBER(12, 4), 
"MONTHLYPROFITABC" VARCHAR2(5), "FPROFITABC" VARCHAR2(5), "TURNOVERDAY" NUMBER(12, 4), "MONTHPROFITS" NUMBER(12, 4), "REFUNDRATE" NUMBER(12, 4), 
"MONTHCLASSPROFIT" NUMBER(12, 4), "CHANGEAMOUNT" NUMBER(12, 4), "LITERRATIO" NUMBER(12, 4), "CLASSCONTRIBUTIONRATIO" NUMBER(12, 4), 
"MONTHREFUNDRATE" NUMBER(12, 4), "HISTORYAVGPROFITRATIO" NUMBER(12, 4), "HISTORYAVGPROFIT" NUMBER(12, 4), "HISTORYNETPROFITAMOUNT" NUMBER(12, 4), 
"VOLUMEWEIGHT" NUMBER(12, 4), "GST" NUMBER(12, 4), "TARIFF" NUMBER(12, 4), "OCEANSHIPPING" NUMBER(12, 4), CONSTRAINT "DB_PRODUCT_HISTORY2" 
PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_PRODUCTANDSELL" ( "SEQUENCEID" VARCHAR2(50), "SKU" VARCHAR2(50), "FLAG" VARCHAR2(10), CONSTRAINT "PK_DB_PRODUCTANDSELL" 
PRIMARY KEY ("SEQUENCEID", "SKU") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 320K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

--------------------hj--------2013-09-24------------

CREATE TABLE "DB_TWODEVELOPMENTPRODUCT" ( 
"SID" VARCHAR2(100), 
"NAME" VARCHAR2(200) NOT NULL , 
"CONTENT" VARCHAR2(4000), 
"DESCR" VARCHAR2(4000), 
"CATEGORYID" VARCHAR2(100), 
"PROJECTID" VARCHAR2(100), 
"STATUS" VARCHAR2(100),
"STOCKPRICE" NUMBER(8, 2), 
"COSTPRICE" NUMBER(8, 2), 
"SELLPRICE" NUMBER(8, 2), 
"OTHERPRICE1" NUMBER(8, 2), 
"OTHERPRICE2" NUMBER(8, 2), 
"WEIGHT" VARCHAR2(100), 
"SIZES" VARCHAR2(100), 
"COLOR" VARCHAR2(100), 
"PICTURE1" VARCHAR2(200), 
"PICTURE2" VARCHAR2(200), 
"PICTURE3" VARCHAR2(200), 
"PICTURE4" VARCHAR2(200), 
"ORDERNUM" NUMBER(8), 
"ALIAS1" VARCHAR2(4000), 
"ALIAS2" VARCHAR2(200), 
"ALIAS3" VARCHAR2(200), 
"OPER" VARCHAR2(100), 
"OPERTIME" DATE, 
"RESERVE1" VARCHAR2(200), 
"RESERVE2" VARCHAR2(200), 
"RESERVE3" VARCHAR2(200), 
"RESERVE4" VARCHAR2(200), 
"RESERVE5" VARCHAR2(200), 
"RESERVE6" VARCHAR2(200), 
"RESERVE7" NUMBER(8, 2), 
"RESERVE8" NUMBER(8, 2), 
"CORPID" VARCHAR2(100), 
"DEVELOPMENTTIME" DATE, 
"PURCHASEFLAG" NUMBER(10),
CONSTRAINT "PK_DB_TWODEVELOPMENTPRODUCT" PRIMARY KEY ("SID") VALIDATE 
) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

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;


CREATE TABLE "DB_TWODEVELOPMENTLIST" ( 
"SID" VARCHAR2(50), "BINDID" VARCHAR2(200), "ALIAS1" VARCHAR2(4000), "NUM" NUMBER(10), "OPERTIME" DATE, "CORPID" VARCHAR2(100), "RESERVE1" VARCHAR2(100), 
"RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "RESERVE4" NUMBER(11, 4), "RESERVE5" NUMBER(11, 4), CONSTRAINT "DB_TWODEVELOPMENTLIST" 
PRIMARY KEY ("SID") VALIDATE) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;



--------fst--范松涛 15:03:39 ---2013-09-27-----
CREATE TABLE "DB_WORKREPORT" ( "SEQUENCEID" NUMBER(10), "TITLE" VARCHAR2(500), "WORKATTRIBUTEID" NUMBER(10), "WORKMOULDID" NUMBER(10), 
"WORKMOULD" VARCHAR2(4000), "CREATEOPER" VARCHAR2(100), "CREATETIME" DATE, "WORK1" VARCHAR2(4000), "WORK2" VARCHAR2(4000), "WORK3" VARCHAR2(4000), 
"WORK4" VARCHAR2(4000), "WORK5" VARCHAR2(4000), "WORK6" VARCHAR2(4000), "OPERTIME" DATE, "WARMOPER" VARCHAR2(4000), "FLAG" NUMBER(8), "CORPID" VARCHAR2(10), 
"OPENFLAG" NUMBER(8), "OPER" VARCHAR2(100), "CONTENT" VARCHAR2(4000), "STATUS" NUMBER(10), "PROTOCOLTIME1" VARCHAR2(50), "PROTOCOLTIME2" VARCHAR2(50), 
"UPDATEFLAG" VARCHAR2(2000), "ALERTFLAG" NUMBER(4), "FILEURL" VARCHAR2(200), CONSTRAINT "PK_DB_WORKREPORT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 2048K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

CREATE TABLE "DB_WORKREPORTLOG" ( "SEQUENCEID" VARCHAR2(50), "TITLE" VARCHAR2(500), "WORKATTRIBUTEID" NUMBER(10), "WORKMOULDID" NUMBER(10), 
"WORKMOULD" VARCHAR2(4000), "CREATEOPER" VARCHAR2(100), "CREATETIME" DATE, "WORK1" VARCHAR2(4000), "WORK2" VARCHAR2(4000), "WORK3" VARCHAR2(4000), 
"WORK4" VARCHAR2(4000), "WORK5" VARCHAR2(4000), "WORK6" VARCHAR2(4000), "OPERTIME" DATE, "WARMOPER" VARCHAR2(4000), "FLAG" NUMBER(8), "CORPID" VARCHAR2(10), 
"OPENFLAG" NUMBER(8), "OPER" VARCHAR2(100), "CONTENT" VARCHAR2(4000), "STATUS" NUMBER(10), "PROTOCOLTIME1" VARCHAR2(50), "PROTOCOLTIME2" VARCHAR2(50), 
"UPDATEFLAG" VARCHAR2(2000), "SID" NUMBER(10), CONSTRAINT "PK_DB_WORKREPORTLOG" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 2048K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;

--LYT专用
create table db_back_money
(
	sequenceid number(8) primary key not null,  --主键
	supplierid varchar2(100),          --供应商id
	suppliername varchar2(100),         --供应商姓名
	backmoney number(8,2),                   --返回金钱
	oper varchar2(20),                 --员工工号
	opertime date,                        --员工操作时间
	productid varchar2(100)                --商品SKU
);
CREATE TABLE "DB_CUSTOMERTYPE" ( "SID" NUMBER(6), "NAME" VARCHAR2(50), "DESCR" VARCHAR2(200), "OPER" VARCHAR2(50), "OPERTIME" DATE, "OPENFLAG" VARCHAR2(10), 
"RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), CONSTRAINT "PK_CUSTOMERTYPE_SID" PRIMARY KEY ("SID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_REPEATPRODUCT" ( "SEQUENCEID" NUMBER(10), "TITLE" VARCHAR2(2000), "SALSEMONEY" VARCHAR2(50), "PUBLISNUM" VARCHAR2(50), 
"CHANGERATE" VARCHAR2(50), "PRICEAVG" VARCHAR2(50), "OFFER" VARCHAR2(50), "TOPSALSENUM" NUMBER(10), "TOPSALSEMONEY" NUMBER(10), "OPENFLAG" NUMBER(10), 
"OPER" VARCHAR2(50), "OPERTIME" DATE, "CORPID" NUMBER(10), CONSTRAINT "PK_DB_REPEATPRODUCT" PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_ENMITY" ( "SEQUENCEID" NUMBER(6), "SHOPNAME" VARCHAR2(100), "DESCR" VARCHAR2(2000), "OPER" VARCHAR2(100), "OPERTIME" DATE, "OPENFLAG" NUMBER(2),
 "STATUS" NUMBER(2), "CORPID" NUMBER(2), "EBAYITEMID" VARCHAR2(100), "USERNAME" VARCHAR2(100), CONSTRAINT "PK_DB_DB_ENMITY" 
 PRIMARY KEY ("SEQUENCEID") VALIDATE ) TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_CKYSKUCONFIG" ( "PRODUCTID" VARCHAR2(50), "CKYPRODUCTID" VARCHAR2(200), "OPENFLAG" NUMBER(10), "OPER" VARCHAR2(50), "OPERTIME" DATE, 
"CREATEOPER" VARCHAR2(50), "CREATETIME" DATE, "PRODUCTNAME" VARCHAR2(500), "CKYPRODUCTNAME" VARCHAR2(500), "CKYSTATUS" VARCHAR2(100), "CATEGORYID" VARCHAR2(100),
 "PRICE1" NUMBER(10, 4), "PRICE2" NUMBER(10, 4), "CKYSAVENUM" NUMBER(10), "CKYORDERNUM" NUMBER(10), "STATUS" VARCHAR2(100), "LENGTH" NUMBER(8, 2), 
 "WIDTH" NUMBER(8, 2), "HIGH" NUMBER(8, 2), "RESERVE1" VARCHAR2(100), "RESERVE2" VARCHAR2(100), "RESERVE3" VARCHAR2(100), "RESERVE4" NUMBER(10, 4), 
 "RESERVE5" NUMBER(10, 4), "RESERVE6" NUMBER(10), "RESERVE7" NUMBER(10), CONSTRAINT "DB_CKYSKUCONFIG" PRIMARY KEY ("PRODUCTID") VALIDATE ) 
 TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_OUTBOUND" ( "SEQUENCEID" NUMBER(10), "PRODUCTID" VARCHAR2(100), "PRODUCTNAME" VARCHAR2(100), "SAVENUMBER" NUMBER(10), "ORDERNUM" NUMBER(10), 
"OPER" VARCHAR2(100), "OPERTIME" VARCHAR2(20), PRIMARY KEY ("SEQUENCEID") VALIDATE ) 
TABLESPACE "ZHRGPT" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;

CREATE TABLE "DB_CKYEXPRESSTYPE" ("SID" VARCHAR2(20 byte)
    NOT NULL, "NAME" VARCHAR2(100 byte), "COUNTRY" VARCHAR2(10 
    byte), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE, "FLAG" 
    NUMBER(10), "OPENFLAG" NUMBER(10), "SORT" NUMBER(4), 
    "RESERVE1" VARCHAR2(200 byte), "RESERVE2" VARCHAR2(200 byte),
    CONSTRAINT "PK_CKYEXPRESSTYPE_SID" PRIMARY KEY("SID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

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), "ANTISTOP1" VARCHAR2(500 byte), "ANTISTOP2" 
    VARCHAR2(500 byte), "ANTISTOP3" VARCHAR2(500 byte), 
    "ANTISTOP4" VARCHAR2(500 byte), "ANTISTOP5" VARCHAR2(500 
    byte), "NAME" VARCHAR2(200 byte), "REMARK" VARCHAR2(4000 
    byte), "TOTALSALES" VARCHAR2(50 byte), "TOTALLISTINGS" 
    VARCHAR2(50 byte), "SUCESSFULLISTING" VARCHAR2(50 byte), 
    "BIDS" VARCHAR2(50 byte), "ITEMSSOLD" VARCHAR2(200 byte), 
    "AVERAGEPRICE" VARCHAR2(50 byte), "SELLTHROUGH" VARCHAR2(200 
    byte), "RANK" VARCHAR2(50 byte), "SORT" NUMBER(5), 
    CONSTRAINT "PK_DB_OPENFLAG" PRIMARY KEY("SEQUENCEID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_ANTISTOPRELE" ("SEQUENCEID" VARCHAR2(50 
    byte) NOT NULL, "ANTISTOP1" VARCHAR2(500 byte), "ANTISTOP2" 
    VARCHAR2(500 byte), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE,
    "CORPID" VARCHAR2(10 byte), "OPENFLAG" VARCHAR2(10 byte), 
    CONSTRAINT "PK_DB_ANTISTOPRELE" PRIMARY KEY("SEQUENCEID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;	

CREATE TABLE "DB_ANTISTOPSHOP" ("SEQUENCEID" NUMBER(10) 
    NOT NULL, "SITE" VARCHAR2(20 byte), "SORT" NUMBER(10), 
    "SELLSHOP" VARCHAR2(50 byte), "SELLMONEY" NUMBER(10, 4), 
    "PUBLISHNUM" NUMBER(10), "DEALNUM" NUMBER(10), "SELLPRICE" 
    NUMBER(10, 4), "PRODUCT" NUMBER(10), "AVGPRICE" NUMBER(10, 4),
    "SUBRATE" VARCHAR2(50 byte), "CORPID" NUMBER(10), "OPENFLAG" 
    NUMBER(10), "OPER" VARCHAR2(50 byte), "OPERTIME" DATE, 
    "ANTISTOPID" NUMBER(10), "RESULTFLAG" NUMBER(5), "SHOPFLAG" 
    NUMBER(5), 
    CONSTRAINT "SYS_C009619" PRIMARY KEY("SEQUENCEID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;
	
CREATE TABLE "DB_AUTOADDSALENUM" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "STARTSALENUM" NUMBER(8, 3), 
    "ENDSALENUM" NUMBER(8, 3), "ALERTNUM" NUMBER(4), 
    "PURCHASENUM" NUMBER(4), "OPER" VARCHAR2(100 byte), 
    "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 byte), "RESERVE2" 
    VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100 byte), "RESERVE4"
    NUMBER, "RESERVE5" NUMBER, "RESERVE6" NUMBER(8, 3), 
    CONSTRAINT "PK_DB_AUTOADDSALENUM" PRIMARY KEY("SEQUENCEID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;

CREATE TABLE "DB_AUTOADDSALENUMLOG" ("SEQUENCEID" 
    VARCHAR2(50 byte) NOT NULL, "SID" VARCHAR2(100 byte), 
    "STARTSALENUM" NUMBER(8, 3), "ENDSALENUM" NUMBER(8, 3), 
    "ALERTNUM" NUMBER(4), "PURCHASENUM" NUMBER(4), "OPER" 
    VARCHAR2(100 byte), "OPERTIME" DATE, "RESERVE1" VARCHAR2(100 
    byte), "RESERVE2" VARCHAR2(100 byte), "RESERVE3" VARCHAR2(100
    byte), "RESERVE4" NUMBER, "RESERVE5" NUMBER, "RESERVE6" 
    NUMBER(8, 3), "CORPID" VARCHAR2(50 byte), "OPENFLAG" 
    VARCHAR2(10 byte), "OPERTYPE" VARCHAR2(50 byte), "CONTENT" 
    VARCHAR2(2000 byte), 
    CONSTRAINT "PK_DB_AUTOADDSALENUMLOG" PRIMARY 
    KEY("SEQUENCEID") 
    )
     
    pctfree 10
    initrans 1
    maxtrans 255
    storage(
       initial 64K
       minextents 1
       maxextents unlimited
    )
    tablespace ZHRGPT
    logging
    noparallel;
	
