mail_mail

-1 rows


Description

Outgoing Mails

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_mail_id_seq'::regclass)
mail_mail_res_partner_rel.mail_mail_id mail_mail_res_partner_rel_mail_mail_id_fkey C
mail_notification.mail_mail_id mail_notification_mail_mail_id_fkey N
mail_message_id int4 10 null
mail_message.id mail_mail_mail_message_id_fkey C

Message
fetchmail_server_id int4 10 √ null
fetchmail_server.id mail_mail_fetchmail_server_id_fkey N

Inbound Mail Server
create_uid int4 10 √ null
res_users.id mail_mail_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id mail_mail_write_uid_fkey N

Last Updated by
email_cc varchar 2147483647 √ null

Cc
state varchar 2147483647 √ null

Status
failure_type varchar 2147483647 √ null

Failure type
body_html text 2147483647 √ null

Text Contents
references text 2147483647 √ null

References
headers text 2147483647 √ null

Headers
email_to text 2147483647 √ null

To
failure_reason text 2147483647 √ null

Failure Reason
is_notification bool 1 √ null

Notification Email
auto_delete bool 1 √ null

Auto Delete
scheduled_date timestamp 29,6 √ null

Scheduled Send Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
mail_mail_pkey Primary key Asc id
mail_mail__mail_message_id_index Performance Asc mail_message_id

Relationships

Close relationships within degrees of separation