Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| uid | text | 2147483647 | null |
|
|
uid неразобранного, к которому относится metadata |
|||||
| from_email | text | 2147483647 | null |
|
|
email отправителя |
|||||
| from_name | text | 2147483647 | √ | null |
|
|
Имя отправителя |
||||
| received_at | timestamp | 29,6 | null |
|
|
Дата получения письма |
|||||
| subject | text | 2147483647 | null |
|
|
Тема письма |
|||||
| thread_id | int4 | 10 | null |
|
|
id треда |
|||||
| message_id | int4 | 10 | null |
|
|
id сообщения |
|||||
| content_summary | text | 2147483647 | null |
|
|
Краткое содержание письма |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| unsorted_metadata_mail_pkey | Primary key | Asc | uid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| unsorted_metadata_mail_thread_id_check | ((thread_id > 0)) |
| unsorted_metadata_mail_message_id_check | ((message_id > 0)) |
Relationships
Close relationships within degrees of separation
