assignments

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
assignment_entry.assignment_id assignment_entry_assignment_id_foreign C
assignment_result.assignment_id assignment_result_assignment_id_foreign C
case_result.assignment_id case_result_assignment_id_foreign C
cases.assignment_id cases_assignment_id_foreign C
meeting_id INT 10 null
sort_order INT 10 null
name TEXT 65535 null
intro TEXT 65535 null
outro TEXT 65535 √ null
info TEXT 65535 null
sub_assignment TEXT 65535 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

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

Relationships

Close relationships within degrees of separation