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