Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPPO_OH_Idnr int NUMBER(38,0) int int false ID of the object.
JPPO_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the workflow tasks.
JPPO_Location smallint NUMBER(38,0) smallint smallint false Execution time of the condition/action. 1 = pre condition, 2 = post condition, 3 if workflow
JPPO_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the condition/action.
JPPO_CarName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the condition/action.
JPPO_Type char (1) CHAR (1 CHAR) char(1) char (1) true Indicates the type of this entry. C = condition, A = action, E = else, F = end if
JPPO_Active smallint NUMBER(38,0) smallint smallint true Entry is active or not.
JPPO_Once smallint NUMBER(38,0) smallint smallint true Indicates when to check the condition. 0 = every time, 1 = once
JPPO_UIInfo varchar(max) CLOB clob(20480 k) COMPACT text true User field for UI.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPO JPPO_OH_Idnr, JPPO_JPP_Lnr, JPPO_Location, JPPO_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPO_JPP JPPO_OH_Idnr, JPPO_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File