Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
| Primary key. | ||||||
| admin_id | int4 | 10 | √ | null |
| Id of the admin the record belongs to. | |||||
| admin_name | varchar | 255 | √ | null | Admin name. | ||||||
| candidate_id | int4 | 10 | √ | null |
| Id of the candidate the record belongs to. | |||||
| candidate_name | varchar | 255 | √ | null | Candidate name. Note: this field is only available for primary user (with full access). | ||||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||
| created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||
| event | varchar | 255 | √ | null | Event name - one of (‘candidate_added’, ‘candidate_applied’, ‘candidate_merged’, ‘candidate_assigned_to_offer’, ‘candidate_removed_from_offer’, ‘candidate_disqualified’, ‘candidate_requalified’, ‘candidate_changed_stage’, ‘candidate_gone_overdue’). | ||||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||
| offer_kind | varchar | 255 | √ | null | Offer kind - one of (‘job’, ‘talent_pool’). | ||||||
| offer_title | varchar | 255 | √ | null | Offer title. | ||||||
| previous_stage_id | int4 | 10 | √ | null |
| Id of the previous stage candidate was in. | |||||
| previous_stage_name | varchar | 255 | √ | null | Name of the previous stage. | ||||||
| stage_id | int4 | 10 | √ | null |
| Id of the stage activity occured in. | |||||
| stage_name | varchar | 255 | √ | null | Name of the stage. | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |