_gwm_pay_history - GolfWithMe/Master GitHub Wiki

Description

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

Field Descriptions

uid

The unique record ID

GroupID

This is the unique ID for the JomSocial group that the payment was for.

MemberID

This is the Joomla member ID that the payment is for.

TimeStamp

This is the timestamp that the payment was made.

Amount

This is the amount that was paid.

PaymentMethod

This is the payment method used to make the payment for this transaction.

Type

This is the type of transaction that was made. It could be one of 3:

• Payment for themselves to join a group
• Payment for someone else to join a group, it could be for multiple people too
• A gift from someone else to join a group (from the item above this one)

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    |                |
| Timestamp     | datetime | YES  |     | NULL    |                |
| Amount        | float    | YES  |     | NULL    |                |
| PaymentMethod | int(11)  | YES  |     | NULL    |                |
| Type          | int(11)  | YES  |     | NULL    |                |
+---------------+----------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Creation Script

create table _pay_history (uid int auto_increment, GroupID int, MemberID int, Timestamp datetime, Amount float, primary key(uid));