create table conn
( centryno                      number(9) primary key,
  cgroup                        number(6),
  corder                        number(3),
  cflag                         char(1),
  cstatus                       char(1),
  cmodelno                      number(6) references models,
  csetno                        number(9) references sets,
  cphotog                       varchar2(6) references photographer,
  ctype                         varchar2(20) not null,
  cdesc                         varchar2(80),
  ccomments                     varchar2(240),
  cpath                         varchar2(160)
  cadded                        date,
  camended                      date
);