techinfo.lib_self_files.sql

来自「jdbc oracle jdbc oraclejdbc oraclejdbc o」· SQL 代码 · 共 21 行

drop table LIB_SELF_FILES;
CREATE TABLE "TECHINFO"."LIB_SELF_FILES" ("SORT_CODE" VARCHAR2(10
    byte), "IDX_CODE" VARCHAR2(30 byte), "GCH" VARCHAR2(30 byte),
    "TITLE_CN" VARCHAR2(100 byte), "PUBLISHER" VARCHAR2(50 byte),
    "SECURITY_LEVEL" VARCHAR2(4 byte), "DOCUMENT_TYPE" VARCHAR2(4
    byte), "RESPONSER" VARCHAR2(50 byte), "RESP_UNIT" VARCHAR2(50
    byte), "PUB_DATE" DATE, "CARRIER_FORM" VARCHAR2(20 byte), 
    "GT_SORT" VARCHAR2(30 byte), "KEYWORD_CN" VARCHAR2(255 byte),
    "INTRODUCE_CN" CLOB, "MEMO" VARCHAR2(255 byte), "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_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) 
;