calendar_table


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dt DATE 10 null
site_extension.nxt_dlr_opt_notice_dt Implied Constraint R
y SMALLINT 5 √ null
q TINYINT 3 √ null
m TINYINT 3 √ null
d TINYINT 3 √ null
dw TINYINT 3 √ null
monthName VARCHAR 9 √ null
dayName VARCHAR 9 √ null
w TINYINT 3 √ null
isWeekday BINARY 1 √ null
isHoliday BINARY 1 √ null
holidayDescr VARCHAR 32 √ null
isPayday BINARY 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc dt

Relationships

Close relationships within degrees of separation