TABLE RequiredCurationTask

Contains the matrix of programmes and required curation tasks.

This table specifies the required curation tasks for every programme
curated in the archive. In addition, a single curation task is
identified as the final one required to be run before that programme
data can be released. At the verification stage prior to release,
the timestamp of the curation task specified here is checked to make
sure that it has been executed most recently. Finally, the order in
which the curation tasks are to be executed for the given programme
are indicated in the attribute sequence (sequence numbers are spaced
out to allow for insertion of new tasks at a later date).

Required constraints:
Primary key is (programmeID,cuID)
(programmeID) references Programme(programmeID)
(cuID) references CurationTask(cuID)

Name Type Length Unit Description Default Value Unified Content Descriptor

programmeID int 4 the unique programme ID ID_SURVEY

cuID smallint 2 the unique curation task ID REFER_CODE

finalTask tinyint 1 is this task the final one before release (0=no; 1=yes)? ??

sequence smallint 2 Indicates the order in which the tasks are to be executed ??

Total length 9

Name	Type	Length	Description	Unified Content Descriptor
programmeID	int	4	the unique programme ID	ID_SURVEY
cuID	smallint	2	the unique curation task ID	REFER_CODE
finalTask	tinyint	1	is this task the final one before release (0=no; 1=yes)?	??
sequence	smallint	2	Indicates the order in which the tasks are to be executed	??
Total length		9