CREATE TABLE Trains (
	number INT(3),
	make VARCHAR(64),
	capacity INT(5) NOT NULL,
	PRIMARY KEY(number)
);

CREATE TABLE Stations (
	name VARCHAR(64),
	PRIMARY KEY(name)
);

CREATE TABLE Lines (
	line VARCHAR(64),
	startS VARCHAR(64) NOT NULL,
	endS VARCHAR(64) NOT NULL,
	PRIMARY KEY(line),
	FOREIGN KEY(startS, endS) REFERENCES Stations(name)
);

CREATE TABLE isOn (
	station VARCHAR(64),
	line VARCHAR(64),
	PRIMARY KEY(station, line),
	FOREIGN KEY(station) REFERENCES Stations(name),
	FOREIGN KEY(line) REFERENCES Lines(line)
);

CREATE TABLE arrivals (
	train INT(3),
	station VARCHAR(64),
	time TIME,
	PRIMARY KEY(train, station, time),
	FOREIGN KEY(train) REFERENCES Trains(number),
	FOREIGN KEY(station) REFERENCES Stations(name)
);