techinfo.lib_inspect_report.sql

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

drop table LIB_INSPECT_REPORT;
CREATE TABLE "TECHINFO"."LIB_INSPECT_REPORT" ("SORT_CODE" 
    VARCHAR2(10 byte), "IDX_CODE" VARCHAR2(20 byte), "FILE_NAME" 
    VARCHAR2(50 byte), "REPORT_CODE" VARCHAR2(50 byte), "TITLE" 
    VARCHAR2(255 byte), "REPORTER" VARCHAR2(255 byte), 
    "JOIN_UNIT" VARCHAR2(255 byte), "AREA" VARCHAR2(255 byte), 
    "MAIN_MEMBER" VARCHAR2(255 byte), "REPORT_DATE" DATE, 
    "VISIT_DATE" DATE, "BACK_DATE" DATE, "PROF_AREA" VARCHAR2(50 
    byte), "KEYWORDS" VARCHAR2(255 byte), "INTRODUCE" CLOB, 
    "PAGE_COUNT" NUMBER(5), "MEMO" VARCHAR2(50 byte), "REGISTER" 
    VARCHAR2(50 byte), "UPDATE_DATE" DATE, "OPENED" NUMBER(2) NOT
    NULL, "GOOD" 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") STORE AS ( TABLESPACE "TECHINFO"  
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    ENABLE 
    STORAGE IN ROW 
    NOCACHE CHUNK 8192 PCTVERSION 10) 
;