Name |
Datatype |
Comment |
Is PK |
Is FK |
time_zone_region_name |
varchar(255) |
The name of the Time Zone Region. |
Yes |
No |
time_zone_region_abbr |
varchar(255) |
A well-known string identifier used as a code to identify the Time Zone Region.
This could be provided by user entry, but it is not available from the Timezone
class. It should probably not be used.
|
No |
No |
time_zone_region_id |
bigint |
An alternate Key to the Time Zone Region table, which is arbitrarily calculated
and assigned by FootPrints. The reason for this is performance of the Foreign
Key join to large numbers of rows. There is no suitable short data length key
available in a published standard data source.
|
No |
No |