_gwm_event_times - GolfWithMe/Master GitHub Wiki

Description

This table holds the dates and times that the request creator selected for the invitees to select from.

Field Descriptions

uid

The unique record ID

EventID

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

Date

This is the date that the requester wants to be an option.

Time

This is the time that the requester wants to be an option.

Table Layout

+---------+---------+------+-----+---------+----------------+
| Field   | Type    | Null | Key | Default | Extra          |
+---------+---------+------+-----+---------+----------------+
| uid     | int(11) | NO   | PRI | NULL    | auto_increment |
| EventID | int(11) | YES  |     | NULL    |                |
| Date    | date    | YES  |     | NULL    |                |
| Time    | time    | YES  |     | NULL    |                |
+---------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Creation Script

create table _gwm_event_times (uid int auto_increment, EventID int, Date date, Time time, primary key(uid));