Tango.info events: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 4: | Line 4: | ||
==tables== | ==tables== | ||
===venues=== | ===venues=== | ||
*venue_id | |||
*...adress | |||
===user=== | ===user=== | ||
*user_name | *user_name | ||
*user_pass | *user_pass | ||
===event_group=== | ===event_group=== | ||
festival, workshop weekend ... | festival, workshop weekend ... | ||
Line 12: | Line 16: | ||
*event_group_place | *event_group_place | ||
=== | ===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.... | *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 | *event_id | ||
*time_start | *time_start |
Revision as of 2008-05-10T15:09:21
- 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_place
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