WebSphere Commerce database table: FLSTATEDCT

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
FLSTATEDCT_ID BIGINT NOT NULL Reserved for IBM internal use.
IDENTIFIER INTEGER NOT NULL Reserved for IBM internal use.
STATENAME VARCHAR(32) NOT NULL Reserved for IBM internal use.
FLOWTYPE_ID BIGINT NOT NULL Reserved for IBM internal use.
FLSTATEGP_ID BIGINT Reserved for IBM internal use.
APPROVERMBRGRPNAME VARCHAR(254) Reserved for IBM internal use.
STATETYPE INTEGER NOT NULL Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000107 IDENTIFIER+FLOWTYPE_ID Unique Index
I0000108 STATENAME+FLOWTYPE_ID Unique Index
SQL050212031228320 FLSTATEDCT_ID Primary Key
I0000575 FLSTATEGP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_331 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade
F_332 FLSTATEGP_ID FLSTATEGP FLSTATEGP_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_66 FLSTATEDCT_ID APRVSTATUS FLSTATEDCT_ID Cascade
F_334 FLSTATEDCT_ID FLSTATEREL FLSTATEDCT_ID Cascade
F_336 FLSTATEDCT_ID FLSTDCTDSC FLSTATEDCT_ID Cascade
F_343 SOURCESTATE_ID FLTRANSITN FLSTATEDCT_ID Cascade
F_344 TARGETSTATE_ID FLTRANSITN FLSTATEDCT_ID Cascade

Feedback