내공 많이..

<몇개는 생략하고>

create table cigarette  (goods_id varchar(5),   name varchar(20) not null,   cost varchar(10),   storage varchar(3) ,   primary key (goods_id)  ); create table drink  (goods_id varchar(5),   name varchar(20) not null,   cost varchar(10),   storage varchar(3) ,   primary key (goods_id)  ); create table snack  (goods_id varchar(5),   name varchar(20) not null,   cost varchar(10),   storage varchar(3) ,   primary key (goods_id)  );

create table carry  (goods_id varchar(5),   number varchar(3) ,   primary key (goods_id),  foreign key (goods_id) references cigarette (goods_id),  foreign key (goods_id) references drink (goods_id),  foreign key (goods_id) references snack (goods_id)  );

insert into carry values ('CI-06', '10'); insert into carry values ('SI-01', '5'); insert into carry values ('SN-02', '20'); insert into carry values ('SN-03', '2'); insert into carry values ('CI-04', '4'); insert into carry values ('SI-05', '6'); insert into carry values ('SI-02', '12'); insert into carry values ('CI-03', '6'); insert into carry values ('SN-04', '5');

이런식인데

자꾸 이런 에러가 뜹니다. 

도움 부탁드립니다.