ERD cloud Task
Tables (27)
adhd_advice_records
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- advice_type — VARCHAR(30) — NOT NULL — FOCUS_TIP|ENERGY_MANAGEMENT|TASK_BREAKDOWN|MOTIVATION
- trigger_context — TEXT — NOT NULL
- advice_content — TEXT — NOT NULL
- user_feedback — VARCHAR(20) — HELPFUL|NOT_HELPFUL|SOMEWHAT_HELPFUL
- was_applied — TINYINT(1)
- related_task_id — VARCHAR(255)
- created_at — DATETIME
- INDEX — idx_adhd_advice_type
- INDEX — idx_adhd_advice_feedback
ai_goal_generations
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- goal_id — VARCHAR(255) — NOT NULL
- user_input — TEXT — NOT NULL
- selected_category_id — VARCHAR(255) — NOT NULL
- ai_response — TEXT — NOT NULL
- generated_tasks_count — INT — NOT NULL
- api_response_time_ms — INT
- created_at — DATETIME
- INDEX — idx_ai_generations_user
- INDEX — idx_ai_generations_goal
ai_task_recommendations
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- recommendation_context — TEXT — NOT NULL
- user_preferences — TEXT — NOT NULL
- recommended_tasks — TEXT — NOT NULL
- recommendation_scores — TEXT — NOT NULL
- user_selection — VARCHAR(255)
- feedback_score — TINYINT
- model_version — VARCHAR(50) — NOT NULL
- recommendation_type — VARCHAR(20) — NOT NULL — TIME_SLOT|NEXT_TASK|GOAL_BASED|HABIT
- created_at — DATETIME
- INDEX — idx_ai_recommendations_user
- INDEX — idx_ai_recommendations_type
- INDEX — idx_ai_recommendations_feedback
appointments
- appointment_id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- place_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- transportation — VARCHAR(10) — NOT NULL — WALK|CAR|TRANSIT
- estimated_travel_time — INT — NOT NULL
- status — VARCHAR(15) — PENDING|CONFIRMED|CANCELLED
- created_at — DATETIME
- updated_at — DATETIME
categories
- id — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- color_code — VARCHAR(7)
- icon_image — TEXT
- description — TEXT
- sort_order — INT
- is_default — TINYINT(1)
- category_type — VARCHAR(20) — STUDY|EXERCISE|HOBBY|REST|MEAL|WORK|ETC
- user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_categories_user
- INDEX — idx_categories_type
daily_schedules
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- schedule_date — DATE — NOT NULL
- schedule_summary — TEXT
- status — VARCHAR(15) — DRAFT|ACTIVE|COMPLETED
- total_blocks — INT
- completed_blocks — INT
- created_at — DATETIME
- updated_at — DATETIME
email_verifications
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- verification_code — VARCHAR(10) — NOT NULL
- verification_type — VARCHAR(30) — SIGNUP|PASSWORD_RESET
- is_used — TINYINT(1)
- expires_at — DATETIME — NOT NULL
- verified_at — DATETIME
- created_at — DATETIME
focus_prompts
- id — BIGINT
- prompt_type — VARCHAR(10) — NOT NULL — WARMUP|COOLDOWN
- category_id — VARCHAR(255)
- question — TEXT — NOT NULL
- placeholder — VARCHAR(255)
- order_priority — INT
- is_active — TINYINT(1)
- created_at — DATETIME
- INDEX — idx_focus_prompts_type
- INDEX — idx_focus_prompts_category
focus_reflections
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- task_id — VARCHAR(255)
- work_session_id — BIGINT
- reflection_type — VARCHAR(10) — NOT NULL — WARMUP|COOLDOWN
- prompt_id — BIGINT
- prompt_question — TEXT — NOT NULL
- user_response — TEXT — NOT NULL
- category_id — VARCHAR(255)
- session_date — DATE — NOT NULL
- created_at — DATETIME
- INDEX — idx_focus_reflections_mypage
- INDEX — idx_focus_reflections_task
gemini_api_logs
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- api_type — VARCHAR(30) — NOT NULL — GOAL_GENERATION|ADHD_ADVICE|TASK_BREAKDOWN|PERSONALIZED_TIP
- request_context — TEXT — NOT NULL
- request_prompt — TEXT — NOT NULL
- response_content — TEXT — NOT NULL
- token_usage — TEXT
- response_time_ms — INT
- is_successful — TINYINT(1) — NOT NULL
- error_message — TEXT
- related_entity_type — VARCHAR(20) — GOAL|TASK|SESSION|GENERAL
- related_entity_id — VARCHAR(255)
- created_at — DATETIME
- INDEX — idx_gemini_logs_user_type
- INDEX — idx_gemini_logs_success
goals
- id — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- category_id — VARCHAR(255) — NOT NULL
- description — TEXT
- is_ai_generated — TINYINT(1)
- status — VARCHAR(15) — ACTIVE|COMPLETED|PAUSED
- target_date — DATE
- total_estimated_hours — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_goals_user_status
- INDEX — idx_goals_category
google_calendar_events
- id — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- google_event_id — VARCHAR(255) — NOT NULL
- calendar_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- description — TEXT
- location — VARCHAR(500)
- is_synced — TINYINT(1)
- last_synced_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_google_events_sync
- INDEX — idx_google_events_time
places
- place_id — BIGINT
- name — VARCHAR(200) — NOT NULL
- address — VARCHAR(500) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
refresh_tokens
- id — VARCHAR(255)
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- is_revoked — TINYINT(1)
- device_info — VARCHAR(500)
- ip_address — VARCHAR(45)
- user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- INDEX — idx_refresh_tokens_user
schedule_blocks
- id — BIGINT
- schedule_id — BIGINT — NOT NULL
- task_id — VARCHAR(255)
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- duration_minutes — INT — NOT NULL
- block_type — VARCHAR(10) — TASK|BREAK|MEAL|FREE
- status — VARCHAR(15) — SCHEDULED|IN_PROGRESS|COMPLETED|SKIPPED
- title — VARCHAR(255) — NOT NULL
- color_code — VARCHAR(7)
- metadata — TEXT
- sort_order — INT
- created_at — DATETIME
- updated_at — DATETIME
simple_habits
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- icon — VARCHAR(50)
- category — VARCHAR(20) — NOT NULL — HEALTH|WORKSPACE|WELLNESS|ENERGY
- estimated_minutes — INT
- is_active — TINYINT(1)
- sort_order — INT
- created_at — DATETIME
tags
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- category_id — VARCHAR(255)
- color_code — VARCHAR(7)
- is_default — TINYINT(1)
- usage_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tags_category
- INDEX — idx_tags_usage
task_tags
- task_id — VARCHAR(255) — Primary key — NOT NULL
- tag_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
task_templates
- id — BIGINT
- template_name — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- estimated_pomodoros — INT
- default_tags — TEXT
- priority — VARCHAR(10) — LOW|MEDIUM|HIGH
- default_duration_minutes — INT
- is_ai_generated — TINYINT(1)
- template_type — VARCHAR(20) — STUDY|WORK|EXERCISE|CUSTOM
- usage_count — INT
- category_id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
tasks
- id — VARCHAR(255)
- user_id — VARCHAR(255) — NOT NULL
- category_id — VARCHAR(255) — NOT NULL
- goal_id — VARCHAR(255)
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- priority — VARCHAR(10) — LOW|MEDIUM|HIGH
- status — VARCHAR(15) — TODO|IN_PROGRESS|COMPLETED|PAUSED|CANCELLED|OVERDUE
- estimated_pomodoros — INT
- completed_pomodoros — INT
- due_at — DATETIME
- is_recurring — TINYINT(1)
- recurring_pattern — VARCHAR(10) — DAILY|WEEKLY|MONTHLY|YEARLY
- scheduled_date — DATE
- scheduled_start_time — TIME
- scheduled_end_time — TIME
- actual_duration_minutes — INT
- break_time_minutes — INT
- is_ai_generated — TINYINT(1)
- weekday_preference — TINYINT
- hour_preference — TINYINT
- ai_confidence_score — DECIMAL(3, 2)
- sort_order — INT
- completed_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tasks_timeline
- INDEX — idx_tasks_timeline_status
- INDEX — idx_tasks_goal_status
- INDEX — idx_tasks_preferences
- INDEX — idx_tasks_daily_count
- INDEX — idx_tasks_time_range
timeline_conflicts
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- conflict_date — DATE — NOT NULL
- conflict_start_time — TIME — NOT NULL
- conflict_end_time — TIME — NOT NULL
- conflict_type — VARCHAR(20) — NOT NULL — OVERLAP|GOOGLE_SYNC|USER_DOUBLE_BOOKING
- involved_task_ids — TEXT — NOT NULL
- resolution_status — VARCHAR(10) — PENDING|RESOLVED|IGNORED
- resolution_method — VARCHAR(20) — TIME_SHIFT|DURATION_ADJUST|PRIORITY_SELECT|MANUAL
- resolved_at — DATETIME
- created_at — DATETIME
- INDEX — idx_timeline_conflicts_user_date
- INDEX — idx_timeline_conflicts_status
user_behavior_patterns
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- pattern_type — VARCHAR(30) — NOT NULL — TIME_PREFERENCE|CATEGORY_PREFERENCE|DURATION_PATTERN|COMPLETION_RATE
- pattern_data — TEXT — NOT NULL
- confidence_score — DECIMAL(3, 2) — NOT NULL
- sample_size — INT — NOT NULL
- last_updated_at — DATETIME — NOT NULL
- created_at — DATETIME
- INDEX — idx_behavior_patterns_confidence
user_habit_records
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- habit_id — BIGINT — NOT NULL
- performed_at — DATETIME — NOT NULL
- session_count — INT — NOT NULL
- encouragement_message — TEXT
- created_at — DATETIME
- INDEX — idx_habit_records_user_time
- INDEX — idx_habit_records_timeline
user_habit_stats
- user_id — VARCHAR(255) — Primary key — NOT NULL
- habit_id — BIGINT — Primary key — NOT NULL
- total_count — INT
- last_performed_at — DATETIME
- current_streak — INT
- updated_at — DATETIME
user_preferences
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- work_duration — INT
- short_break_duration — INT
- long_break_duration — INT
- sessions_until_long_break — INT
- notification_settings — TEXT
- language — VARCHAR(5)
- auto_start_breaks — TINYINT(1)
- auto_start_work — TINYINT(1)
- created_at — DATETIME
- updated_at — DATETIME
users
- id — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(50)
- password_hash — VARCHAR(255)
- birth_date — DATE
- gender — VARCHAR(10) — MALE|FEMALE|OTHER
- profile_image_url — VARCHAR(500)
- auth_type — VARCHAR(20) — EMAIL|KAKAO|GOOGLE
- social_id — VARCHAR(100)
- email_verified — TINYINT(1)
- email_verified_at — DATETIME
- status — VARCHAR(10) — ACTIVE|INACTIVE
- last_login_at — DATETIME
- terms_agreed — TEXT
- timezone — VARCHAR(50) — Asia/Seoul|UTC|America/New_York|Europe/London
- subscription_type — VARCHAR(20) — FREE|PREMIUM
- user_mode — VARCHAR(20) — COMPANION|FOCUS|ASSISTANT
- my_message — TEXT
- google_calendar_token — TEXT
- google_calendar_refresh_token — TEXT
- created_at — DATETIME
- updated_at — DATETIME
work_sessions
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- task_id — VARCHAR(255) — NOT NULL
- session_id — BIGINT
- block_id — BIGINT
- session_type — VARCHAR(20) — NOT NULL — WORK|SHORT_BREAK|LONG_BREAK
- duration_minutes — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- status — VARCHAR(15) — ACTIVE|PAUSED|COMPLETED|CANCELLED
- notes — TEXT
- interruptions — TEXT
- focus_score — INT
- created_at — DATETIME
- INDEX — idx_work_sessions_user_task
- INDEX — idx_work_sessions_status