# Gmail schema ERD

Table and field reference for the Fivetran Gmail connector.

## Table & Field Reference

### profile

| Column | Type | Keys |
| --- | --- | --- |
| email_id | Unknown | PK |
| history_id | Unknown |  |
| total_message | Unknown |  |
| total_thread | Unknown |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| background_color | Unknown |  |
| label_list_visibility | Unknown |  |
| message_list_visibility | Unknown |  |
| name | Unknown |  |
| text_color | Unknown |  |
| total_message | Unknown |  |
| total_thread | Unknown |  |
| type | Unknown |  |
| unread_message | Unknown |  |
| unread_thread | Unknown |  |

### thread

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| history_id | Unknown |  |
| snippet | Unknown |  |

### message_sub_part_header

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_id | Unknown | PK, FK |
| part_id | Unknown | PK, FK |
| sub_part_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### message_payload_sub_part_body

| Column | Type | Keys |
| --- | --- | --- |
| sub_nested_part_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| part_id | Unknown | PK, FK |
| sub_part_id | Unknown | PK, FK |
| attachment_id | Unknown |  |
| data | Unknown |  |
| filename | Unknown |  |
| headers | Json |  |
| mime_type | Unknown |  |
| parts | Json |  |
| size | Unknown |  |

### message_payload_sub_part

| Column | Type | Keys |
| --- | --- | --- |
| sub_part_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| part_id | Unknown | PK, FK |
| attachment_id | Unknown |  |
| data | Unknown |  |
| filename | Unknown |  |
| mime_type | Unknown |  |
| size | Unknown |  |

### message_payload_part_header

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

### message_payload_part

| Column | Type | Keys |
| --- | --- | --- |
| part_id | Unknown | PK |
| message_id | Unknown | PK, FK |
| attachment_id | Unknown |  |
| data | Unknown |  |
| filename | Unknown |  |
| mime_type | Unknown |  |
| size | Unknown |  |

### payload_header

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

### message_label

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

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| thread_id | Unknown | FK |
| history_id | Unknown |  |
| internal_date | Unknown |  |
| payload_attachment_id | Unknown |  |
| payload_body_data | Unknown |  |
| payload_body_size | Unknown |  |
| payload_file_name | Unknown |  |
| payload_mime_type | Unknown |  |
| payload_part_id | Unknown |  |
| size_estimate | Unknown |  |
| snippet | Unknown |  |

## Relationships

- message_sub_part_header(sub_part_id) → message_payload_sub_part(sub_part_id)
- message_sub_part_header(part_id) → message_payload_sub_part(part_id)
- message_sub_part_header(message_id) → message_payload_sub_part(message_id)
- message_payload_sub_part_body(part_id) → message_payload_sub_part(part_id)
- message_payload_sub_part_body(sub_part_id) → message_payload_sub_part(sub_part_id)
- message_payload_sub_part_body(message_id) → message_payload_sub_part(message_id)
- message_payload_sub_part(part_id) → message_payload_part(part_id)
- message_payload_sub_part(message_id) → message_payload_part(message_id)
- message_payload_part_header(part_id) → message_payload_part(part_id)
- message_payload_part_header(message_id) → message_payload_part(message_id)
- message_payload_part(message_id) → message(id)
- payload_header(message_id) → message(id)
- message_label(label_id) → label(id)
- message_label(message_id) → message(id)
- message(thread_id) → thread(id)