Constraints

Restrict delete

company_videos_company_video_scope_foreign

company_videos.scope

company_video_scope.scope

Restrict delete

reflection_summarize_reports_period_foreign

reflection_summarize_reports.period

period_types.period_code

Restrict delete

reflection_summarize_reports_reflection_setting_id_foreign

reflection_summarize_reports.reflection_setting_id

Cascade on delete

organization_free_text_answers_principle_id_foreign

assessment_organization_free_text_answers.principle_id

organization_principles.principle_id

Restrict delete

organization_free_text_answers_assessment_id_foreign

assessment_organization_free_text_answers.assessment_id

assessments.assessment_id

Cascade on delete

organization_free_text_answers_question_id_foreign

assessment_organization_free_text_answers.question_id

assessment_organization_free_text_questions.question_id

Restrict delete

deleted_company_videos_organization_foreign

deleted_company_videos.organization_id

Restrict delete

deleted_company_videos_company_video_scope_foreign

deleted_company_videos.scope

company_video_scope.scope

Restrict delete

deleted_company_videos_company_video_status_foreign

deleted_company_videos.status

company_video_status.status

Restrict delete

reflection_reports_reflection_setting_id_foreign

reflection_daily_employee_reports.reflection_setting_id

Cascade on delete

reflection_reports_status_foreign

reflection_daily_employee_reports.status

reflection_report_status.status

Restrict delete

free_text_question_id_foreign

assessment_free_text_answers.question_id

assessment_free_text_questions.question_id

Restrict delete

free_text_answers_assessment_id_foreign

assessment_free_text_answers.assessment_id

assessments.assessment_id

Cascade on delete

ai_knowledge_base_configs_kind_foreign

ai_knowledge_base_configs.kind

ai_chat_kind.id

Restrict delete

company_video_department_association_department_foreign

company_video_department_association.department_id

departments.department_id

Restrict delete

company_video_department_association_video_foreign

company_video_department_association.video_id

company_videos.id

Restrict delete

organization_id_foreign

legend_story_content_principles.organization_id

Restrict delete

principle_id_foreign

legend_story_content_principles.principle_id

organization_principles.principle_id

Cascade on delete

legend_id_and_story_id_foreign

legend_story_content_principles.legend_id

legend_story_content_principles.story_id

legend_story_contents.legend_id

Cascade on delete

choice_questions_assessment_stance_foreign

assessment_choice_questions.stance

stance.tag

Restrict delete

legend_story_watching_histories_status_foreign

legend_story_watching_histories.status

watching_status.status

Cascade on delete

action_plan_outcome_feedbacks_reviewers_foreign

action_plan_outcome_feedbacks.user_id

action_plan_outcome_feedbacks.action_plan_id

action_plan_reviewers.user_id

action_plan_reviewers.action_plan_id

Restrict delete

inquiry_company_position_names_ibfk_1

inquiry_company_position_names.position

inquiry_company_positions.position

Restrict delete

openai_tts_configs_model_foreign

openai_tts_configs.model

openai_tts_models.model

Restrict delete

openai_tts_configs_voice_foreign

openai_tts_configs.voice

openai_tts_voices.voice

Restrict delete

free_text_questions_assessment_stance_foreign

assessment_free_text_questions.stance

stance.tag

Restrict delete

gift_received_user_id_foreign

gifts.received_user_id

customers.id

Restrict delete

gift_legend_id_foreign

gifts.legend_id

legend_overviews.id

Restrict delete

gift_send_user_id_foreign

gifts.send_user_id

customers.id

Restrict delete

reflection_report_schedules_organization_id_foreign

reflection_report_schedules.organization_id

Cascade on delete

reflection_report_schedules_execution_day_foreign

reflection_report_schedules.execution_day

week_days.day_code

Restrict delete

inquiries_ibfk_2

inquiries.position

inquiry_company_positions.position

Restrict delete

inquiries_ibfk_1

inquiries.department

inquiry_company_departments.department

Restrict delete

inquiries_ibfk_3

inquiries.inquiry_type

inquiry_types.type

Restrict delete

fk_action_plan_stances_action_plan

action_plan_stances.action_plan_id

action_plans.id

Cascade on delete

fk_action_plan_stances_stance

action_plan_stances.stance_tag

stance.tag

Cascade on delete

fk_reflection_team_kb_setting_id

reflection_team_knowledge_bases.reflection_setting_id

Cascade on delete

roles_department_id_foreign

roles.department_id

departments.department_id

Restrict delete

roles_organization_id_foreign

roles.organization_id

Restrict delete

roles_employee_role_role_foreign

roles.role

employee_roles.role

Restrict delete

assessments_distribution_foreign

assessments.distribution_id

assessments.organization_id

assessment_distributions.distribution_id

assessment_distributions.organization_id

Restrict delete

inquiry_company_department_names_ibfk_1

inquiry_company_department_names.department

inquiry_company_departments.department

Restrict delete

company_video_watching_histories_company_video_foreign

company_video_watching_histories.company_video_id

company_videos.id

Cascade on delete

company_video_watching_histories_status_foreign

company_video_watching_histories.status

watching_status.status

Restrict delete

fk_organization_features_organization

organization_features.organization_id

Cascade on delete

fk_organization_features_feature

organization_features.feature_key

features.feature_key

Cascade on delete

reflection_setting_id_foreign

