_gwm_event - GolfWithMe/Master GitHub Wiki

Description

This table holds the details of each Golf With Me request.

Field Descriptions

uid

The unique record ID

RequesterID

The Joomla User ID

GroupID

The JomSocial GroupID

CourseID

This is the uid of the course that was selected.

MaxPicks

The maximum number of dates/times that someone can select, 0 means no limit

MaxResponses

This is the maximum number of people that can respond. For example, the request might go out to 10 people but you only need 3 to make a foursome. This would be set to 3 and the first 3 that respond would be able to respond, after thsoe 3 the request would not allow anyone else to respond.

Notify

This is the notify setting for this request.

Opened

This is a timestamp of when the request was created.

Closed

This is a timestamp of when the request was closed.

ResponseBy

This is a date that all responses need to be back by. At the end of the day of this date.

FinalDate

This is the final selected date when the request owner selects a date.

FinalTime

This is the final selected time when the request owner selects a time.

Status

This is the current status of the request. The list of available statuses has not yet been determined but some potential ones are:

• Closed
• In Response Mode
• Scheduled
• New

Table Layout

+--------------+------------+------+-----+---------+----------------+
| Field        | Type       | Null | Key | Default | Extra          |
+--------------+------------+------+-----+---------+----------------+
| uid          | int(11)    | NO   | PRI | NULL    | auto_increment |
| RequesterID  | int(11)    | YES  |     | NULL    |                |
| GroupID      | int(11)    | YES  |     | NULL    |                |
| CourseID     | int(11)    | YES  |     | NULL    |                |
| MaxPicks     | int(11)    | YES  |     | NULL    |                |
| MaxResponses | int(11)    | YES  |     | NULL    |                |
| Notify       | tinyint(1) | YES  |     | NULL    |                |
| Opened       | datetime   | YES  |     | NULL    |                |
| Closed       | datetime   | YES  |     | NULL    |                |
| ResponsBy    | date       | YES  |     | NULL    |                |
| FinalDate    | date       | YES  |     | NULL    |                |
| FinalTime    | time       | YES  |     | NULL    |                |
| Status       | int(11)    | YES  |     | NULL    |                |
+--------------+------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)`

Creation Script

create table _gwm_event (uid int auto_increment, RequesterID int, GroupID int, CourseID int, MaxPicks int, MaxResponses int, Notify bool, Opened datetime, Closed datetime, ResponsBy date, FinalDate date, FinalTime time, Status int, primary key(uid));