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