HubSpotEmails
| Column | Type | Notes |
|---|---|---|
| archived | BINARY | |
| createdAt | DATETIME | |
| hs_body_preview_html | TEXT | |
| hs_body_preview | TEXT | |
| hs_created_by_user_id | WHOLE NUMBER | |
| hs_created_by | WHOLE NUMBER | |
| hs_email_attached_video_id | TEXT | |
| hs_email_attached_video_name | TEXT | |
| hs_email_attached_video_opened | BINARY | |
| hs_email_attached_video_watched | BINARY | |
| hs_email_bcc_email | TEXT | |
| hs_email_bcc_firstname | TEXT | |
| hs_email_bcc_lastname | TEXT | |
| hs_email_bcc_raw | TEXT | |
| hs_email_cc_email | TEXT | |
| hs_email_cc_firstname | TEXT | |
| hs_email_cc_lastname | TEXT | |
| hs_email_cc_raw | TEXT | |
| hs_email_direction | TEXT | |
| hs_email_encoded_email_associations_request | TEXT | |
| hs_email_error_message | TEXT | |
| hs_email_facsimile_send_id | TEXT | |
| hs_email_from_email | TEXT | |
| hs_email_from_firstname | TEXT | |
| hs_email_from_lastname | TEXT | |
| hs_email_from_raw | TEXT | |
| hs_email_headers | TEXT | |
| hs_email_html | TEXT | |
| hs_email_logged_from | TEXT | |
| hs_email_media_processing_status | TEXT | |
| hs_email_member_of_forwarded_subthread | TEXT | |
| hs_email_message_id | TEXT | |
| hs_email_migrated_via_portal_data_migration | TEXT | |
| hs_email_post_send_status | TEXT | |
| hs_email_send_event_id_created | TEXT | |
| hs_email_send_event_id | TEXT | |
| hs_email_sender_email | TEXT | |
| hs_email_sender_firstname | TEXT | |
| hs_email_sender_lastname | TEXT | |
| hs_email_sender_raw | TEXT | |
| hs_email_sent_via | TEXT | |
| hs_email_status | TEXT | |
| hs_email_subject | TEXT | |
| hs_email_text | TEXT | |
| hs_email_thread_id | TEXT | |
| hs_email_to_email | TEXT | |
| hs_email_to_firstname | TEXT | |
| hs_email_to_lastname | TEXT | |
| hs_email_to_raw | TEXT | |
| hs_email_tracker_key | TEXT | |
| hs_email_validation_skipped | TEXT | |
| hs_engagement_source_id | TEXT | |
| hs_engagement_source | TEXT | |
| hs_follow_up_action | TEXT | |
| hs_gdpr_deleted | BINARY | |
| hubspot_owner_assigneddate | TEXT | |
| hubspot_owner_id | WHOLE NUMBER | |
| id | WHOLE NUMBER | |
| updatedAt | DATETIME | |
| LastTugDate | WHOLE NUMBER | |
| Deleted | BINARY |