미니

테이블 (7)

bookmarks

  • id — INT
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • quote_id — INT — 외래 키 → quotes.id — NOT NULL

diaries

  • id — INT
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_user_diary

questions

  • id — INT
  • question_text — VARCHAR(500) — NOT NULL

quotes

  • id — INT
  • content — TEXT — NOT NULL
  • author — VARCHAR(100)

token_blacklist

  • id — INT
  • token — VARCHAR(500) — NOT NULL
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • expired_at — TIMESTAMP — NOT NULL
  • INDEX — idx_token

user_questions

  • id — INT
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • question_id — INT — 외래 키 → questions.id — NOT NULL
  • received_at — TIMESTAMP

users

  • id — INT
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP