mail_message

308 rows


Description

Message

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_message_id_seq'::regclass)
discuss_channel_member.fetched_message_id discuss_channel_member_fetched_message_id_fkey N
discuss_channel_member.seen_message_id discuss_channel_member_seen_message_id_fkey N
mail_compose_message.parent_id mail_compose_message_parent_id_fkey N
mail_link_preview.message_id mail_link_preview_message_id_fkey C
mail_mail.mail_message_id mail_mail_mail_message_id_fkey C
mail_message.parent_id mail_message_parent_id_fkey N
mail_message_reaction.message_id mail_message_reaction_message_id_fkey C
mail_message_res_partner_rel.mail_message_id mail_message_res_partner_rel_mail_message_id_fkey C
mail_message_res_partner_starred_rel.mail_message_id mail_message_res_partner_starred_rel_mail_message_id_fkey C
mail_message_schedule.mail_message_id mail_message_schedule_mail_message_id_fkey C
mail_message_translation.message_id mail_message_translation_message_id_fkey C
mail_notification.mail_message_id mail_notification_mail_message_id_fkey C
mail_resend_message.mail_message_id mail_resend_message_mail_message_id_fkey N
mail_tracking_value.mail_message_id mail_tracking_value_mail_message_id_fkey C
message_attachment_rel.message_id message_attachment_rel_message_id_fkey C
sms_resend.mail_message_id sms_resend_mail_message_id_fkey C
sms_sms.mail_message_id sms_sms_mail_message_id_fkey N
snailmail_letter.message_id snailmail_letter_message_id_fkey N
snailmail_letter_format_error.message_id snailmail_letter_format_error_message_id_fkey N
parent_id int4 10 √ null
mail_message.id mail_message_parent_id_fkey N

Parent Message
res_id int4 10 √ null

Related Document ID
record_alias_domain_id int4 10 √ null
mail_alias_domain.id mail_message_record_alias_domain_id_fkey N

Alias Domain
record_company_id int4 10 √ null
res_company.id mail_message_record_company_id_fkey N

Company
subtype_id int4 10 √ null
mail_message_subtype.id mail_message_subtype_id_fkey N

Subtype
mail_activity_type_id int4 10 √ null
mail_activity_type.id mail_message_mail_activity_type_id_fkey N

Mail Activity Type
author_id int4 10 √ null
res_partner.id mail_message_author_id_fkey N

Author
author_guest_id int4 10 √ null
mail_guest.id mail_message_author_guest_id_fkey N

Guest
mail_server_id int4 10 √ null
ir_mail_server.id mail_message_mail_server_id_fkey N

Outgoing mail server
create_uid int4 10 √ null
res_users.id mail_message_create_uid_fkey N

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

Last Updated by
subject varchar 2147483647 √ null

Subject
model varchar 2147483647 √ null

Related Document Model
record_name varchar 2147483647 √ null

Message Record Name
message_type varchar 2147483647 null

Type
email_from varchar 2147483647 √ null

From
message_id varchar 2147483647 √ null

Message-Id
reply_to varchar 2147483647 √ null

Reply-To
email_layout_xmlid varchar 2147483647 √ null

Layout
body text 2147483647 √ null

Contents
is_internal bool 1 √ null

Employee Only
reply_to_force_new bool 1 √ null

No threading for answers
email_add_signature bool 1 √ null

Email Add Signature
date timestamp 29,6 √ null

Date
pinned_at timestamp 29,6 √ null

Pinned
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_message_pkey Primary key Asc id
mail_message__author_id_index Performance Asc author_id
mail_message__mail_activity_type_id_index Performance Asc mail_activity_type_id
mail_message__message_id_index Performance Asc message_id
mail_message__parent_id_index Performance Asc parent_id
mail_message__subtype_id_index Performance Asc subtype_id
mail_message_model_res_id_id_idx Performance Asc/Asc/Asc model + res_id + id
mail_message_model_res_id_idx Performance Asc/Asc model + res_id

Relationships

Close relationships within degrees of separation