Workshopform Numerrors Table Schema (workshopform_numerrors)


Description

The assessment dimensions definitions of Number of errors grading strategy forms

workshopform_numerrors table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 null
workshop.id worknume_wor2_fk R

Workshop ID

sort BIGINT 19 0

Defines the dimension order within the assessment form

description LONGTEXT 2147483647 null

The description of the dimension

descriptionformat SMALLINT 5 0

The format of the description field

descriptiontrust BIGINT 19 null
grade0 VARCHAR 50 null

The word describing the negative evaluation (like Poor, Missing, Absent, etc.). If NULL, it defaults to a translated string False

grade1 VARCHAR 50 null

A word for possitive evaluation (like Good, Present, OK etc). If NULL, it defaults to a translated string True

weight MEDIUMINT 7 1

Weight of this dimension

Table contained -1 rows

workshopform_numerrors table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worknume_wor_ix Performance Asc workshopid

workshopform_numerrors table relationships