Brightspace Data Sets for Chat have a dependency on Chat. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Chat. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Chat Objects
The Chat Objects Brightspace Data Set returns the attributes for all chats in the organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 3.6 / 4.1 |
ChatId |
Unique chat identifier. |
bigint |
8 |
PK |
| 3.6 / 4.1 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
ChatType
|
Type of chat.
Field can be null.
|
nvarchar
|
128
|
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Name of chat object.
|
nvarchar
|
150
|
|
| 3.6 / 4.1 |
Description
|
Description of chat object.
Field can be null.
|
nvarchar
|
1000
|
|
| 7.8 - Changed Key |
CreatorUserId
|
Unique chat object creator identifier.
|
int
|
4
|
FK
|
| 3.6 / 4.1 |
LastModified
|
Date / time the chat object was last modified.
Field can be null.
|
datetime2
|
8
|
|
Chat Session Log
The Chat Session Log Brightspace Data Set returns a log of when messages were sent in chat sessions for your org units.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
FK
|
| 1.0 |
UserId
|
Unique user identifier.
|
int
|
4
|
FK
|
| 1.0 |
ChatSessionId
|
Unique chat session identifier.
|
bigint
|
8
|
|
| 1.0 |
StartDate
|
Chat session start date.
|
datetime2
|
8
|
|
| 1.0 |
EndDate
|
Chat session end date.
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
TimeSent
|
Time message was sent.
|
datetime2
|
8
|
|
| 1.4 |
MessageId |
Unique message identifier. |
bigint |
8 |
PK |