Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
offer_id | varchar | 2147483647 | null |
|
|
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 |
|
|
ID of the opportunity connected to this entity. |
|||||||||
posting_id | varchar | 2147483647 | √ | null |
|
|
ID of the posting connected to this entity. |
|||||||||
requisition_id | varchar | 2147483647 | √ | null |
|
|
ID of the requisition associated with this entity. |
|||||||||
active_revision_key | varchar | 2147483647 | √ | null |
|
|
ID of the active offer revision, currently sent out to the candidate. |
|||||||||
offer_status_id | varchar | 2147483647 | √ | 'NOT_APPLICABLE'::character varying |
|
|
ID of the current status for this offer. |
|||||||||
anticipated_start_date | timestamp | 29,6 | √ | null |
|
|
A default offer date form field. Date the candidate is anticipated to start. |
|||||||||
salary_amount | numeric | 131089 | √ | null |
|
|
A default offer form field. Compensation amount the candidate is offered. |
|||||||||
salary_interval | varchar | 2147483647 | √ | null |
|
|
A default offer form field. The time period for the amount of compensation the candidate is offered. |
|||||||||
compensation_currency | varchar | 2147483647 | √ | null |
|
|
A default offer form field. The currency that applies to the compensation the candidate is offered. |
|||||||||
last_sent_offer_revision_id | varchar | 2147483647 | √ | null |
|
|
The revision id for the most recent sent revision. |
|||||||||
last_sent_offer_revision_key | varchar | 2147483647 | √ | null |
|
|
The revision key for the most recent sent revision. |
|||||||||
last_sent_at | timestamp | 29,6 | √ | null |
|
|
Timestamp of most recent sent event for this offer |
|||||||||
last_signed_at | timestamp | 29,6 | √ | null |
|
|
Timestamp of most recent signed event for this offer |
|||||||||
last_declined_at | timestamp | 29,6 | √ | null |
|
|
Timestamp of most recent declined event for this offer |
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 |