Nylas

Explore the interactive ERD

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	PKFK

event_metadata

Column	Type	Keys
`name`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown	FK

message_file

Column	Type	Keys
`file_id`	Unknown	PK
`message_id`	Unknown	PKFK
`id`	Unknown	FK

message_label

Column	Type	Keys
`label_id`	Unknown	PK
`message_id`	Unknown	PKFK
`id`	Unknown	FK

cid

Column	Type	Keys
`content_id`	Unknown	PK
`message_id`	Unknown	PKFK

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	PKFK
`name`	Unknown

message_recipient

Column	Type	Keys
`email`	Unknown	PK
`object_type`	Unknown	PK
`message_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown	FK

draft_file

Column	Type	Keys
`file_id`	Unknown	PK
`draft_id`	Unknown	PKFK
`id`	Unknown	FK

draft_folder

Column	Type	Keys
`folder_id`	Unknown	PK
`draft_id`	Unknown	PKFK
`id`	Unknown	FK

draft_label

Column	Type	Keys
`label_id`	Unknown	PK
`draft_id`	Unknown	PKFK
`id`	Unknown	FK

draft_metadata

Column	Type	Keys
`name`	Unknown	PK
`draft_id`	Unknown	PKFK
`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	PKFK
`name`	Unknown

draft_recipient

Column	Type	Keys
`email`	Unknown	PK
`object_type`	Unknown	PK
`draft_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown	FK

thread_label

Column	Type	Keys
`label_id`	Unknown	PK
`thread_id`	Unknown	PKFK
`id`	Unknown	FK

thread_folder

Column	Type	Keys
`folder_id`	Unknown	PK
`thread_id`	Unknown	PKFK
`id`	Unknown	FK

thread_message

Column	Type	Keys
`message_id`	Unknown	PK
`thread_id`	Unknown	PKFK
`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