CPD Question Answers data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
AnswerId | int | 4 | PK |
AnswerText | nvarchar | 4000 | |
QuestionId | int | 4 | FK |
RecordId | int | 4 | FK |
UserId | int | 4 | FK |
Action | nvarchar | 16 | |
LastModified | datetime2 | 8 | |
DateDeleted | datetime2 | 8 | |
Version | bigint | 8 |
Joins to (3)
- CPD Questions
QuestionId→QuestionId - CPD User Records
RecordId→RecordId - Users
UserId→UserId
Joined from (0)
None
Edit history links
None