1111

Tables (4)

Checked (Untitled3)

  • habit_id (Key) — Integer — Foreign key → Habit.habit_id — NOT NULL
  • day_id (2) — Integer — Foreign key → Habit.day_id — NOT NULL — AUTO_INCREMENT
  • check (Field) — Bool

Cycle (Untitled4)

  • habit_id (Key) — Integer — Foreign key → Habit.habit_id — NOT NULL
  • day (Field) — Integer

Day (Untitled)

  • day_id — Integer — Primary key — NOT NULL — AUTO_INCREMENT
  • today_date (Field) — Date
  • content (Field2) — String

Habit (Untitled2)

  • habit_id (Key) — Integer — Primary key — NOT NULL
  • day_id (2) — Integer — Foreign key → Day.day_id — NOT NULL — AUTO_INCREMENT
  • title (Field) — String
  • desc (Field2) — String
  • color (Field3) — String
  • created_at (Field5) — Date