# Nylas schema ERD

Table and field reference for the Fivetran Nylas connector.

## Table & Field Reference

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| email | Unknown |  |
| type | Unknown |  |

### contact_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| contact_id | Unknown | FK |
| name | Unknown |  |
| object | Unknown |  |
| path | Unknown |  |

### contact_im_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| im_address | Unknown |  |
| type | Unknown |  |

### contact_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| number | Unknown |  |
| type | Unknown |  |

### contact_physical_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| format | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| street_address | Unknown |  |
| type | Unknown |  |

### contact_web_page

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| type | Unknown |  |
| url | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| birthday | Unknown |  |
| company_name | Unknown |  |
| given_name | Unknown |  |
| job_title | Unknown |  |
| manager_name | Unknown |  |
| middle_name | Unknown |  |
| nickname | Unknown |  |
| notes | Unknown |  |
| object | Unknown |  |
| office_location | Unknown |  |
| picture_url | Unknown |  |
| source | Unknown |  |
| suffix | Unknown |  |
| surname | Unknown |  |

### participant

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| comment | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| status | Unknown |  |

### phone

| Column | Type | Keys |
| --- | --- | --- |
| phone | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| calendar_id | Unknown | FK |
| message_id | Unknown | FK |
| busy | Unknown |  |
| conferencing_details_meeting_code | Unknown |  |
| conferencing_provider | Unknown |  |
| customer_event_id | Unknown |  |
| description | Unknown |  |
| hide_participants | Unknown |  |
| ical_uid | Unknown |  |
| location | Unknown |  |
| object | Unknown |  |
| organizer_email | Unknown |  |
| organizer_name | Unknown |  |
| original_start_time | Unknown |  |
| owner | Unknown |  |
| read_only | Unknown |  |
| recurrence_rrule | Unknown |  |
| recurrence_timezone | Unknown |  |
| reminders_reminder_method | Unknown |  |
| reminders_reminder_minutes | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| visibility | Unknown |  |
| when_date_date | Unknown |  |
| when_date_object | Unknown |  |
| when_datespan_end_time | Unknown |  |
| when_datespan_object | Unknown |  |
| when_datespan_start_time | Unknown |  |
| when_time_object | Unknown |  |
| when_time_time | Unknown |  |
| when_time_timezone | Unknown |  |
| when_timespan_end_time | Unknown |  |
| when_timespan_end_timezone | Unknown |  |
| when_timespan_object | Unknown |  |
| when_timespan_start_time | Unknown |  |
| when_timespan_start_timezone | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| email_address | Unknown |  |
| linked_at | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| organization_unit | Unknown |  |
| provider | Unknown |  |
| sync_state | Unknown |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| display_name | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| provider_id | Unknown |  |

### folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| display_name | Unknown |  |
| name | Unknown |  |

### calendar

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| description | Unknown |  |
| is_primary | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| read_only | Unknown |  |
| timezone | Unknown |  |

### message_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| id | Unknown | FK |

### message_file

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| id | Unknown | FK |

### message_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| id | Unknown | FK |

### cid

| Column | Type | Keys |
| --- | --- | --- |
| content_id | Unknown | PK |
| message_id | Unknown | PK, FK |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| folder_id | Unknown | FK |
| thread_id | Unknown | FK |
| body | Unknown |  |
| date | Unknown |  |
| object | Unknown |  |
| reply_to_message_id | Unknown |  |
| snippet | Unknown |  |
| starred | Unknown |  |
| subject | Unknown |  |
| unread | Unknown |  |

### message_sender

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| object_type | Unknown | PK |
| message_id | Unknown | PK, FK |
| name | Unknown |  |

### message_recipient

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| object_type | Unknown | PK |
| message_id | Unknown | PK, FK |
| name | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| content_disposition | Unknown |  |
| content_type | Unknown |  |
| filename | Unknown |  |
| object | Unknown |  |
| size | Unknown |  |

### job_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| action | Unknown |  |
| created_at | Unknown |  |
| object | Unknown |  |
| status | Unknown |  |
| status_id | Unknown |  |

### draft_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| draft_id | Unknown | PK, FK |
| id | Unknown | FK |

### draft_file

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK |
| draft_id | Unknown | PK, FK |
| id | Unknown | FK |

### draft_folder

