Table INSURANCE_POLICY_PHYSICAL_OBJECT_BRIDGE

Columns
INSURANCE_POLICY_IDINSURANCE_POLICY_ID
PHYSICAL_OBJECT_IDPHYSICAL_OBJECT_ID
NATURE_IDNATURE_ID
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE

Foreign Key
INSURANCE__INSU_FKINSURANCE__INSU_FK
INSURANCE__PHYS_FKINSURANCE__PHYS_FK

Primary Key
INSURANCE_POLICY_PHYSICAL_OBJECT_BRIDGE_PKINSURANCE_POLICY_PHYSICAL_OBJECT_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



 PHYSICAL_OBJECT_ID
DescriptionThe unique identifier of the Road vehicle
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

Foreign Key Details

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



 INSURANCE__PHYS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINSURANCE_POLICY_PHYSICAL_OBJECT_BRIDGE
Child Role NameVerb2
Child Multiplicity*
Key ColumnPHYSICAL_OBJECT_ID [BIGINT]
Parent TablePHYSICAL_OBJECT
Parent Multiplicity1
Unique ConstraintPHYSICAL_OBJECT_PK

Primary Key Details

 INSURANCE_POLICY_PHYSICAL_OBJECT_BRIDGE_PK
MemberINSURANCE_POLICY_ID [BIGINT]
MemberPHYSICAL_OBJECT_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]