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 | 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 |