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