Grades and assessment

Question Library data set: columns, keys and joins

Primary key: QuestionIdQuestionVersionId 13 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`QuestionId`	`bigint`	`8`	PK
`QuestionVersionId`	`bigint`	`8`	PK
`IsAutoGraded`	`bit`	`1`
`TemplateTypeId`	`int`	`4`
`QuestionType`	`varchar`	`28`
`Name`	`nvarchar`	`256`
`Question`	`nvarchar`	`1000`
`Comment`	`nvarchar`	`1000`
`AnswerKey`	`nvarchar`	`1000`
`CreationDate`	`datetime2`	`8`
`Version`	`bigint`	`8`
`AllowsAttachments`	`bit`	`1`
`AIUtilization`	`int`	`4`

None

None

None