WACS: Database Schemas

Database Schemas: Contents

Download Table

This is the download table - directly below is the sample SQL command to create it and below that details of the fixed values for each of the short fields. There are a lot of statuses I know, but they each do mean something different; for instance an error set is kept around such that a future auto-generated pull list realises we have already seen that set and doesn't just pull it again as it would if we didn't keep it around.

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

Defined Values For The Download Table

Values For Short Fields In Download Table
dstatus	U	Not yet attempted
	F	Failed - Retry
	S	Successful - in database
	P	Pending - awaiting unpacking
	A	Aborted - don't download for some reason
	D	Deferred - held back from being downloaded
	R	Relationship Entry - a second model for a set
	L	Liasion - a proto-Relationship Entry not yet linked
	E	Error - not the right model, etc
dtype	I	Image Set
	V	Video Clip
	A	Audio File
dsetflag	see sets	Suggested value for scatflag based on parsing result

Previous Schema: Assoc Next Schema: Photographer
Back to Schema Overview Next Section: Futures
Back to WACS Documentation Index