Health

Tables (7)

RecordWorkout (Untitled6)

  • userid (Key2) — INT — Foreign key → UserRoutine.userid — NOT NULL
  • routineid (Key22) — INT — Foreign key → UserRoutine.routineid — NOT NULL
  • workoutid (Key3) — INT — Foreign key → Workout.workoutid — NOT NULL
  • set (Key) — INT — NOT NULL
  • reps (Field) — INT
  • weight (Field2) — INT
  • date (Field3) — DateTime

Routine (Untitled2)

  • routineid (Key) — INT — Primary key — NOT NULL
  • routinename (Field) — VARCHAR(50)

RoutineWorkout (Untitled4)

  • routineid (Key) — INT — Foreign key → Routine.routineid — NOT NULL
  • standardseq (Key2) — INT — Foreign key → StandardWorkout.standardseq — NOT NULL
  • workoutid (Key22) — INT — Foreign key → StandardWorkout.workoutid — NOT NULL

StandardWorkout (Untitled5)

  • standardseq (Key) — INT — Primary key — NOT NULL
  • workoutid (Key2) — INT — Foreign key → Workout.workoutid — NOT NULL
  • workoutid (Field)
  • Field2

User (Untitled)

  • userid (Key) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR(50)

UserRoutine (Untitled3)

  • userid (Key) — INT — Foreign key → User.userid — NOT NULL
  • routineid (Key2) — INT — Foreign key → Routine.routineid — NOT NULL

Workout (Untitled7)

  • workoutid (Key) — INT — Primary key — NOT NULL
  • workoutname (Field) — VARCHAR(50)