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