assignment_entry

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
assignment_entry_properties.entry_id assignment_entry_property_entry_id_foreign C
assignment_result.entry_id assignment_result_entry_id_foreign C
sort_order INT 10 null
name TEXT 65535 null
info TEXT 65535 null
assignment_id INT 10 null
assignments.id assignment_entry_assignment_id_foreign C
type enum('mcq', 'text_input', 'text_separator', 'mcq-2', 'mcq-3', 'video_youtube', '') 14 null
optional INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assignment_entry_assignment_id_foreign Performance Asc assignment_id

Relationships

Close relationships within degrees of separation