Comparing versions
Version 1Current version

Proposed Table Changes


EVENTS TABLE

event_id
content_id
title
body
description
start_time
end_time
recurance
daily
weekly
monthly
yearly
location (text)
lat - Geo Package
lng - Geo Package
category - Pigeonholes Package
comments - Liberty Package
invite_guests - T/F
image
url
permissions

GUESTLIST TABLE

event_id
name
email_address
status

NOTE: Most of this could be implemented quickly, but guest stuff might come later as the security requirements and making use of email might be beyond my abilities. -wjames5


 
Events are a complicated thing. This page is a resource for brainstorming and planning a professional events package for bitweaver. Please feel free to append ideas, resources, or whatever else may make an events package better.

While this page defines the needs or a possible new implementation for an event calendar system, also have a look at CalendarResearch for an evaluation of existing solutions.


People Thinking and Working On This

If you want to join the fun on a very dedicated level so as to see implemention of this through to reality, add your name or handle here with a method of contact.
wjames5: wjames5-at-nyc.rr.com
michael dean: mdean@sourceview.com
phoenixandy: andy at andystanford dot me dot uk

Big Issues

  • Event Recurrance
    See the first comment by James at the bottom of this page
  • Invitation and Viewing Permissions Management
  • Notification Management

Possible Table Changes

EVENTS TABLE

event_id
content_id
title - Liberty Package
body/data - Liberty Package
description
start_time
end_time
recurance (will take a stringe of days 0-7, weeks, months, years)
location (text)
lat - Geo Package
lng - Geo Package
category - Pigeonholes Package
comments - Liberty Package
invite_guests - T/F
image
url
permissions - Liberty Package

GUESTLIST TABLE

event_id
name
email_address
status

NOTE: The above tables include fields which might be covered by other packages and thus not really be in the table. They are noted with their dependent package.

Additional References


Page History
Date/CommentUserIPVersion
14 Jun 2007 (20:37 UTC)
link EventsPackage
laetzer85.178.55.11613
Current • Source
hiran85.233.40.19211
View • Compare • Difference • Source
hiran85.233.40.19210
View • Compare • Difference • Source
sourceview64.81.71.309
View • Compare • Difference • Source
Will68.174.111.478
View • Compare • Difference • Source
Will68.174.111.477
View • Compare • Difference • Source
Will68.174.111.476
View • Compare • Difference • Source
Will68.174.111.475
View • Compare • Difference • Source
Will68.174.111.474
View • Compare • Difference • Source
Will68.174.111.473
View • Compare • Difference • Source
Will68.174.111.472
View • Compare • Difference • Source
Will68.174.111.471
View • Compare • Difference • Source