Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OTZC_OH_Idnr int NUMBER(38,0) int int false ID of the timezone object.
OTZC_Year smallint NUMBER(38,0) smallint smallint false Year
OTZC_TzDiffhh smallint NUMBER(38,0) smallint smallint true Time difference (hours) to UTC.
OTZC_TzDiffmi smallint NUMBER(38,0) smallint smallint true Time difference (minutes) to UTC.
OTZC_DlsSmo smallint NUMBER(38,0) smallint smallint true Month for start of daylight saving time (dst). (e.g. second Sunday of 'March')
OTZC_DlsStt smallint NUMBER(38,0) smallint smallint true Ordinal number (1 to 5) of the day for start of daylight saving time. (e.g. 'second' Sunday of March)
OTZC_DlsSwd smallint NUMBER(38,0) smallint smallint true Weekday (1 = Monday to 7 = Sunday) on which the daylight saving time starts. (e.g second 'Sunday' of March)
OTZC_DlsShh smallint NUMBER(38,0) smallint smallint true Hour the daylight saving time starts.
OTZC_DlsSmi smallint NUMBER(38,0) smallint smallint true Minute the daylight saving time starts.
OTZC_DlsEmo smallint NUMBER(38,0) smallint smallint true Month for end of daylight saving time. (e.g. second Sunday of 'November')
OTZC_DlsEtt smallint NUMBER(38,0) smallint smallint true Ordinal number (1 to 5) of the day for end of daylight saving time. (e.g. 'second' Sunday of November)
OTZC_DlsEwd smallint NUMBER(38,0) smallint smallint true Weekday (1 = Monday to 7 = Sunday) on which the daylight saving time ends. (e.g second 'Sunday' of November)
OTZC_DlsEhh smallint NUMBER(38,0) smallint smallint true Hour the daylight saving time ends.
OTZC_DlsEmi smallint NUMBER(38,0) smallint smallint true Minute the daylight saving time ends.
OTZC_DlsDiffmi smallint NUMBER(38,0) smallint smallint true Time difference between daylight savint and standard time.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OTZC OTZC_OH_Idnr, OTZC_Year true true true false

Foreign Keys:

Name Local References Foreign References
FK_OTZC_OH OTZC_OH_Idnr OH_Idnr

Return to the Index File