_gwm_notifications - GolfWithMe/Master GitHub Wiki

Description

This table holds notifications of public golf with me requests and the members they are for. This table is sued to build the you might be interested list.

Field Descriptions

uid

The unique record ID

RequestID

This is the unique record ID for the public request.

MemberID

This is the unique member id of the member that this notification is for.

Status

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

• Disabled (0) - happens if an event is deleted or date selected. Can be deleted.
• New (1)
• Ignored (2)
• Past (To be deleted) (3)

Table Layout

+-----------+---------+------+-----+---------+----------------+
| Field     | Type    | Null | Key | Default | Extra          |
+-----------+---------+------+-----+---------+----------------+
| uid       | int(11) | NO   | PRI | NULL    | auto_increment |
| RequestID | int(11) | YES  |     | NULL    |                |
| MemberID  | int(11) | YES  |     | NULL    |                |
| Status    | int(11) | YES  |     | NULL    |                |
+-----------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Creation Script

create table akzwy_gwm_notifications (uid int auto_increment, RequestID int, MemberID int, Status int, primary key(uid));