create table aircraft ( acr_code varchar2(3) primary key, acr_number varchar2(30) not null unique, fir_code varchar2(1) not null, fir_class number(3) not null, exe_code varchar2(1) not null, exe_class number(3) not null, eco_code varchar2(1) not null, eco_class number(3) not null ) /