chat_topic_user Table (331)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table connected the chat topics with the users (i.e. the membership).
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| user_id | The reference to the associated user | FK ejuser | |
| topic_id | The reference to the associated chat topic. | FK chat_topic | |
| can_respond | True if the user can respond to chats in this topic | Bool | ● |
| notifications | True if the user should receive notifications for this topic | Bool | ● |
| can_listen | True of a user can listen in on this topic | Bool | ● |
| manager | True if the user is a manager for this topic | Bool | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.