Table CAMPAIGN_SCORE_FACT

Columns
PERSON_IDPERSON_ID
SCORE_IDSCORE_ID
SCORE_MINI_DIMENSION_IDSCORE_MINI_DIMENSION_ID
CALENDAR_DATE_IDCALENDAR_DATE_ID
PERSON_MINI_DIMENSION_IDPERSON_MINI_DIMENSION_ID
SCORE_VALUESCORE_VALUE
CAMPAIGN_IDCAMPAIGN_ID
CAMPAIGN_MINI_DIMENSION_IDCAMPAIGN_MINI_DIMENSION_ID

Foreign Key
CAMPAIGN_S_PERS_FKCAMPAIGN_S_PERS_FK
CAMPAIGN_S_SCOR_FKCAMPAIGN_S_SCOR_FK
CAMPAI_SCORE_M_FKCAMPAI_SCORE_M_FK
CAMPAIGN_S_CALE_F1CAMPAIGN_S_CALE_F1
CAMPAI_PERSON_M_FKCAMPAI_PERSON_M_FK
CAMPAIGN_S_CAMP_F1CAMPAIGN_S_CAMP_F1
CAMPA_CAMPAIGN__F1CAMPA_CAMPAIGN__F1

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



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



 SCORE_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Score mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_ID
DescriptionThe unique identifier of the Calendar date
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Person mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCORE_VALUE
Data TypeCHAR(5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 CAMPAIGN_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Campaign mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 CAMPAIGN_S_PERS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnPERSON_ID [BIGINT]
Parent TablePERSON
Parent Multiplicity1
Unique ConstraintPERSON_PK



 CAMPAIGN_S_SCOR_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb2
Child Multiplicity*
Key ColumnSCORE_ID [BIGINT]
Parent TableSCORE
Parent Multiplicity1
Unique ConstraintSCORE_PK



 CAMPAI_SCORE_M_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb3
Child Multiplicity*
Key ColumnSCORE_MINI_DIMENSION_ID [BIGINT]
Parent TableSCORE_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintSCORE_MINI_DIMENSION_PK



 CAMPAIGN_S_CALE_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb4
Child Multiplicity*
Key ColumnCALENDAR_DATE_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 CAMPAI_PERSON_M_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb6
Child Multiplicity*
Key ColumnPERSON_MINI_DIMENSION_ID [BIGINT]
Parent TablePERSON_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintPERSON_MINI_DIMENSION_PK



 CAMPAIGN_S_CAMP_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb5
Child Multiplicity*
Key ColumnCAMPAIGN_ID [BIGINT]
Parent TableCAMPAIGN
Parent Multiplicity1
Unique ConstraintCAMPAIGN_PK



 CAMPA_CAMPAIGN__F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableCAMPAIGN_SCORE_FACT
Child Role NameVerb7
Child Multiplicity*
Key ColumnCAMPAIGN_MINI_DIMENSION_ID [BIGINT]
Parent TableCAMPAIGN_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCAMPAIGN_MINI_DIMENSION_PK

Primary Key Details

 CAMPAIGN_SCORE_FACT_PK
MemberPERSON_ID [BIGINT]
MemberSCORE_ID [BIGINT]
MemberCALENDAR_DATE_ID [BIGINT]
MemberCAMPAIGN_ID [BIGINT]