Table FINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE

Columns
PARENT_FINANCIAL_SERVICES_PRODUCT_IDPARENT_FINANCIAL_SERVICES_PRODUCT_ID
CHILD_FINANCIAL_SERVICES_PRODUCT_IDCHILD_FINANCIAL_SERVICES_PRODUCT_ID
NATURE_IDNATURE_ID
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
TOP_LEVEL_INDTOP_LEVEL_IND
BOTTOM_LEVEL_INDBOTTOM_LEVEL_IND
LEVEL_NUMBERLEVEL_NUMBER
LEVEL_DESCRIPTIONLEVEL_DESCRIPTION
PARENT_LEVEL_NUMBERPARENT_LEVEL_NUMBER
PARENT_LEVEL_DESCRIPTIONPARENT_LEVEL_DESCRIPTION
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Foreign Key
FINANCIAL__FINA_FKFINANCIAL__FINA_FK
FINANCIAL__FINA_F1FINANCIAL__FINA_F1

Primary Key
FINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE_PKFINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE_PK

Column Details

 PARENT_FINANCIAL_SERVICES_PRODUCT_ID
DescriptionThe unique identifier of the Financial services product
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHILD_FINANCIAL_SERVICES_PRODUCT_ID
DescriptionThe unique identifier of the Financial services product
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATURE_ID
Data TypeCHAR(5)
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOP_LEVEL_IND
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BOTTOM_LEVEL_IND
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LEVEL_NUMBER
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LEVEL_DESCRIPTION
Data TypeCHAR(5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_LEVEL_NUMBER
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARENT_LEVEL_DESCRIPTION
Data TypeCHAR(5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 FINANCIAL__FINA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableFINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Key ColumnPARENT_FINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
Parent TableFINANCIAL_SERVICES_PRODUCT
Parent Multiplicity1
Unique ConstraintFINANCIAL_SERVICES_PRODUCT_PK



 FINANCIAL__FINA_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableFINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE
Child Role NameVerb2
Child Multiplicity*
Key ColumnCHILD_FINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
Parent TableFINANCIAL_SERVICES_PRODUCT
Parent Multiplicity1
Unique ConstraintFINANCIAL_SERVICES_PRODUCT_PK

Primary Key Details

 FINANCIAL_SERVICES_PRODUCT_HIERARCHY_BRIDGE_PK
MemberPARENT_FINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
MemberCHILD_FINANCIAL_SERVICES_PRODUCT_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]