Planner ERD v2

Tables (10)

category

  • category_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • color — VARCHAR(20)
  • sort_order — INT — NOT NULL
  • is_default — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

feedback

  • feedback_id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • progress_rate — INT — NOT NULL
  • memo — TEXT
  • is_completed — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notification_setting

  • notification_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — NOT NULL
  • notify_before — INT — NOT NULL
  • is_enabled — TINYINT(1) — NOT NULL

playlist

  • playlist_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

playlist_item

  • playlist_item_id — BIGINT — Primary key — NOT NULL
  • playlist_id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • sort_order — INT — NOT NULL
  • added_at — DATETIME — NOT NULL

task

  • task_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • category_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • priority — ENUM('HIGH','MEDIUM','LOW') — NOT NULL
  • is_starred — TINYINT(1) — NOT NULL
  • deadline — DATE
  • estimated_time — INT
  • status — ENUM('TODO','IN_PROGRESS','DONE') — NOT NULL
  • repeat_type — ENUM('NONE','DAILY','WEEKLY','MONTHLY') — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

task_session

  • session_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME
  • elapsed_time — INT — NOT NULL
  • status — ENUM('PLAYING','PAUSED','DONE') — NOT NULL

timetable

  • timetable_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • day_of_week — TINYINT — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • social_provider — VARCHAR(20) — NOT NULL
  • social_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • profile_image_url — VARCHAR(500)
  • recommended_daily_time — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_notification_settings

  • setting_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • service_notification — TINYINT(1) — NOT NULL
  • pack_notification — TINYINT(1) — NOT NULL
  • updated_at — DATETIME — NOT NULL