Name Type MSSql Type Oracle Type DB2 Nullable Description
OKD_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OKD_OKB_Lnr smallint NUMBER(38,0) smallint false reference to the keyword
OKD_Year smallint NUMBER(38,0) smallint false Year
OKD_Content varchar(372) VARCHAR2 (372 CHAR) varchar(372) true One Byte per day and year (0=unselected, 1=selected), Fixed column width per month (31 digits x 12)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OKD OKD_OH_Idnr, OKD_OKB_Lnr, OKD_Year true true true false

Foreign Keys:

Name Local References Foreign References
FK_OKD_OKB OKD_OH_Idnr, OKD_OKB_Lnr OKB_OH_Idnr, OKB_Lnr

Return to the Index File