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

Close relationships within degrees of separation