TABLE ExternalProductCatalogue

Contains original files imported

This table contains original files imported in external directory

Required constraints:
Primary key is (productID,fileName)
(productID) references ExternalProduct(productID)

Name Type Length Unit Description Default Value Unified Content Descriptor

programmeID int 4 the unique programme ID meta.id

productID int 4 unique productID over all programmes meta.id;meta.main

fieldID varchar 16 ID of field NONE meta.id

fileName varchar 128 Filename of file sent from survey team

versNum int 4 Version of file sent from survey team

isIngested tinyint 1 Has been ingested? 0 NO 1 Yes

centralRa float 8 deg Central right-ascension of field -0.9999995e9

centralDec float 8 deg Central declination of field -0.9999995e9

Total length 173

Name	Type	Length	Unit	Description	Default Value	Unified Content Descriptor
programmeID	int	4		the unique programme ID		meta.id
productID	int	4		unique productID over all programmes		meta.id;meta.main
fieldID	varchar	16		ID of field	NONE	meta.id
fileName	varchar	128		Filename of file sent from survey team
versNum	int	4		Version of file sent from survey team
isIngested	tinyint	1		Has been ingested? 0 NO 1 Yes
centralRa	float	8	deg	Central right-ascension of field	-0.9999995e9
centralDec	float	8	deg	Central declination of field	-0.9999995e9
Total length		173