I need to setup models to store the results of athletic events. I think this is fairly straightforward, but want to make sure I'm making the right decision at the outset.
I'm planning Athlete and Match models. Each Match has just two Athletes.
Do I need anything more than a HABTM relationship? Since there are only two athletes for any match, is there any sense in just storing both athlete_id's in the Match model directly?
In a HABTM, what's the cleanest code to query for matches played between two specific athletes?
Thanks in advance!