Table PRODUCT_CUSTOMER_BRIDGE

DescriptionProduct Group Bridge supports many-to-many relationships between the Product Dimension or the Financial Market Instrument Dimension, and the Group Dimension or any other sub-type dimension of Group.

Columns
RELATIONSHIP_DIMENSION_IDRELATIONSHIP_DIMENSION_ID
PRODUCT_DIMENSION_IDPRODUCT_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
NATURE_OF_RELATIONSHIPNATURE_OF_RELATIONSHIP
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM

Foreign Key
PRODUCT_CUSTOMER_BRIDGE_INDIVIDUAL_CUSTOMER_DIMENSION_FKPRODUCT_CUSTOMER_BRIDGE_INDIVIDUAL_CUSTOMER_DIMENSION_FK
PRODUCT_CUSTOMER_BRIDGE_PRODUCT_DIMENSION_FKPRODUCT_CUSTOMER_BRIDGE_PRODUCT_DIMENSION_FK

Primary Key
PRODUCT_CUSTOMER_BRIDGE_PKPRODUCT_CUSTOMER_BRIDGE_PK

Indexes
PRODUCT_CUSTOMER_BRIDGE_PKPRODUCT_CUSTOMER_BRIDGE_PK

Column Details

 RELATIONSHIP_DIMENSION_ID
DescriptionThe unique identifier of the Nature Of Relationship.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_DIMENSION_ID
DescriptionThe unique identifier of the Product Dimension. This identifier can be populated with values from the Product Dimension or the Financial Market Instrument Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATURE_OF_RELATIONSHIP
DescriptionNature Of Relationship classifies instances of Product Group Bridge based on the type of relationship that links the Product and the Group.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
DescriptionCurrent Row Indicator indicates whether or not, among the different versions of each relationship recorded in this bridge entity, this row holds the values that are currently valid in the business reality. This indicator enables the current values of the bridge to be retrieved quickly.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the bridge occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the bridge occurrence are true in the business reality.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid From Date indicates the transaction time that represents the beginning of the time period during which the values of all attributes of the bridge occurrence are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid To Date indicates the transaction time that represents the end of the time period during which the values of all attributes of the bridge occurrence are true in the source system.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 PRODUCT_CUSTOMER_BRIDGE_INDIVIDUAL_CUSTOMER_DIMENSION_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePRODUCT_CUSTOMER_BRIDGE
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK



 PRODUCT_CUSTOMER_BRIDGE_PRODUCT_DIMENSION_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePRODUCT_CUSTOMER_BRIDGE
Child Multiplicity*
Key ColumnPRODUCT_DIMENSION_ID [BIGINT]
Parent TablePRODUCT_DIMENSION
Parent Multiplicity0..1
Unique ConstraintPRODUCT_DIMENSION_PK

Primary Key Details

 PRODUCT_CUSTOMER_BRIDGE_PK
MemberRELATIONSHIP_DIMENSION_ID [BIGINT]
MemberPRODUCT_DIMENSION_ID [BIGINT]
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]

Index Details

 PRODUCT_CUSTOMER_BRIDGE_PK
Is Uniquetrue
Is Clusteredfalse
MemberRELATIONSHIP_DIMENSION_ID [BIGINT] Ascending
MemberPRODUCT_DIMENSION_ID [BIGINT] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending