Table: Observed_Holiday
Columns
NameTypeConstraintsDescription
observed_holiday_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLDescription of the holiday.
holiday_datesmalldatetimeNOT NULLThe date that this entry corresponds to.
Primary key
NameColumnsDescription
PK_Observed_Holiday$observed_holiday_KEYobserved_holiday_KEYCLUSTERED

Schema diagram