Assignfeedback Editpdf Cmnt Table Schema (assignfeedback_editpdf_cmnt)


Description

Stores comments added to pdfs

assignfeedback_editpdf_cmnt table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
gradeid bigint 10 0
assign_grades.id assieditcmnt_gra2_fk R
x bigint 10 0

x-position of the top-left corner of the comment (in pixels - image resolution is set to 100 pixels per inch)

y bigint 10 0

y-position of the top-left corner of the comment (in pixels - image resolution is set to 100 pixels per inch)

width bigint 10 120

width, in pixels, of the comment box

rawtext longtext 2147483647 null

Raw text of the comment

pageno bigint 10 0

The page in the PDF that this comment appears on

colour varchar 10 black

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

draft tinyint 2 1

Is this a draft comment?

Table contained -1 rows

assignfeedback_editpdf_cmnt table indexes

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

assignfeedback_editpdf_cmnt table relationships