techinfo.books_item.sql

jdbc oracle jdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oraclejdbc oracle

drop table BOOKS_ITEM;
CREATE TABLE "TECHINFO"."BOOKS_ITEM" ("BOOK_ID" NUMBER(10) NOT 
    NULL, "BOOK_TITLE" VARCHAR2(100 byte) NOT NULL, 
    "BOOK_DESCRIPTION" VARCHAR2(4000 byte), "AUTHOR" VARCHAR2(100
    byte), "PUBLISHER" VARCHAR2(100 byte), "PUB_VERSION" 
    VARCHAR2(50 byte), "REF_TYPE" VARCHAR2(1 byte), "ATTACH_FILE"
    VARCHAR2(300 byte), "RENT_DAYS" NUMBER(10), "TOTAL_ITEMS" 
    NUMBER(10), "LEFT_ITEMS" NUMBER(10), "CREATE_DATE" DATE, 
    "DELETED" VARCHAR2(1 byte), "RENT_TIMES" NUMBER(10), 
    "BOOK_COVER" VARCHAR2(300 byte), "SORT_ID" NUMBER(10), 
    "BOOK_TITLE_EN" VARCHAR2(100 byte), "PUB_YEAR" NUMBER(4), 
    "KEYWORDS" VARCHAR2(100 byte), "ADDRESS_DEGREE" VARCHAR2(100 
    byte), "VOLUMN" VARCHAR2(10 byte), "ORIGIN_FILE_NAME" 
    VARCHAR2(200 byte), "PAGE_COUNT" NUMBER(10), 
    CONSTRAINT "PK_BOOK_ID" PRIMARY KEY("BOOK_ID"))  
    TABLESPACE "TECHINFO" PCTFREE 10 PCTUSED 0 INITRANS 1 
    MAXTRANS 255 
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0) 
    LOGGING 
;