TABLE ProductLinks

Contains links between different products, e.g. tiles and stacks, mosaics and tiles, mosaics and stacks

This table contains the combined productID and the intermediate productIDs that go into it

Required constraints:
Primary key is (programmeID,combiProductID,intProductID,combiProdType,intProdType)
(programmeID) references Programme(programmeID)

Name Type Length Unit Description Default Value Unified Content Descriptor

programmeID int 4 the unique programme ID meta.id

combiProductID int 4 Product ID of combination frame ??

intProductID int 4 Product ID of intermediate frame ??

combiProdType varchar 8 Type (stack,tile,mosaic) of combination frame ??

intProdType varchar 8 Type (stack,tile,mosaic) of intermediate frame ??

Total length 28

Name	Type	Length	Description	Unified Content Descriptor
programmeID	int	4	the unique programme ID	meta.id
combiProductID	int	4	Product ID of combination frame	??
intProductID	int	4	Product ID of intermediate frame	??
combiProdType	varchar	8	Type (stack,tile,mosaic) of combination frame	??
intProdType	varchar	8	Type (stack,tile,mosaic) of intermediate frame	??
Total length		28