Table HLPDTEST.STATEGPS.T_GPS_CALENDER_DATES | Generated by SchemaSpy |
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 |