I think this is an easy question, but i just don't know the best way to do this.
I have the following tables:
- Exercises - Biking_details - Running_details.
as you can see i have 2 kinds of Excercises: running and biking
so i could do this:
Exercise: has_one :biking_details has_one :running detail
running_detail belongs_to :exercise
biking_detail belongs_to :exercise.
of course this could work, but these models would allow that an exercise would have both running and bking details, which is not possible
when i would like to generate a list of exercisess with a column "exercise type", i would have to loop though a the list of exercises and for each record check if there is biking detail OR a running detail, generating a lot of queries
i could solve this by adding a field exercise_type to the exercises table, but wouldn't this be kind of redundant?
so now i am having troubles to decide what to do
who can give me some insight?
thanks