Mixmax

Explore the interactive ERD

Table & Field Reference

snippet

Column	Type	Keys
`id`	Unknown	PK
`archived_at`	Unknown
`created_at`	Unknown
`custom_shortcut`	Unknown
`deleted_at`	Unknown
`is_inline`	Unknown
`name`	Unknown
`saved_at`	Unknown
`saved_by`	Unknown
`shared`	Json
`source`	Unknown
`tag_id`	Unknown
`tag_name`	Unknown
`title`	Unknown
`user_id`	Unknown

live_feed_recipient

Column	Type	Keys
`index`	Unknown	PK
`live_feed_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

live_feed

Column	Type	Keys
`id`	Unknown	PK
`message_id`	Unknown	FK
`from_email`	Unknown
`from_name`	Unknown
`include_in_team_live_feed`	Unknown
`last_event_at`	Unknown
`last_event_by_email`	Unknown
`last_event_by_name`	Unknown
`last_event_type`	Unknown
`num_click`	Unknown
`num_download`	Unknown
`num_open`	Unknown
`perma_link`	Unknown
`sent`	Unknown
`service`	Unknown
`service_thread_id`	Unknown
`show_content_team_feed`	Unknown
`subject`	Unknown
`tracking_muted`	Unknown
`user_id`	Unknown
`was_accepted`	Unknown
`was_bounced`	Unknown
`was_declined`	Unknown
`was_replied`	Unknown
`was_tentative`	Unknown

unsubscribe

Column	Type	Keys
`id`	Unknown	PK
`message_id`	Unknown	FK
`team_id`	Unknown	FK
`email`	Unknown
`name`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`google_contact_id`	Unknown
`name`	Unknown
`saleforce_id`	Unknown
`time_stamp`	Unknown
`used_count`	Unknown
`user_id`	Unknown
`analytics_`
`locked_`
`meta_`

live_feed_event

Column	Type	Keys
`_fivetran_id`	String	PK
`message_id`	Unknown	FK
`city`	Unknown
`country`	Unknown
`file_name`	Unknown
`id`	Unknown
`is_mobile`	Unknown
`link_text`	Unknown
`link_url`	Unknown
`opereting_system`	Unknown
`program`	Unknown
`recipient_email`	Unknown
`recipient_name`	Unknown
`region`	Unknown
`time_stamp`	Unknown
`type`	Unknown

contact_group

Column	Type	Keys
`contact_id`	Unknown	PKFK
`groups_id`	Unknown	PKFK
`google_contact_id`	Unknown

sequence_variable

Column	Type	Keys
`index`	Unknown	PK
`sequence_id`	Unknown	PKFK
`variable`	Unknown

sequence_stage

Column	Type	Keys
`index`	Unknown	PK
`sequence_id`	Unknown	PKFK
`stage_id`	Unknown

sequence_bcc

Column	Type	Keys
`index`	Unknown	PK
`sequence_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

sequence_cc

Column	Type	Keys
`index`	Unknown	PK
`sequence_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

sequence

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`file_track_enabled`	Unknown
`link_track_enabled`	Unknown
`name`	Unknown
`notification_enabled`	Unknown
`sync_org`	Unknown
`timezone`	Unknown
`updated_at`	Unknown
`user_id`	Unknown

sequence_folder

Column	Type	Keys
`sequence_id`	Unknown	PK
`folder_id`	Unknown	PKFK

folder

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`saved_at`	Unknown
`shared`	Json
`user_id`	Unknown

insight_report

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`created_at`	Unknown
`query`	Unknown
`shared`	Json
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown

rule_action

Column	Type	Keys
`id`	Unknown	PK
`rule_id`	Unknown	FK
`body`	Unknown
`created_at`	Unknown
`delta_`	Unknown
`delta_unit`	Unknown
`is_paused`	Unknown
`modified_at`	Unknown
`subject`	Unknown
`type`	Unknown

rule

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`filter`	Unknown
`is_paused`	Unknown
`modified_at`	Unknown
`name`	Unknown
`trigger_event_name`	Unknown
`trigger_type`	Unknown
`user_id`	Unknown

meeting_invite_event

Column	Type	Keys
`_fivetran_id`	String	PK
`meeting_invite_id`	Unknown	FK
`message_id`	Unknown	FK
`custom_`	Unknown
`guest_email`	Unknown
`guest_name`	Unknown
`id`	Unknown
`ip_address`	Unknown
`responded_at`	Unknown
`user_agent`	Unknown

meeting_invite_timeslot

Column	Type	Keys
`index`	Unknown	PK
`meeting_invite_id`	Unknown	PKFK
`end_`	Unknown
`start`	Unknown

meeting_invite

Column	Type	Keys
`id`	Unknown	PK
`additional_guest`	Json
`allow_double_booking`	Unknown
`any_room_in_building`	Json
`calendar_id`	Unknown
`calendar_name`	Unknown
`created_by`	Unknown
`creation_date`	Unknown
`description`	Unknown
`guest_can_modify`	Unknown
`include_message_link`	Unknown
`integration_zoom`	Unknown
`locale`	Unknown
`location`	Unknown
`meeting_type_id`	Unknown
`room_and_resource`	Json
`timezone`	Unknown
`title`	Unknown
`user_id`	Unknown

meeting_type_guest

Column	Type	Keys
`index`	Unknown	PK
`meeting_type_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown
`required`	Unknown

