Name Type MSSql Type Oracle Type DB2 Nullable Description
OKZ_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OKZ_OKB_Lnr smallint NUMBER(38,0) smallint false ascending number of the element
OKZ_From datetime DATE timestamp false from time
OKZ_To datetime DATE timestamp false to time

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