FLSTATEDCT

Reserved for IBM internal use.

Column Descriptions:

Name	Type	Description
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 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>	FLSTATEDCT_ID	Primary Key
I0000107	IDENTIFIER+FLOWTYPE_ID	Unique Index
I0000108	STATENAME+FLOWTYPE_ID	Unique Index
I0000575	FLSTATEGP_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_331	FLOWTYPE_ID	FLOWTYPE	FLOWTYPE_ID	Cascade
F_332	FLSTATEGP_ID	FLSTATEGP	FLSTATEGP_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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