Welcome to Checkered Past...your race data pipeling

Database Description | MySQL | 'racing'

Table html - Contains boilerplate html for web pages and other (non-html) configuration data.

Field Home_Club | varchar(100) | No Null
Each record of this table contains a seperate webpage design.
This field distinguishes one design from another.
Field Head | text | No Null
First part of the html page code that typically repeats on every page.
Field Tail | varchar(500) | NULL
Last part of the html page code that typically repeats on every page.
Field Menu_Top | text | NULL
First part of the html menu code that typically repeats on every page.
Field Menu_Bottom | text | NULL
Last part of the html menu code that typically repeats on every page.
Spliting the menu is useful when unique menu items are used on some pages.
Field Car_Classes | text | NULL
Current list of car classes in PHP serialized form.
Field Heat_Size | text | NULL
Current list of maximum Heat race sizes in PHP serialized form.
Car_Class => Heat_Max
Field Main_Size | text | NULL
Current list of maximum Main race sizes in PHP serialized form.
Car_Class => Main_Max
Field Club_Array | text | NULL
Current list of participating clubs in PHP serialized form.
Used to create a selectable list of clubs for visitor's registration.
Field Race_Name | text | NULL
Current list of race names (ie A Main, Trophy Dash, Qualification, etc.) in PHP serialized form.

Table events - Each event is typically a collection of races.

Field Event_Num | smallint(5) | unsigned | No Null | auto_increment
Identifying number for the event.
Assigned by the database automatically.
Field Event_Date | date | No Null
Beginning date of the event in numbers of form yyyy-mm-dd
Field Thru_Date | date | No Null | default: '0000-00-00'
Last day of the event in numbers of form yyyy-mm-dd
Field Description | text | No Null
Brief descriptive title of the event.
This text will be linked with the web address recorded in the URL field.
Field URL | varchar(200) | NULL
Web address which will be linked to the Description.
Field Home_Club | varchar(100) | No Null
Allows events for several clubs to be recorded in one table.
Field Event_Scope | varchar(50) | NULL
Examples of event scope: Local, Region, National, N/A
The choices for event scope are embedded in the script.
Field Location | varchar(100) | No Null | default: 'Home Track'
Field Jr_Novice | Text | NULL
This is an example of fields created to hold driver's registration in each class.
There will be a field for each car class in the current configuration.
If it did not previously exist, it will be created by the 'Edit Current Configuration' : 'Car Classes' action.
Driver_ID => pill_number in PHP serialized form.

Table drivers

Field Driver_ID | smallint(5) | unsigned | No Null | auto_increment
Identifying number for the driver.
Assigned by the database automatically.
Field First_Name | varchar(30) | No Null
Field Last_Name | varchar(30) | No Null
Field Birthday | date | NULL
Uses numbers of form yyyy-mm-dd
Field Race_Points | text | NULL
Contains the current list of points earned by race in PHP serialized form.
Race_ID => points
Field Car_Class | text | NULL
Contains the current list of car classes by race in PHP serialized form.
Race_ID => Car_Class
Field Home_Club | varchar(20) | No Null | default: 'I-5'
Identifies the home club of the driver.

Table race

Field Race_ID | smallint(7) | unsigned | No Null | auto_increment
Identifying number for the race.
Assigned by the database automatically.
Field Type | varchar(30) | No Null
The scope of each event (ie Club Points, Region, N/A, etc.)
Choices for event scope are embedded in the script.
Field Race_Class | varchar(30) | No Null
Field Status | varchar(30) | No Null
The race name (ie Heat 1, A Main, Trophy Dash, etc.)
Field Race_Date | date | No Null
Field Results | text | NULL
html for a table showing the results of a single race.
Field Results_Array | text | NULL
Race results in PHP serialized form.
Driver_ID => finish_position

Table validate

Home_Club

Mode