Вход на сайт
my SQL
765 просмотров
Перейти к просмотру всей ветки
в ответ akidervish 26.05.21 13:14
CREATE TABLE flightexecution (
flight_no varchar(7) NOT NULL,
departure_date_time_utc timestamp NOT NULL,
icao_code_origin varchar(4) NOT NULL,
icao_code_destination varchar(4) NOT NULL,
plane_id int NOT NULL,
flight_duration_minutes int NOT NULL,
PRIMARY KEY (flight_no,departure_date_time_utc),
FOREIGN KEY (plane_id) REFERENCES plane (id),
FOREIGN KEY (icao_code_origin) REFERENCES airport (icao_code),
FOREIGN KEY (icao_code_destination) REFERENCES airport (icao_code)
) ;