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)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
programmeIDint4 the unique programme ID
combiProductIDint4 Product ID of combination frame ??
intProductIDint4 Product ID of intermediate frame ??
combiProdTypevarchar8 Type (stack,tile,mosaic) of combination frame ??
intProdTypevarchar8 Type (stack,tile,mosaic) of intermediate frame ??
Total length28