Active Record database Organization

Question

I'm creating my first web app as an assignment. I am writing my project proposal and part of the proposal is to create a schema.

The app concept is simple, it's creating a workout log, where users can create, edit and delete workouts all kept in an organized log.

I am having trouble thinking about the best way to structure the database so when a user wants to fetch a specific workout, it comes with all exercises and their results.

So far I've come up with this layout. I guess workouts.exercises.results would gather the correct information, but I wanted to know if their was a tidier way to organize this data as it is my first time and I am trying to create this using best practices.

workouts

column name

id
name
user_id
updated_at

exercises

column name

id
name
workout_id
updated_at

results

column name

id
exercise_id
workout_id
sets
reps
duration
updated_at

Chakreshwar Sharma · Accepted Answer · 2017-08-21 03:44:05Z

1

As per my understanding, Workouts has many exercises, Exercise has one Result.

If yes, then you don't need workout id in result table.

For fetching the records by workout, use the following code:

w = Workout.find(workout_id)
w.exercises.each do |e|
   puts "Exercise=#{e.name} and result = #{e.result}}
end

answered Aug 21, 2017 at 3:44

Chakreshwar Sharma

2,6101 gold badge16 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Active Record database Organization

workouts

exercises

results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

workouts

exercises

results

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related