| WEALTH Data Model |
Description | This fact table captures the facts on the Life events of individuals and also the action performed by the individual over the life event. For example. Customer at the age of 21 may achieve the life event of "New Job" and perform actions like "Open IRA Account" or "Open Health Insurance". |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Product Dimension. |
Data Type | BIGINT |
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 Event Characteristics Mini Dimension |
Data Type | BIGINT |
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 Calendar Date Dimension. |
Data Type | BIGINT |
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 Individual Activity. |
Data Type | BIGINT |
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 Life Event Activity Fact. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique identifier of the customer segment. |
Data Type | BIGINT |
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 | Customer Age at the time of Life Event. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Customer Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure indicates the cost incurred during the life event. |
Data Type | DECIMAL(10 , 2) |
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 | LIFE_EVENT_ACTIVITY_FACT |
Child Multiplicity | * |
Key Column | PRODUCT_DIMENSION_ID [BIGINT] |
Parent Table | PRODUCT_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | PRODUCT_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | LIFE_EVENT_ACTIVITY_FACT |
Child Multiplicity | * |
Key Column | LIFE_EVENT_DIMENSION_ID [BIGINT] |
Parent Table | LIFE_EVENT_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | LIFE_EVENT_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | LIFE_EVENT_ACTIVITY_FACT |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CALENDAR_DATE_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | LIFE_EVENT_ACTIVITY_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_ACTVITY_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_ACTIVITY_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_ACTIVITY_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | LIFE_EVENT_ACTIVITY_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Primary Key Details |
Description | Unique identifier of the Life Event Activity Fact table. |
Member | LIFE_EVENT_ACTIVITY_ID_ [INTEGER] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | LIFE_EVENT_ACTIVITY_ID_ [INTEGER] Ascending |
| WEALTH Data Model |