Table CUSTOMER_FA_BRIDGE

DescriptionCustomer FA Bridge associates customer to a financial advisor

Columns
FA_DIMENSION_IDFA_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID

Foreign Key
CUSTOMER_F_FA_D_FKCUSTOMER_F_FA_D_FK
INDIVIDUAL_F_FA_D_FKINDIVIDUAL_F_FA_D_FK

Primary Key
CUSTOMER_SEGMENT_MAPPING_PKCUSTOMER_SEGMENT_MAPPING_PK

Indexes
CUSTOMER_SEGMENT_MAPPING_PKCUSTOMER_SEGMENT_MAPPING_PK

Column Details

 FA_DIMENSION_ID
DescriptionThe unique identifier of the FA dimension
Data TypeINTEGER
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 CUSTOMER_F_FA_D_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteCASCADE
Is Identifying Relationshiptrue
Child TableCUSTOMER_FA_BRIDGE
Child Multiplicity*
Key ColumnFA_DIMENSION_ID [INTEGER]
Parent TableFA_DIMENSION
Parent Multiplicity0..1
Unique ConstraintFA_DIMENSION_PK



 INDIVIDUAL_F_FA_D_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteCASCADE
Is Identifying Relationshiptrue
Child TableCUSTOMER_FA_BRIDGE
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK

Primary Key Details

 CUSTOMER_SEGMENT_MAPPING_PK
DescriptionThe unique identifier of the Customer Segment Mapping.
MemberFA_DIMENSION_ID [INTEGER]
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]

Index Details

 CUSTOMER_SEGMENT_MAPPING_PK
Is Uniquetrue
Is Clusteredfalse
MemberFA_DIMENSION_ID [INTEGER] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending