ARCHIVE

Tables (17)

ai_summary_feedback

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • ai_summary_job_id — VARCHAR(36) — Foreign key → ai_summary_jobs.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • feedback_text — TEXT
  • created_at — DATETIME — NOT NULL

ai_summary_jobs

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • kind — ENUM('weekly','monthly','yearly') — NOT NULL
  • target_date_key — VARCHAR(10) — NOT NULL
  • status — ENUM('pending','processing','completed','failed') — NOT NULL
  • journal_entry_id — VARCHAR(36) — Foreign key → journal_entries.id
  • error_message — TEXT
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME

daily_productivity_snapshots

  • date_key — VARCHAR(10) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • todos_created — INT — NOT NULL
  • todos_completed — INT — NOT NULL
  • retros_written — INT — NOT NULL
  • commits_linked — INT — NOT NULL
  • ai_summaries_generated — INT — NOT NULL

feature_usage_events

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • event_name — VARCHAR(100) — NOT NULL
  • properties — JSON
  • occurred_at — DATETIME — NOT NULL

github_configs

  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • encrypted_token — TEXT — NOT NULL
  • owner — VARCHAR(255) — NOT NULL
  • repo — VARCHAR(255) — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • connected_as — VARCHAR(255)
  • target_repository — VARCHAR(255)
  • auto_retrospective_enabled — BOOLEAN — NOT NULL
  • last_synced_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

journal_entries

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • date_key — VARCHAR(10) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT — NOT NULL
  • retro_type — ENUM('daily','weekly','monthly','yearly') — NOT NULL
  • synced — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • type — ENUM('success','info','warning') — NOT NULL
  • category — ENUM('general','summary','sync','system') — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

oauth_connections

  • id — VARCHAR(36) — Primary key — NOT NULL
  • provider — ENUM('github','google') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • access_token — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL

payment_history

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • plan — ENUM('free','pro') — NOT NULL
  • amount — INT — NOT NULL
  • currency — VARCHAR(3) — NOT NULL
  • payment_method — VARCHAR(50)
  • status — ENUM('pending','completed','failed','refunded') — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL

push_subscriptions

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • endpoint — TEXT — NOT NULL
  • p256dh — TEXT — NOT NULL
  • auth — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

todo_status_logs

  • id — VARCHAR(36) — Primary key — NOT NULL
  • todo_id — VARCHAR(36) — Foreign key → todos.id — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • from_status — ENUM('not-start','in-progress','done') — NOT NULL
  • to_status — ENUM('not-start','in-progress','done') — NOT NULL
  • changed_at — DATETIME — NOT NULL

todos

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • status — ENUM('not-start','in-progress','done') — NOT NULL
  • completed — BOOLEAN — NOT NULL
  • date_key — VARCHAR(10) — NOT NULL
  • description — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • updated_at — DATETIME — NOT NULL

tracked_repositories

  • id — VARCHAR(36) — Primary key — NOT NULL
  • github_user_id — VARCHAR(36) — Foreign key → github_configs.user_id — NOT NULL
  • repo_name — VARCHAR(255) — NOT NULL
  • enabled — BOOLEAN — NOT NULL

user_goals

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • period_type — ENUM('weekly','monthly') — NOT NULL
  • period_key — VARCHAR(10) — NOT NULL
  • goal_todos — INT — NOT NULL
  • goal_retros — INT — NOT NULL
  • actual_todos — INT — NOT NULL
  • actual_retros — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_settings

  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • locale — ENUM('ko','en','zh','ja') — NOT NULL
  • auto_summary_weekly — BOOLEAN — NOT NULL
  • auto_summary_monthly — BOOLEAN — NOT NULL
  • auto_summary_yearly — BOOLEAN — NOT NULL
  • notification_retention_days — INT — NOT NULL
  • last_schedule_check_at — DATETIME
  • updated_at — DATETIME — NOT NULL

user_streaks

  • user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
  • current_streak — INT — NOT NULL
  • longest_streak — INT — NOT NULL
  • last_active_date — VARCHAR(10)
  • streak_started_at — DATE
  • updated_at — DATETIME — NOT NULL

users

  • id — VARCHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • totp_secret — VARCHAR(255)
  • totp_enabled — BOOLEAN
  • plan — ENUM('free', 'pro') — NOT NULL
  • plan_expires_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL