case_entry

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
case_entry_properties.entry_id case_entry_properties_entry_id_foreign C
case_result.entry_id case_result_entry_id_foreign C
sort_order INT 10 null
name TEXT 65535 null
info TEXT 65535 null
case_id INT 10 null
cases.id case_entry_case_id_foreign C
type enum('mcq', 'text_input', 'text_separator', 'mcq-2', 'mcq-3', '') 14 null
optional INT 10 0

Indexes

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

Relationships

Close relationships within degrees of separation