_gwm_member_ratings - GolfWithMe/Master GitHub Wiki

Description

This table holds the ratings given by one golfer of another golfer.

Field Descriptions

uid

The unique record ID

MemberID

This is the Joomla user id.

RatedMemberID

This is the Jooma user id of the member that is being rated.

Rating

This is a 0 to 5 rating with a single decimal place.

TimeStamp

This is the timestamp when the rating was recorded.

EventID

The id of the event if there was one associated with the rating.

CourseID

The id of the course where the event took place, if there was one.

EventDate

This is the date of the event if the rating was attached to an event.

Table Layout

+---------------+----------+------+-----+---------+----------------+
| Field         | Type     | Null | Key | Default | Extra          |
+---------------+----------+------+-----+---------+----------------+
| uid           | int(11)  | NO   | PRI | NULL    | auto_increment |
| MemberID      | int(11)  | YES  |     | NULL    |                |
| RatedMemberID | int(11)  | YES  |     | NULL    |                |
| Rating        | double   | YES  |     | NULL    |                |
| TimeStamp     | datetime | YES  |     | NULL    |                |
| EventID       | int(11)  | YES  |     | NULL    |                |
| CourseID      | int(11)  | YES  |     | NULL    |                |
| EventDate     | date     | YES  |     | NULL    |                |
+---------------+----------+------+-----+---------+----------------+
8 rows in set (0.01 sec)

Creation Script

create table _gwm_member_ratings (uid int auto_increment, MemberID int, RatedMemberID int, Rating double, TimeStamp datetime, EventID int, CourseID int, EventDate date, primary key(uid));