Table TENURE_FACT

DescriptionDefines the tenure (in months) of t

Columns
TENURETENURE
MARKET_SEGMENT_IDMARKET_SEGMENT_ID
TENURE_CATEGORY_IDTENURE_CATEGORY_ID
CALENDAR_DATE_IDCALENDAR_DATE_ID
PRODUCT_GROUP_IDPRODUCT_GROUP_ID
GEOGRAPHIC_AREA_IDGEOGRAPHIC_AREA_ID
GEOGRAPHIC_AREA_MINI_DIMENSION_IDGEOGRAPHIC_AREA_MINI_DIMENSION_ID

Foreign Key
TENUR_MARKET_S_FKTENUR_MARKET_S_FK
TENURE_F_CATEG_FKTENURE_F_CATEG_FK
TENURE_CALENDAR_FKTENURE_CALENDAR_FK
TENURE_PRODUCT__FKTENURE_PRODUCT__FK
TENUR_GEOGRAPHI_FKTENUR_GEOGRAPHI_FK
TENU_GEOGRAPHIC_FKTENU_GEOGRAPHIC_FK

Primary Key
TENURE_FACT_PKTENURE_FACT_PK

Column Details

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



 TENURE_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



 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



 PRODUCT_GROUP_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



 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



 GEOGRAPHIC_AREA_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Geographic Area Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 TENUR_MARKET_S_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableTENURE_FACT
Child Role NameVerb2
Child Multiplicity*
Key ColumnMARKET_SEGMENT_ID [BIGINT]
Parent TableMARKET_SEGMENT
Parent Multiplicity1
Unique ConstraintMARKET_SEGMENT_PK



 TENURE_F_CATEG_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableTENURE_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnTENURE_CATEGORY_ID [BIGINT]
Parent TableCATEGORY
Parent Multiplicity1
Unique ConstraintCATEGORY_PK



 TENURE_CALENDAR_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableTENURE_FACT
Child Role NameVerb3
Child Multiplicity*
Key ColumnCALENDAR_DATE_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 TENURE_PRODUCT__FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableTENURE_FACT
Child Role NameVerb4
Child Multiplicity*
Key ColumnPRODUCT_GROUP_ID [BIGINT]
Parent TablePRODUCT_GROUP
Parent Multiplicity1
Unique ConstraintPRODUCT_GROUP_PK



 TENUR_GEOGRAPHI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableTENURE_FACT
Child Role NameVerb5
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



 TENU_GEOGRAPHIC_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableTENURE_FACT
Child Role NameVerb6
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintGEOGRAPHIC_AREA_MINI_DIMENSION_PK

Primary Key Details

 TENURE_FACT_PK
MemberMARKET_SEGMENT_ID [BIGINT]
MemberTENURE_CATEGORY_ID [BIGINT]
MemberCALENDAR_DATE_ID [BIGINT]
MemberPRODUCT_GROUP_ID [BIGINT]
MemberGEOGRAPHIC_AREA_ID [BIGINT]