ple_content_cards

238 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
learning_activity_responses.ple_content_card_id content_card_id_content_response_foreign R
ple_assessment_questions.ple_content_card_id ple_assessments_question_ple_content_card_foreign R
ple_content_card_ple_skill.content_card_id content_card_id_skill_id_foreign R
ple_content_id CHAR 36 null
ple_contents.id content_card_content_id_foreign R
language_id CHAR 36 null
languages.id content_card_language_id_foreign R
url TEXT 65535 √ null
card_number INT 10 null
content_data TEXT 65535 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
content_card_content_id_foreign Performance Asc ple_content_id
content_card_language_id_foreign Performance Asc language_id

Relationships

Close relationships within degrees of separation