Workshopform Numerrors Map Table Schema (workshopform_numerrors_map)


Description

This maps the number of errors to a percentual grade for submission

workshopform_numerrors_map table columns

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

The id of the workshop

nonegative BIGINT 19 null

Number of negative responses given by the reviewer

grade DECIMAL 10,5 null

Percentual grade 0..100 for this number of negative responses

Table contained -1 rows

workshopform_numerrors_map table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worknumemap_wor_ix Performance Asc workshopid
worknumemap_wornon_uix Must be unique Asc/Asc workshopid + nonegative

workshopform_numerrors_map table relationships