Options - netnutmike/subracetracker GitHub Wiki

Description

This table holds the options for the races.

Field Descriptions

uid

The unique record ID

Zipcode

This is the Zipcode where the race is taking place.

FPS

The Frames Per second on the cideo recording.

MeasureMethod

1 = Metric, 2 = Imperial

Total Distance

Total distance from start to finish

Time1Distance

Distance from Start to first timing line.

Time2Distance

Distance from Start to second timing line.

Time3Distance

Distance from Start to third timing line.

Time4Distance

Distance from Start to fourth timing line.

Table Layout

+---------------+-------------+------+-----+---------+----------------+
| Field         | Type        | Null | Key | Default | Extra          |
+---------------+-------------+------+-----+---------+----------------+
| uid           | int(11)     | NO   | PRI | NULL    | auto_increment |
| Zipcode       | varchar(10) | YES  |     | NULL    |                |
| FPS           | int(11)     | YES  |     | NULL    |                |
| MeasureMethod | int(11)     | YES  |     | NULL    |                |
| TotalDistance | int(11)     | YES  |     | NULL    |                |
| Time1Distance | int(11)     | YES  |     | NULL    |                |
| Time2Distance | int(11)     | YES  |     | NULL    |                |
| Time3Distance | int(11)     | YES  |     | NULL    |                |
| Time4Distance | int(11)     | YES  |     | NULL    |                |
+---------------+-------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

Creation Script

create table Options (uid int auto_increment, Zipcode varchar(10), FPS int, MeasureMethod int, TotalDistance int, Time1Distance int, Time2Distance int, Time3Distance int, Time4Distance int, primary key(uid));