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. | ||||||||
| candidate_email | varchar | 255 | √ | null | Candidate email address. | |||||||||
| 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 | Interview duration. | |||||||||
| kind | varchar | 255 | √ | null | Interview kind. | |||||||||
| location | varchar | 255 | √ | null | Interview location. | |||||||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | ||||||||
| organizer_id | int4 | 10 | √ | null |
| Id of the admin the event was organized by. | ||||||||
| reschedule_reason | varchar | 65535 | √ | null | Reason for rescheduling interview. | |||||||||
| rescheduled | bool | 1 | √ | null | Whether the interview was rescheduled. | |||||||||
| rescheduler_id | int4 | 10 | √ | null |
| Id of the admin the event was rescheduled by. | ||||||||
| scheduled | bool | 1 | √ | null | Whether the interview was scheduled. | |||||||||
| scheduler | varchar | 255 | √ | null | Interview scheduler. | |||||||||
| stage_id | int4 | 10 | √ | null |
| Id of the stage the record belongs to. | ||||||||
| starts_at | timestamp | 29,6 | √ | null | Interview start date. | |||||||||
| talent_pool_id | int4 | 10 | √ | null |
| Id of the talent pool the record belongs to. | ||||||||
| timezone | varchar | 255 | √ | null | Interview timezone. | |||||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. | |||||||||
| video_provider | varchar | 255 | √ | null | Provider for the interview video call - one of (‘recruitee’, ‘zoom’, ‘google’). |