message: Odoo itgen_odoo_message
read only per partition
- Catalog:
Odoo - Schema:
mail - Label: itgen_odoo_message
Message
Can only retrieve data.
Summary
Override MailMessage class in order to add a new type: SMS messages. Those messages comes with their own notification method, using SMS gateway.
Table Columns
The columns of the table message are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
attachment_ |
varchar2 |
||||
author_ |
varbinary |
Author's avatar | |||
author_ |
varchar2 |
||||
author_ |
varchar2 |
||||
author_ |
varchar2 |
Author of the message. If not set, email_from may hold an email address that did not match any partner. | |||
author_ |
varchar2 |
Author of the message. If not set, email_from may hold an email address that did not match any partner. | |||
body |
varchar2 |
Contents | |||
canned_ |
varchar2 |
||||
child_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Date | |||
description |
varchar2 |
Short description | Message description: either the subject, or the beginning of the body | ||
display_ |
varchar2 |
Display Name | |||
email_ |
boolean |
Email Add Signature | |||
email_ |
varchar2 |
From | Email address of the sender. This field is set when no matching partner is found and replaces the author_id field in the chatter. | ||
email_ |
varchar2 |
Layout | |||
has_ |
boolean |
Has error | |||
has_ |
boolean |
Has SMS error | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Current User Or Guest Author | |||
is_ |
boolean |
Employee Only | Hide to public / portal users, independently from subtype configuration. | ||
letter_ |
varchar2 |
||||
link_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
mail_ |
varchar2 |
||||
message_ |
varchar2 |
Message-Id | Message unique identifier | ||
message_ |
varchar2 |
Type | Message type: email for email message, notification for system message, comment for other messages such as user replies | ||
model |
varchar2 |
Related Document Model | |||
needaction |
boolean |
Need Action | |||
notification_ |
varchar2 |
||||
notified_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
preview |
varchar2 |
Preview | The text-only beginning of the body used as email preview. | ||
rating_ |
varchar2 |
||||
rating_ |
numeric |
Rating Value | |||
reaction_ |
varchar2 |
||||
record_ |
varchar2 |
Message Record Name | |||
reply_ |
varchar2 |
Reply-To | Reply email address. Setting the reply_to bypasses the automatic thread creation. | ||
reply_ |
boolean |
No threading for answers | If true, answers do not go in the original document discussion thread. Instead, it will check for the reply_to in tracking message-id and redirected accordingly. This has an impact on the generated message-id. | ||
res_id |
int32 |
Related Document ID | |||
snailmail_ |
boolean |
Snailmail message in error | |||
starred |
boolean |
Starred | Current user has a starred notification linked to this message | ||
starred_ |
varchar2 |
||||
subject |
varchar2 |
Subject | |||
subtype_ |
varchar2 |
||||
subtype_ |
varchar2 |
||||
tracking_ |
varchar2 |
Tracked values are stored in a separate model. This field allow to reconstruct the tracking and to generate statistics on the model. | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: