Teams - netnutmike/subracetracker GitHub Wiki

Description

This table holds the details of each Team.

Field Descriptions

uid

The unique record ID

TeamName

This field will hold the name of the team as displayed in the team name areas.

SchoolName

This is the name of the school or organization that is represented by this team.

SubName

This is the name of the submarine.

Status

This is the status of the team / Sub. For sure there should be In the Water and Out of the Water, there could be many other possible statuses. The list of statuses come from the list table so new statuses can be easily added.

Lane

This is an integer that indicated which lane this sub is currently in.

Class

This is a value from the lists table that indicated the class or design category for the sub.

Notes

Free form field for notes for the team.

Table Layout

+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| uid        | int(11)     | NO   | PRI | NULL    | auto_increment |
| TeamName   | varchar(50) | YES  |     | NULL    |                |
| SchoolName | varchar(50) | YES  |     | NULL    |                |
| SubName    | varchar(50) | YES  |     | NULL    |                |
| Status     | int(11)     | YES  |     | NULL    |                |
| Lane       | int(11)     | YES  |     | NULL    |                |
| Class      | int(11)     | YES  |     | NULL    |                |
| Notes      | text        | YES  |     | NULL    |                |
| BestSpeed  | float       | YES  |     | NULL    |                |
| BestRunID  | int         | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Creation Script

create table Teams (uid int auto_increment, TeamName varchar(50), SchoolName varchar(50), SubName varchar(50), Status int, Lane, int, Class int, Notes text, BestSpeed float, BestRunID int, primary key(uid));