Name Type MSSql Type Oracle Type DB2 Nullable Description
OTZC_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OTZC_Year smallint NUMBER(38,0) smallint false year
OTZC_TzDiffhh smallint NUMBER(38,0) smallint true time difference to UTC hours
OTZC_TzDiffmi smallint NUMBER(38,0) smallint true time difference to UTC minutes
OTZC_DlsSmo smallint NUMBER(38,0) smallint true Month for start of daylight saving time
OTZC_DlsStt smallint NUMBER(38,0) smallint true Day for start of daylight saving (1 = first day,.. 5 = last day)
OTZC_DlsSwd smallint NUMBER(38,0) smallint true Weekday for start of daylight saving (1= monday, .... 7= sunday)
OTZC_DlsShh smallint NUMBER(38,0) smallint true hour for start of daylight saving
OTZC_DlsSmi smallint NUMBER(38,0) smallint true minutes for start of daylight saving
OTZC_DlsEmo smallint NUMBER(38,0) smallint true Month for end of daylight saving time
OTZC_DlsEtt smallint NUMBER(38,0) smallint true Day for end of daylight saving (1 = first day,.. 5 = last day)
OTZC_DlsEwd smallint NUMBER(38,0) smallint true Weekday for end of daylight saving (1= monday, .... 7= sunday)
OTZC_DlsEhh smallint NUMBER(38,0) smallint true hour for end of daylight saving
OTZC_DlsEmi smallint NUMBER(38,0) smallint true minutes for end of daylight saving
OTZC_DlsDiffmi smallint NUMBER(38,0) smallint true time difference daylight saving (minutes)

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