_gwm_group_membership - GolfWithMe/Master GitHub Wiki

Description

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

Field Descriptions

uid

The unique record ID

Table Layout

+-------------------+----------+------+-----+---------+----------------+
| Field             | Type     | Null | Key | Default | Extra          | 
+-------------------+----------+------+-----+---------+----------------+
| uid               | int(11)  | NO   | PRI | NULL    | auto_increment |
| GroupID           | int(11)  | YES  |     | NULL    |                |
| MemberID          | int(11)  | YES  |     | NULL    |                |
| LastPayment       | datetime | YES  |     | NULL    |                |
| NextPayment       | date     | YES  |     | NULL    |                |
| PaymentMethod     | int(11)  | YES  |     | NULL    |                |
| MemberType        | int(11)  | YES  |     | NULL    |                |
| LastPaymentAmount | float    | YES  |     | NULL    |                |
| LastPaidBy        | int(11)  | YES  |     | NULL    |                |
| NextPayBy         | int(11)  | YES  |     | NULL    |                |
| AutoRecurring     | int(11)  | YES  |     | NULL    |                |
+-------------------+----------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

Creation Script

create table _gwm_group_membership (uid int auto_increment, GroupID int, MemberID int, LastPayment datetime, NextPayment date, PaymentMethod int, MemberType int, LastPaymentAmount float, LastPaidBy int, NextPayBy int, AutoRecurring int, primary key(uid));