_gwm_event_responses - GolfWithMe/Master GitHub Wiki

Description

This table holds the responses to a GWM request. It links to a date/time entry. The existence of a record indicates that the invitee has checked this date/time. The absence of a record indicates that the user has not select a particular date/time.

Field Descriptions

uid

The unique record ID

EventID

This is the uid from the _gwm_event record that these times relate to.

ResponderID

This is the Jooma user ID of the user that is responding to the request.

EventTimeID

This is the uid of the _gwm_event_times record.

FinalSelection

If this record links to the final selection record then this value will be true. This value can be used to display notifications and show on future calendars.

Table Layout

+----------------+---------+------+-----+---------+----------------+
| Field          | Type    | Null | Key | Default | Extra          |
+----------------+---------+------+-----+---------+----------------+
| uid            | int(11) | NO   | PRI | NULL    | auto_increment |
| EventID        | int(11) | YES  |     | NULL    |                |
| ResponderID    | int(11) | YES  |     | NULL    |                |
| EventTimeID    | int(11) | YES  |     | NULL    |                |
| FinalSelection | int(11) | YES  |     | NULL    |                |
+----------------+---------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Creation Script

create table _gwm_event_responses (uid int auto_increment, EventID int, ResponderID int, EventTimeID int, FinalSelection int, primary key(uid));