Database Table: FLSTATEDCT

Reserved for IBM internal use.

Column Name Column Type Column Description
APPROVERMBRGRPNAME VARCHAR (254)
NULL
Reserved for IBM internal use.
FLOWTYPE_ID BIGINT
NOT NULL
Reserved for IBM internal use.
FLSTATEDCT_ID BIGINT
NOT NULL
Reserved for IBM internal use.
FLSTATEGP_ID BIGINT
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.
STATETYPE INTEGER
NOT NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000107 IDENTIFIER, FLOWTYPE_ID Unique Index
I0000108 STATENAME, FLOWTYPE_ID Unique Index
SQL030416034933810 FLSTATEDCT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_331 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade
F_332 FLSTATEGP_ID FLSTATEGP FLSTATEGP_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_334 FLSTATEDCT_ID FLSTATEREL FLSTATEDCT_ID Cascade
F_336 FLSTATEDCT_ID FLSTDCTDSC FLSTATEDCT_ID Cascade
F_343 FLSTATEDCT_ID FLTRANSITN SOURCESTATE_ID Cascade
F_344 FLSTATEDCT_ID FLTRANSITN TARGETSTATE_ID Cascade
F_66 FLSTATEDCT_ID APRVSTATUS FLSTATEDCT_ID Cascade