Not a problem, the more the merrier.
Originally posted by shane
Kinda sticking my nose in late but what the hell...
True, but there are multiple shows per event, and the artists will only play one show.
Dave, I'm not sure you need the Shows for the Events. I think Creole's saying that the whole 'festival' be a number of single day Events that take place over a single week.
If I'm right adding the extra Shows will just add unrequired complexity. It gives more flexibility but as the whole event is over just a single week the simpler route may be better.
Good catch!!! I missed that entirely....
Also, if the db schema stays as your last post I think changing the ShowType table to EventType would be best as it's now used in the Event table. This'd help to avoid any confusion later on.
Another good idea....
Assuming Dave's last schema is used, I think adding an EndTime field to the Show table could be of use (and renaming the ShowTime to StartTime) so that people knew the Show length. Or a ShowLength field could be used instead, in conjunction with the ShowTime (start time).
Could definitely be a future enhancement (like the pop-up window to select artists. Great idea, but not key to functionality.
Also, it may be of use to add some kind of history audit to the Shows/Events tables, so that if an Event is moved to another Venue or Cancelled then this too can be listed.