WACS: Database Schemas

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 );