Table INTERACTION_DIMENSION

DescriptionInteraction Dimension defines the interaction Patterns identified in the solution. For example - Rare, Less Frequent, Frequent

Columns
INTERACTION_DIMENSION_IDINTERACTION_DIMENSION_ID
NAMENAME

Primary Key
PRODUCT_TYPE_PKPRODUCT_TYPE_PK

Indexes
SQL150612123544600SQL150612123544600

Column Details

 INTERACTION_DIMENSION_ID
DescriptionThe unique identifier of the Interaction dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionName identifies the Interaction pattern name - Rare, Less Frequent, Frequent
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PRODUCT_TYPE_PK
DescriptionUnique identifier of the product type
MemberINTERACTION_DIMENSION_ID [BIGINT]

Index Details

 SQL150612123544600
Is Uniquetrue
Is Clusteredfalse