Table PERSON_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
SCORE_INDICATORSCORE_INDICATOR

Foreign Key
PERSON_SCO_PERS_FKPERSON_SCO_PERS_FK
PERSON_SCO_SCOR_FKPERSON_SCO_SCOR_FK
PERSO_SCORE_MI_FKPERSO_SCORE_MI_FK
PERSON_SC_CALEN_FKPERSON_SC_CALEN_FK
PERSO_PERSON_MI_FKPERSO_PERSON_MI_FK

Primary Key
PERSON_SCORE_FACT_PKPERSON_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 TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SCORE_INDICATOR
DescriptionBoolean value that stores a yes or no for certain scores. Stays null if not applicable
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

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



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



 PERSO_SCORE_MI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePERSON_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



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



 PERSO_PERSON_MI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePERSON_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

Primary Key Details

 PERSON_SCORE_FACT_PK
MemberPERSON_ID [BIGINT]
MemberSCORE_ID [BIGINT]
MemberCALENDAR_DATE_ID [BIGINT]