Workshopform Accumulative Table Schema (workshopform_accumulative)


Description

The assessment dimensions definitions of Accumulative grading strategy forms

workshopform_accumulative table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 null
workshop.id workaccu_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

grade BIGINT 19 null

If greater than 0, then the value is maximum grade on a scale 0..grade. If lesser than 0, then its absolute value is the id of a record in scale table. If equals 0, then no grading is possible for this dimension, just commenting.

weight MEDIUMINT 7 1

The weigh of the dimension

Table contained -1 rows

workshopform_accumulative table indexes

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

workshopform_accumulative table relationships