TABLE  ProgrammeCurationHistory

Contains details of the matrix of programmes and required curation tasks.

This table contains details of the matrix of programmes and
required curation tasks; each time a curation task is run, this table
gets updated with timestamps indicating which programme(s) have been
affected by a curation process.

Required constraints:
  • Primary key is (programmeID,cuEventID)
  • (programmeID) references Programme(programmeID)
  • (cuEventID) references ArchiveCurationHistory(cuEventID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID ID_SURVEY
cuEventIDint4 UID of curation event giving rise to this record REFER_CODE
timeStampdatetime8UTCTime of individual programme curation completion TIME_DATE
statustinyint1 successful (1) or unsuccessful (0) CODE_MISC
Total length17