Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
| Primary key. | ||||||||||||
| candidate_id | int4 | 10 | √ | null |
| Id of the candidate the record belongs to. | |||||||||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||||||||
| created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||||||||
| disqualified_at | timestamp | 29,6 | √ | null | Date the candidate has been disqualified from a job/talent pool. | ||||||||||||
| disqualify_kind | varchar | 255 | √ | null | Disqualification kind - one of (‘admin’, ‘system’). | ||||||||||||
| disqualify_reason | varchar | 255 | √ | null | Disqualification reason. | ||||||||||||
| disqualifying_admin_id | int4 | 10 | √ | null |
| Id of the admin the candidate was disqualified by. | |||||||||||
| hired_at | timestamp | 29,6 | √ | null | Date the candidate was hired. | ||||||||||||
| hiring_admin_id | int4 | 10 | √ | null |
| Id of the admin the candidate was hired by. | |||||||||||
| is_hired | bool | 1 | √ | null | Whether candidate was hired. | ||||||||||||
| job_starts_at | timestamp | 29,6 | √ | null | Date of anticipated job start date. | ||||||||||||
| moved_at | timestamp | 29,6 | √ | null | Date the candidate has been proceeded between stages in a job. | ||||||||||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||||||||
| overdue_at | timestamp | 29,6 | √ | null | Date the placement in a job becomes overdue. | ||||||||||||
| positive_ratings | int4 | 10 | √ | null | Candidate score for specific placement (offer). | ||||||||||||
| proceeded_at | timestamp | 29,6 | √ | null | Date the candidate was proceeded (moved from the initial stages). | ||||||||||||
| proceeding_admin_id | int4 | 10 | √ | null |
| Id of the admin the candidate was proceeded by. | |||||||||||
| reached_interview_stage_at | timestamp | 29,6 | √ | null | Date the candidate has reached interview stage in a job. | ||||||||||||
| reached_offer_stage_at | timestamp | 29,6 | √ | null | Date the candidate has reached offer stage in a job. | ||||||||||||
| stage_id | int4 | 10 | √ | null |
| Id of the stage the record belongs to. | |||||||||||
| talent_pool_id | int4 | 10 | √ | null |
| Id of the talent pool the record belongs to. | |||||||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. | ||||||||||||
| work_location_id | int4 | 10 | √ | null |
| Id of the location the hired candidate belongs to. |