workshop_submissions

0 rows


Description

Info about the submission and the aggregation of the grade f

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshop_assessments.submissionid workasse_sub2_fkR
workshopid BIGINT 19 null
workshop.id worksubm_wor2_fkR
example TINYINT 3 √ 0
authorid BIGINT 19 null
user.id worksubm_aut2_fkR
timecreated BIGINT 19 null
timemodified BIGINT 19 null
title VARCHAR 255
content LONGTEXT 2147483647 √ null
contentformat SMALLINT 5 0
contenttrust SMALLINT 5 0
attachment TINYINT 3 √ 0
grade DECIMAL 10,5 √ null
gradeover DECIMAL 10,5 √ null
gradeoverby BIGINT 19 √ null
user.id worksubm_gra2_fkR
feedbackauthor LONGTEXT 2147483647 √ null
feedbackauthorformat SMALLINT 5 √ 0
timegraded BIGINT 19 √ null
published TINYINT 3 √ 0
late TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worksubm_aut4_ix Performance Asc authorid
worksubm_gra4_ix Performance Asc gradeoverby
worksubm_wor4_ix Performance Asc workshopid

Relationships

Close relationships within degrees of separation