create table flight ( route_code varchar2(6) primary key, source varchar2(60) not null, destination varchar2(60) not null, via varchar2(60), via2 varchar2(60), constraint c_name unique (source,destination,via,via2) ) /