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 — 성공 여부