SOPY's Library

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