gym_exercise_log_app - Laravel Schema Designer

exercise_types

id increments
name string (250)
timestamps timestamps

exercise_equipments

id increments
name string (250)
timestamps timestamps

workout_types

id increments
name string (250)
timestamps timestamps

exercises

id increments
name string (250)
exercise_type_id ^FK integer
exercise_equipment_id ^FK integer
timestamps timestamps

workouts

id increments
workout_type_id ^FK integer
name string (250)
timestamps timestamps

junctions

id increments
exercise_id ^FK integer
workout_id ^FK integer
timestamps timestamps

logs

id increments
workout_id ^FK integer
date_time timestamp
timestamps timestamps

targets

id increments
junction_id ^FK integer
set_number tinyInteger
min_reps smallInteger
max_reps smallInteger
timestamps timestamps

log_entries

id increments
log_id ^FK integer
junction_id ^FK integer
set_number tinyInteger
weight smallInteger
reps smallInteger
time_recorded timestamp
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01