APPROVAL_STATE_FLOW

This table holds the state transition allowed for a given approval type.

Column Descriptions:

Name	Type	Description
STATE_FLOW_ID	INT4 NOT NULL	The unique identifier for the approval state flow transition
APPROVAL_TYPE_ID	INT4 NOT NULL	Reference to the approval type for which the flow transitions are defined
SOURCE_STATE_ID	INT4 NOT NULL	Source state for the allowed transition
TARGET_STATE_ID	INT4 NOT NULL	Possible target state for the allowed transition
FLOW_ACTION_INTERFACE	TEXT	Class to be invoked for the allowed transition

Indexes:

Name	Column Names	Type
APPROVAL_STATE_FLOW_PKEY	STATE_FLOW_ID	Primary Key

Constrained by parent tables:

Constraint	Columns	Parent Table	Parent Columns	Type
APPROVAL_STATE_FLOW_APPROVAL_TYPE_ID_FKEY	APPROVAL_TYPE_ID	APPROVAL_TYPE	TYPE_ID	Simple
APPROVAL_STATE_FLOW_SOURCE_STATE_ID_FKEY	SOURCE_STATE_ID	APPROVAL_STATE	STATE_ID	Simple
APPROVAL_STATE_FLOW_TARGET_STATE_ID_FKEY	TARGET_STATE_ID	APPROVAL_STATE	STATE_ID	Simple

Referenced by child tables:

Constraint	Columns	Child Table	Child Columns	Type
APPROVAL_STATE_FLOW_STEPS_STATE_FLOW_ID_FKEY	STATE_FLOW_ID	APPROVAL_STATE_FLOW_STEPS	STATE_FLOW_ID	Simple