routineapp
Tables (4)
Routine (RoutineModel)
- pk (Key) — int — Primary key — NOT NULL
- title (Field) — char
- category (Field2) — char
- goal (Field3) — char
- is_alarm (Field4) — bool
- is_deleted (Field5) — bool
- account (Forignkey) — int — Foreign key → User.pk — NOT NULL
RoutineDay (RoutineDayModel)
- pk (Key) — int — Primary key — NOT NULL
- day (Field) — char
- routine (Forignkey) — int — Foreign key → Routine.pk — NOT NULL
RoutineResult (RoutineResultModel)
- pk (Key) — int — Primary key — NOT NULL
- result (Field) — char
- routine (OnetoOne) — int — Foreign key → Routine.pk — NOT NULL
- is_deleted (Field2) — bool
User (UserModel)
- pk (Key) — int — Primary key — NOT NULL
- email (Field) — email
- password (Field2) — char
- username (Field6) — char
- join_date (Field3) — datetime
- is_active (Field4) — bool
- is_admin (Field5) — bool