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. | ||||||
| evaluation_id | int4 | 10 | √ | null |
| Id of the evaluation the record belongs to. | |||||
| evaluation_rating | varchar | 255 | √ | null | Evaluation rating. | ||||||
| event | varchar | 255 | √ | null | Interview event - one of (‘interview_rescheduled’, ‘interview_scheduled’, ‘interview_requested’, ‘interview_deleted’, ‘evaluation_added’, ‘questionnaire_added’, ‘evaluation_requested’, ‘questionnaire_requested’). | ||||||
| interview_duration | int4 | 10 | √ | null | Interview duration. | ||||||
| interview_id | int4 | 10 | √ | null |
| Id of the interview the record belongs to. | |||||
| interview_kind | varchar | 255 | √ | null | Interview kind. | ||||||
| interview_starts_at | varchar | 255 | √ | null | Start date of the interview. | ||||||
| questionnaire_id | int4 | 10 | √ | null |
| Id of the questionnaire the record belongs to. | |||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |