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)