meeting_type_custom

Column	Type	Keys
`index`	Unknown	PK
`meeting_type_id`	Unknown	PKFK
`label`	Unknown
`label_valid`	Unknown
`required`	Unknown
`type`	Unknown

meeting_type_calendar

Column	Type	Keys
`calendar_id`	Unknown	PKFK
`meeting_type_id`	Unknown	PKFK

meeting_type_rule

Column	Type	Keys
`meeting_type_id`	Unknown	PKFK
`rule_id`	Unknown	PKFK

meeting_type

Column	Type	Keys
`id`	Unknown	PK
`any_room_in_building`	Json
`buffer`	Unknown
`copy_of`	Unknown
`created_at`	Unknown
`day_end`	Unknown
`day_start`	Unknown
`day_unit`	Unknown
`description`	Unknown
`duration_min`	Unknown
`end_date`	Unknown
`guest_can_modify_invite`	Unknown
`include_message_link`	Unknown
`integration_zoom`	Unknown
`link`	Unknown
`location`	Unknown
`name`	Unknown
`page_title`	Unknown
`prevent_book`	Json
`reduced_interval`	Unknown
`room_and_resource`	Json
`round_queue`	Json
`start_date`	Unknown
`title`	Unknown
`updated_at`	Unknown
`use_specific_date`	Unknown
`user_id`	Unknown

meeting_type_day

Column	Type	Keys
`_fivetran_id`	String	PK
`day`	Unknown
`enabled`	Unknown
`end_time`	Unknown
`meeting_type_id`	Unknown
`start_time`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`shared`	Json
`url`	Unknown
`user_id`	Unknown

team_member

Column	Type	Keys
`member_id`	Unknown	PK
`team_id`	Unknown	FK
`accepted`	Unknown
`accepted_at`	Unknown
`created_at`	Unknown
`email`	Unknown
`invited_at`	Unknown
`name`	Unknown
`role`	Unknown
`user_id`	Unknown

team

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`modified_at`	Unknown
`name`	Unknown

message_team

Column	Type	Keys
`message_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

message_snippet

Column	Type	Keys
`message_id`	Unknown	PKFK
`snippet_id`	Unknown	PKFK

message_crms_connected

Column	Type	Keys
`index`	Unknown	PK
`message_id`	Unknown	PKFK
`log_to`	Unknown
`name`	Unknown

message_to

Column	Type	Keys
`index`	Unknown	PK
`message_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

message_cc

Column	Type	Keys
`index`	Unknown	PK
`message_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

message_bcc

Column	Type	Keys
`index`	Unknown	PK
`message_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

message_attachment

Column	Type	Keys
`index`	Unknown	PK
`message_id`	Unknown	PKFK
`name`	Unknown
`size`	Unknown
`type`	Unknown

message

Column	Type	Keys
`id`	Unknown	PK
`sequence_id`	Unknown	FK
`body`	Unknown
`created`	Unknown
`error_response`	Unknown
`file_tracking_enabled`	Unknown
`follow_up_description`	Unknown
`follow_up_trigger`	Unknown
`follow_up_unparsed_date`	Unknown
`from_email`	Unknown
`from_is_delegated`	Unknown
`from_name`	Unknown
`link_tracking_enabled`	Unknown
`notification_enabled`	Unknown
`scheduled`	Unknown
`sending_error`	Unknown
`sent`	Unknown
`subject`	Unknown
`sync_to_org`	Unknown
`tracking_enabled`	Unknown
`updated_at`	Unknown
`user_has_modified`	Unknown
`user_id`	Unknown

