create table leverancier ( lev_code number(15) constraint c_t_leverancier_pk_lev_code primary key, naam varchar2(30) not null constraint c_t_leverancier_un_name unique, straat varchar2(30) not null, postcode varchar2(7) not null, plaats varchar(30) not null );