Communication

Discussion Forums data set: columns, keys and joins

Primary key: ForumId 18 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`OrgUnitId`	`int`	`4`	FK
`ForumId`	`bigint`	`8`	PK
`Name`	`nvarchar`	`400`
`Description`	`nvarchar`	`1000`
`MustPostToParticipate`	`bit`	`1`
`AllowAnon`	`bit`	`1`
`IsHidden`	`bit`	`1`
`RequiresApproval`	`bit`	`1`
`SortOrder`	`int`	`4`
`IsDeleted`	`bit`	`1`
`DeletedDate`	`datetime2`	`8`
`DeletedByUserId`	`int`	`4`	FK
`ResultId`	`int`	`4`	FK
`StartDate`	`datetime2`	`8`
`StartDateAvailabilityType`	`smallint`	`2`
`EndDate`	`datetime2`	`8`
`EndDateAvailabilityType`	`smallint`	`2`
`Version`	`bigint`	`8`

Joins to (1)

Organizational UnitsOrgUnitId → OrgUnitId

Joined from (1)

Discussion TopicsForumId → ForumId

Edit history links

UsersDeletedByUserId → UserId

Foreign keys without a stated target

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

Source

Source: Discussions data sets on the D2L Brightspace Community