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