create table notes
( nentryno                            number(9) primary key,
  ntype                               char(1),
  norder                              number(3),
  ntitle                              varchar2(80),
  ntext                               varchar2(2048),
  nstatus                             char(1),
  nnext                               number(9) references notes,
  nexpiry                             date,
  nmodelno                            number(6) references models,
  nsetno                              number(9) references sets,
  nphotog                             varchar2(6) references photographers,
  nconn                               number(6),
  ncomments                           varchar2(120),
  nadded                              date,
  namended                            date
);