ERD 초안
테이블 (11)
bookmark_reminders
- id — BIGINT — 기본 키 — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- remind_at — DATETIME — NOT NULL
- status — VARCHAR(50) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- send_attempt_count — INT — NOT NULL
- sent_at — DATETIME
- cancelled_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
bookmark_tags
- id — BIGINT — 기본 키 — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- tag_id — BIGINT — 외래 키 → tags.id — NOT NULL
- created_at — DATETIME — NOT NULL
bookmark_visits
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- visit_source — VARCHAR(50) — NOT NULL
- score_awarded — TINYINT(1) — NOT NULL
- visited_at — DATETIME — NOT NULL
bookmarks
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- url — TEXT — NOT NULL
- normalized_url — VARCHAR(2048)
- title — VARCHAR(500)
- thumbnail_url — TEXT
- purpose_type — VARCHAR(50) — NOT NULL
- purpose_detail — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- view_count — INT — NOT NULL
- first_viewed_at — DATETIME
- last_viewed_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
character_grades
- id — BIGINT — 기본 키 — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- min_score — INT — NOT NULL
- max_score — INT — NOT NULL
- expression — VARCHAR(100)
- asset_key — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
checklist_items
- id — BIGINT — 기본 키 — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- content — VARCHAR(500) — NOT NULL
- display_order — INT — NOT NULL
- is_checked — TINYINT(1) — NOT NULL
- checked_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
daily_recommendations
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- recommendation_date — DATE — NOT NULL
- slot_number — INT — NOT NULL
- source_type — VARCHAR(50) — NOT NULL
- clicked_at — DATETIME
- created_at — DATETIME — NOT NULL
notifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id — NOT NULL
- reminder_id — BIGINT — 외래 키 → bookmark_reminders.id
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — VARCHAR(250) — NOT NULL
- group_key — VARCHAR(100) — NOT NULL
- sent_at — DATETIME
- read_at — DATETIME
- clicked_at — DATETIME
- created_at — DATETIME — NOT NULL
score_events
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- bookmark_id — BIGINT — 외래 키 → bookmarks.id
- event_type — VARCHAR(50) — NOT NULL
- score_delta — INT — NOT NULL
- reference_key — VARCHAR(150) — NOT NULL
- created_at — DATETIME — NOT NULL
tags
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- current_grade_id — BIGINT — 외래 키 → character_grades.id
- login_id — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- total_score — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME