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)