Database structure

 

 

 

The following drawing displays table links with identifier and foreign keys. Caution: do not alter the database integrity by doing direct changes. That may cause UR30 to hang.

 

 

 

Table

Description

Circuit

Contains all circuit details

Hardware

Hardware and events parameters of each circuit managed in the database

Lane

Circuit lanes with attributes. Linked to corresponding circuit.

Driver

List of all drivers and their characteristics

SlotCar

List of all slot cars

Maintenance

Slot car maintenance task list

Race

All completed races. Races with temporary drivers or slot cars are automatically removed from the database

Lap

Race laps with their statistics

Scores

Scores awarded during a race and linked to the corresponding lap

Tournament

On going and completed tournaments

Administration

Administrative data