WebSphere Commerce database table: FLTRANSITN

Reserved for IBM internal use.

Column Descriptions
Column Name Column Type Description
FLTRANSITN_ID BIGINT NOT NULL Reserved for IBM internal use.
FLOW_ID BIGINT NOT NULL Reserved for IBM internal use.
SOURCESTATE_ID BIGINT NOT NULL Reserved for IBM internal use.
TARGETSTATE_ID BIGINT NOT NULL Reserved for IBM internal use.
PRIORITY INTEGER Reserved for IBM internal use.
EVENTIDENTIFIER VARCHAR(64) NOT NULL Reserved for IBM internal use.
APPROVAL INTEGER NOT NULL Reserved for IBM internal use.
ACTIONINTERFACE VARCHAR(254) Reserved for IBM internal use.
ACCESSCTRLGUARD VARCHAR(254) NOT NULL Reserved for IBM internal use.
BUSINESSLOGICGUARD VARCHAR(254) Reserved for IBM internal use.
SPAWNFLWTYPE_ID BIGINT Reserved for IBM internal use.
SPAWNTYPE INTEGER Reserved for IBM internal use.
RESPONSEVIEWNAME VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000110 FLOW_ID+EVENTIDENTIFIER+SOURCESTATE_ID+TARGETSTATE_ID Unique Index
SQL060903235200700 FLTRANSITN_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_342 FLOW_ID FLOW FLOW_ID Cascade
F_345 SPAWNFLWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade
F_343 SOURCESTATE_ID FLSTATEDCT FLSTATEDCT_ID Cascade
F_344 TARGETSTATE_ID FLSTATEDCT FLSTATEDCT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_340 FLTRANSITN_ID FLTRANSDSC FLTRANSITN_ID Cascade
Related reference