TABLE  RequiredTile

Contains details of default stack image products curated in the archive.

This table contains details of all the default image tile products that
are curated within the archive as part of the requirements for a
particular survey. For example, the VISTA-VIDEO is a deep stacked survey.
The stacking curation task implemented within the archive uses the
information in this table to produce the required stack(s) for a given
programme when invoked as part of archive operations.

Required constraints:
  • Primary key is (programmeID,productID)
  • (programmeID) references Programme(programmeID)
  • (filterID) references Filter(filterID)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID
productIDint4 A unique identifier assigned to each required stack product entry ??
namevarchar64 Name of the stacked product ??
descriptionvarchar256 Description of the product ??
filterIDtinyint1 UID of combined filter (assigned in VSA: 1=Z,2=Y,3=J,4=H,5=Ks) meta.code;instr.filter
rafloat8degreesRight Ascension of stack centre pos.eq.ra;meta.main
decfloat8degreesDeclination of stack centre pos.eq.dec;meta.main
nusteptinyint1 Amount of microstepping ??
stackRadiusreal4degradius within which intermediate stacks are selected for this deep stack.-0.9999995e9 
fieldIDint4 UID of position on sky.-99999999??
posAnglereal4degOrientation of image x-axis to N-S-0.9999995e9 
Total length358