FLOW

Reserved for IBM internal use.


Column Descriptions:

Name Type Description
FLOW_ID BIGINT NOT NULL Reserved for IBM internal use.
FLOWTYPE_ID BIGINT NOT NULL Reserved for IBM internal use.
COMPOSITEFLOW INTEGER Reserved for IBM internal use.
ATTRIBUTE VARCHAR (254) Reserved for IBM internal use.
IDENTIFIER VARCHAR (64) NOT NULL Reserved for IBM internal use.
PRIORITY INTEGER Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


Indexes:

Name Column Names Type
<SYSTEM-GENERATED> FLOW_ID Primary Key
I0000103 FLOWTYPE_ID+IDENTIFIER Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_324 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_318 FLOW_ID FLCOMPOSE COMPOSITEFLOW_ID Cascade
F_319 FLOW_ID FLCOMPOSE SINGLEFLOW_ID Cascade
F_322 FLOW_ID FLINSTANCE FLOW_ID Cascade
F_327 FLOW_ID FLOWADMIN FLOW_ID Cascade
F_328 FLOW_ID FLOWDESC FLOW_ID Cascade
F_335 FLOW_ID FLSTATEREL FLOW_ID Cascade
F_342 FLOW_ID FLTRANSITN FLOW_ID Cascade
F_65 FLOW_ID APRVSTATUS FLOW_ID Cascade