Footprints Data Model |
Table |
Name | time_zone_region |
Comment |
A region of the world defined in the Olson time zone database. Only the entries actually used by a FootPrints instance will be stored. The localized name of the region is provided by the Java.Util.Timezone getDisplayName() method. Only the java class can be used to determine the time zone offset from GMT, which varies historically and in the future. See the Time Zone Local Hour table. Take aspirin as needed. |
Column |
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 |