erd
Tables (11)
circuit_tbl
- circuit_id — varchar — Primary key — NOT NULL
- circuit_name — varchar — NOT NULL
- locality — varchar — NOT NULL
- country — varchar
constructor_tbl
- constructor_id — varchar — Primary key — NOT NULL
- name — varchar — NOT NULL
- nationality — varchar — NOT NULL
constructorstanding_tbl
- season — int — Primary key — NOT NULL
- round — int — Primary key
- constructor_id — varchar — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- constructor_id — varchar — Foreign key → constructor_tbl.constructor_id
- position — int
- position_text — varchar
- points — int
- wins — int
driver_tbl
- driver_id — varchar — Primary key
- permanent_num — int
- given_name — varchar
- family_name — varchar
- date_of_birth — date
- nationality — varchar
driverstanding_tbl
- season — int — Primary key
- round — int — Primary key
- driver_id — varchar — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- driver_id — varchar — Foreign key → driver_tbl.driver_id
- constructor_id — varchar — Foreign key → constructor_tbl.constructor_id
- constructor_id — varchar
- position — int
- position_text — varchar
- points — int
- wins — int
lap_tbl
- lap_num — int — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- driver_id — varchar — Foreign key → driver_tbl.driver_id
- lap_time — varchar
pitstop_tbl
- ps_stop — int — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- driver_id — varchar — Foreign key → driver_tbl.driver_id
- ps_lap — int — NOT NULL
- ps_time — time
- ps_duration — varchar
qualifying_tbl
- season — int — Primary key
- round — int — Primary key
- driver_id — varchar — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- driver_id — varchar — Foreign key → driver_tbl.driver_id
- constructor_id — varchar — Foreign key → constructor_tbl.constructor_id
- constructor_id — varchar
- position — int
- q1_time — varchar
- q2_time — varchar
- q3_time — varchar
race_session_tbl
- session_id — int — Primary key
- season — int — Foreign key → race_tbl.season — NOT NULL
- round — int — Foreign key → race_tbl.round — NOT NULL
- session_type — varchar
- session_date — date
- session_time — time
race_tbl
- season — int — Primary key — NOT NULL
- round — int — Primary key — NOT NULL
- circuit_id — varchar — Foreign key → circuit_tbl.circuit_id
- race_name — varchar — NOT NULL
- circuit_id — varchar
- race_date — date
- race_time — time
result_tbl
- season — int — Primary key — NOT NULL
- round — int — Primary key — NOT NULL
- driver_id — varchar — Primary key
- season — int — Foreign key → race_tbl.season
- round — int — Foreign key → race_tbl.round
- driver_id — varchar — Foreign key → driver_tbl.driver_id
- constructor_id — varchar — Foreign key → constructor_tbl.constructor_id
- constructor_id — varchar
- grid — int
- laps — int
- position — int
- position_text — varchar
- points — int
- status — varchar
- race_time — varchar
- fastest_lap_rank — int
- fastest_lap_num — int
- fastest_lap_time — varchar
- is_sprint — boolean