Communication

Discussion Posts data set: columns, keys and joins

Primary key: PostId 20 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`OrgUnitId`	`int`	`4`	FK
`TopicId`	`bigint`	`8`	FK
`UserId`	`int`	`4`	FK
`PostId`	`bigint`	`8`	PK
`ThreadId`	`bigint`	`8`
`IsReply`	`bit`	`1`
`ParentPostId`	`bigint`	`8`	FK
`NumReplies`	`int`	`4`
`DatePosted`	`datetime2`	`8`
`IsDeleted`	`bit`	`1`
`RatingSum`	`bigint`	`8`
`NumRatings`	`bigint`	`8`
`Score`	`decimal`	`19, 9`
`LastEditDate`	`datetime2`	`8`
`SortOrder`	`int`	`4`
`Depth`	`int`	`4`
`Thread`	`nvarchar`	`400`
`WordCount`	`int`	`4`
`AttachmentCount`	`int`	`4`
`Version`	`bigint`	`8`

None

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