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