Grades and assessment

Question Answer Options data set: columns, keys and joins

Primary key: AnswerIdQuestionIdQuestionVersionIdAnswerOptionId 6 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
AnswerIdbigint8PK, FK
AnswerTextnvarchar1000
Weightdecimal19, 9
QuestionIdbigint8PK, FK
QuestionVersionIdbigint8PK, FK
AnswerOptionIdint4PK

Joins to (0)

None

Joined from (0)

None

Edit history links

None

Foreign keys without a stated target

  • AnswerId: 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