| WEALTH Data Model |
Description | This fact table captures the social interations of the customer. |
Columns | |
![]() |
|
![]() |
|
![]() |
|
![]() |
Foreign Key | |
![]() |
|
![]() |
Column Details |
Description | Channel usage measure indicates the channel usage by the customer. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique identifier of the social channel. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Customer Dimension. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Indicates the interaction date. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | SOCIAL_INTERACTION_CHANNEL_USAGE_FACT |
Child Multiplicity | * |
Key Column | CHANNEL_DIMENSION_ID [INTEGER] |
Parent Table | SOCIAL_INTERACTION_CHANNEL_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | SOCIAL_INTERACTION_CHANNEL_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | SOCIAL_INTERACTION_CHANNEL_USAGE_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [INTEGER] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
| WEALTH Data Model |