requisition_approvers


Description

A row in this table represents a connection between a requisition and the people involved in its approval.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
requisition_id varchar 2147483647 null
requisitions.requisition_id requisition_approvers_requisition_id_fkeyC

ID of the requisition associated with this entity.

account_id varchar 2147483647 null

ID of the account the record belongs to.

approver_id varchar 2147483647 null
users.user_id requisition_approvers_approver_id_fkeyN

The approver for the entity in this entity.

approval_step_index numeric 131089 null

Represent the order of the step in the approval sequence. The lowest the index, the earliest the step is in the chain. Starts at 0.

approver_decided_at timestamp 29,6 null

Date and time when the approval decision was made.

approver_index numeric 131089 null

Represent the order of the approver.

is_approved bool 1 null

TRUE if the approver approved this requisition.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
requisition_approvers_pkey Primary key Asc/Asc/Asc requisition_id + approver_id + approval_step_index
req_approvers_account_id_idx Performance Asc account_id
req_approvers_approver_id_idx Performance Asc approver_id

Relationships