UMC-Week2

Tables (7)

Users

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • nickname — VARCHAR(50)

book

  • Key2 (book_id) — Primary key — NOT NULL
  • Field (title)
  • Field (is_available)
  • Key (category_id) — Foreign key → category.Key — NOT NULL
  • Field (description)

book_like

  • Key (user_id) — Foreign key → Users.user_id — NOT NULL
  • Key2 (book_id) — Foreign key → book.Key2 — NOT NULL

book_tag

  • Key2 (book_id) — Foreign key → book.Key2 — NOT NULL
  • Key (tag_id) — Foreign key → tag.Key — NOT NULL

category

  • Key (category_id) — Primary key — NOT NULL
  • Field (name)

rental

  • Key (rental_id) — Primary key — NOT NULL
  • Field (rented_at)
  • Field (due_at)
  • Field (returned_at)
  • Key (user_id) — Foreign key → Users.user_id — NOT NULL
  • Key2 (book_id) — Foreign key → book.Key2 — NOT NULL

tag

  • Key (tag_id) — Primary key — NOT NULL
  • Field (name)