chat_topic_user table - SuperOffice

chat_topic_user Table (331)

This table connected the chat topics with the users (i.e. the membership).

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
user_id	The reference to the associated user	FK ejuser	No
topic_id	The reference to the associated chat topic.	FK chat_topic	No
can_respond	True if the user can respond to chats in this topic	Bool	Yes
notifications	True if the user should receive notifications for this topic	Bool	Yes
can_listen	True of a user can listen in on this topic	Bool	Yes
manager	True if the user is a manager for this topic	Bool	Yes

Indexes

Fields	Types	Description
user_id	FK	Index
topic_id	FK	Index

Relationships

Table	Description
chat_topic	This table contains chat topics.
ejuser	This table contains entries for the users of the system.

Replication Flags

None

Security Flags

No access control via user’s Role.