_gwm_courses - GolfWithMe/Master GitHub Wiki

Description

This table holds the details of each Golf Course.

Field Descriptions

uid

The unique record ID

Source

The source of where the data came from that created the record. Each source will have it's own unique ID.

SourceID

The unique ID of the record at the source. This will be used when going back to the source to get updates or during an import of updated data.

Name

The name of the Gold Course.

URL

The url to the webpage of the golf course.

MembershipType

The type of membership at the course.

Table Layout

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| uid            | int(11)      | NO   | PRI | NULL    | auto_increment |
| Source         | int(11)      | YES  |     | NULL    |                |
| SourceID       | int(11)      | YES  |     | NULL    |                |
| Name           | varchar(250) | YES  |     | NULL    |                |
| URL            | varchar(250) | YES  |     | NULL    |                |
| MembershipType | int(11)      | YES  |     | NULL    |                |
| Holes          | int(11)      | YES  |     | NULL    |                |
| LocalRank      | int(11)      | YES  |     | NULL    |                |
| LocalMaxRank   | int(11)      | YES  |     | NULL    |                |
| Address1       | varchar(100) | YES  |     | NULL    |                |
| Address2       | varchar(100) | YES  |     | NULL    |                |
| City           | varchar(100) | YES  |     | NULL    |                |
| State          | varchar(10)  | YES  |     | NULL    |                |
| Country        | varchar(100) | YES  |     | NULL    |                |
| ZipCode        | varchar(10)  | YES  |     | NULL    |                |
| Lat            | mediumtext   | YES  |     | NULL    |                |
| Lon            | mediumtext   | YES  |     | NULL    |                |
| Phone          | varchar(25)  | YES  |     | NULL    |                |
| Inserted       | datetime     | YES  |     | NULL    |                |
| Updated        | datetime     | YES  |     | NULL    |                |
| Status         | int(11)      | YES  |     | NULL    |                |
| HomeGroup      | int(11)      | YES  |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+
21 rows in set (0.00 sec)

Creation Script

create table gwm_courses (uid int auto_increment, Source int, SourceID int, Name varchar(250), URL varchar(250), MembershipType int, Holes int, LocalRank int, LocalMaxRank int, Address1 varchar(100), Address2 varchar(100), City varchar(100), State varchar(10), Country varchar(100), ZipCode varchar(10), Lat long, Lon long, Phone varchar(25), Inserted datetime, Updated datetime, Status int, primary key(uid));