ple_skills

60 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
ple_assessment_questions.skill_id ple_assessment_questions_skill_id_foreign R
ple_content_card_ple_skill.skill_id skill_id_content_card_id_foreign R
ple_content_ple_skill.skill_id skill_id_content_id_foreign R
ple_course_skill.skill_id course_skill_skill_id_foreign R
ple_skill_trade.skill_id ple_skill_trade_skill_id_foreign R
ple_skill_user.skill_id skill_user_skill_id_foreign R
name VARCHAR 125 null
image VARCHAR 125 null
long_description TEXT 65535 null
sort_order INT 10 null
language_id CHAR 36 null
languages.id skills_language_id_foreign R
created_by CHAR 36 null
users.id skills_created_by_foreign R
tenant_id CHAR 36 null
tenants.id skills_tenant_id_foreign R
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
skills_created_by_foreign Performance Asc created_by
skills_language_id_foreign Performance Asc language_id
skills_tenant_id_foreign Performance Asc tenant_id

Relationships

Close relationships within degrees of separation