미니
테이블 (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