Table PERSON_MARKET_SEGMENT_BRIDGE

Columns
PERSON_IDPERSON_ID
NATURE_IDNATURE_ID
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
MARKET_SEGMENT_IDMARKET_SEGMENT_ID
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE

Foreign Key
PERSON_MAR_PERS_FKPERSON_MAR_PERS_FK
PERSON_MAR_MARK_FKPERSON_MAR_MARK_FK

Primary Key
PERSON_MARKET_SEGMENT_BRIDGE_PKPERSON_MARKET_SEGMENT_BRIDGE_PK

Column Details

 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



 MARKET_SEGMENT_ID
DescriptionThe unique identifier of the Role player category
Data TypeBIGINT
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

Foreign Key Details

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



 PERSON_MAR_MARK_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_MARKET_SEGMENT_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Key ColumnMARKET_SEGMENT_ID [BIGINT]
Parent TableMARKET_SEGMENT
Parent Multiplicity1
Unique ConstraintMARKET_SEGMENT_PK

Primary Key Details

 PERSON_MARKET_SEGMENT_BRIDGE_PK
MemberPERSON_ID [BIGINT]
MemberMARKET_SEGMENT_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]