Workout App
Tables (14)
Equipment (equipment)
- Id (id) — UUID — Primary key — NOT NULL
- Name (name) — Varchar
Excercise (exercise)
- Id (id) — UUID — Primary key — NOT NULL
- Name (name) — Varchar
- Type Id (Type_id) — UUID — Foreign key → Type.Id — NOT NULL
- Equipment Id (equipment_id) — UUID — Foreign key → Equipment.Id — NOT NULL
Exercise/Workout Targets (exercise/workout_targests)
- Id (id) — UUID — Primary key — NOT NULL
- Team_user_id (team_user_id) — Foreign key → Team Users.Id — NOT NULL
- Id (id2) — UUID — Foreign key → Excercise.Id — NOT NULL
- Set Number (set_number) — Integer
- Mininum Reps (min_reps) — int
- Maximum Reps (max_reps) — Integer
- Distance (distance) — Integer
- Duration (duration) — Integer
- Weight (weight) — int
Log Entry (log_entry)
- Exersise log id (id) — int — Primary key — NOT NULL
- workout_log_id (Workout Log Id) — Long — Foreign key → Workout Log.workout_log_id — NOT NULL
- Target Id (target_id) — UUID — Foreign key → Exercise/Workout Targets.Id — NOT NULL
- reps (Reps Done) — Int
- distance (Distance)
- weight (Weight)
Roles (roles)
- Id (id) — UUID — Primary key — NOT NULL
- Role (role) — Varchar
Team Users (team_users)
- Id (id) — UUID — Primary key — NOT NULL
- Team Id (team_id) — UUID — Foreign key → Teams.Id — NOT NULL
- User Id (user_id) — UUID — Foreign key → Users.Id — NOT NULL
- Nickname (nickname) — Varchar
Team Workouts (team_workouts)
- Workout Id (workout_id) — UUID — Foreign key → Workouts.Id — NOT NULL
- Team Id (team_id) — UUID — Foreign key → Teams.Id — NOT NULL
Teams (teams)
- Id (id) — UUID — Primary key — NOT NULL
- Name (name) — Varchar — NOT NULL
- Field
Type (type)
- Id (id) — UUID — Primary key — NOT NULL
- Type (type) — Varchar — NOT NULL
User Roles (user_roles)
- User Id (user_jd) — UUID — Foreign key → Users.Id — NOT NULL
- Role id (role_id) — UUID — Foreign key → Roles.Id — NOT NULL
Users (users)
- Id (id) — UUID — Primary key — NOT NULL
- Password (password) — Varchar — NOT NULL
- Username (username) — Varchar — NOT NULL — Unique
- Weight (wieght) — int
- Height (height) — int
Workout Exersise (workout_exersises)
- Exercise Id (exercise_id) — UUID — Foreign key → Excercise.Id — NOT NULL
- Workout Id (workout_id) — UUID — Foreign key → Workouts.Id — NOT NULL
Workout Log (workout_log)
- workout_log_id (Workout Log Id) — Long — Primary key — NOT NULL
- Workout Id (workout_id) — UUID — Foreign key → Workouts.Id — NOT NULL
- Team User Id (team_user_id) — UUID — Foreign key → Team Users.Id — NOT NULL
Workouts (workouts)
- Id (id) — UUID — Primary key — NOT NULL
- Name (name) — Varchar
- Type Id (type_id) — UUID — Foreign key → Type.Id — NOT NULL