플래너
테이블 (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