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