139 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| day_streak_user_tenant_id_foreign |
|
|
Restrict delete | ||
| day_streak_user_created_by_foreign |
|
|
Restrict delete | ||
| day_streak_user_user_id_foreign |
|
|
Restrict delete | ||
| avatar_categories_tenant_id_foreign |
|
|
Restrict delete | ||
| avatar_categories_created_by_foreign |
|
|
Restrict delete | ||
| ple_video_assets_language_id_foreign |
|
|
Restrict delete | ||
| ple_video_assets_created_by_foreign |
|
|
Restrict delete | ||
| ple_video_assets_tenant_id_foreign |
|
|
Restrict delete | ||
| centre_mqops_centre_visit_ibfk_1 |
|
|
Restrict delete | ||
| centre_mqops_session_tracker_ibfk_1 |
|
|
Restrict delete | ||
| job_types_tenant_id_foreign |
|
|
Restrict delete | ||
| job_types_trade_id_foreign |
|
|
Restrict delete | ||
| job_types_created_by_foreign |
|
|
Restrict delete | ||
| guide_books_tenant_id_foreign |
|
|
Restrict delete | ||
| guide_books_created_by_foreign |
|
|
Restrict delete | ||
| guide_books_course_id_foreign |
|
|
Restrict delete | ||
| batches_ibfk_1 |
|
|
Restrict delete | ||
| batches_ibfk_3 |
|
|
Restrict delete | ||
| batches_ibfk_2 |
|
|
Restrict delete | ||
| ple_assessment_response_keys_assessment_option_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_response_keys_assessment_question_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_response_keys_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_response_keys_assessment_responses_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_response_keys_created_by_foreign |
|
|
Restrict delete | ||
| credits_tenant_id_foreign |
|
|
Restrict delete | ||
| credits_created_by_foreign |
|
|
Restrict delete | ||
| centre_types_old_ibfk_1 |
|
|
Restrict delete | ||
| ple_assessment_pages_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_pages_assessment_id_foreign |
|
|
Cascade on delete | ||
| ple_assessment_pages_created_by_foreign |
|
|
Restrict delete | ||
| ple_avatars_language_id_foreign |
|
|
Restrict delete | ||
| ple_avatars_avatar_category_id_foreign |
|
|
Restrict delete | ||
| ple_avatars_created_by_foreign |
|
|
Restrict delete | ||
| ple_avatars_tenant_id_foreign |
|
|
Restrict delete | ||
| course_skill_updated_by_foreign |
|
|
Restrict delete | ||
| course_skill_created_by_foreign |
|
|
Restrict delete | ||
| course_skill_course_id_foreign |
|
|
Restrict delete | ||
| course_skill_skill_id_foreign |
|
|
Restrict delete | ||
| course_skill_tenant_id_foreign |
|
|
Restrict delete | ||
| trade_mqops_activity_tracker_ibfk_1 |
|
|
Restrict delete | ||
| centre_mqops_activity_tracker_ibfk_1 |
|
|
Restrict delete | ||
| learning_activity_id_content_response_foreign |
|
|
Restrict delete | ||
| content_card_id_content_response_foreign |
|
|
Restrict delete | ||
| content_id_content_response_foreign |
|
|
Restrict delete | ||
| guide_book_user_tenant_id_foreign |
|
|
Restrict delete | ||
| guide_book_user_course_id_foreign |
|
|
Restrict delete | ||
| guide_book_user_guide_book_id_foreign |
|
|
Restrict delete | ||
| guide_book_user_user_id_foreign |
|
|
Restrict delete | ||
| guide_book_user_created_by_foreign |
|
|
Restrict delete | ||
| ple_user_onboardings_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_user_onboardings_trade_id_foreign |
|
|
Restrict delete | ||
| ple_user_onboardings_user_id_foreign |
|
|
Restrict delete | ||
| ple_user_onboardings_created_by_foreign |
|
|
Restrict delete | ||
| batch_mqops_activity_tracker_ibfk_1 |
|
|
Restrict delete | ||
| centre_user_ibfk_2 |
|
|
Restrict delete | ||
| centre_user_ibfk_1 |
|
|
Restrict delete | ||
| centre_project_ibfk_1 |
|
|
Restrict delete | ||
| centre_project_ibfk_2 |
|
|
Restrict delete | ||
| skill_id_content_id_foreign |
|
|
Restrict delete | ||
| content_id_skill_id_foreign |
|
|
Restrict delete | ||
| ple_avatar_user_avatar_id_foreign |
|
|
Restrict delete | ||
| ple_avatar_user_created_by_foreign |
|
|
Restrict delete | ||
| ple_avatar_user_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_avatar_user_user_id_foreign |
|
|
Restrict delete | ||
| centre_subject_ibfk_1 |
|
|
Restrict delete | ||
| centre_subject_ibfk_2 |
|
|
Restrict delete | ||
| skills_created_by_foreign |
|
|
Restrict delete | ||
| skills_language_id_foreign |
|
|
Restrict delete | ||
| skills_tenant_id_foreign |
|
|
Restrict delete | ||
| job_cards_language_id_foreign |
|
|
Restrict delete | ||
| job_cards_tenant_id_foreign |
|
|
Restrict delete | ||
| job_cards_created_by_foreign |
|
|
Restrict delete | ||
| job_cards_trade_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_responses_created_by_foreign |
|
|
Restrict delete | ||
| ple_assessment_responses_user_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_responses_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_responses_assessment_id_foreign |
|
|
Restrict delete | ||
| centre_phase_ibfk_1 |
|
|
Restrict delete | ||
| skill_user_skill_id_foreign |
|
|
Restrict delete | ||
| skill_user_tenant_id_foreign |
|
|
Restrict delete | ||
| skill_user_created_by_foreign |
|
|
Restrict delete | ||
| skill_user_user_id_foreign |
|
|
Restrict delete | ||
| ple_image_assets_created_by_foreign |
|
|
Restrict delete | ||
| ple_image_assets_language_id_foreign |
|
|
Restrict delete | ||
| ple_image_assets_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessments_created_by_foreign |
|
|
Restrict delete | ||
| ple_assessments_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessments_ple_content_foreign |
|
|
Restrict delete | ||
| job_cards_text_language_id_foreign |
|
|
Restrict delete | ||
| badges_ibfk_1 |
|
|
Restrict delete | ||
| badges_ibfk_2 |
|
|
Restrict delete | ||
| badge_type_ibfk_1 |
|
|
Restrict delete | ||
| job_card_id_content_id_foreign |
|
|
Restrict delete | ||
| content_id_job_card_id_foreign |
|
|
Restrict delete | ||
| job_card_user_user_id_foreign |
|
|
Restrict delete | ||
| job_card_user_created_by_foreign |
|
|
Restrict delete | ||
| job_card_user_job_card_id_foreign |
|
|
Restrict delete | ||
| job_card_user_tenant_id_foreign |
|
|
Restrict delete | ||
| content_card_id_skill_id_foreign |
|
|
Restrict delete | ||
| skill_id_content_card_id_foreign |
|
|
Restrict delete | ||
| job_card_job_type_tenant_id_foreign |
|
|
Restrict delete | ||
| job_card_job_type_job_card_id_foreign |
|
|
Restrict delete | ||
| job_card_job_type_job_type_id_foreign |
|
|
Restrict delete | ||
| job_card_job_type_created_by_foreign |
|
|
Restrict delete | ||
| ple_assessment_questions_created_by_foreign |
|
|
Restrict delete | ||
| ple_assessments_question_ple_content_card_foreign |
|
|
Restrict delete | ||
| ple_assessment_questions_assessment_page_id_foreign |
|
|
Cascade on delete | ||
| ple_assessment_questions_language_FK |
|
|
Restrict delete | ||
| ple_assessment_questions_skill_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_questions_tenant_id_foreign |
|
|
Restrict delete | ||
| batch_subject_ibfk_1 |
|
|
Restrict delete | ||
| batch_subject_ibfk_2 |
|
|
Restrict delete | ||
| job_type_user_job_type_id_foreign |
|
|
Restrict delete | ||
| job_type_user_tenant_id_foreign |
|
|
Restrict delete | ||
| job_type_user_created_by_foreign |
|
|
Restrict delete | ||
| job_type_user_user_id_foreign |
|
|
Restrict delete | ||
| ple_skill_trade_skill_id_foreign |
|
|
Restrict delete | ||
| ple_skill_trade_trade_id_foreign |
|
|
Restrict delete | ||
| ple_skill_trade_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_skill_trade_created_by_foreign |
|
|
Restrict delete | ||
| ple_skill_trade_updated_by_foreign |
|
|
Restrict delete | ||
| communities_ibfk_1 |
|
|
Restrict delete | ||
| ple_analytics_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_analytics_created_by_foreign |
|
|
Restrict delete | ||
| ple_analytics_user_id_foreign |
|
|
Restrict delete | ||
| state_user_ibfk_2 |
|
|
Restrict delete | ||
| state_user_ibfk_1 |
|
|
Restrict delete | ||
| career_path_id_foreign |
|
|
Restrict delete | ||
| job_types_text_language_id_foreign |
|
|
Restrict delete | ||
| badge_category_ibfk_1 |
|
|
Restrict delete | ||
| success_stories_language_id_foreign |
|
|
Restrict delete | ||
| success_stories_created_by_foreign |
|
|
Restrict delete | ||
| success_stories_tenant_id_foreign |
|
|
Restrict delete | ||
| content_card_content_id_foreign |
|
|
Restrict delete | ||
| content_card_language_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_options_tenant_id_foreign |
|
|
Restrict delete | ||
| ple_assessment_options_assessment_question_id_foreign |
|
|
Cascade on delete | ||
| ple_assessment_options_created_by_foreign |
|
|
Restrict delete | ||
| centre_types_ibfk_11 |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|