Table: Time_Zone
Just enough information about Windows Time Zones to be able to record the time zone a user was in when they last edited a datetime field.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
time_zone_KEYsmallint (5)NOT NULL
time_zone_identifiernvarchar (200)NOT NULLThe time zone identifier from Windows (for example from the System.TimeZoneInfo.Id property).
time_zone_base_utc_offsetintNOT NULLGets the time difference between this time zone's standard time and Coordinated Universal Time (UTC) in minutes.
Primary key
NameColumnsDescription
PK_Time_Zone$time_zone_KEYtime_zone_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Time_Zone$time_zone_identifiertime_zone_identifier
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact__Time_Zone__time_zone_KEYtime_zone_KEYContact
FK_Schedule_Item__Time_Zone__target_complete__time_zone_KEYtarget_complete__time_zone_KEYSchedule_Item
FK_Schedule_Item__Time_Zone__target_start__time_zone_KEYtarget_start__time_zone_KEYSchedule_Item
FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEYschedule_entry_end__time_zone_KEYSchedule_Entry
FK_Schedule_Entry__Time_Zone__schedule_entry_start__time_zone_KEYschedule_entry_start__time_zone_KEYSchedule_Entry

Schema diagram