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