techinfo.lib_nation_std.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table LIB_NATION_STD;
CREATE TABLE "TECHINFO"."LIB_NATION_STD" ("UPDATE_DATE" DATE, 
    "UPDATE_FIELD" VARCHAR2(5 byte), "SORT_CODE" VARCHAR2(50 
    byte), "STD_CODE" VARCHAR2(50 byte), "FILE_NAME" VARCHAR2(50 
    byte), "ICS_SORT" VARCHAR2(30 byte), "GB_SORT" VARCHAR2(15 
    byte), "VERSION_TYPE" VARCHAR2(10 byte), "TITLE_CN" 
    VARCHAR2(255 byte), "TITLE_EN" CLOB, "PUB_DATE" DATE, 
    "IMPL_DATE" DATE, "ACCEPT_RELATION" VARCHAR2(150 byte), 
    "INSTEAD_STD" VARCHAR2(255 byte), "INSTEADED_STD" 
    VARCHAR2(255 byte), "PAGE_COUNT" NUMBER(5), "DROPED" 
    NUMBER(2) NOT NULL, "DROP_YEAR" VARCHAR2(10 byte), 
    "KEYWORD_CN" VARCHAR2(255 byte), "KEYWORD_EN" VARCHAR2(255 
    byte), "WRITER" VARCHAR2(100 byte), "PUBLISHER" VARCHAR2(100 
    byte), "OWNER" VARCHAR2(100 byte), "MEMO" CLOB, "PUB_YEAR" 
    VARCHAR2(50 byte), 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("TITLE_EN") 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("MEMO") STORE AS ( 
    TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;