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.

Related topics

chat_topic table Chat Topics For User Get Chat Topic User Agent Add Chat Topic User Agent Update Chat Topic User Agent

⌘I