POS - habit
Tables (3)
Habit (habits)
- id (Key) — uuid — Primary key
- studyId (FK) — uuid — Foreign key → Study.id — NOT NULL
- name (Field) — varchar(20)
- startDate (Field2) — date
- endedDate (Field3) — date nullable
- createdAt (Field4) — timestamp
- updatedAt (Field5) — timestamp
HabitRecord (habit_records)
- id (Key) — uuid — Primary key — NOT NULL
- habitId (FK) — uuid — Foreign key → Habit.id
- date (Field) — date
- isChecked (Field2) — boolean
- createdAt (Field3) — timestamp
- updatedAt (Field4) — timestamp
Study (stydies)
- id (Key) — uuid — Primary key — NOT NULL