offers


Description

A row in this table represents an offer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
offer_id varchar 2147483647 null
offer_approvers.offer_id offer_approvers_offer_id_fkeyC
offer_events.offer_id offer_events_offer_id_fkeyN
offer_revision_fields.offer_id offer_revision_fields_offer_id_fkeyN
offer_revisions.offer_id offer_revisions_offer_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.

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.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id offers_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

posting_id varchar 2147483647 null
postings.posting_id offers_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id offers_requisition_id_fkeyN

ID of the requisition associated with this entity.

Indexes

Constraint Name Type Sort Column(s)
offers_pkey Primary key Asc offer_id
offers_account_id_index Performance Asc account_id
offers_opportunity_id_idx Performance Asc opportunity_id
offers_posting_id_idx Performance Asc posting_id
offers_requisition_id_idx Performance Asc requisition_id

Relationships