tenants

3 rows


Description

Tenant details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
badge_category.tenant_id badge_category_ibfk_1 R
badge_type.tenant_id badge_type_ibfk_1 R
batches.tenant_id batches_ibfk_2 R
centre_types.tenant_id centre_types_ibfk_11 R
centre_types_old.tenant_id centre_types_old_ibfk_1 R
ple_analytics.tenant_id ple_analytics_tenant_id_foreign R
ple_assessment_options.tenant_id ple_assessment_options_tenant_id_foreign R
ple_assessment_pages.tenant_id ple_assessment_pages_tenant_id_foreign R
ple_assessment_questions.tenant_id ple_assessment_questions_tenant_id_foreign R
ple_assessment_response_keys.tenant_id ple_assessment_response_keys_tenant_id_foreign R
ple_assessment_responses.tenant_id ple_assessment_responses_tenant_id_foreign R
ple_assessments.tenant_id ple_assessments_tenant_id_foreign R
ple_avatar_categories.tenant_id avatar_categories_tenant_id_foreign R
ple_avatar_user.tenant_id ple_avatar_user_tenant_id_foreign R
ple_avatars.tenant_id ple_avatars_tenant_id_foreign R
ple_career_path_user.tenant_id job_type_user_tenant_id_foreign R
ple_career_paths.tenant_id job_types_tenant_id_foreign R
ple_course_skill.tenant_id course_skill_tenant_id_foreign R
ple_credits.tenant_id credits_tenant_id_foreign R
ple_day_streak_user.tenant_id day_streak_user_tenant_id_foreign R
ple_guide_book_user.tenant_id guide_book_user_tenant_id_foreign R
ple_guide_books.tenant_id guide_books_tenant_id_foreign R
ple_image_assets.tenant_id ple_image_assets_tenant_id_foreign R
ple_job_card_career_path.tenant_id job_card_job_type_tenant_id_foreign R
ple_job_card_user.tenant_id job_card_user_tenant_id_foreign R
ple_job_cards.tenant_id job_cards_tenant_id_foreign R
ple_skill_trade.tenant_id ple_skill_trade_tenant_id_foreign R
ple_skill_user.tenant_id skill_user_tenant_id_foreign R
ple_skills.tenant_id skills_tenant_id_foreign R
ple_success_stories.tenant_id success_stories_tenant_id_foreign R
ple_user_onboardings.tenant_id ple_user_onboardings_tenant_id_foreign R
ple_video_assets.tenant_id ple_video_assets_tenant_id_foreign R
name VARCHAR 125 null

Can be Quest or any other Companies
status TINYINT 3 √ 1

1:Active,0:Inactive
updated_at DATETIME 19 null
created_at DATETIME 19 null
deleted_at DATETIME 19 √ null

Indexes

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

Relationships

Close relationships within degrees of separation