Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JPPA_OH_Idnr int NUMBER(38,0) int int false ID of the workflow.
JPPA_JPP_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number. Line number within the workflow.
JPPA_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the line connecting two children.
JPPA_PreLnr smallint NUMBER(38,0) smallint smallint true Sequenced number of the predesessor.
JPPA_LineDef varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Definition of the line. Format: aaa/bbb/c/d, aaa = row, bbb = column, c = position, d = width of the line
JPPA_When varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Possible success status of the line's precondition (e.g. ANY_OK, ENDED_SKIPPED, ENDED_NOT_OK).
JPPA_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Name of the line.
JPPA_BranchType smallint NUMBER(38,0) smallint smallint true Type of branch in case of a IF or FOREACH workflow. IF: 1 = true branch, 2 = false branch, FOREACH: 1 = loop path, 2= end path

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JPPA JPPA_OH_Idnr, JPPA_JPP_Lnr, JPPA_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_JPPA_JPP JPPA_OH_Idnr, JPPA_JPP_Lnr JPP_OH_Idnr, JPP_Lnr

Return to the Index File