TABLE  ExternalProduct

Contains details of external products imported into archive

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

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

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme 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' 
Total length650