umc_11th_week 1

Tables (8)

book

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → category.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

book_hashtag

  • id — BIGINT — Primary key — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • hashtag_id — BIGINT — Foreign key → hashtag.id — NOT NULL

book_like

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • created_at — DATETIME — NOT NULL

category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

hashtag

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

member

  • id — BIGINT — Primary key — NOT NULL
  • kakao_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

notification

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

rental

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • rented_at — DATETIME — NOT NULL
  • due_at — DATETIME — NOT NULL
  • returned_at — DATETIME