tama

Tables (4)

Untitled (user)

  • Key (id) — text — Primary key — NOT NULL — uuid
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (deleted_at) — datetime
  • Field (account_id) — text — NOT NULL — social account id?
  • Field (name) — text — NOT NULL
  • Field (role) — enum — NOT NULL — 유저 관리자 등등?
  • Field (photo) — text — photo url
  • Field (os) — enum — NOT NULL — android, ios
  • Field (streak) — int — NOT NULL — 연속으로 todo 다 했을때
  • Field2 (marketing_aggrement) — boolean — NOT NULL

Untitled (pet)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — text — Foreign key → Untitled.Key — NOT NULL — uuid
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (name) — text — NOT NULL
  • Field (type) — enum — NOT NULL — 펫 종류 만큼? 아니면 별도의 table?
  • Field (level) — int — NOT NULL
  • Field (xp) — int — NOT NULL
  • Field (attachment) — int — NOT NULL
  • Field (health) — int — NOT NULL

Untitled (routine_setting)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — text — Foreign key → Untitled.Key — NOT NULL — uuid
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (is_active) — boolean — NOT NULL
  • Field (title) — text — NOT NULL
  • Field (action) — text — NOT NULL
  • Field (value) — decimal — NOT NULL — 이름 quantitiy?
  • Field (unit) — enum — NOT NULL — 회, 권, ml... 등등?
  • Field (memo) — text
  • Field (start_date) — date — NOT NULL
  • Field (end_date) — date
  • Field (days) — int — NOT NULL — 비트단위로?

Untitled (routine)

  • Key (id) — int — Primary key — NOT NULL
  • Key (setting_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (date) — date — NOT NULL — habit_id랑 묶어서 unique
  • Field (day) — enum — NOT NULL — 요일
  • Field (progress) — decimal — NOT NULL — 진행량
  • Field (accomplished) — boolean — NOT NULL — 성공 여부