History of Events Package Overhauling Plan
!Proposed Table Changes
!!!EVENTS TABLE
event_id
content_id
title - Liberty Package
body/data - Liberty Package
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 - 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.
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 TABLE
event_id
content_id
title - Liberty Package
body/data - Liberty Package
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 - 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.
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