# Mixmax schema ERD

Table and field reference for the Fivetran Mixmax connector.

## 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 | PK, FK |
| 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 | PK, FK |
| groups_id | Unknown | PK, FK |
| google_contact_id | Unknown |  |

### sequence_variable

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sequence_id | Unknown | PK, FK |
| variable | Unknown |  |

### sequence_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sequence_id | Unknown | PK, FK |
| stage_id | Unknown |  |

### sequence_bcc

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sequence_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### sequence_cc

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sequence_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |

### meeting_type_custom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_type_id | Unknown | PK, FK |
| label | Unknown |  |
| label_valid | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### meeting_type_calendar

| Column | Type | Keys |
| --- | --- | --- |
| calendar_id | Unknown | PK, FK |
| meeting_type_id | Unknown | PK, FK |

### meeting_type_rule

| Column | Type | Keys |
| --- | --- | --- |
| meeting_type_id | Unknown | PK, FK |
| rule_id | Unknown | PK, FK |

### 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 | PK, FK |
| team_id | Unknown | PK, FK |

### message_snippet

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

### message_crms_connected

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_id | Unknown | PK, FK |
| log_to | Unknown |  |
| name | Unknown |  |

### message_to

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

### message_cc

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

### message_bcc

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

### message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- live_feed_recipient(live_feed_id) → live_feed(id)
- live_feed(message_id) → message(id)
- unsubscribe(team_id) → team(id)
- unsubscribe(message_id) → message(id)
- live_feed_event(message_id) → message(id)
- contact_group(contact_id) → contact(id)
- contact_group(groups_id) → groups(id)
- sequence_variable(sequence_id) → sequence(id)
- sequence_stage(sequence_id) → sequence(id)
- sequence_bcc(sequence_id) → sequence(id)
- sequence_cc(sequence_id) → sequence(id)
- sequence_folder(folder_id) → folder(id)
- insight_report(user_id) → contact(user_id)
- rule_action(rule_id) → rule(id)
- meeting_invite_event(message_id) → message(id)
- meeting_invite_event(meeting_invite_id) → meeting_invite_timeslot(meeting_invite_id)
- meeting_invite_timeslot(meeting_invite_id) → meeting_invite(id)
- meeting_type_guest(meeting_type_id) → meeting_type(id)
- meeting_type_custom(meeting_type_id) → meeting_type(id)
- meeting_type_calendar(calendar_id) → meeting_invite(calendar_id)
- meeting_type_calendar(meeting_type_id) → meeting_type(id)
- meeting_type_rule(rule_id) → rule(id)
- meeting_type_rule(meeting_type_id) → meeting_type(id)
- team_member(team_id) → team(id)
- message_team(team_id) → team(id)
- message_team(message_id) → message(id)
- message_snippet(snippet_id) → snippet(id)
- message_snippet(message_id) → message(id)
- message_crms_connected(message_id) → message(id)
- message_to(message_id) → message(id)
- message_cc(message_id) → message(id)
- message_bcc(message_id) → message(id)
- message_attachment(message_id) → message(id)
- message(sequence_id) → sequence(id)
- recipient_stage(recipient_id) → recipient(id)
- recipient(sequence_id) → sequence(id)
- sequence_search_stage(sequence_search_id) → sequence_search(id)