test

Tables (10)

Excercise (Untitled6)

  • Excerciseid (Key) — INT — Primary key — NOT NULL
  • ExcerciseName (Field) — VARCHAR(50)

Record (Untitled5)

  • Recordid (Key) — INT — Primary key — NOT NULL
  • Excerciseid (Key3) — INT — Foreign key → Excercise.Excerciseid — NOT NULL
  • UserId (Key2) — INT — Foreign key → User.UserId — NOT NULL
  • set (Field) — INT
  • reps (Field2) — INT
  • weight (Field3) — INT

Routine

  • RoutineId (Key) — INT — Primary key — NOT NULL
  • RoutineName (Field) — VARCHAR(50)

Routine (Untitled8)

  • Routineid (Key) — INT — Primary key — NOT NULL
  • RoutineName (Field) — VARCHAR(50)

RoutineRecord (Untitled7)

  • Recordid (Key) — INT — Foreign key → Record.Recordid — NOT NULL
  • Excerciseid (Key3) — INT — Foreign key → Record.Excerciseid — NOT NULL
  • UserId (Key2) — INT — Foreign key → Record.UserId — NOT NULL
  • Routineid (Key4) — INT — Foreign key → Routine.Routineid — NOT NULL
  • set (Field) — INT
  • reps (Field2) — INT
  • weight (Field3) — INT

RoutineWorkout (Untitled2)

  • RoutineId (Key) — INT — Foreign key → Routine.RoutineId — NOT NULL
  • WorkoutId (Key2) — INT — Foreign key → Workout.WorkoutId — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

User (Untitled4)

  • UserId (Key) — INT — Primary key — NOT NULL

User (CopyOfUntitled4)

  • UserId (Key) — INT — Primary key — NOT NULL

UserRoutine (Untitled3)

  • UserId (Key) — INT — Foreign key → User.UserId — NOT NULL
  • RoutineId (Key2) — INT — Foreign key → RoutineWorkout.RoutineId — NOT NULL
  • WorkoutId (Key22) — INT — Foreign key → RoutineWorkout.WorkoutId — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Workout (Untitled)

  • WorkoutId (Key) — INT — Primary key — NOT NULL
  • WorkoutName (Field) — VARCHAR(50)