Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPOP_OH_Idnr int NUMBER(38,0) int int false ID of the workflow.
JPOP_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the workflow tasks.
JPOP_Location smallint NUMBER(38,0) smallint smallint false Execution time of the condition/action. 1 = pre condition, 2 = post condition, 3 if workflow
JPOP_JPOV_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of parameters within the condition/action.
JPOP_JPOV_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name (S = Parameter set).
JPOP_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of the refereneced prompt set.
JPOP_Value varchar(max) CLOB clob(128 M) INLINE LENGTH 1024 COMPACT text true Variable value.
JPOP_AltView smallint NUMBER(38,0) smallint smallint true Flag for alternative view.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPOP JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName, JPOP_VName true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPOP_JPOV JPOP_OH_Idnr, JPOP_JPP_Lnr, JPOP_Location, JPOP_JPOV_Lnr, JPOP_JPOV_VName JPOV_OH_Idnr, JPOV_JPP_Lnr, JPOV_Location, JPOV_JPPO_Lnr, JPOV_VName

Return to the Index File