Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OKC_OH_Idnr int NUMBER(38,0) int int false ID of the calendar object.
OKC_OKB_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for calendar events.
OKC_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for sort order.
OKC_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the collision calendar.
OKC_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the collision calendar event.
OKC_Operator char (1) CHAR (1 CHAR) char(1) char (1) true Operator for ROLL calendars. + = shift forward, - = shift backward, S = skip
OKC_Offset smallint NUMBER(38,0) smallint smallint true Offset by wordkin days.
OKC_RCaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the reference calendar object.
OKC_RCaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the referenced calendar event.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OKC_Cale OKC_CaleName, OKC_CaleKeyName false false false false
NK_OKC_RCale OKC_RCaleName, OKC_RCaleKeyName false false false false
PK_OKC OKC_OH_Idnr, OKC_OKB_Lnr, OKC_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OKC_OKB OKC_OH_Idnr, OKC_OKB_Lnr OKB_OH_Idnr, OKB_Lnr

Return to the Index File