Table HLPDTEST.STATEGPS.T_GPS_CALENDER_DATES Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DATE_ID number 22
FACT_DATE date 7  √  null
FACT_WEEK date 7  √  null
FACT_MONTH date 7  √  null
FACT_YEAR date 7  √  null
FACT_QUARTER date 7  √  null
DAY_TYPE varchar2 50  √  null
PERIOD_START_DATE date 7  √  null
PERIOD_END_DATE date 7  √  null

Table contained 10,956 rows at Mon May 23 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name Anomalies
DATE_ID Primary key Asc SYS_C0017297  
FACT_DATE + FACT_MONTH Must be unique Asc/Asc T_GPS_CAL_MONTH_UNIQUE These unique columns are also nullable
FACT_DATE + FACT_WEEK Must be unique Asc/Asc T_GPS_CAL_WEEK_UNIQUE These unique columns are also nullable
FACT_DATE + FACT_YEAR Must be unique Asc/Asc T_GPS_CAL_YEAR_UNIQUE These unique columns are also nullable
FACT_DATE Performance Asc T_GPS_CALENDER_DATES_INDEX