Table PERSON_CONTACT_POINT_BRIDGE

Columns
CONTACT_POINT_IDCONTACT_POINT_ID
PERSON_IDPERSON_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
PERSON_CON_CONT_FKPERSON_CON_CONT_FK
PERSON_CON_PERS_FKPERSON_CON_PERS_FK

Primary Key
PERSON_CONTACT_POINT_BRIDGE_PKPERSON_CONTACT_POINT_BRIDGE_PK

Column Details

 CONTACT_POINT_ID
DescriptionThe unique identifier of the Geographic Area
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_ID
DescriptionThe unique identifier of the Person
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATURE_ID
Data TypeVARCHAR(20)
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

 PERSON_CON_CONT_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_CONTACT_POINT_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Key ColumnCONTACT_POINT_ID [BIGINT]
Parent TableCONTACT_POINT
Parent Multiplicity1
Unique ConstraintCONTACT_POINT_PK



 PERSON_CON_PERS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_CONTACT_POINT_BRIDGE
Child Role NameVerb2
Child Multiplicity*
Key ColumnPERSON_ID [BIGINT]
Parent TablePERSON
Parent Multiplicity1
Unique ConstraintPERSON_PK

Primary Key Details

 PERSON_CONTACT_POINT_BRIDGE_PK
MemberCONTACT_POINT_ID [BIGINT]
MemberPERSON_ID [BIGINT]
MemberNATURE_ID [VARCHAR(20)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]