requisition_postings


Description

A row in this table represents a connection between a requisition and job posting.

Columns

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

ID of the requisition associated with this entity.

posting_id varchar 2147483647 null
postings.posting_id requisition_postings_posting_id_fkeyC

ID of the posting connected to this entity.

account_id varchar 2147483647 null

ID of the account the record belongs to.

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_postings_pkey Primary key Asc/Asc requisition_id + posting_id
requisition_postings_account_id_index Performance Asc account_id
requisition_postings_posting_id_index Performance Asc posting_id

Relationships