create table download
( downloadno                            number(7) primary key,
  dmodelno                              number(6) references models,
  dsetno                                number(9) references sets,
  dstatus                               char(1),
  dtype                                 char(1),
  dsite                                 varchar2(20) not null,
  dkey                                  varchar2(30),
  dsetkey                               varchar2(40),
  dsetname                              varchar2(240),
  dsetflag                              char(1),
  dnotes                                varchar2(240),
  durl                                  varchar2(240),
  darchive                              varchar2(240),
  dsignature                            varchar2(82),
  dsize                                 number(9),
  dpulled                               date,
  dadded                                date,
  damended                              date
);