workout_counter

Tables (5)

exercise (Untitled5)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • count (Field) — int(11) — NOT NULL
  • name (Field2) — varchar(15) — NOT NULL

routine (Untitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (id) — bigint(20) — Foreign key → user.id — NOT NULL
  • name (Field) — varchar(15) — NOT NULL

routine_exercise (Untitled4)

  • routine_id (Key) — bigint(20) — Foreign key → routine.id — NOT NULL
  • exercise_id (Key2) — bigint(20) — Foreign key → exercise.id — NOT NULL

user (Untitled)

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password (Field2) — varchar(255) — NOT NULL
  • username (Field) — varchar(15) — NOT NULL

workout (Untitled2)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (id) — bigint(20) — Foreign key → user.id — NOT NULL
  • exercise_id (Key2) — bigint(20) — Foreign key → exercise.id — NOT NULL
  • done (Field) — int(11) — NOT NULL
  • date (Field2) — date