cases

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
case_entry.case_id case_entry_case_id_foreign C
case_result.case_id case_result_case_id_foreign C
assignment_id INT 10 null
assignments.id cases_assignment_id_foreign C
sort_order INT 10 null
name TEXT 65535 null
intro TEXT 65535 null
outro TEXT 65535 null
info TEXT 65535 null
complete_action TEXT 65535 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

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

Relationships

Close relationships within degrees of separation