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 |