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