database logic

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Tables for events and event_instances can handle this. If you have multiple instances of the same event at the same venue, just create a new event_instances row for each.

However, you'd now want to create a separate venues table since venue data would be shared by several instances - a one-venue-to-many-event_instances relationship.
Post Reply