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 10 null
gradeid bigint 10 0
assign_grades.id assieditanno_gra2_fk R
pageno bigint 10 0

The page in the PDF that this annotation appears on

x bigint 10 0

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

y bigint 10 0

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

endx bigint 10 0

x-position of the end of the annotation

endy bigint 10 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 2 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