Table PERSON_GEOGRAPHIC_AREA_BRIDGE

Columns
GEOGRAPHIC_AREA_IDGEOGRAPHIC_AREA_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_GEO_GEOG_FKPERSON_GEO_GEOG_FK
PERSON_GEO_PERS_FKPERSON_GEO_PERS_FK

Primary Key
PERSON_GEOGRAPHIC_AREA_BRIDGE_PKPERSON_GEOGRAPHIC_AREA_BRIDGE_PK

Column Details

 GEOGRAPHIC_AREA_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 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

 PERSON_GEO_GEOG_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_GEOGRAPHIC_AREA_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



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

Primary Key Details

 PERSON_GEOGRAPHIC_AREA_BRIDGE_PK
MemberGEOGRAPHIC_AREA_ID [BIGINT]
MemberPERSON_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]