reflection_summarize_employee_reports.reflection_setting_id

Cascade on delete

reflection_summarize_employee_reports_period_foreign

reflection_summarize_employee_reports.period

period_types.period_code

Restrict delete

fk_action_plan_principles_action_plan

action_plan_principles.action_plan_id

action_plans.id

Cascade on delete

fk_action_plan_principles_principle

action_plan_principles.principle_id

organization_principles.principle_id

Cascade on delete

organization_choice_answers_question_id_foreign

assessment_organization_choice_answers.question_id

assessment_organization_choice_questions.question_id

Restrict delete

organization_choice_answers_assessment_id_foreign

assessment_organization_choice_answers.assessment_id

assessments.assessment_id

Cascade on delete

organization_choice_answers_principle_id_foreign

assessment_organization_choice_answers.principle_id

organization_principles.principle_id

Restrict delete

assessment_distributions_organization_id_foreign

assessment_distributions.organization_id

Restrict delete

reflection_kpis_reflection_setting_id_foreign

reflection_kpis.reflection_setting_id

Cascade on delete

reflection_settings_status_foreign

reflection_settings.status

reflection_setting_status.status

Restrict delete

reflection_settings_week_closing_day_foreign

reflection_settings.week_closing_day

week_days.day_code

Restrict delete

reflection_settings_organization_id_foreign

reflection_settings.organization_id

Cascade on delete

departments_parent_department_id_foreign

departments.parent_department_id

departments.department_id

Restrict delete

departments_organization_id_foreign

departments.organization_id

Restrict delete

ai_chatbot_configs_organization_id_foreign

ai_chatbot_configs.organization_id

Restrict delete

ai_chatbot_configs_kind

ai_chatbot_configs.kind

ai_chat_kind.id

Restrict delete

ai_chatbot_config_openai_tts_id_foreign

ai_chatbot_configs.openai_tts_id

openai_tts_configs.openai_tts_id

Restrict delete

ai_skills_ibfk_1

ai_skills.category_id

ai_skill_categories.id

Cascade on delete

reflection_settings_assignments_reflection_id_foreign

reflection_settings_assignments.reflection_id

Cascade on delete

organization_organization_principle_id_foreign

organization_principles.organization_id

Restrict delete

choice_question_id_foreign

assessment_choice_answers.question_id

assessment_choice_questions.question_id

Restrict delete

choice_answers_assessment_id_foreign

assessment_choice_answers.assessment_id

assessments.assessment_id

Cascade on delete

stance_foreign

legend_story_content_stances.stance

stance.tag

Cascade on delete

legend_and_story_id_foreign

legend_story_content_stances.legend_id

legend_story_content_stances.story_id

legend_story_contents.legend_id

Cascade on delete

action_plans_action_plan_status_foreign

action_plans.status

action_plan_status.status

Restrict delete

action_plans_kind_foreign

action_plans.kind

actionplan_kind.id

Restrict delete

assessment_organization_choice_questions_organization_foreign

assessment_organization_choice_questions.organization_id

Cascade on delete

choice_questions_principle_id_foreign

assessment_organization_choice_questions.principle_id

organization_principles.principle_id

Restrict delete

purchase_histories_customer_id_foreign

purchase_histories.customer_id

customers.id

Cascade on delete

purchase_histories_purchase_type_foreign

purchase_histories.purchase_type

purchase_types.purchase_type

Cascade on delete

purchase_histories_payment_method_type_foreign

purchase_histories.payment_method_type

payment_method_types.payment_method_type

Cascade on delete

ai_chat_scenario_legend_id_foreign

ai_chat_scenario.legend_id

legend_overviews.id

Cascade on delete

ai_chat_scenario_legend_and_story_id_foreign

ai_chat_scenario.legend_id

ai_chat_scenario.story_id

legend_story_contents.legend_id

Cascade on delete

employee_issues_issue_status_foreign

employee_issues.status

issue_status.status

Restrict delete

issues_legend_and_story_id_foreign

issues.legend_id

issues.story_id

legend_story_contents.legend_id

Cascade on delete

legend_story_contents_legend_id_foreign

legend_story_contents.legend_id

legend_overviews.id

Cascade on delete

free_text_questions_principle_id_foreign

assessment_organization_free_text_questions.principle_id

organization_principles.principle_id

Restrict delete

assessment_organization_free_text_questions_organization_foreign

assessment_organization_free_text_questions.organization_id

reflection_daily_employee_reports.id

Cascade on delete

reflection_kpi_values_kpi_id_foreign

reflection_kpi_values.kpi_id

reflection_kpis.id

Cascade on delete

reflection_kpi_values_report_id_foreign

reflection_kpi_values.report_id

Null on delete

action_plan_action_feedbacks_reviewers_foreign

action_plan_action_feedbacks.user_id

action_plan_action_feedbacks.action_plan_id

action_plan_reviewers.user_id

action_plan_reviewers.action_plan_id

Restrict delete

action_plan_action_feedbacks_reactions_foreign

action_plan_action_feedbacks.reaction

action_plan_action_feedback_reactions.id

Restrict delete

organization_action_plan_goal_types_ibfk_2

organization_action_plan_goal_types.action_plan_goal_type_id

action_plan_goal_types.id

Cascade on delete

organization_action_plan_goal_types_ibfk_1

organization_action_plan_goal_types.organization_id