_gwm_group_schedule_member - GolfWithMe/Master GitHub Wiki

+--------+---------+------+-----+---------+----------------+
| Field  | Type    | Null | Key | Default | Extra          |
+--------+---------+------+-----+---------+----------------+
| id     | int(11) | NO   | PRI | NULL    | auto_increment |
| gsid   | int(11) | NO   |     | NULL    |                |
| memid  | int(11) | NO   |     | NULL    |                |
| status | int(2)  | NO   |     | NULL    |                |
+--------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

id

unique id generated for every record

gsid

ID of event or date of event

memid

Member id

status

status of schedule entry for member

• 0 - default when entered into the table, means no response yet
• 1 - Member accepted the date /time
• 2 - Member rejected or event cancelled
• 3 - Added to indicate closed so it does not show up on the waiting for response list after it is closed.