Akina, это не случайная запись, а поднятие конкретной записи из БД. name - primary, потому что по этому полю происходит идентификатция данных во внешнем сервисе и запись должна быть уникальной
| Код |
create table flights
(
name varchar(255) not null,
origin_airport_id smallint(5) unsigned not null,
destination_airport_id smallint(5) unsigned not null,се
airline_id smallint(5) unsigned not null,
updated_at timestamp default CURRENT_TIMESTAMP not null,
constraint flights_number_name_uindex
unique (name),
constraint flights_airlines_id_fk
foreign key (airline_id) references airlines (id)
on update cascade on delete cascade,
constraint flights_number_destination_airport_id_fk
foreign key (destination_airport_id) references airports (id)
on update cascade on delete cascade,
constraint origin_airports_id_fk
foreign key (origin_airport_id) references airports (id)
on update cascade on delete cascade
)
;
create index airline_id
on flights (airline_id)
;
create index destination_airport_id
on flights (destination_airport_id)
;
create index origin_airport_id_destination_airport_id
on flights (origin_airport_id, destination_airport_id)
;
alter table flights
add primary key (name)
;
|
|
)
