APPROVAL

This table holds the details of the approval record.

Column Descriptions:

Name	Type	Description
APPROVAL_ID	INT4 NOT NULL	The unique identifier for the approval record
APPROVAL_TYPE_ID	INT4 NOT NULL	Reference to the approval type for which the record is created.
CREATED_TIME	TIMESTAMP	Time when the approval record is created.
UPDATED_TIME	TIMESTAMP	Time when the approval record is updated.
CURRENT_STATE_ID	INT4 NOT NULL	Representing the current state of the approval record. Reference to APPROVAL_STATE table
MARKFORDELETE	INT4 NOT NULL DEFAULT 0	Indicates when the approval record is marked for deletion. Possible values: 0=No, 1=Yes

Indexes:

Name	Column Names	Type
APPROVAL_PKEY	APPROVAL_ID	Primary Key

Constrained by parent tables:

Constraint	Columns	Parent Table	Parent Columns	Type
APPROVAL_APPROVAL_TYPE_ID_FKEY	APPROVAL_TYPE_ID	APPROVAL_TYPE	TYPE_ID	Simple
APPROVAL_CURRENT_STATE_ID_FKEY	CURRENT_STATE_ID	APPROVAL_STATE	STATE_ID	Simple

Referenced by child tables:

Constraint	Columns	Child Table	Child Columns	Type
NOTIFICATION_MSGSTORE_APPROVAL_ID_FKEY	APPROVAL_ID	NOTIFICATION_MSGSTORE	APPROVAL_ID	Simple
NOTIFICATION_ARCHIVES_APPROVAL_ID_FKEY	APPROVAL_ID	NOTIFICATION_ARCHIVES	APPROVAL_ID	Simple
COMMENT_APPROVAL_ID_FKEY	APPROVAL_ID	COMMENT	APPROVAL_ID	Simple
APPROVAL_STATE_FLOW_STEPS_APPROVAL_ID_FKEY	APPROVAL_ID	APPROVAL_STATE_FLOW_STEPS	APPROVAL_ID	Simple
SELLER_ORG_REQUEST_APPROVAL_ID_FKEY	APPROVAL_ID	SELLER_ORG_REQUEST	APPROVAL_ID	Simple