assignfeedback_editpdf_annot

0 rows


Description

stores annotations added to pdfs submitted by students

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
gradeid BIGINT 19 0
assign_grades.id assieditanno_gra2_fkR
pageno BIGINT 19 0
x BIGINT 19 0
y BIGINT 19 0
endx BIGINT 19 0
endy BIGINT 19 0
path LONGTEXT 2147483647 null
type VARCHAR 10 line
colour VARCHAR 10 black
draft TINYINT 3 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assieditanno_gra4_ix Performance Asc gradeid
assieditanno_grapag2_ix Performance Asc/Asc gradeid + pageno

Relationships