Library 3
Tables (10)
Authority (Untitled7)
- ID (Key22) — Foreign key → User.ID — NOT NULL
- USER_ID (Field) — VARCHAR(50)
- AUTHORITY_NAME (Field2) — VARCHAR(50)
BOOK (Untitled)
- ID (Key) — Primary key — NOT NULL
- NAME (Field) — VARCHAR(50)
- CATEGORY (Field2)
- PAGE (Field3) — INTEGER
- PUBLISHER (Field4) — VARCHAR()
- PUBLISH_DATE (Field5) — DATE
- COMMENTS (Field6)
BOOK_IMAGE (Untitled8)
- ID (Key) — Foreign key → BOOK.ID — NOT NULL
- ID (Key2) — LONG — Foreign key → Image.ID — NOT NULL
Bookmark (Untitled4)
- ID (Key) — Primary key — NOT NULL
- BOOK_ID (Key2) — Foreign key → BOOK.ID — NOT NULL
- USER_ID (Key22) — Foreign key → User.ID — NOT NULL
- PLAYTIME (Field)
- PAGE (Field2)
- LINE (Field3)
Comment (Untitled2)
- ID (Key) — LONG — Primary key — NOT NULL
- BOOK_ID (Key2) — LONG — Foreign key → BOOK.ID — NOT NULL
- CONTENT (Field)
FILES (Untitled3)
- ID (Key) — LONG — Primary key — NOT NULL
- BOOK_ID (Key2) — Foreign key → BOOK.ID — NOT NULL
- ORG_NAME (Field) — VARCHAR(50)
- SYS_NAME (Field2) — VARCHAR(50)
- PATH (Field3) — VARCHAR(50)
- SIZE (Field4) — INTEGER
- TYPE (Field5) — VARCHAR(50)
- REG_TIME (Field6) — DATETIME
Image (Untitled6)
- ID (Key) — LONG — Primary key — NOT NULL
- IMAGE_NAME (Field) — VARCHAR
- IMAGE_ORG_NAME (Field2) — VARCHAR
- PATH (Field3) — VARCHAR
- THUMBNALE (Field4) — VARCHAR
- DTYPE (Field5) — VARCHAR
USER_IMAGE (Untitled9)
- ID (Key22) — Foreign key → User.ID — NOT NULL
- ID (Key2) — LONG — Foreign key → Image.ID — NOT NULL
User (ID)
- ID (Key2) — Primary key — NOT NULL
- USERNAME (Field) — VARCHAR(50)
- PASSWORD (Field2) — VARCHAR(50)
- PASSWORD CONFIRMATION (Field6) — VARCHAR(50)
- EMAIL (Field3) — VARCHAR(50)
- AGE (Field4) — INTEGER
- GROUP (Field5) — VARCHAR(50)
user_likes (Untitled5)
- ID (Key) — LONG — Primary key — NOT NULL
- USER_ID (Key2) — Foreign key → User.ID — NOT NULL
- BOOK_ID (Key3) — Foreign key → BOOK.ID — NOT NULL