루틴

테이블 (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