Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Time Zone Region Name |
The name of the Time Zone Region. This is 2. The 'primary key' of the java timezone is the string region identifier in English, example 'America/Phoenix'. There is no numeric identifier. As the JRE is updated, or specific classes are updated, the list could change to include new entries, and the detail data behind the regions could change.
|
VARCHAR(255) |
Yes |
Time Zone Region Abbreviation |
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.
|
VARCHAR(255) |
No |
Time Zone Region Id |
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.
|
LONG |
No |