WebSphere Commerce database table: APRVSTATUS

APRVSTATUS

This table contains information about the status of an approval.

Column Descriptions:

Name Type Description
APRVSTATUS_ID BIGINT NOT NULL Primary key.
FLOW_ID BIGINT NOT NULL Reference to the flow for the steps in the approval process. Foreign key to FLOW_ID.
SUBMITTER_ID BIGINT NOT NULL ID of the user requesting the action which needs approval.
APPROVER_ID BIGINT The ID of the user eligible to approve or reject the requested action.
FLOWTYPE_ID BIGINT NOT NULL Foreign key reference to the type of flow that determines the type of business object included in the approval. There are different IDs for each type of approval, including RFQ, order, user registration, contract, organization registration approvals and so on. Foreign key to FLOWTYPE_ID.
ENTITY_ID BIGINT NOT NULL Reference to the business object; that is, which particular business object instance within the business object type specified by FLOWTYPE_ID.
MBRGRP_ID BIGINT NOT NULL The ID of the member group to which the approver belongs, making the approver an approver for this record.
FLSTATEDCT_ID BIGINT NOT NULL Current state of the flow instance.
STATUS INTEGER NOT NULL Approval status of this action. Valid values are as follows:

0=pending
1=approved
2=rejected

SUBMITTIME TIMESTAMP The time that the action requiring approval was requested.
ACTIONTIME TIMESTAMP The time when the approval record was acted on; that is, the time it was approved or rejected.
COMMENTS VARCHAR (254) Comments entered by approver during approval or rejection.
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> APRVSTATUS_ID Primary Key
I0000451 MBRGRP_ID Non-Unique Index
I922110 FLOW_ID+ENTITY_ID Non-Unique Index
I9221180 SUBMITTER_ID+APPROVER_ID+FLOWTYPE_ID+STATUS Non-Unique Index
I9221181 APPROVER_ID+STATUS+SUBMITTER_ID+FLOWTYPE_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_61 SUBMITTER_ID USERS USERS_ID Cascade
F_62 APPROVER_ID USERS USERS_ID Cascade
F_63 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_64 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade
F_65 FLOW_ID FLOW FLOW_ID Cascade
F_66 FLSTATEDCT_ID FLSTATEDCT FLSTATEDCT_ID Cascade

Name	Type	Description
APRVSTATUS_ID	BIGINT NOT NULL	Primary key.
FLOW_ID	BIGINT NOT NULL	Reference to the flow for the steps in the approval process. Foreign key to FLOW_ID.
SUBMITTER_ID	BIGINT NOT NULL	ID of the user requesting the action which needs approval.
APPROVER_ID	BIGINT	The ID of the user eligible to approve or reject the requested action.
FLOWTYPE_ID	BIGINT NOT NULL	Foreign key reference to the type of flow that determines the type of business object included in the approval. There are different IDs for each type of approval, including RFQ, order, user registration, contract, organization registration approvals and so on. Foreign key to FLOWTYPE_ID.
ENTITY_ID	BIGINT NOT NULL	Reference to the business object; that is, which particular business object instance within the business object type specified by FLOWTYPE_ID.
MBRGRP_ID	BIGINT NOT NULL	The ID of the member group to which the approver belongs, making the approver an approver for this record.
FLSTATEDCT_ID	BIGINT NOT NULL	Current state of the flow instance.
STATUS	INTEGER NOT NULL	Approval status of this action. Valid values are as follows: 0=pending 1=approved 2=rejected
SUBMITTIME	TIMESTAMP	The time that the action requiring approval was requested.
ACTIONTIME	TIMESTAMP	The time when the approval record was acted on; that is, the time it was approved or rejected.
COMMENTS	VARCHAR (254)	Comments entered by approver during approval or rejection.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	APRVSTATUS_ID	Primary Key
I0000451	MBRGRP_ID	Non-Unique Index
I922110	FLOW_ID+ENTITY_ID	Non-Unique Index
I9221180	SUBMITTER_ID+APPROVER_ID+FLOWTYPE_ID+STATUS	Non-Unique Index
I9221181	APPROVER_ID+STATUS+SUBMITTER_ID+FLOWTYPE_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_61	SUBMITTER_ID	USERS	USERS_ID	Cascade
F_62	APPROVER_ID	USERS	USERS_ID	Cascade
F_63	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade
F_64	FLOWTYPE_ID	FLOWTYPE	FLOWTYPE_ID	Cascade
F_65	FLOW_ID	FLOW	FLOW_ID	Cascade
F_66	FLSTATEDCT_ID	FLSTATEDCT	FLSTATEDCT_ID	Cascade