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. | ||||||
| email_message_from | varchar | 255 | √ | null | Name of the message sender. 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_message_subject | varchar | 255 | √ | null | Email message subject. Note: this field is only available for primary user (with full access). | ||||||
| email_thread_id | int4 | 10 | √ | null |
| Id of the email thread the record belongs to. | |||||
| email_thread_subject | varchar | 255 | √ | null | Email message thread. Note: this field is only available for primary user (with full access). | ||||||
| event | varchar | 255 | √ | null | Email activity event - one of (‘mailbox_bulk_message_sent’, ‘mailbox_message_received’, ‘mailbox_message_sent’, ‘mailbox_reply_received’, ‘mailbox_reply_sent’, ‘mailbox_thread_archived’, ‘mailbox_thread_converted’, ‘mailbox_thread_removed’, ‘mailbox_thread_unarchive’). | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |