Tango.info events: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(22 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
*what do we need for an event calendar | [[Category:Tango.info]] | ||
*what do we need for an event [[calendar]] | |||
==tables== | see also: [[tango.info wiki calendar]] | ||
==new system - tables== | |||
===venues=== | ===venues=== | ||
*venue_id | |||
*...adress | |||
===user=== | ===user=== | ||
* | *user_name | ||
* | *user_pass | ||
=== | |||
===event_group=== | |||
festival, workshop weekend ... | 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 | :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== | ==new system - actions== | ||
*user must be able to create new event | *user must be able to create new event | ||
*input form must be connected with existing data | *input form must be connected with existing data | ||
==See also== | |||
* [[tango.info event code]] |
Latest revision as of 2013-06-10T11:09:09
- 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