techinfo.lib_cgk.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table LIB_CGK;
CREATE TABLE "TECHINFO"."LIB_CGK" ("SORT_CODE" VARCHAR2(12 byte),
    "PROF_CODE" VARCHAR2(30 byte), "RESULT_CODE" VARCHAR2(20 
    byte), "REPORT_CODE" VARCHAR2(40 byte), "TITLE_CN" 
    VARCHAR2(250 byte), "RESULT_TYPE" VARCHAR2(20 byte), 
    "START_DATE" DATE, "END_DATE" DATE, "SUBJECT_CODE" 
    VARCHAR2(60 byte), "GT_SORT" VARCHAR2(50 byte), "KEYWORD_CN" 
    VARCHAR2(255 byte), "INTRODUCE_CN" CLOB, "SOURCE" 
    VARCHAR2(100 byte), "EVAL_WAY" VARCHAR2(100 byte), 
    "EVAL_UNIT" VARCHAR2(100 byte), "EVAL_DATE" DATE, 
    "EVAL_COMMENTS" CLOB, "AWARD_NAME" VARCHAR2(200 byte), 
    "AWARD_UNIT" VARCHAR2(200 byte), "AWARD_YEAR" VARCHAR2(50 
    byte), "AWARD_LEVEL" VARCHAR2(50 byte), "RIGHT_TYPE" 
    VARCHAR2(20 byte), "RIGHT_NAME" VARCHAR2(250 byte), 
    "RIGHT_CODE" VARCHAR2(250 byte), "FIRST_UNIT" VARCHAR2(50 
    byte), "UNIT_PROPERTY" VARCHAR2(50 byte), "OWNERSHIP" 
    VARCHAR2(50 byte), "ADDRESS" VARCHAR2(70 byte), "ZIPCODE" 
    VARCHAR2(50 byte), "TEL" VARCHAR2(80 byte), "FAX" VARCHAR2(80
    byte), "CONTACTOR" VARCHAR2(30 byte), "EMAIL" VARCHAR2(50 
    byte), "OTHER_UNIT" VARCHAR2(255 byte), "FIRST_PERSON" 
    VARCHAR2(50 byte), "FP_GENTLE" VARCHAR2(50 byte), 
    "FP_POSITION" VARCHAR2(50 byte), "FP_UNIT" VARCHAR2(200 byte),
    "FP_TEL" VARCHAR2(250 byte), "OTHER_PERSON" CLOB, 
    "RECOMMEND_COMMENTS" CLOB, "UPDATE_DATE" DATE, "SHARED" 
    NUMBER(2) NOT NULL,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_CN") STORE AS ( TABLESPACE "TECHINFO" 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) LOB("EVAL_COMMENTS") STORE 
    AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) LOB("OTHER_PERSON") STORE 
    AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) LOB("RECOMMEND_COMMENTS") 
    STORE AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;