scormattempts

49140727 rows


Description

SCORM Attempt created by the User

Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyid varchar 36 √ null
companies.id scormattempts_companyid_fkey1 R

The ID of the learning site
id varchar 36 null
scormattemptresponses.scormattemptid scormattemptresponses_scormattemptid_fkey1 R
scormattemptresponses.scormattemptid scormattemptresponses_scormattemptid_fkey1 R

Unique Identifier of the SCORM Attempt
courseid varchar 36 √ null
courses.id scormattempts_courseid_fkey1 R

The courseid of the SCORM Attempt
userid varchar 36 √ null
users.id scormattempts_userid_fkey R

The userid of the SCORM Attempt
topicid varchar 36 √ null

The topicid of the SCORM Attempt
topictype varchar 32 √ null

The topictype of the SCORM Attempt
completionstatus varchar 16 √ null

The completionstatu of the SCORM Attempt
rawscore int4 10 √ null

The rawscore of the SCORM Attempt
minscore int4 10 √ null

The minscore of the SCORM Attempt
maxscore int4 10 √ null

The maxscore of the SCORM Attempt
passed bool 1 √ true

The passed of the SCORM Attempt
createdat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the SCORM Attempt was created
updatedat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the SCORM Attempt was created
completionprogress float8 17,17 √ null
licenseid varchar 36 √ null
scaledscore int4 10 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation