TABLE  ProgrammeTable

Contains details of the set of curated tables for each programme.

Within the archive, for any particular programme (eg. the UKIDSS LAS)
a number of tables are curated as a result of the relational model (eg.
single image detections, merged source lists, list-driven remeasurements).
This table records the names of those tables and various other
table-specific data concerning each table for each programme.


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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID ID_SURVEY
tableIDint4 the unique table ID ID_MAIN
tableNamevarchar256 the name of the table ID_TABLE
sourceIDNamevarchar256 the name of the source ID_TARGET
Total length520