This table contains information about different time zones.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
timezone_id (PK) |
SMALLINT | PK | Unique identifier for a time zone. | Yes |
ntimezone_id |
VARCHAR | Normalized time zone identifier. | Yes | |
display_name |
VARCHAR | User-friendly display name for the time zone. | No | |
standard_time_short |
VARCHAR | Short abbreviation for standard time (for example, "EST"). | No | |
daylight_time_short |
VARCHAR | Short abbreviation for daylight saving time (for example, "EDT"). | No | |
standard_time_long |
VARCHAR | Long name for standard time (for example, "Eastern Standard Time"). | No | |
daylight_time_long |
VARCHAR | Long name for daylight saving time (for example, "Eastern Daylight Time"). | No | |
utc_offset_millis |
INTEGER | Offset from UTC in milliseconds. | No | |
observes_dst |
BOOLEAN | Boolean indicating if the time zone observes Daylight Saving Time. | No | |
dst_savings_millis |
INTEGER | Daylight Saving Time savings in milliseconds. | No |