mail_message_reaction

-1 rows


Description

Message Reaction

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mail_message_reaction_id_seq'::regclass)
message_id int4 10 null
mail_message.id mail_message_reaction_message_id_fkey C

Message
partner_id int4 10 √ null
res_partner.id mail_message_reaction_partner_id_fkey C

Reacting Partner
guest_id int4 10 √ null
mail_guest.id mail_message_reaction_guest_id_fkey C

Reacting Guest
content varchar 2147483647 null

Content

Indexes

Constraint Name Type Sort Column(s)
mail_message_reaction_pkey Primary key Asc id
mail_message_reaction_guest_unique Must be unique Asc/Asc/Asc message_id + content + guest_id
mail_message_reaction_partner_unique Must be unique Asc/Asc/Asc message_id + content + partner_id

Check Constraints

Constraint Name Constraint
mail_message_reaction_partner_or_guest_exists ((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))

Relationships

Close relationships within degrees of separation