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 (‘task_added’, ‘task_removed’, ‘task_completed’). | ||||||
| task_completed_at | timestamp | 29,6 | √ | null | Date the task was completed. | ||||||
| task_id | int4 | 10 | √ | null |
| Id of the task the record belongs to. | |||||
| task_title | varchar | 255 | √ | null | Task title. Note: this field is only available for primary user (with full access). | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |