Participants - netnutmike/subracetracker GitHub Wiki

Description

This table holds the details of each Team.

Field Descriptions

uid

The unique record ID

DiverID

This is the ID # assigned to this diver.

TeamID

The unique record id of the team.

DiverName

The full name of the diver.

Status

This is the status of the diver. The status comes from the lists table. For sure 2 of the statuses would be in the water and out of the water. Other statuses could be injured, disqualified or whatever possible statuses there could be for a diver.

Table Layout

+------------------+-------------+------+-----+---------+----------------+
| Field            | Type        | Null | Key | Default | Extra          |
+------------------+-------------+------+-----+---------+----------------+
| uid              | int(11)     | NO   | PRI | NULL    | auto_increment |
| TeamID           | int(11)     | YES  |     | NULL    |                |
| DiverName        | varchar(50) | YES  |     | NULL    |                |
| Status           | int(11)     | YES  |     | NULL    |                |
| DiverID          | int(11)     | YES  |     | NULL    |                |
| RegistrationType | int(11)     | YES  |     | NULL    |                |
| Color            | int(11)     | YES  |     | NULL    |                |
| Title            | varchar(15) | YE   |     | NULL    |                |
+------------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

Creation Script

create table Participants (uid int auto_increment, DiverID int, TeamID int, DiverName varchar(50), Status int, RegistrationType int, Color int, Title varchar(15), primary key(uid));