Gmail
Explore the interactive ERD
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 | PKFK |
part_id | Unknown | PKFK |
sub_part_id | Unknown | PKFK |
name | Unknown | |
value | Unknown | |
message_payload_sub_part_body
| Column | Type | Keys |
|---|
sub_nested_part_id | Unknown | PK |
message_id | Unknown | PKFK |
part_id | Unknown | PKFK |
sub_part_id | Unknown | PKFK |
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 | PKFK |
part_id | Unknown | PKFK |
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 | PKFK |
part_id | Unknown | PKFK |
name | Unknown | |
value | Unknown | |
message_payload_part
| Column | Type | Keys |
|---|
part_id | Unknown | PK |
message_id | Unknown | PKFK |
attachment_id | Unknown | |
data | Unknown | |
filename | Unknown | |
mime_type | Unknown | |
size | Unknown | |
payload_header
| Column | Type | Keys |
|---|
index | Unknown | PK |
message_id | Unknown | PKFK |
name | Unknown | |
value | Unknown | |
message_label
| Column | Type | Keys |
|---|
index | Unknown | PK |
message_id | Unknown | PKFK |
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 | |
