I want the wordpress CMS to manage a new type of content called Athletes. The data structure for Athlete would be as follows:
Athlete.name Athlete.date_of_birth Athlete.profile etc...
An athlete will also have a photo gallery. So in a typical relational database design, you will have something like
Athlete_Gallery.id Athlete_Gallery.athlete_id Athlete_Gallery.file_name
An athlete will have also participated in many tournaments. So in a typical relational database design, you will have something like:
Athlete_Tournament.id Athlete_Tournament.athlete_id Athlete_Tournament.tournament_name Athlete_Tournament.win_or_loss Athlete_Tournament.score Athlete_Tournament.weight_class etc...
An athlete will also have list coaches he has trained under, following a db schema similar to Athlete_Tournament.
What is the best way to set up a CMS that will manage such a data structure? Which plugins will I need?
ADDITIONAL NOTES I looked at Pods but the steps for creating dependent records is not optimal. If I want to record the fact that John won the 2001 City Tournament, I currently need to:
- go to a tournament page
- create 2001 City Tournament
- go to John page
- relate John to the 2001 City Tournament record
This is not ideal. Instead, I want to:
- go to John page and see a section called tournaments
- add the 2001 City Tournament
Pods doesn't seem to do this out of hte box....please correct if i'm wrong. Thanks