In this production release (March 2nd), we have updated the schema to version v1.16.0. Changes to the schema for this release include adding extra fields to assignments, and exporting group level discussions instead of just course level discussions. We've also started mapping message lengths of 0 in the discussion dim to their proper "0".
Assignment DIM
Column Name | Column Type | Description |
---|
visibility | ENUM | User sets that can view the assignment. Possible values ('everyone', 'only_visible_to_overrides'). |
Discussion Topic DIM
Column Name | Column Type | Description |
---|
course_id | BIGINT | Foreign key to the course dimension. |
group_id | BIGINT | Foreign key to the group dimension. |
Discussion Topic FACT
Column Name | Column Type | Description |
---|
group_id | BIGINT | Foreign key to the group dimension. |
group_parent_course_id | BIGINT | Foreign key to course dimension. |
group_parent_account_id | BIGINT | Foreign key to accounts table. |
group_parent_course_account_id | BIGINT | Foreign key to the account dimension for the account associated with the course to which the group belongs to. |
Discussion Topic FACT
Column Name | Column Type | Description |
---|
message_length | INT | Best guess at the count of characters in the message. Special characters are treated differently in different systems. As a result, you may find variance in message length in your own systems. NULL messages are mapped to 0 length. |