플래너

테이블 (14)

categories

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • color — VARCHAR(30) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

daily_recommendation_items

  • id — BIGINT — NOT NULL
  • daily_recommendation_id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • rank_order — INT — NOT NULL
  • score — DECIMAL(8,2)
  • recommended_minutes — INT
  • reason — VARCHAR(255)

daily_recommendations

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • recommended_date — DATE — NOT NULL
  • mode — VARCHAR(30) — NOT NULL
  • available_minutes — INT
  • total_recommended_minutes — INT
  • created_at — TIMESTAMP — NOT NULL

feedback

  • id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • session_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • progress_rate — INT — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • memo — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

playlist

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

playlist_items

  • id — BIGINT — NOT NULL
  • playlist_id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • sort_order — INT — NOT NULL
  • added_at — TIMESTAMP — NOT NULL

repeat_rules

  • id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • frequency — VARCHAR(20) — NOT NULL
  • interval_value — INT — NOT NULL
  • days_of_week — VARCHAR(50)
  • end_date — DATE
  • max_occurrences — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

social_accounts

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

task_notifications

  • id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • notify_before — INT — NOT NULL
  • is_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

task_sessions

  • id — BIGINT — NOT NULL
  • task_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • elapsed_time — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tasks

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • category_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • due_at — TIMESTAMP
  • estimated_minutes — INT
  • priority — INT
  • is_starred — BOOLEAN — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • progress_percent — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

timetable

  • id — BIGINT — 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 — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_notification_settings

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • is_today_alarm_enabled — BOOLEAN — NOT NULL
  • is_30min_pack_alarm_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • recommended_daily_time — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL