ple_contents

59 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
learning_activity_responses.content_id content_id_content_response_foreign R
ple_assessments.ple_content_id ple_assessments_ple_content_foreign R
ple_content_cards.ple_content_id content_card_content_id_foreign R
ple_content_ple_job_card.content_id content_id_job_card_id_foreign R
ple_content_ple_skill.content_id content_id_skill_id_foreign R
title VARCHAR 125 null
description TEXT 65535 √ null
type enum('lesson', 'activity', 'assessment') 10 null
content_count INT 10 null
meta TEXT 65535 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null
status enum('unpublished', 'published', 'live') 11 null

Indexes

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

Relationships

Close relationships within degrees of separation