learning_activity_responses

83525 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
content_id CHAR 36 null
ple_contents.id content_id_content_response_foreign R
response TEXT 65535 √ null
response_type enum('image', 'video', 'audio', 'text', 'mcq', 'document') 8 √ null
learning_activity_id CHAR 36 null
learning_activities.id learning_activity_id_content_response_foreign R
ple_content_card_id CHAR 36 √ null
ple_content_cards.id content_card_id_content_response_foreign R
created_by CHAR 36 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
content_card_id_content_response_foreign Performance Asc ple_content_card_id
content_id_content_response_foreign Performance Asc content_id
lar_created_by_index Performance Asc created_by
lar_deleted_at_index Performance Asc deleted_at
learning_activity_id_content_response_foreign Performance Asc learning_activity_id

Relationships

Close relationships within degrees of separation