Grades and assessment

Quiz Survey Sections data set: columns, keys and joins

Primary key: SectionId 18 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`CollectionId`	`bigint`	`8`	FK
`SectionId`	`bigint`	`8`	PK
`Name`	`nvarchar`	`256`
`NameIsDisplayed`	`bit`	`1`
`IsQuestionPool`	`bit`	`1`
`SectionText`	`nvarchar`	`1000`
`SectionTextIsHTML`	`bit`	`1`
`IsSectionTextHidden`	`bit`	`1`
`QuestionPoints`	`decimal`	`19, 9`
`NumQuestions`	`int`	`4`
`NumChoices`	`int`	`4`
`Shuffle`	`bit`	`1`
`CreationDate`	`datetime2`	`8`
`CreatedBy`	`bigint`	`8`	FK
`LastModified`	`datetime2`	`8`
`LastModifiedBy`	`bigint`	`8`	FK
`IsDeleted`	`bit`	`1`
`Version`	`bigint`	`8`

Joins to (0)

None

Joined from (1)

Quiz User AnswersSectionId → SectionId

Edit history links

UsersCreatedBy → UserId
UsersLastModifiedBy → UserId

Foreign keys without a stated target

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

Source