discuss_channel_member

-1 rows


Description

Channel Member

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('discuss_channel_member_id_seq'::regclass)
discuss_channel_rtc_session.channel_member_id discuss_channel_rtc_session_channel_member_id_fkey C
partner_id int4 10 √ null
res_partner.id discuss_channel_member_partner_id_fkey C

Partner
guest_id int4 10 √ null
mail_guest.id discuss_channel_member_guest_id_fkey C

Guest
channel_id int4 10 null
discuss_channel.id discuss_channel_member_channel_id_fkey C

Channel
fetched_message_id int4 10 √ null
mail_message.id discuss_channel_member_fetched_message_id_fkey N

Last Fetched
seen_message_id int4 10 √ null
mail_message.id discuss_channel_member_seen_message_id_fkey N

Last Seen
rtc_inviting_session_id int4 10 √ null
discuss_channel_rtc_session.id discuss_channel_member_rtc_inviting_session_id_fkey N

Ringing session
create_uid int4 10 √ null
res_users.id discuss_channel_member_create_uid_fkey N

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

Last Updated by
custom_channel_name varchar 2147483647 √ null

Custom channel name
fold_state varchar 2147483647 √ null

Conversation Fold State
custom_notifications varchar 2147483647 √ null

Customized Notifications
is_minimized bool 1 √ null

Conversation is minimized
is_pinned bool 1 √ null

Is pinned on the interface
mute_until_dt timestamp 29,6 √ null

Mute notifications until
last_interest_dt timestamp 29,6 √ null

Last Interest
last_seen_dt timestamp 29,6 √ null

Last seen date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
discuss_channel_member_pkey Primary key Asc id
discuss_channel_member__fetched_message_id_index Performance Asc fetched_message_id
discuss_channel_member__guest_id_index Performance Asc guest_id
discuss_channel_member__partner_id_index Performance Asc partner_id
discuss_channel_member__seen_message_id_index Performance Asc seen_message_id
discuss_channel_member_guest_unique Must be unique Asc/Asc channel_id + guest_id
discuss_channel_member_partner_unique Must be unique Asc/Asc channel_id + partner_id
discuss_channel_member_seen_message_id_idx Performance Asc/Asc/Asc channel_id + partner_id + seen_message_id

Check Constraints

Constraint Name Constraint
discuss_channel_member_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