Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OKZ_OH_Idnr int NUMBER(38,0) int int false ID of the calendar object.
OKZ_OKB_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for the calendar events.
OKZ_From datetime DATE timestamp timestamp false Valid from.
OKZ_To datetime DATE timestamp timestamp false Valid to.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OKZ OKZ_OH_Idnr, OKZ_OKB_Lnr, OKZ_From true true true false

Foreign Keys:

Name Local References Foreign References
FK_OKZ_OKB OKZ_OH_Idnr, OKZ_OKB_Lnr OKB_OH_Idnr, OKB_Lnr

Return to the Index File