Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OKG_OH_Idnr int NUMBER(38,0) int int false ID of the calendar object.
OKG_OKB_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for the calendar events.
OKG_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for group calendars.
OKG_Operator char (1) CHAR (1 CHAR) char(1) char (1) true Operator. O = or, A = and, N = not
OKG_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the calendar.
OKG_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the calendar event.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OKG_CaleName OKG_CaleName, OKG_CaleKeyName false false false false
PK_OKG OKG_OH_Idnr, OKG_OKB_Lnr, OKG_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OKG_OKB OKG_OH_Idnr, OKG_OKB_Lnr OKB_OH_Idnr, OKB_Lnr

Return to the Index File