PRODUCT_RELATION

The Product Relation table records the relation between different products including maintenance products. .

Product Relation Columns

Columns

Type

Length

Description

PRODUCT_ID

numeric

19

It is a foreign key. The ID is the primary key for the Product dimension.

RELATION_TYPE

nvarchar

255

Defines what relation exists between two products. For example:

• UPGRADE_FROM
• UPGRADE_TO
• UPSELL_FROM
• UPSELL_TO
• DEMO_OF
• PRODUCTION_VERSION_OF
• IS_MAINTENANCE
• HAS_MAINTENANCE

RELATED_PRODUCT_ID

numeric

19

This is a foreign key. The ID is the primary key for the related product in the Product Dimension table.