_gwm_profiles - GolfWithMe/Master GitHub Wiki

Description

This table holds the profile and preferences that are unique to Golf With Me.

Field Descriptions

uid

The unique record ID

MemberID

This is the unique Joomla ID for the member.

HomeCourse

This is the uid of the course that the member considers their home course.

Table Layout

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

Creation Script

create table _gwm_profiles (uid int auto_increment, MemberID int, FavoriteCourseID int, primary key(uid));