tomado

Tables (8)

AUDIO_PRESETS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • name — varchar — NOT NULL
  • lofi_volume — smallint
  • rain_volume — smallint
  • cafe_volume — smallint
  • is_default — boolean — NOT NULL
  • created_at — timestamp — NOT NULL

DAILY_FOCUS_STATS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • focus_date — date — NOT NULL
  • total_focus_sec — int — NOT NULL
  • completed_sessions — int — NOT NULL
  • completed_todos — int — NOT NULL
  • has_daily_log — boolean — NOT NULL
  • has_retro_log — boolean — NOT NULL
  • updated_at — timestamp — NOT NULL

DAILY_LOGS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • log_date — date — NOT NULL
  • content — text
  • tags — varchar
  • is_dirty — boolean — NOT NULL
  • draft_content — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

POMODORO_SESSIONS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • todo_id — uuid — Foreign key → TODOS.id
  • type — varchar — NOT NULL
  • status — varchar — NOT NULL
  • planned_sec — int — NOT NULL
  • actual_sec — int — NOT NULL
  • focus_date — date — NOT NULL
  • started_at — timestamp — NOT NULL
  • ended_at — timestamp
  • created_at — timestamp — NOT NULL

RETRO_LOGS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • daily_log_id — uuid — Foreign key → DAILY_LOGS.id
  • retro_date — date — NOT NULL
  • template_type — varchar — NOT NULL
  • content — jsonb — NOT NULL
  • is_dirty — boolean — NOT NULL
  • draft_content — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

TODOS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • title — varchar — NOT NULL
  • description — text
  • assigned_date — date — NOT NULL
  • sort_order — float — NOT NULL
  • is_completed — boolean — NOT NULL
  • completed_at — timestamp
  • is_carried_over — boolean — NOT NULL
  • original_date — date
  • pomodoro_count — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

USERS

  • id — uuid — Primary key — NOT NULL
  • email — varchar — NOT NULL
  • nickname — varchar
  • avatar_url — text
  • provider — varchar — NOT NULL
  • google_id — varchar
  • account_type — varchar — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

USER_SETTINGS

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → USERS.id — NOT NULL
  • focus_min — int — NOT NULL
  • short_break_min — int — NOT NULL
  • long_break_min — int — NOT NULL
  • sessions_per_set — int — NOT NULL
  • auto_carry_todo — boolean — NOT NULL
  • sound_enabled — boolean — NOT NULL
  • notif_enabled — boolean — NOT NULL
  • theme — varchar — NOT NULL
  • background_id — int — NOT NULL
  • bgm_type — varchar
  • bgm_volume — smallint — NOT NULL
  • active_preset_id — uuid — Foreign key → AUDIO_PRESETS.id
  • updated_at — timestamp — NOT NULL