I am making a crew listing for local events in my area that the crew members have to attend. The events will be updated frequently. Each event will have about 12 to 20 members working.
I have four tables - listed below. Whats happening is that I enter all the crew members in the members table and all the positions in the positions table. Then I add the events in the events table, then I add all the crew members that will be working that event in the list table.
members
member_id
firstname
lastname
email
phone
list
member_id
event_id
position_id
calltime
pay
events
event_id
event
date
time
place
title
positions
position_id
position
First of all, is this a good database structure? Originally I had a members table and an events table - where the events table had name01 - 12, pos01 - 12, time01 - 12, pay01 - 12. After some looking around, the four tables seem to be a better solution - as I will sometimes have more than twelve crew members.
Where I am stuck is that I can view each event with its crew members, just using two different queries.
But what about updating? Im stuck and just trying to read as much as I can. Do I have to somehow join the tables - Im pretty new at PHP and mySQL...
Any direction would be greatly appreciated?
