Grades and assessment

Question Relationships data set: columns, keys and joins

Primary key: ObjectId 17 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
CollectionIdbigint8FK
QuestionIdbigint8FK
QuestionVersionIdbigint8FK
Orderbigint8
SectionIdbigint8
IsQuestionPoolbit1
CreationDatedatetime28
CreatedBybigint8
LastModifieddatetime28
LastModifiedBybigint8
Pointsdecimal19, 9
Difficultyint4
IsBonusbit1
IsMandatorybit1
IsDeletedbit1
Versionbigint8
ObjectIdbigint8PK

Joins to (0)

None

Joined from (0)

None

Edit history links

None

Foreign keys without a stated target

  • CollectionId: Marked as a foreign key by D2L, without a stated target data set.
  • QuestionId: Marked as a foreign key by D2L, without a stated target data set.
  • QuestionVersionId: Marked as a foreign key by D2L, without a stated target data set.

Source