Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null | Primary key. | |||||||
| candidate_activity_id | int4 | 10 | √ | null |
| Id of the candidate activity the record belongs to. | |||||
| 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. | ||||||
| duration | int4 | 10 | √ | null | Number of seconds the candidate spent in stage. (Candidate has to proceed between stages for the value to update, duration for their current stage will always be 0). | ||||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||
| placement_id | int4 | 10 | √ | null |
| Id of the placement the record belongs to. | |||||
| previous_stage_category | varchar | 255 | √ | null | Previous stage category name. | ||||||
| previous_stage_id | int4 | 10 | √ | null |
| Id of the previous stage candidate was in. | |||||
| previous_stage_name | varchar | 255 | √ | null | Previous stage name. | ||||||
| stage_category | varchar | 255 | √ | null | Stage category name. | ||||||
| stage_changed_at | timestamp | 29,6 | √ | null | Stage name. | ||||||
| stage_id | int4 | 10 | √ | null |
| Id of the stage the record belongs to. | |||||
| stage_name | varchar | 255 | √ | null | Stage name. | ||||||
| talent_pool_id | Unknown | 0 | null |
| Id of the talent pool the record belongs to. | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |