# Missive schema ERD

Table and field reference for the Fivetran Missive connector.

## Table & Field Reference

### contact_info

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| contact_id | Unknown | FK |
| custom_label | Unknown |  |
| kind | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### contact_membership

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| kind | Unknown |  |
| name | Unknown |  |
| title | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_book_id | Unknown | FK |
| deleted | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| modified_at | Unknown |  |
| starred | Unknown |  |

### shared_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| color | Unknown |  |
| name | Unknown |  |
| name_with_parent_names | Unknown |  |
| parent | Unknown |  |
| share_with_organization | Unknown |  |
| share_with_team | Unknown |  |
| share_with_users | Unknown |  |
| visibility | Unknown |  |

### conversation_message_in_reply_to

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_message_id | Unknown | PK, FK |
| in_reply_to | Unknown |  |

### conversation_message_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_message_id | Unknown | PK, FK |
| reference | Unknown |  |

### conversation_message_to_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_message_id | Unknown | FK |
| address | Unknown |  |
| name | Unknown |  |

### conversation_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_message_id | Unknown | PK, FK |
| extension | Unknown |  |
| filename | Unknown |  |
| height | Unknown |  |
| media_type | Unknown |  |
| size | Unknown |  |
| sub_type | Unknown |  |
| url | Unknown |  |
| width | Unknown |  |

### conversation_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author | Unknown |  |
| bcc_field | Json |  |
| cc_field | Json |  |
| created_at | Unknown |  |
| delivered_at | Unknown |  |
| email_message_id | Unknown |  |
| from_field_address | Unknown |  |
| from_field_name | Unknown |  |
| preview | Unknown |  |
| reply_to_field | Json |  |
| subject | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### contact_group_organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| temp_contact_book_id | Unknown | PK |
| kind | String |  |
| name | Unknown |  |

### contact_book

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| share_with_team | Unknown | FK |
| user_id | Unknown | FK |
| description | Unknown |  |
| email_account_id | Unknown |  |
| exclude_from_search | Unknown |  |
| import_error_text | Unknown |  |
| import_processed_rows_count | Unknown |  |
| import_rows_count | Unknown |  |
| importing | Unknown |  |
| name | Unknown |  |
| share_with_organization | Unknown |  |
| share_with_users | Json |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar_url | Unknown |  |
| email | Unknown |  |
| me | Unknown |  |
| name | Unknown |  |

### conversation_author

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| address | Unknown |  |
| name | Unknown |  |

### conversation_external_author

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| conversation_id | Unknown | FK |
| address | Unknown |  |
| name | Unknown |  |

### conversation_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| archived | Unknown |  |
| assigned | Unknown |  |
| closed | Unknown |  |
| email | Unknown |  |
| flagged | Unknown |  |
| junked | Unknown |  |
| name | Unknown |  |
| snoozed | Unknown |  |
| trashed | Unknown |  |
| unassigned | Unknown |  |

### conversation_assignee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| archived | Unknown |  |
| assigned | Unknown |  |
| closed | Unknown |  |
| email | Unknown |  |
| flagged | Unknown |  |
| junked | Unknown |  |
| name | Unknown |  |
| snoozed | Unknown |  |
| trashed | Unknown |  |
| unassigned | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| team_id | Unknown | FK |
| app_url | Unknown |  |
| assignee_emails | Unknown |  |
| assignee_names | Unknown |  |
| attachments_count | Unknown |  |
| color | Unknown |  |
| completed_tasks_count | Unknown |  |
| drafts_count | Unknown |  |
| last_activity_at | Unknown |  |
| latest_message_subject | Unknown |  |
| messages_count | Unknown |  |
| send_later_messages_count | Unknown |  |
| shared_label_names | Unknown |  |
| shared_labels | Json |  |
| subject | Unknown |  |
| tasks_count | Unknown |  |
| web_url | Unknown |  |

## Relationships

- contact_info(contact_id) → contact(id)
- contact_membership(id) → contact_group_organization(id)
- contact_membership(contact_id) → contact(id)
- contact(contact_book_id) → contact_book(id)
- shared_label(organization_id) → organization(id)
- conversation_message_in_reply_to(conversation_message_id) → conversation_message(id)
- conversation_message_reference(conversation_message_id) → conversation_message(id)
- conversation_message_to_field(conversation_message_id) → conversation_message(id)
- conversation_message_attachment(conversation_message_id) → conversation_message(id)
- contact_book(user_id) → users(id)
- contact_book(share_with_team) → team(id)
- contact_book(organization_id) → organization(id)
- team(organization_id) → organization(id)
- conversation_author(conversation_id) → conversation(id)
- conversation_external_author(conversation_id) → conversation(id)
- conversation_user(conversation_id) → conversation(id)
- conversation_assignee(conversation_id) → conversation(id)
- conversation(organization_id) → organization(id)
- conversation(team_id) → team(id)