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