Assignment Table Schema (assignment)


Description

Defines assignments

assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
assignment_submissions.assignment assisubm_ass4_fk R
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
assignmenttype VARCHAR 50
resubmit TINYINT 3 0
preventlate TINYINT 3 0
emailteachers TINYINT 3 0
var1 BIGINT 19 √ 0
var2 BIGINT 19 √ 0
var3 BIGINT 19 √ 0
var4 BIGINT 19 √ 0
var5 BIGINT 19 √ 0
maxbytes BIGINT 19 100000
timedue BIGINT 19 0
timeavailable BIGINT 19 0
grade BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assi_cou2_ix Performance Asc course

assignment table relationships

Close relationships within degrees of separation