Assignment Table Schema (assignment)


Description

Defines assignments

assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
assignment_submissions.assignment assisubm_ass4_fk R
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
assignmenttype varchar 50
resubmit tinyint 2 0
preventlate tinyint 2 0
emailteachers tinyint 2 0
var1 bigint 10 0
var2 bigint 10 0
var3 bigint 10 0
var4 bigint 10 0
var5 bigint 10 0
maxbytes bigint 10 100000
timedue bigint 10 0
timeavailable bigint 10 0
grade bigint 10 0
timemodified bigint 10 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