I'm working on creating a basic database for a theatre and really need some suggestions as the best way to approach this.
Each production from this theatre will have its own page. The page should display who was in the production, displayed in a table. This information is "set", and doesn't need to change dynamically, though it would be nice to be able to display a thumbnail image for each actor (and display a default blank image if no headshot is available). I would like the user to be able to click on an actor's name to display a list of other productions that the actor has been involved in.
Here's a picture to give an idea:
Create custom taxonomy for each actor. Add custom meta field to new taxonomy for headshot image.
Store info for each production in a CSV file and use PHP to generate an HTML table when the page loads. Use PHP to grab meta information about each actor and display headshot image.
Can anyone give me any feedback as to whether there is an easier or better way of approaching this? Any feedback would be strongly welcomed!