루틴
테이블 (7)
app_settings (Untitled5)
- Key (setting_id) — INT — 기본 키 — NOT NULL
- Field (setting_key) — TEXT
- Field (setting_value) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Key (user_id) — INT — 외래 키 → users.Key — NOT NULL
daily_memos (Untitled4)
- Key (daily_memo_id) — INT — 기본 키 — NOT NULL
- Field (memo_content) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Key (daily_record_id) — INT — 외래 키 → daily_records.Key — NOT NULL
daily_records (Untitled)
- Key (daily_record_id) — INT — 기본 키 — NOT NULL
- Field (record_date) — TEXT
- Field (total_score) — INT
- Field (max_score) — INT
- Field (score_percent) — REAL
- Field (completed_count) — INT
- Field (total_count) — INT
- Field (completion_rate) — REAL
- Field (is_succes_day) — INT
- Field (current_streak) — INT
- Field (max_streak_snapshot) — INT
- Field (color_level) — TEXT
- Field (created_at) — TEXT
- Field (update_at) — TEXT
- Key (user_id) — INT — 외래 키 → users.Key — NOT NULL
routines
- Key (routine_id) — INT — 기본 키 — NOT NULL
- Field (routine_name) — TEXT
- Field (display_order) — INT
- Field (is_active) — INT
- Field (is_deleted) — INT
- Field (deleted_at) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Key (user_id) — INT — 외래 키 → users.Key — NOT NULL
sub_routine_records (Untitled2)
- Key (sub_record_id) — INT — 기본 키 — NOT NULL
- Field (rating') — TEXT — CHECK (rating IN ('상', '중', '하', '미완료'))
- Field (score) — INT
- Field (is_checked) — INT
- Field (memo) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Key (sub_routine_id) — INT — 외래 키 → sub_routines.Key — NOT NULL
- Key (daily_record_id) — INT — 외래 키 → daily_records.Key — NOT NULL
sub_routines (Untitled3)
- Key (sub_routine_id) — INT — 기본 키 — NOT NULL
- Field (sub_routine_name) — TEXT
- Field (display_order) — INT
- Field (is_active) — INT
- Field (is_deleted) — INT
- Field (deleted_at) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Key (routine_id) — INT — 외래 키 → routines.Key — NOT NULL
users (users\)
- Key (user_id) — INT — 기본 키 — NOT NULL
- Field (nickname) — TEXT
- Field (created_at) — TEXT
- Field (updated_at) — TEXT
- Field (is_deleted) — INT
- Field (deleted_at) — TEXT