week2_practice

Tables (8)

book

  • book_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • is_available — BOOLEAN — NOT NULL

book_like

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL

book_tag

  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL
  • tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL

category

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

notification

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(30) — NOT NULL

rental

  • rental_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL
  • rented_at — DATETIME — NOT NULL
  • due_at — DATETIME — NOT NULL
  • returned_at — DATETIME

tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL