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