| WEALTH Data Model |
Description | Customer FA Bridge associates customer to a financial advisor |
Columns | |
![]() |
|
![]() |
Foreign Key | |
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the FA dimension |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | true |
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 | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | CASCADE |
Is Identifying Relationship | true |
Child Table | CUSTOMER_FA_BRIDGE |
Child Multiplicity | * |
Key Column | FA_DIMENSION_ID [INTEGER] |
Parent Table | FA_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | FA_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | CASCADE |
Is Identifying Relationship | true |
Child Table | CUSTOMER_FA_BRIDGE |
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 | The unique identifier of the Customer Segment Mapping. |
Member | FA_DIMENSION_ID [INTEGER] |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | FA_DIMENSION_ID [INTEGER] Ascending |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |