0 rows


History table


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
action BIGINT 19 0

created/modified/deleted constants

oldid BIGINT 19 null gradoutchist_old2_fkR
source VARCHAR 255 null

What caused the modification? manual/module/import/…

timemodified BIGINT 19 null

The last time this grade_item was modified

loggeduser BIGINT 19 null gradoutchist_log2_fkR

the userid of the person who last modified this outcome

courseid BIGINT 19 null gradoutchist_cou2_fkR

Mostly these are defined site wide ie NULL

shortname VARCHAR 255

The short name or code for this outcome statement

fullname LONGTEXT 2147483647 null

The full description of the outcome (usually 1 sentence)

scaleid BIGINT 19 null gradoutchist_sca2_fkR

The recommended scale for this outcome.

description LONGTEXT 2147483647 null

Outcome description

descriptionformat TINYINT 3 0


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradoutchist_act2_ix Performance Asc action
gradoutchist_cou4_ix Performance Asc courseid
gradoutchist_log4_ix Performance Asc loggeduser
gradoutchist_old4_ix Performance Asc oldid
gradoutchist_sca4_ix Performance Asc scaleid
gradoutchist_tim2_ix Performance Asc timemodified