Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Creator+. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Creator+ Practices Adoption
In the Creator+ Practices Adoption Brightspace Data Set, each row represents a Practice created using Creator+.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 9.7 |
ActivityInstanceId |
Identifies the unique location of the Practice within a Brightspace course. If a Practice appears multiple times in a course, this value changes but the CourseId and ProviderObjectId remain the same.
|
int
|
4
|
PK
|
| 9.7 |
CreatedById |
Identifies the user who created the Practice. |
int
|
4
|
FK
|
| 9.8 - Change Field name |
OrgUnitId
|
Identifies the Brightspace organizational unit containing the Practice.
Field can be null.
|
int
|
4
|
FK
|
| 9.7 |
PracticeType
|
The type of Practice. |
nvarchar
|
32
|
|
| 9.7 |
PracticeTitle |
The title provided by the creator of the Practice.
|
nvarchar
|
255
|
|
| 9.11 - Fixed nullability |
ProviderObjectId |
ID of the Practice on the provider service. If a Practice is copied to multiple courses, the CourseId and ProviderObjectId should both change.
Field can be null.
|
int
|
4
|
|
| 9.7 |
CreatedDate |
The date and time (UTC) the Practice was created. For Practices created before July 2024, this is the date the Practice was transformed into a data-enabled Practice. |
datetime2
|
8
|
|
| 9.7 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first.
|
int
|
4
|
|
Creator+ Practices Engagement
In the Practices Engagement Brightspace Data Set, each row represents an instance where a learner attempted a Practice and checked their answer.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 9.8 |
PracticeEngagementId
|
Identifies each attempt available for a learner to complete a Practice.
|
int
|
4
|
PK
|
| 9.8 |
UserId
|
Identifies the user engaging with the Practice attempt. |
int
|
4
|
FK
|
| 9.8 |
OrgUnitId |
Identifies the Brightspace course containing the Practice.
Field can be null.
|
int
|
4
|
FK
|
| 9.8 |
CompletionStatus |
The status of the engagement: NotStarted or Completed. |
nvarchar
|
10
|
|
| 9.8 |
ActivityInstanceId |
Identifies the Practice being attempted.
|
int
|
4
|
FK
|
| 9.8 |
CompletionDate |
The date and time (UTC) the attempt was completed. |
datetime2
|
8
|
|
| 9.8 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first.
|
int
|
4
|
|