_gwm_group_schedule - GolfWithMe/Master GitHub Wiki

+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| id               | int(11)      | NO   | PRI | NULL    | auto_increment |
| selgroup         | int(11)      | NO   |     | NULL    |                |
| coursetype       | varchar(100) | NO   |     | NULL    |                |
| selcourse        | int(11)      | NO   |     | NULL    |                |
| picks            | varchar(50)  | NO   |     | NULL    |                |
| responses        | varchar(50)  | NO   |     | NULL    |                |
| notify           | varchar(100) | NO   |     | NULL    |                |
| uid              | int(11)      | NO   |     | NULL    |                |
| adate            | datetime     | NO   |     | NULL    |                |
| status           | int(2)       | NO   |     | NULL    |                |
| teetime          | varchar(100) | NO   |     | NULL    |                |
| SelectedDateTime | datetime     | YES  |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

id

Unique ID

selgroup

The group id for the golfing group

coursetype

This contains either Local, Favorites or search. Not sure why it is in here except maybe to go back and edit the request later.

selcourse

This is the course ID that was selected to play at.

picks

responses

notify

seems to have notify in the field if there is supposed to be a notification

uid

seems to be the member id

adate

the data and time added

status

Status code, still figuring out the status code meanings

• 1 is what it is when it is inserted
• 2 is set when it expires

teetime

The final teetime that was set

SelectedDateTime

does not look to be used