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


Column Type Size Nulls Auto Default Children Parents Comments
offer_id varchar 2147483647 null
offers.offer_id offer_approvers_offer_id_fkeyC

ID of the offer.

account_id varchar 2147483647 null

ID of the account the record belongs to.

approver_id varchar 2147483647 null
users.user_id offer_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 this approver approved the offer.

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.


Constraint Name Type Sort Column(s)
offer_approvers_pkey Primary key Asc/Asc/Asc offer_id + approver_id + approval_step_index
offer_approvers_account_id_idx Performance Asc account_id
offer_approvers_approver_id_idx Performance Asc approver_id