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_datedatetimeNOT NULL
create_datedatetimeNOT NULL
descriptionnvarchar (30)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