code_snippet

Column	Type	Keys
`id`	Unknown	PK
`background`	Unknown
`code`	Unknown
`created_at`	Unknown
`html`	Unknown
`languages`	Unknown
`theme`	Unknown
`title`	Unknown
`user_id`	Unknown

recipient_stage

Column	Type	Keys
`_fivetran_id`	String	PK
`recipient_id`	Unknown	FK
`accepted`	Unknown
`bounced`	Unknown
`click`	Unknown
`declined`	Unknown
`download`	Unknown
`failed_error`	Unknown
`from_email`	Unknown
`from_name`	Unknown
`has_files`	Unknown
`has_link`	Unknown
`has_open`	Unknown
`initial_scheduled_at`	Unknown
`opens`	Unknown
`ordinal`	Unknown
`processed_at`	Unknown
`replied`	Unknown
`schedule`	Unknown
`scheduled_at`	Unknown
`scheduled_end`	Unknown
`scheduled_start`	Unknown
`scheduled_timezone`	Unknown
`sender_replied`	Unknown
`sending_error`	Unknown
`sent_at`	Unknown
`stage_id`	Unknown
`state`	Unknown
`task_assignee`	Unknown
`task_created_at`	Unknown
`task_id`	Unknown
`task_message_status`	Unknown
`task_status`	Unknown
`tentative`	Unknown
`trigger`	Unknown
`type`	Unknown

recipient

Column	Type	Keys
`id`	Unknown	PK
`sequence_id`	Unknown	FK
`completed_reason`	Unknown
`created_at`	Unknown
`event_click`	Unknown
`event_download`	Unknown
`event_open`	Unknown
`last_stage_sent_ordinal`	Unknown
`rst_failed`	Unknown
`state`	Unknown
`to_email`	Unknown
`to_name`	Unknown
`user_id`	Unknown

sequence_search_stage

Column	Type	Keys
`id`	Unknown	PK
`sequence_search_id`	Unknown	PKFK
`delegator_email`	Unknown
`delegator_name`	Unknown
`did_exit_from`	Unknown
`did_unsubscribe_from`	Unknown
`failed_error`	Unknown
`from_email`	Unknown
`from_name`	Unknown
`initial_scheduled_at`	Unknown
`is_active`	Unknown
`is_completed`	Unknown
`is_last_processed_stage`	Unknown
`is_next_stage`	Unknown
`is_paused`	Unknown
`is_scheduled`	Unknown
`message_id`	Unknown
`num_click`	Unknown
`num_delivered`	Unknown
`num_download`	Unknown
`num_open`	Unknown
`ordinal`	Unknown
`processed_at`	Unknown
`saleforce_task_assignee`	Unknown
`saleforce_task_created_at`	Unknown
`saleforce_task_id`	Unknown
`saleforce_task_status`	Unknown
`scheduled_at`	Unknown
`sending_error`	Unknown
`sent_at`	Unknown
`state`	Unknown
`task_assignee_id`	Unknown
`task_created_at`	Unknown
`task_id`	Unknown
`task_status`	Unknown
`trigger`	Unknown
`type`	Unknown
`was_accepted`	Unknown
`was_bounced`	Unknown
`was_clicked`	Unknown
`was_declined`	Unknown
`was_delivered`	Unknown
`was_delivered_with_tracked_file`	Unknown
`was_delivered_with_tracked_invite`	Unknown
`was_delivered_with_tracked_link`	Unknown
`was_delivered_with_tracked_open`	Unknown
`was_downloaded`	Unknown
`was_opened`	Unknown
`was_processed`	Unknown
`was_replied`	Unknown
`was_sender_replied`	Unknown
`was_sent`	Unknown
`was_task_created`	Unknown
`was_task_deleted`	Unknown
`was_tentative`	Unknown

sequence_search

Column	Type	Keys
`id`	Unknown	PK
`completed_at`	Unknown
`completed_reason`	Unknown
`created_at`	Unknown
`domain`	Unknown
`email`	Unknown
`last_stage_sent_ordinal`	Unknown
`last_stage_sent_processed_at`	Unknown
`name`	Unknown
`recipient_id`	Unknown
`sequence_id`	Unknown
`sequence_name`	Unknown
`state`	Unknown
`to_email`	Unknown
`to_name`	Unknown
`user_id`	Unknown