Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| companyId | uuid | 2147483647 | null |
|
|
The ID of the learning site |
||||
| id | uuid | 2147483647 | null |
|
|
Unique Identifier of the Scorm Attempt Response |
||||
| courseId | uuid | 2147483647 | null |
|
|
The ID of the Course associated with the Scorm Attempt Response |
||||
| questionId | varchar | 255 | √ | null |
|
|
The ID of the Question associated with the Scorm Attempt Response |
|||
| result | varchar | 16 | √ | null |
|
|
The result of the Scorm Attempt Response |
|||
| studentResponse | varchar | 2048 | √ | null |
|
|
The student response of the Scorm Attempt Response |
|||
| questionDescription | varchar | 2048 | √ | null |
|
|
The question description of the Scorm Attempt Response |
|||
| userId | uuid | 2147483647 | null |
|
|
The ID of the User associated with the Scorm Attempt Response |
||||
| topicId | uuid | 2147483647 | null |
|
|
The ID of the Topic associated with the Scorm Attempt Response |
||||
| scormAttemptId | uuid | 2147483647 | null |
|
|
The ID of the Scorm Attempt associated with the Scorm Attempt Response |
||||
| createdAt | timestamp | 29,6 | √ | null |
|
|
The date and time the Scorm Attempt Response was created |
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| scormAttemptResponses_pkey | Primary key | Asc | id |
| scormAttemptResponses_courseId_idx | Performance | Asc | courseId |
| scormAttemptResponses_createdAt_idx | Performance | Asc | createdAt |
| scormAttemptResponses_scormAttemptId_idx | Performance | Asc | scormAttemptId |
| scormAttemptResponses_topicId_idx | Performance | Asc | topicId |
| scormAttemptResponses_userId_idx | Performance | Asc | userId |
Relationships
Close relationships within degrees of separation
