TimeZone
- Section: Universal
Metadata
- Base Table Class: Static
- Default Size: 100
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this TimeZone. |
| Status | Set of Status | 4 | |
| ShortName | String | 24 | The short text identifier of this TimeZone. |
| Name | String | 48 | The long text identifier of this TimeZone. |
| UTCOffset | Integer (signed) | 4 | |
| DSTChange | One of DSTChange | 2 | |
| DSTStartMonth | One of Month | 1 | |
| DSTStartDayNum | Integer (unsigned) | 1 | |
| DSTStartDay | One of DayOfWeek | 1 | |
| DSTStartDayOrdinal | One of DayOrdinal | 1 | |
| DSTStartTime | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| DSTEndMonth | One of Month | 1 | |
| DSTEndDayNum | Integer (unsigned) | 1 | |
| DSTEndDay | One of DayOfWeek | 1 | |
| DSTEndDayOrdinal | One of DayOrdinal | 1 | |
| DSTEndTime | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| UpdateNumber | Integer (unsigned) | 8 | A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this TimeZone. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this TimeZone. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this TimeZone. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this TimeZone. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this TimeZone was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this TimeZone. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this TimeZone was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the TimeZone table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; Market-->|TimeZone|TimeZone click Market "/marketgrid/developer/model/tables/Market" Venue-->|TimeZone|TimeZone click Venue "/marketgrid/developer/model/tables/Venue"