Assignfeedback Editpdf Annot Table Schema (assignfeedback_editpdf_annot)


Description

stores annotations added to pdfs submitted by students

assignfeedback_editpdf_annot table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
gradeid BIGINT 19 0
assign_grades.id assieditanno_gra2_fk R
pageno BIGINT 19 0

The page in the PDF that this annotation appears on

x BIGINT 19 0

x-position of the start of the annotation (in pixels - image resolution is set to 100 pixels per inch)

y BIGINT 19 0

y-position of the start of the annotation (in pixels - image resolution is set to 100 pixels per inch)

endx BIGINT 19 0

x-position of the end of the annotation

endy BIGINT 19 0

y-position of the end of the annotation

path LONGTEXT 2147483647 null

SVG path describing the freehand line

type VARCHAR 10 line

line, oval, rect, etc.

colour VARCHAR 10 black

Can be red, yellow, green, blue, white, black

draft TINYINT 3 1

Is this a draft annotation?

Table contained -1 rows

assignfeedback_editpdf_annot table indexes

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

assignfeedback_editpdf_annot table relationships