languages

10 rows


Description

Master table for available lesson languages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
ple_assessment_questions.language_id ple_assessment_questions_language_FK R
ple_avatars.language_id ple_avatars_language_id_foreign R
ple_career_path_texts.language_id job_types_text_language_id_foreign R
ple_content_cards.language_id content_card_language_id_foreign R
ple_image_assets.language_id ple_image_assets_language_id_foreign R
ple_job_card_texts.language_id job_cards_text_language_id_foreign R
ple_job_cards.language_id job_cards_language_id_foreign R
ple_skill_texts.language_id skill_text_language_id_foreign R
ple_skills.language_id skills_language_id_foreign R
ple_success_stories.language_id success_stories_language_id_foreign R
ple_video_assets.language_id ple_video_assets_language_id_foreign R
name VARCHAR 125 null
tenant_id VARCHAR 36 null
old_data_id INT 10 √ null
order BIT 1 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
status BIT 1 √ 1

0:Inactive,1:Active

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_languages_order Performance Asc order
updated_at_index Performance Asc updated_at

Relationships

Close relationships within degrees of separation