Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('mail_compose_message_id_seq'::regclass) |
|
|
||||||||
| template_id | int4 | 10 | √ | null |
|
|
Use template |
|||||||
| parent_id | int4 | 10 | √ | null |
|
|
Parent Message |
|||||||
| int4 | 10 | √ | null |
|
|
Author |
||||||||
| res_domain_user_id | int4 | 10 | √ | null |
|
|
Responsible |
|||||||
| record_alias_domain_id | int4 | 10 | √ | null |
|
|
Alias Domain |
|||||||
| record_company_id | int4 | 10 | √ | null |
|
|
Company |
|||||||
| subtype_id | int4 | 10 | √ | null |
|
|
Subtype |
|||||||
| mail_activity_type_id | int4 | 10 | √ | null |
|
|
Mail Activity Type |
|||||||
| mail_server_id | int4 | 10 | √ | null |
|
|
Outgoing mail server |
|||||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
|||||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
|||||||
| lang | varchar | 2147483647 | √ | null |
|
|
Language |
|||||||
| subject | varchar | 2147483647 | √ | null |
|
|
Subject |
|||||||
| email_layout_xmlid | varchar | 2147483647 | √ | null |
|
|
Email Notification Layout |
|||||||
| email_from | varchar | 2147483647 | √ | null |
|
|
From |
|||||||
| composition_mode | varchar | 2147483647 | √ | null |
|
|
Composition mode |
|||||||
| model | varchar | 2147483647 | √ | null |
|
|
Related Document Model |
|||||||
| record_name | varchar | 2147483647 | √ | null |
|
|
Record Name |
|||||||
| message_type | varchar | 2147483647 | null |
|
|
Type |
||||||||
| reply_to | varchar | 2147483647 | √ | null |
|
|
Reply To |
|||||||
| scheduled_date | varchar | 2147483647 | √ | null |
|
|
Scheduled Date |
|||||||
| body | text | 2147483647 | √ | null |
|
|
Contents |
|||||||
| res_ids | text | 2147483647 | √ | null |
|
|
Related Document IDs |
|||||||
| res_domain | text | 2147483647 | √ | null |
|
|
Active domain |
|||||||
| email_add_signature | bool | 1 | √ | null |
|
|
Add signature |
|||||||
| reply_to_force_new | bool | 1 | √ | null |
|
|
Considers answers as new thread |
|||||||
| auto_delete | bool | 1 | √ | null |
|
|
Delete Emails |
|||||||
| auto_delete_keep_log | bool | 1 | √ | null |
|
|
Keep Message Copy |
|||||||
| force_send | bool | 1 | √ | null |
|
|
Send mailing or notifications directly |
|||||||
| use_exclusion_list | bool | 1 | √ | null |
|
|
Check Exclusion List |
|||||||
| 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_compose_message_pkey | Primary key | Asc | id |

