discuss_channel

-1 rows


Description

Discussion Channel

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('discuss_channel_id_seq'::regclass)
discuss_channel_member.channel_id discuss_channel_member_channel_id_fkey C
discuss_channel_res_groups_rel.discuss_channel_id discuss_channel_res_groups_rel_discuss_channel_id_fkey C
discuss_channel_rtc_session.channel_id discuss_channel_rtc_session_channel_id_fkey N
group_public_id int4 10 √ null
res_groups.id discuss_channel_group_public_id_fkey N

Authorized Group
create_uid int4 10 √ null
res_users.id discuss_channel_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
channel_type varchar 2147483647 null

Channel Type
default_display_mode varchar 2147483647 √ null

Default Display Mode
sfu_channel_uuid varchar 2147483647 √ null

Sfu Channel Uuid
sfu_server_url varchar 2147483647 √ null

Sfu Server Url
uuid varchar 50 √ null

UUID
description text 2147483647 √ null

Description
active bool 1 √ null

Active
allow_public_upload bool 1 √ null

Allow Public Upload
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_pkey Primary key Asc id
discuss_channel_uuid_unique Must be unique Asc uuid

Check Constraints

Constraint Name Constraint
discuss_channel_group_public_id_check ((((channel_type)::text = 'channel'::text) OR (group_public_id IS NULL)))

Relationships

Close relationships within degrees of separation