WebSphere Commerce database table: FLOW

Reserved for IBM internal use.

Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000103 FLOWTYPE_ID+IDENTIFIER Unique Index
SQL060903235158730 FLOW_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_324 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_65 FLOW_ID APRVSTATUS FLOW_ID Cascade
F_318 COMPOSITEFLOW_ID FLCOMPOSE FLOW_ID Cascade
F_319 SINGLEFLOW_ID FLCOMPOSE FLOW_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