无法在分配的表中添加外键约束

Question

create table assigned(
num int,
tripdate date,
PRIMARY KEY(num),
FOREIGN KEY(num) REFERENCES seats(num),
FOREIGN KEY(tripdate) REFERENCES trip(tripdate)
);
create table trip(
num int,
tripdate date,
meal varchar(50),
PRIMARY KEY(num,tripdate),
FOREIGN KEY(num) REFERENCES ticket(num)
);
create table seats(
aircraft_seats_id varchar(50),
num int,
class varchar(50),
PRIMARY KEY(aircraft_seats_id,num), 
FOREIGN KEY(aircraft_seats_id) REFERENCES aircraft(crafts_id)
);

创建桌椅( aircraft_seats_id瓦尔查尔(50(， 数字整数， 瓦尔查尔级(50(， 主键(aircraft_seats_id，数(， 外键(aircraft_seats_id(参考飞机(crafts_id( );

错误在分配的表中无法添加外键约束

Answer 1

你的陈述中有错别字。不能为主键和外键分配相同的名称。 注意：外键只是从另一个表中引用主数据库。