Column Type Size Nulls Auto Default Children Parents Comments
posting_id varchar 2147483647 null
postings.posting_id posting_approvers_posting_id_fkeyC

ID of the posting connected to this entity.

account_id varchar 2147483647 null

ID of the account the record belongs to.

approver_id varchar 2147483647 null
users.user_id posting_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 has approved this posting.

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)
posting_approvers_pkey Primary key Asc/Asc/Asc posting_id + approver_id + approval_step_index
posting_approvers_account_id_idx Performance Asc account_id
posting_approvers_approver_id_idx Performance Asc approver_id