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 |