ple_assessments

51 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
ple_assessment_lock_activities.ple_assessment_id ple_assessment_lock_activities_ple_assessment_id_foreign C
ple_assessment_pages.assessment_id ple_assessment_pages_assessment_id_foreign C
ple_assessment_responses.assessment_id ple_assessment_responses_assessment_id_foreign R
title VARCHAR 125 null
description TEXT 65535 null
assessment_type enum('baseline', 'endline', 'lesson') 8 null
duration VARCHAR 125 √ null
published BIT 1 0
career_path_id CHAR 36 √ null
created_by CHAR 36 null
users.id ple_assessments_created_by_foreign R
tenant_id CHAR 36 null
tenants.id ple_assessments_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null
ple_content_id CHAR 36 √ null
ple_contents.id ple_assessments_ple_content_foreign R
lock_status TINYINT 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ple_assessments_career_path_id_IDX Performance Asc career_path_id
ple_assessments_created_by_foreign Performance Asc created_by
ple_assessments_ple_content_foreign Performance Asc ple_content_id
ple_assessments_tenant_id_foreign Performance Asc tenant_id

Relationships

Close relationships within degrees of separation