Table PERSON_PRODUCT_GROUP_BRIDGE

Columns
NATURE_IDNATURE_ID
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
CATEGORY_IDCATEGORY_ID

Foreign Key
PERSON_PRO_GEOG_FKPERSON_PRO_GEOG_FK
PERSON_PRO_PROD_FKPERSON_PRO_PROD_FK

Primary Key
PERSON_PRODUCT_GROUP_BRIDGE_PKPERSON_PRODUCT_GROUP_BRIDGE_PK

Column Details

 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 TypeCHAR(5)
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



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

Foreign Key Details

 PERSON_PRO_GEOG_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_PRODUCT_GROUP_BRIDGE
Child Role NameVerb1
Child Multiplicity*
Parent TableGEOGRAPHIC_AREA
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



 PERSON_PRO_PROD_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_PRODUCT_GROUP_BRIDGE
Child Role NameVerb3
Child Multiplicity*
Key ColumnCATEGORY_ID [BIGINT]
Parent TablePRODUCT_GROUP
Parent Multiplicity1
Unique ConstraintPRODUCT_GROUP_PK

Primary Key Details

 PERSON_PRODUCT_GROUP_BRIDGE_PK
MemberCATEGORY_ID [BIGINT]
MemberNATURE_ID [CHAR(5)]
MemberEFFECTIVE_FROM_DATE [TIMESTAMP]