mail_notification

20 rows


Description

Message Notifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_notification_id_seq'::regclass)
mail_notification_mail_resend_message_rel.mail_notification_id mail_notification_mail_resend_message_mail_notification_id_fkey C
mail_resend_partner.notification_id mail_resend_partner_notification_id_fkey C
sms_resend_recipient.notification_id sms_resend_recipient_notification_id_fkey C
sms_tracker.mail_notification_id sms_tracker_mail_notification_id_fkey C
author_id int4 10 √ null
res_partner.id mail_notification_author_id_fkey N

Author
mail_message_id int4 10 null
mail_message.id mail_notification_mail_message_id_fkey C

Message
mail_mail_id int4 10 √ null
mail_mail.id mail_notification_mail_mail_id_fkey N

Mail
res_partner_id int4 10 √ null
res_partner.id mail_notification_res_partner_id_fkey C

Recipient
notification_type varchar 2147483647 null

Notification Type
notification_status varchar 2147483647 √ null

Status
failure_type varchar 2147483647 √ null

Failure type
failure_reason text 2147483647 √ null

Failure reason
is_read bool 1 √ null

Is Read
read_date timestamp 29,6 √ null

Read Date
sms_id_int int4 10 √ null

SMS ID
sms_number varchar 2147483647 √ null

SMS Number
letter_id int4 10 √ null
snailmail_letter.id mail_notification_letter_id_fkey C

Snailmail Letter

Indexes

Constraint Name Type Sort Column(s)
mail_notification_pkey Primary key Asc id
mail_notification__is_read_index Performance Asc is_read
mail_notification__letter_id_index Performance Asc letter_id
mail_notification__mail_mail_id_index Performance Asc mail_mail_id
mail_notification__mail_message_id_index Performance Asc mail_message_id
mail_notification__notification_status_index Performance Asc notification_status
mail_notification__notification_type_index Performance Asc notification_type
mail_notification__res_partner_id_index Performance Asc res_partner_id
mail_notification__sms_id_int_index Performance Asc sms_id_int
mail_notification_author_id_notification_status_failure Performance Asc/Asc author_id + notification_status
mail_notification_res_partner_id_is_read_notification_status_ma Performance Asc/Asc/Asc/Asc res_partner_id + is_read + notification_status + mail_message_id
unique_mail_message_id_res_partner_id_if_set Must be unique Asc/Asc mail_message_id + res_partner_id

Check Constraints

Constraint Name Constraint
mail_notification_notification_partner_required ((((notification_type)::text <> ALL ((ARRAY['email'::character varying, 'inbox'::character varying])::text[])) OR (res_partner_id IS NOT NULL)))

Relationships

Close relationships within degrees of separation