Tango.info events

• what do we need for an event calendar

tables

venues

• venue_id
• ...adress

user

• user_name
• user_pass

event_group

festival, workshop weekend ...

• event_group_id
• event_group_city? if venue not known

event_group_venue

• normally should be in events_venues, but sometimes you may know the venues, but not the specific events that take place there. Which wrokshops of a festival will be in which place....
• event_group_id
• venue_id

event_venue

• event_id
• venue_id

event

• event_id
• time_start
• time_end

if you have a venue, e.g. "Dt.Theater" for a festival, but don't know yet when the events will take place there (milonga saturday or sunday) then specify event without time but with venue and connect that event to the eventgroup

actions

• user must be able to create new event
• input form must be connected with existing data