mail_template

-1 rows


Description

Email Templates

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_template_id_seq'::regclass)
account_move_send.mail_template_id account_move_send_mail_template_id_fkey N
email_template_attachment_rel.email_template_id email_template_attachment_rel_email_template_id_fkey C
ir_act_server.template_id ir_act_server_template_id_fkey N
mail_activity_type_mail_template_rel.mail_template_id mail_activity_type_mail_template_rel_mail_template_id_fkey C
mail_compose_message.template_id mail_compose_message_template_id_fkey N
mail_template_ir_actions_report_rel.mail_template_id mail_template_ir_actions_report_rel_mail_template_id_fkey C
mail_template_mail_template_reset_rel.mail_template_id mail_template_mail_template_reset_rel_mail_template_id_fkey C
mail_template_preview.mail_template_id mail_template_preview_mail_template_id_fkey C
res_company.stock_mail_confirmation_template_id res_company_stock_mail_confirmation_template_id_fkey N
res_config_settings.invoice_mail_template_id res_config_settings_invoice_mail_template_id_fkey N
sale_order.pending_email_template_id sale_order_pending_email_template_id_fkey N
sale_order_cancel.template_id sale_order_cancel_template_id_fkey N
sale_order_template.mail_template_id sale_order_template_mail_template_id_fkey N
model_id int4 10 √ null
ir_model.id mail_template_model_id_fkey N

Applies to
user_id int4 10 √ null
res_users.id mail_template_user_id_fkey N

User
mail_server_id int4 10 √ null
ir_mail_server.id mail_template_mail_server_id_fkey N

Outgoing Mail Server
ref_ir_act_window int4 10 √ null
ir_act_window.id mail_template_ref_ir_act_window_fkey N

Sidebar action
create_uid int4 10 √ null
res_users.id mail_template_create_uid_fkey N

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

Last Updated by
template_fs varchar 2147483647 √ null

Template Filename
lang varchar 2147483647 √ null

Language
model varchar 2147483647 √ null

Related Document Model
email_from varchar 2147483647 √ null

From
email_to varchar 2147483647 √ null

To (Emails)
partner_to varchar 2147483647 √ null

To (Partners)
email_cc varchar 2147483647 √ null

Cc
reply_to varchar 2147483647 √ null

Reply To
email_layout_xmlid varchar 2147483647 √ null

Email Notification Layout
scheduled_date varchar 2147483647 √ null

Scheduled Date
name jsonb 2147483647 √ null

Name
description jsonb 2147483647 √ null

Template description
subject jsonb 2147483647 √ null

Subject
body_html jsonb 2147483647 √ null

Body
active bool 1 √ null

Active
use_default_to bool 1 √ null

Default recipients
auto_delete bool 1 √ null

Auto Delete
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_template_pkey Primary key Asc id
mail_template__model_index Performance Asc model

Relationships

Close relationships within degrees of separation