techinfo.lib_china_cgk.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table LIB_CHINA_CGK;
CREATE TABLE "TECHINFO"."LIB_CHINA_CGK" ("SORT_CODE" VARCHAR2(100
    byte), "RESULT_CODE" VARCHAR2(20 byte), "TITLE" VARCHAR2(150 
    byte), "FINISHER_UNIT" VARCHAR2(255 byte), "FINISHER" 
    VARCHAR2(100 byte), "ADDRESS" VARCHAR2(255 byte), "ZIPCODE" 
    VARCHAR2(6 byte), "TEL" VARCHAR2(255 byte), "INTRODUCE" CLOB,
    "KEYWORD_CN" VARCHAR2(100 byte), "RESEARCH_TIME_SCOPE" 
    VARCHAR2(50 byte), "GT_SORT" VARCHAR2(35 byte), "RESULT_TYPE"
    VARCHAR2(15 byte), "RESULT_LEVEL" VARCHAR2(10 byte), 
    "EVAL_UNIT" VARCHAR2(50 byte), "EVAL_DATE" VARCHAR2(20 byte),
    "AWARDED" VARCHAR2(150 byte), "PUB_UNIT" VARCHAR2(100 byte), 
    "SOURCE" VARCHAR2(60 byte), "PUB_YEAR" VARCHAR2(10 byte), 
    "SOURCE_CODE" VARCHAR2(10 byte), "FIELD_CODE" VARCHAR2(7 
    byte), "FIELD_NAME" VARCHAR2(50 byte), "PROF_RIGHT" 
    VARCHAR2(100 byte), "OPENED" NUMBER(2) NOT NULL, 
    "UPDATE_DATE" DATE,id NUMBER   PRIMARY   KEY)  
    TABLESPACE "TECHINFO" PCTFREE 10 PCTUSED 0 INITRANS 1 
    MAXTRANS 255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING LOB("INTRODUCE") STORE AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;