Table SOCIAL_INTERACTION_CHANNEL_USAGE_FACT

DescriptionThis fact table captures the social interations of the customer.

Columns
CHANNEL_USAGECHANNEL_USAGE
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID

Foreign Key
SOCIAL_CHANNEL_CHANNEL_DIM_FKSOCIAL_CHANNEL_CHANNEL_DIM_FK
SOCIAL_CHANNEL_INDIVIDUAL_FKSOCIAL_CHANNEL_INDIVIDUAL_FK

Column Details

 CHANNEL_USAGE
DescriptionChannel usage measure indicates the channel usage by the customer.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_DIMENSION_ID
DescriptionUnique identifier of the social channel.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionIndicates the interaction date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 SOCIAL_CHANNEL_CHANNEL_DIM_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSOCIAL_INTERACTION_CHANNEL_USAGE_FACT
Child Multiplicity*
Key ColumnCHANNEL_DIMENSION_ID [INTEGER]
Parent TableSOCIAL_INTERACTION_CHANNEL_DIMENSION
Parent Multiplicity0..1
Unique ConstraintSOCIAL_INTERACTION_CHANNEL_DIMENSION_PK



 SOCIAL_CHANNEL_INDIVIDUAL_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSOCIAL_INTERACTION_CHANNEL_USAGE_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [INTEGER]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK