learning_activity_responses

1363 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

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
learning_activity_id_content_response_foreign Performance Asc learning_activity_id

Relationships

Close relationships within degrees of separation