Planner

Tables (10)

categories (과업 카테고리)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • color — VARCHAR(30)
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

daily_recommendation_items (오늘의 추천 과업)

  • id — BIGINT — Primary key — NOT NULL
  • daily_recommendation_id — BIGINT — Foreign key → daily_recommendations.id — NOT NULL
  • task_id — BIGINT — Foreign key → tasks.id — NOT NULL
  • rank_order — INT — NOT NULL
  • score — DECIMAL(8, 2)
  • recommended_minutes — INT
  • reason — VARCHAR(255)

daily_recommendations (오늘의 추천 설정)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • recommended_date — DATE — NOT NULL
  • mode — VARCHAR(30) — NOT NULL
  • available_minutes — INT
  • total_recommended_minutes — INT
  • created_at — TIMESTAMP — NOT NULL

repeat_rules (과업 반복 규칙)

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → tasks.id — 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

schedule_blocks (에타시간표)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

social_accounts (소셜계정 연동용)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

task_time_logs (과업 수행 기록)

  • id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → tasks.id — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • duration_minutes — INT
  • memo — TEXT
  • created_at — TIMESTAMP — NOT NULL

tasks (과업들)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • due_at — TIMESTAMP
  • reminder_at — TIMESTAMP
  • estimated_minutes — INT
  • actual_minutes — INT
  • priority — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • progress_percent — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_notification_settings (이용자별 설정)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — 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 — Primary key — 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
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL