TABLE  ExternalProduct

Contains details of external products imported into archive

This table contains details of product sets that are imported into the
VSA from an external group, to be used by the VSA.

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID meta.id
productTypevarchar16 The product type within the imported directory ??
descriptionvarchar256 Description of the product set ??
institutionvarchar256 Name of the institution that created the product ??
creatorvarchar32 Name of the individual that created the product ??
releaseNumsmallint2 Release number of deep stack frame (or intermediate stack if used as a deep stack).-9999 
directoryvarchar32 Name of directory which these data reside in  
fileNameRootvarchar32 File name root of the products  
zeroPointreal4 Zeropoint of each product-0.9999995e9 
zpSystemvarchar16 System of zeropoint (Vega/AB)'NONE' 
sqlSchemaFilevarchar32 Relative path of the schema file containing the table description that the data will be ingested into if necessary'NONE' 
tableNamevarchar32 Name of the table that the data will be ingested into if necessary'NONE' 
sourceMatchedtinyint1 Does the main ID of the table have an exact 1 - 1 match with the source table0 
referencevarchar64 Reference paper describing the dataNONE 
productIDint4 unique productID over all programmes meta.id;meta.main
Total length783