112 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| announcement_target_organizations_ibfk_1 |
|
|
Cascade on delete | ||||||
| announcement_target_organizations_ibfk_2 |
|
|
Cascade on delete | ||||||
| company_videos_company_video_status_foreign |
|
|
Restrict delete | ||||||
| company_videos_organization_foreign |
|
|
Restrict delete | ||||||
| company_videos_company_video_scope_foreign |
|
|
Restrict delete | ||||||
| fk_gms_goal_setting |
|
|
Cascade on delete | ||||||
| fk_gms_report |
|
|
Cascade on delete | ||||||
| reflection_reports_reflection_setting_id_foreign |
|
|
Cascade on delete | ||||||
| ai_knowledge_base_configs_kind_foreign |
|
|
Restrict delete | ||||||
| fk_goal_unset_notification_goal_setting |
|
|
Cascade on delete | ||||||
| company_video_department_association_department_foreign |
|
|
Restrict delete | ||||||
| company_video_department_association_video_foreign |
|
|
Restrict delete | ||||||
| organization_id_foreign |
|
|
Restrict delete | ||||||
| principle_id_foreign |
|
|
Cascade on delete | ||||||
| legend_id_and_story_id_foreign |
|
|
Cascade on delete | ||||||
| choice_questions_assessment_stance_foreign |
|
|
Restrict delete | ||||||
| fk_team_goals_goal_setting_id |
|
|
Cascade on delete | ||||||
| inquiry_company_position_names_ibfk_1 |
|
|
Restrict delete | ||||||
| gift_received_user_id_foreign |
|
|
Restrict delete | ||||||
| gift_legend_id_foreign |
|
|
Restrict delete | ||||||
| gift_send_user_id_foreign |
|
|
Restrict delete | ||||||
| fk_actual_entries_goal |
|
|
Cascade on delete | ||||||
| fk_user_kb_reflection_setting_id |
|
|
Cascade on delete | ||||||
| fk_reflection_team_kb_setting_id |
|
|
Cascade on delete | ||||||
| roles_department_id_foreign |
|
|
Restrict delete | ||||||
| roles_organization_id_foreign |
|
|
Restrict delete | ||||||
| roles_employee_role_role_foreign |
|
|
Restrict delete | ||||||
| inquiry_company_department_names_ibfk_1 |
|
|
Restrict delete | ||||||
| fk_employee_goals_goal_setting_id |
|
|
Cascade on delete | ||||||
| company_video_watching_histories_company_video_foreign |
|
|
Cascade on delete | ||||||
| company_video_watching_histories_status_foreign |
|
|
Restrict delete | ||||||
| reflection_setting_id_foreign |
|
|
Cascade on delete | ||||||
| reflection_summarize_employee_reports_period_foreign |
|
|
Restrict delete | ||||||
| reflection_kpis_reflection_setting_id_foreign |
|
|
Cascade on delete | ||||||
| reflection_settings_status_foreign |
|
|
Restrict delete | ||||||
| reflection_settings_week_closing_day_foreign |
|
|
Restrict delete | ||||||
| reflection_settings_organization_id_foreign |
|
|
Cascade on delete | ||||||
| fk_agg_team_goal_items_goal_setting_id |
|
|
Cascade on delete | ||||||
| ai_chatbot_configs_organization_id_foreign |
|
|
Restrict delete | ||||||
| ai_chatbot_configs_kind |
|
|
Restrict delete | ||||||
| fk_ai_chatbot_configs_dify_app_id |
|
|
Null on delete | ||||||
| ai_chatbot_config_tts_id_foreign |
|
|
Restrict delete | ||||||
| reflection_settings_assignments_reflection_id_foreign |
|
|
Cascade on delete | ||||||
| organization_organization_principle_id_foreign |
|
|
Restrict delete | ||||||
| fk_goal_settings_team_setting_id |
|
|
Cascade on delete | ||||||
| stance_foreign |
|
|
Cascade on delete | ||||||
| legend_and_story_id_foreign |
|
|
Cascade on delete | ||||||
| assessment_organization_choice_questions_organization_foreign |
|
|
Cascade on delete | ||||||
| choice_questions_principle_id_foreign |
|
|
Restrict delete | ||||||
| purchase_histories_customer_id_foreign |
|
|
Cascade on delete | ||||||
| purchase_histories_purchase_type_foreign |
|
|
Cascade on delete | ||||||
| purchase_histories_payment_method_type_foreign |
|
|
Cascade on delete | ||||||
| ai_chat_retriever_resources_conversation_fk |
|
|
Cascade on delete | ||||||
| action_plan_action_feedbacks_reviewers_foreign |
|
|
Restrict delete | ||||||
| action_plan_action_feedbacks_reactions_foreign |
|
|
Restrict delete | ||||||
| organization_action_plan_goal_types_ibfk_2 |
|
|
Cascade on delete | ||||||
| organization_action_plan_goal_types_ibfk_1 |
|
|
Cascade on delete | ||||||
| cs_accounts_ibfk_1 |
|
|
Cascade on delete | ||||||
| reflection_summarize_reports_period_foreign |
|
|
Restrict delete | ||||||
| reflection_summarize_reports_reflection_setting_id_foreign |
|
|
Cascade on delete | ||||||
| organization_free_text_answers_principle_id_foreign |
|
|
Restrict delete | ||||||
| organization_free_text_answers_assessment_id_foreign |
|
|
Cascade on delete | ||||||
| organization_free_text_answers_question_id_foreign |
|
|
Restrict delete | ||||||
| deleted_company_videos_organization_foreign |
|
|
Restrict delete | ||||||
| deleted_company_videos_company_video_scope_foreign |
|
|
Restrict delete | ||||||
| deleted_company_videos_company_video_status_foreign |
|
|
Restrict delete | ||||||
| free_text_question_id_foreign |
|
|
Restrict delete | ||||||
| free_text_answers_assessment_id_foreign |
|
|
Cascade on delete | ||||||
| organization_dify_apps_ibfk_1 |
|
|
Cascade on delete | ||||||
| organization_dify_apps_ibfk_2 |
|
|
Cascade on delete | ||||||
| legend_story_watching_histories_status_foreign |
|
|
Cascade on delete | ||||||
| action_plan_outcome_feedbacks_reviewers_foreign |
|
|
Restrict delete | ||||||
| fk_eac_organization |
|
|
Cascade on delete | ||||||
| fk_eac_ai_chat_kind |
|
|
Restrict delete | ||||||
| free_text_questions_assessment_stance_foreign |
|
|
Restrict delete | ||||||
| reflection_report_schedules_organization_id_foreign |
|
|
Cascade on delete | ||||||
| reflection_report_schedules_execution_day_foreign |
|
|
Restrict delete | ||||||
| inquiries_ibfk_2 |
|
|
Restrict delete | ||||||
| inquiries_ibfk_1 |
|
|
Restrict delete | ||||||
| inquiries_ibfk_3 |
|
|
Restrict delete | ||||||
| fk_action_plan_stances_action_plan |
|
|
Cascade on delete | ||||||
| fk_action_plan_stances_stance |
|
|
Cascade on delete | ||||||
| assessments_distribution_foreign |
|
|
Restrict delete | ||||||
| fk_organization_features_organization |
|
|
Cascade on delete | ||||||
| fk_organization_features_feature |
|
|
Cascade on delete | ||||||
| fk_action_plan_principles_action_plan |
|
|
Cascade on delete | ||||||
| fk_action_plan_principles_principle |
|
|
Cascade on delete | ||||||
| organization_choice_answers_question_id_foreign |
|
|
Restrict delete | ||||||
| organization_choice_answers_assessment_id_foreign |
|
|
Cascade on delete | ||||||
| organization_choice_answers_principle_id_foreign |
|
|
Restrict delete | ||||||
| fk_agg_member_values_item_id |
|
|
Cascade on delete | ||||||
| assessment_distributions_organization_id_foreign |
|
|
Restrict delete | ||||||
| departments_parent_department_id_foreign |
|
|
Restrict delete | ||||||
| departments_organization_id_foreign |
|
|
Restrict delete | ||||||
| ai_skills_ibfk_1 |
|
|
Cascade on delete | ||||||
| choice_question_id_foreign |
|
|
Restrict delete | ||||||
| choice_answers_assessment_id_foreign |
|
|
Cascade on delete | ||||||
| fk_team_goal_actual_entries_goal |
|
|
Cascade on delete | ||||||
| action_plans_action_plan_status_foreign |
|
|
Restrict delete | ||||||
| action_plans_kind_foreign |
|
|
Restrict delete | ||||||
| ai_chat_scenario_legend_id_foreign |
|
|
Cascade on delete | ||||||
| ai_chat_scenario_legend_and_story_id_foreign |
|
|
Cascade on delete | ||||||
| employee_issues_issue_status_foreign |
|
|
Restrict delete | ||||||
| fk_helpdesk_conversations_organization_id |
|
|
Restrict delete | ||||||
| issues_legend_and_story_id_foreign |
|
|
Cascade on delete | ||||||
| legend_story_contents_legend_id_foreign |
|
|
Cascade on delete | ||||||
| fk_helpdesk_messages_conversation_id |
|
|
Cascade on delete | ||||||
| free_text_questions_principle_id_foreign |
|
|
Restrict delete | ||||||
| assessment_organization_free_text_questions_organization_foreign |
|
|
Cascade on delete | ||||||
| reflection_kpi_values_kpi_id_foreign |
|
|
Cascade on delete | ||||||
| reflection_kpi_values_report_id_foreign |
|
|
Null on delete | ||||||
| fk_gmar_report |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|