Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OQT_OH_Idnr int NUMBER(38,0) int int false ID of the remote task manager.
OQT_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for all filters.
OQT_Type char (1) CHAR (1 CHAR) char(1) char (1) true Data type of the value that is going to be checked.
OQT_Operator char (1) CHAR (1 CHAR) char(1) char (1) true The operator used. O = or, N = not, G = greater, L = less
OQT_FltrMsgNr int NUMBER(38,0) int int true Filter for message number.
OQT_FltrChar varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Filter for a certain text.
OQT_FltrLong int NUMBER(38,0) int int true Filter for a certain number.
OQT_FltrTimeStamp datetime DATE timestamp timestamp true Filter for a certain date.

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