Tango.info events: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
(tango.info wiki calendar)
Line 2: Line 2:
*what do we need for an event calendar
*what do we need for an event calendar


see also: [[data.tango.info_wikicalendar]]
see also: [[tango.info wiki calendar]]


==new system - tables==
==new system - tables==

Revision as of 2008-10-26T19:51:07

  • what do we need for an event calendar

see also: tango.info wiki calendar

new system - 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

new system - actions

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