Appearance
dbo.ethCalendar
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethCalendar.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | CalendarDate | date | no | ||
| 2 | State | varchar(3) | no | ||
| 3 | DayOfWeek | tinyint | no | ||
| 4 | IsWeekend | bit | no | ||
| 5 | IsPublicHoliday | bit | no | ||
| 6 | HolidayNames | nvarchar(4000) | yes | ||
| 7 | IsBusinessDay | bit | no |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_ethCalendar | CLUSTERED | yes | yes | CalendarDate, State | ||
| IX_ethCalendar_StateDate | NONCLUSTERED | State, CalendarDate | HolidayNames, IsBusinessDay, IsPublicHoliday, IsWeekend |
Referenced by
Procedures: dbo.spEthCalendarUpsertNextYear