Name Type MSSql Type Oracle Type DB2 Nullable Description
OKC_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OKC_OKB_Lnr smallint NUMBER(38,0) smallint false reference to the keyword
OKC_Lnr smallint NUMBER(38,0) smallint false line number for sort order
OKC_CaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true collision calendar name
OKC_CaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true collision calendar key name
OKC_Operator char (1) CHAR (1 CHAR) char(1) true operator ('+'=forward, '-'=backward, 'S'=skip)
OKC_Offset smallint NUMBER(38,0) smallint true Offset by workingdays (0=adjust to next workingday according to operator, >0=adjust to next workingday according to operator + offset workingdays)
OKC_RCaleName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Ref. calendar name
OKC_RCaleKeyName varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Ref. calendar key name

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