_gwm_event_invites - GolfWithMe/Master GitHub Wiki

Description

This table holds the list of invitees to events. There is one record for each invitee for each event.

Field Descriptions

uid

The unique record ID

EventID

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

ResponderID

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

Table Layout

+-----------+---------+------+-----+---------+----------------+
| Field     | Type    | Null | Key | Default | Extra          |
+-----------+---------+------+-----+---------+----------------+
| uid       | int(11) | NO   | PRI | NULL    | auto_increment |
| EventID   | int(11) | YES  |     | NULL    |                |
| InviteeID | int(11) | YES  |     | NULL    |                |
+-----------+---------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

Creation Script

create table _gwm_event_invites (uid int auto_increment, EventID int, InviteeID int, primary key(uid));