database

Tables (6)

car

  • car_id (car id) — INT — Primary key — NOT NULL
  • team_id (team id) — INT — Foreign key → team.team_id — NOT NULL
  • lap_time (lap time) — DATETIME
  • fuel — DATETIME

driver

  • driver_id (driver id) — INT — Primary key — NOT NULL
  • team_id (team id) — INT — Foreign key → team.team_id — NOT NULL
  • gender — DATETIME
  • nation (naion) — DATETIME
  • brith_date (brithday) — DATETIME

race

  • race_id (race id) — INT — Primary key — NOT NULL
  • race_nm (race name) — DATETIME
  • start_dt (start_date) — DATETIME
  • location — DATETIME
  • mail (Field) — DATETIME

repair

  • repair_id (repair id) — INT — Primary key — NOT NULL
  • car_id (car id) — INT — Foreign key → car.car_id — NOT NULL
  • itme (item) — DATETIME

result

  • result_id (result id) — INT — Primary key — NOT NULL
  • driver_id (driver id) — INT — Foreign key → driver.driver_id — NOT NULL
  • race_id (race id) — INT — Foreign key → race.race_id — NOT NULL
  • team_id (team id) — INT — Foreign key → driver.team_id — NOT NULL
  • grade — DATETIME
  • retirement_yn (retirement yn) — DATETIME
  • reason — DATETIME
  • Field — DATETIME

team

  • team_id (team id) — INT — Primary key — NOT NULL
  • adress — DATETIME
  • adress _dtl (adress detail) — DATETIME
  • road_nm (road name) — DATETIME
  • Field — DATETIME