Name: Takahiro Kashihara
E-mail: tk515@columbia.edu
calendar
| Field name | type | description |
| event_id | int | every event is identified, by a unique id. |
| event_group_id | int | this id indicate which group event_id belongs to. NOT NULL |
| start_time | datetime | start time of the event |
| end_time | datetime | end time of the event |
| access | enum | access privileges for this event record, e.g., only creator, group or public. |
| description | text | textual description of the event. This is used when sending notification. |
event_resource
| event_id | int | |
| resource_id | int |
resource
| resource_id | int | every resource is identified, by a unique id. |
| resource_type | enum | resource type (this is necessary in order to distinguish room from the other resources |
| resource_name | varchar | resource name, which includes rooms and additional resources |
| resource_access | varchar | access privileges for resources, specially for rooms,
using "gwclass groups"(faculty, phd, staff... etc) |
| resource_availability | int | number of the resources available |
| resource_description | text | resource description and additional information |
event_notify
| event_id | int | |
| notify_id | varchar | return value from $ at <time> <script> |
| notify_target | varchar | target to send notification to, e.g., mailto:tk515@columbia.edu, or sip:tk515@columbia.edu. |
| notify_time | datetime | notify time of the event (Should be stored so that the creator can modify it) |
event_group
| Field name | type | description |
| event_group_id | int | this id indicate which group event_id belongs to. this is primary key for this table. |
| creator | varchar | user id of the creater, e.g., tk515@columbia.edu. This is also index in primary user table (put). |
| recurrence | varchar | describe recurring events, e.g., weekly, yearly, daily |
| group_description | text | textual description of the event group |
| dtstart | date | start time of this recurring event |
| dtend | date | end time of this recurring event |