Table INSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE

Columns
INSURANCE_POLICY_IDINSURANCE_POLICY_ID
NATURE_IDNATURE_ID
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
COVERAGE_COMPONENT_IDCOVERAGE_COMPONENT_ID

Foreign Key
INSURANCE__INSU_F1INSURANCE__INSU_F1
INSURANCE__COVE_FKINSURANCE__COVE_FK

Primary Key
INSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE_PKINSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE_PK

Column Details

 INSURANCE_POLICY_ID
DescriptionThe unique identifier of the Top level financial services agreement
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



 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



 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



 COVERAGE_COMPONENT_ID
DescriptionThe unique identifier of the Coverage component
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 INSURANCE__INSU_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Key ColumnINSURANCE_POLICY_ID [BIGINT]
Parent TableINSURANCE_POLICY
Parent Multiplicity1
Unique ConstraintINSURANCE_POLICY_PK



 INSURANCE__COVE_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE
Child Role NameVerb3
Child Multiplicity*
Key ColumnCOVERAGE_COMPONENT_ID [BIGINT]
Parent TableCOVERAGE_COMPONENT
Parent Multiplicity1
Unique ConstraintCOVERAGE_COMPONENT_PK

Primary Key Details

 INSURANCE_POLICY_COVERAGE_COMPONENT_BRIDGE_PK
MemberINSURANCE_POLICY_ID [BIGINT]
MemberCOVERAGE_COMPONENT_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]