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_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. | ||||||
| delivery_type | varchar | 255 | √ | null | Type of email message delivery - one of (‘from’, ‘to’, ‘cc’, ‘bcc’). | ||||||
| varchar | 255 | √ | null | Participant email. Note: this field is only available for primary user (with full access). | |||||||
| email_message_id | int4 | 10 | √ | null |
| Id of the email message the record belongs to. | |||||
| email_thread_id | int4 | 10 | √ | null |
| Id of the email thread the record belongs to. | |||||
| name | varchar | 255 | √ | null | Participant name. Note: this field is only available for primary user (with full access). | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |