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
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
time_zone_KEY | smallint (5) | NOT NULL |
time_zone_identifier | nvarchar (200) | NOT NULL | The time zone identifier from Windows (for example from the System.TimeZoneInfo.Id property).
time_zone_base_utc_offset | int | NOT NULL | Gets the time difference between this time zone's standard time and Coordinated Universal Time (UTC) in minutes.

Primary key
Name | Columns | Description
PK_Time_Zone$time_zone_KEY | time_zone_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Time_Zone__time_zone_identifier | time_zone_identifier |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Schedule_Item__Time_Zone__target_complete__time_zone_KEY | target_complete__time_zone_KEY | Schedule_Item |
FK_Schedule_Item__Time_Zone__target_start__time_zone_KEY | target_start__time_zone_KEY | Schedule_Item |
FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEY | schedule_entry_end__time_zone_KEY | Schedule_Entry |
FK_Schedule_Entry__Time_Zone__schedule_entry_start__time_zone_KEY | schedule_entry_start__time_zone_KEY | Schedule_Entry |