Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPPF_OH_Idnr int NUMBER(38,0) int int false ID of the workflow.
JPPF_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the workflow tasks. Always 1.
JPPF_Source smallint NUMBER(38,0) smallint smallint true Source for the iteration variable. 1 = VARA, 2 = Array
JPPF_SourceName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the iteration variable.
JPPF_Column smallint NUMBER(38,0) smallint smallint true Column used within the VARA.
JPPF_PublishAs varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the published script variable the iteration value is stored.

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPF JPPF_OH_Idnr, JPPF_JPP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPF_JPP JPPF_OH_Idnr, JPPF_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File