TABLE  ExternalProduct

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)

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
programmeID	int	4		the unique programme ID		meta.id
productType	varchar	16		The product type within the imported directory		??
description	varchar	256		Description of the product set		??
institution	varchar	256		Name of the institution that created the product		??
creator	varchar	32		Name of the individual that created the product		??
releaseNum	smallint	2		Release number of deep stack frame (or intermediate stack if used as a deep stack).	-9999
directory	varchar	32		Name of directory which these data reside in
fileNameRoot	varchar	32		File name root of the products
zeroPoint	real	4		Zeropoint of each product	-0.9999995e9
zpSystem	varchar	16		System of zeropoint (Vega/AB)	'NONE'
sqlSchemaFile	varchar	32		Relative path of the schema file containing the table description that the data will be ingested into if necessary	'NONE'
tableName	varchar	32		Name of the table that the data will be ingested into if necessary	'NONE'
sourceMatched	tinyint	1		Does the main ID of the table have an exact 1 - 1 match with the source table	0
reference	varchar	64		Reference paper describing the data	NONE
productID	int	4		unique productID over all programmes		meta.id;meta.main
Total length		783