create table assoc 
( assocno                       number(9) primary key,
  amodelno                      number(6) references models,
  asetno                        number(9) references sets,
  astatus                       char(1),
  aadded                        date,
  aamended                      date
);