training_assignments

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
training_assignment_entry.assignment_id training_assignment_entry_assignment_id_foreign C
training_assignment_result.assignment_id training_assignment_result_assignment_id_foreign C
training_case_result.assignment_id training_case_result_assignment_id_foreign C
training_cases.assignment_id training_cases_assignment_id_foreign C
training_id INT 10 null
trainings.id training_assignments_trainings_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
training_assignments_trainings_id_foreign Performance Asc training_id

Relationships

Close relationships within degrees of separation