ParticipantHistory - netnutmike/subracetracker GitHub Wiki

Description

This table holds the details of each Team.

Field Descriptions

uid

The unique record ID

TeamID

The unique record id of the team.

ParticipantID

The unique record id of the participant.

Action

This is the id of the action. For example, in the water could be 1 and out of the water could be 2. Additional things could be tracked like when an air tank is changed, etc. This value comes from the list table.

TrackedTime

This is a calculated time when a diver leaves the water, the time they went in will be used to record the amount of time they were in the water. This information can be used for reporting stats.

Timestamp

The data and time the entry was recorded.

RaceID

If the action is associated with a race, this is the raceID of the race.

Table Layout

+---------------+---------+------+-----+---------+----------------+
| Field         | Type    | Null | Key | Default | Extra          |
+---------------+---------+------+-----+---------+----------------+
| uid           | int(11) | NO   | PRI | NULL    | auto_increment |
| TeamID        | int(11) | YES  |     | NULL    |                |
| ParticipantID | int(11) | YES  |     | NULL    |                |
| Action        | int(11) | YES  |     | NULL    |                |
| TrackedTime   | time    | YES  |     | NULL    |                |
| Timestamp     | datetime| YES  |     | NULL    |                |
| RaceID        | int(11) | YES  |     | NULL    |                |
+---------------+---------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Creation Script

create table ParticipantHistory (uid int auto_increment, TeamID int, ParticipantID int, Action int, TrackedTime time, Timestamp datetime, RaceID int, primary key(uid));