| Column | Type | Keys |
| --- | --- | --- |
| folder_id | Unknown | PK |
| draft_id | Unknown | PK, FK |
| id | Unknown | FK |

### draft_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK |
| draft_id | Unknown | PK, FK |
| id | Unknown | FK |

### draft_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| draft_id | Unknown | PK, FK |
| value | Unknown |  |

### draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| job_status_id | Unknown | FK |
| reply_to_message_id | Unknown | FK |
| thread_id | Unknown | FK |
| body | Unknown |  |
| content_id | Unknown |  |
| date | Unknown |  |
| object | Unknown |  |

### draft_sender

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| object_type | Unknown | PK |
| draft_id | Unknown | PK, FK |
| name | Unknown |  |

### draft_recipient

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| object_type | Unknown | PK |
| draft_id | Unknown | PK, FK |
| name | Unknown |  |

### thread_participant

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| thread_id | Unknown | FK |
| email | Unknown |  |
| name | Unknown |  |

### thread_draft

| Column | Type | Keys |
| --- | --- | --- |
| draft_id | Unknown | PK |
| thread_id | Unknown | PK, FK |
| id | Unknown | FK |

### thread_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK |
| thread_id | Unknown | PK, FK |
| id | Unknown | FK |

### thread_folder

| Column | Type | Keys |
| --- | --- | --- |
| folder_id | Unknown | PK |
| thread_id | Unknown | PK, FK |
| id | Unknown | FK |

### thread_message

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| thread_id | Unknown | PK, FK |
| id | Unknown | FK |

### thread

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| first_message_timestamp | Unknown |  |
| has_attachments | Unknown |  |
| last_message_received_timestamp | Unknown |  |
| last_message_sent_timestamp | Unknown |  |
| last_updated_timestamp | Instant |  |
| object | Unknown |  |
| snippet | Unknown |  |
| starred | Unknown |  |
| subject | Unknown |  |
| unread | Unknown |  |
| version | Unknown |  |

## Relationships

- contact_email(contact_id) → contact(id)
- contact_group(account_id) → account(account_id)
- contact_group(contact_id) → contact(id)
- contact_im_address(contact_id) → contact(id)
- contact_phone_number(contact_id) → contact(id)
- contact_physical_address(contact_id) → contact(id)
- contact_web_page(contact_id) → contact(id)
- contact(account_id) → account(account_id)
- participant(event_id) → event(id)
- phone(event_id) → event(id)
- event_metadata(event_id) → event(id)
- event(calendar_id) → calendar(id)
- event(account_id) → account(account_id)
- event(message_id) → message(id)
- label(account_id) → account(account_id)
- folder(account_id) → account(account_id)
- calendar(account_id) → account(account_id)
- message_event(message_id) → message(id)
- message_event(id) → event(id)
- message_file(id) → file(id)
- message_file(message_id) → message(id)
- message_label(id) → label(id)
- message_label(message_id) → message(id)
- cid(message_id) → message(id)
- message(folder_id) → folder(id)
- message(thread_id) → thread(id)
- message(account_id) → account(account_id)
- message_sender(message_id) → message(id)
- message_recipient(message_id) → message(id)
- file(account_id) → account(account_id)
- job_status(account_id) → account(account_id)
- draft_event(draft_id) → draft(id)
- draft_event(id) → event(id)
- draft_file(draft_id) → draft(id)
- draft_file(id) → file(id)
- draft_folder(draft_id) → draft(id)
- draft_folder(id) → folder(id)
- draft_label(draft_id) → draft(id)
- draft_label(id) → label(id)
- draft_metadata(draft_id) → draft(id)
- draft(reply_to_message_id) → message(reply_to_message_id)
- draft(thread_id) → thread(id)
- draft(job_status_id) → job_status(id)
- draft(account_id) → account(account_id)
- draft_sender(draft_id) → draft(id)
- draft_recipient(draft_id) → draft(id)
- thread_participant(thread_id) → thread(id)
- thread_draft(thread_id) → thread(id)
- thread_draft(id) → draft(id)
- thread_label(thread_id) → thread(id)
- thread_label(id) → label(id)
- thread_folder(thread_id) → thread(id)
- thread_folder(id) → folder(id)
- thread_message(thread_id) → thread(id)
- thread_message(id) → message(id)
- thread(account_id) → account(account_id)