umc_workbook

Tables (8)

book (책)

  • Key — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR — NOT NULL
  • description (Field2) — TEXT
  • category_Key (Key2) — Foreign key → category.Key — NOT NULL
  • hastagKey (Key4) — Foreign key → hash_tag.Key — NOT NULL
  • lend_status (Field3)

category (Untitled)

  • Key — Primary key — NOT NULL
  • genre (Field) — VARCHAR — NOT NULL

category_num (Untitled4)

  • Key — Foreign key → category.Key — NOT NULL
  • num (개수)

hash_tag (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • book_Key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL

like (Untitled3)

  • uesr_key (Key) — BIGINT — Foreign key → user.Key — NOT NULL
  • book_key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL

rent_book (Untitled5)

  • Key3 — Primary key — NOT NULL
  • user_Key (Key) — BIGINT — Foreign key → user.Key — NOT NULL
  • book_Key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL
  • date (Field) — DATE

return_alarm (Untitled6)

  • Key — Primary key — NOT NULL
  • lend_book_Key3 (Key3) — Foreign key → rent_book.Key3 — NOT NULL
  • status (Field)
  • user_Key (Key2) — BIGINT — Foreign key → user.Key — NOT NULL

user (사용자)

  • Key — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • nickname (Field2) — VARCHAR
  • phonenumber (Field3)
  • gender (Field4)
  • status (Field5) — BOOLEAN — NOT NULL