techinfo.lib_law_policy.sql

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

drop table LIB_LAW_POLICY;
CREATE TABLE "TECHINFO"."LIB_LAW_POLICY" ("UPDATE_DATE" DATE, 
    "UPDATE_FIELD" VARCHAR2(10 byte), "SORT_CODE" VARCHAR2(20 
    byte), "IDX_CODE" VARCHAR2(30 byte), "FILE_NAME" VARCHAR2(50 
    byte), "POLICY_CODE" VARCHAR2(255 byte), "TITLE" VARCHAR2(255
    byte), "PUBLISHER" VARCHAR2(255 byte), "PUB_DATE" DATE, 
    "IMPL_DATE" DATE, "DROPED" VARCHAR2(100 byte), "DROP_DATE" 
    DATE, "PAGE_SIZE" VARCHAR2(4 byte), "PAGE_COUNT" NUMBER(5), 
    "MEMO" CLOB, "PROF_SORT" VARCHAR2(20 byte), "FULL_CHECK" 
    NUMBER(2) NOT NULL, "OPENED" NUMBER(2) NOT NULL, "REGISTER" 
    VARCHAR2(4 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("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) 
;