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