Name Type MSSql Type Oracle Type DB2 Nullable Description
OQT_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OQT_Lnr smallint NUMBER(38,0) smallint false ascending number of the filter
OQT_Type char (1) CHAR (1 CHAR) char(1) true datatype C / E / L / T
OQT_Operator char (1) CHAR (1 CHAR) char(1) true or/not/greater/lower (O / N / G / L)
OQT_FltrMsgNr int NUMBER(38,0) int true MessageNr Filtername
OQT_FltrChar varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Text Filter
OQT_FltrLong int NUMBER(38,0) int true Integer Filter
OQT_FltrTimeStamp datetime DATE timestamp true Date Filter

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OQT OQT_OH_Idnr, OQT_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OQT_OH OQT_OH_Idnr OH_Idnr

Return to the Index File