formula1.sql

formula1.sql

create table Team( 
id integer,
name text,
country text,
primary key (id)
);

create table Car(
id integer,
carNumber integer,
weight integer,
maxSpeed integer,
team_id integer,
primary key(id),
foreign key(team_id) references team(id)
);

create table Pilot(
id integer,
name text,
birthdate integer,
country text,
car_id integer,
primary key(id),
foreign key(car_id) references car(id)
);

create table Race(
id integer,
date date,
numberOfLaps integer,
circuit_id integer,
primary key(id),
foreign key(circuit_id) references Circuit(id)
);

create table Participation( 
startingPosition integer,
finalPosition integer,
pilot_id integer,
race_id integer,
foreign key (pilot_id) references pilot(id),
foreign key (race_id) references race(id),
PRIMARY key(startingPosition,finalPosition)
);

create table Circuit( 
id integer,
city text,
country text,
distance integer,
primary key (id)
);