create table sets
( setno                 number(9) primary key,
  stype                 char(1) not null,
  sstatus               char(1) not null,
  sauto                 char(1),
  srating               char(1),
  sflag                 char(1),
  stechqual             number(2),
  svariety              number(2),
  svisits               number(2),
  sformat               varchar2(10),
  scodec                varchar2(40),
  stitle                varchar2(240),
  sofftitle             varchar2(240),
  sofficon              varchar2(160),
  saddicon              varchar2(160),
  sname                 varchar2(80),
  shair                 varchar2(80),
  smodelno              varchar2(40),
  slocation             varchar2(20),
  slocdetail            varchar2(40),
  sattire               varchar2(20),
  sphotog               varchar2(6) references photographer,
  ssource               varchar2(80),
  sfoundry              varchar2(80),
  sproddate             date,
  sreldate              date,
  suscattr              char(1),
  snotes                varchar2(240),
  sdesc                 varchar2(2048),
  sindexes              number(6),
  simages               number(6),
  sdurhrs               number(2),
  sdurmin               number(2),
  sdursec               number(2),
  slandx                number(6),
  slandy                number(6),
  sportx                number(6),
  sporty                number(6),
  saspect               varchar(10),
  sbytes                number(12),
  sdvdno                number(6),
  sdvddisc              number(2),
  sdvdtitle             number(3),
  sdvdstartch           number(3),
  sdvdendch             number(3),
  sidlogo               char(1),
  serrors               char(1),
  sduplicates           number(9),
  scatinfo              varchar2(160),
  scatflag              char(1),
  snamestem             varchar2(80),
  sdownload             varchar2(160),
  sarea                 varchar2(160),
  scategory             varchar2(160),
  sdirectory            varchar2(240),
  scomments             varchar2(240),
  sadded                date,
  samended              date
);

	Note
	sattire is a new field introduced into the schema in release 0.8.1; it comes into use in WACS 0.8.2. It will be scored using the other attribute of the keyword system.