145 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| appointments_customer_id_foreign |
|
|
Restrict delete | ||
| appointments_service_operator_id_foreign |
|
|
Restrict delete | ||
| customers_company_id_foreign |
|
|
Restrict delete | ||
| visit_reservation_setting_id_foreign |
|
|
Restrict delete | ||
| analysis_summary_records_analysis_summary_id_foreign |
|
|
Restrict delete | ||
| company_feature_permission_company_id_foreign |
|
|
Cascade on delete | ||
| company_feature_permission_feature_permission_id_foreign |
|
|
Cascade on delete | ||
| search_favorites_staff_id_foreign |
|
|
Restrict delete | ||
| message_template_folders_store_id_foreign |
|
|
Restrict delete | ||
| export_analysis_csv_files_login_staff_id_foreign |
|
|
Restrict delete | ||
| export_analysis_csv_files_staff_id_foreign |
|
|
Restrict delete | ||
| estimation_jsb_details_estimation_id_foreign |
|
|
Restrict delete | ||
| message_destinations_message_id_foreign |
|
|
Restrict delete | ||
| customer_statuses_company_id_foreign |
|
|
Restrict delete | ||
| auto_suggestion_settings_store_customer_id_foreign |
|
|
Restrict delete | ||
| customer_interaction_histories_message_id_foreign |
|
|
Restrict delete | ||
| customer_interaction_histories_customer_id_foreign |
|
|
Restrict delete | ||
| customer_interaction_histories_store_customer_id_foreign |
|
|
Restrict delete | ||
| customer_interaction_histories_staff_id_foreign |
|
|
Restrict delete | ||
| customer_interaction_histories_inquiry_id_foreign |
|
|
Restrict delete | ||
| visit_reservations_store_id_foreign |
|
|
Restrict delete | ||
| visit_reservations_customer_id_foreign |
|
|
Restrict delete | ||
| contact_rentals_store_customer_id_foreign |
|
|
Restrict delete | ||
| company_task_templates_company_id_foreign |
|
|
Cascade on delete | ||
| aggregation_candidates_customer_id2_foreign |
|
|
Restrict delete | ||
| aggregation_candidates_customer_id1_foreign |
|
|
Restrict delete | ||
| customer_addition_item_values_company_addition_item_id_foreign |
|
|
Cascade on delete | ||
| customer_addition_item_values_customer_id_foreign |
|
|
Cascade on delete | ||
| roles_company_id_foreign |
|
|
Restrict delete | ||
| line_users_customer_id_foreign |
|
|
Restrict delete | ||
| line_users_store_id_foreign |
|
|
Restrict delete | ||
| line_users_store_customer_id_foreign |
|
|
Restrict delete | ||
| analysis_summary_fields_analysis_summary_record_id_foreign |
|
|
Restrict delete | ||
| analysis_summary_fields_company_addition_item_option_id_foreign |
|
|
Restrict delete | ||
| read_messages_staff_id_foreign |
|
|
Restrict delete | ||
| read_messages_message_id_foreign |
|
|
Restrict delete | ||
| visit_reservation_settings_store_id_foreign |
|
|
Restrict delete | ||
| message_read_times_store_id_foreign |
|
|
Restrict delete | ||
| message_read_times_customer_id_foreign |
|
|
Restrict delete | ||
| message_read_times_staff_id_foreign |
|
|
Restrict delete | ||
| company_analysis_configs_company_id_foreign |
|
|
Restrict delete | ||
| store_customer_event_dates_store_customer_id_foreign |
|
|
Restrict delete | ||
| analysis_log_per_customers_store_customer_id_foreign |
|
|
Restrict delete | ||
| visit_reservation_inquiry_rentals_inquiry_rental_id_foreign |
|
|
Restrict delete | ||
| visit_reservation_inquiry_rentals_visit_reservation_id_foreign |
|
|
Restrict delete | ||
| company_estimation_templates_company_id_foreign |
|
|
Restrict delete | ||
| inquiry_definition_sorting_rules_inquiry_definition_id_foreign |
|
|
Restrict delete | ||
| auto_suggestions_store_customer_id_foreign |
|
|
Restrict delete | ||
| aggregation_releases_released_customer_id_foreign |
|
|
Restrict delete | ||
| aggregation_releases_customer_id_foreign |
|
|
Restrict delete | ||
| web_meeting_durations_web_meeting_id_foreign |
|
|
Restrict delete | ||
| messages_staff_id_foreign |
|
|
Restrict delete | ||
| messages_bulk_message_id_foreign |
|
|
Null on delete | ||
| messages_store_customer_id_foreign |
|
|
Restrict delete | ||
| temporary_obic_customer_supplement_code_foreign |
|
|
Restrict delete | ||
| company_addition_item_options_company_addition_item_id_foreign |
|
|
Cascade on delete | ||
| estimation_action_logs_staff_id_foreign |
|
|
Restrict delete | ||
| estimation_action_logs_estimation_id_foreign |
|
|
Restrict delete | ||
| temporary_obic_customer_choice_school_code_foreign |
|
|
Restrict delete | ||
| activity_logs_store_id_foreign |
|
|
Restrict delete | ||
| relationship_candidates_customer_id2_foreign |
|
|
Restrict delete | ||
| relationship_candidates_customer_id1_foreign |
|
|
Restrict delete | ||
| role_permissions_access_control_target_code_foreign |
|
|
Restrict delete | ||
| role_permissions_role_id_foreign |
|
|
Restrict delete | ||
| telescope_entries_tags_entry_uuid_foreign |
|
|
Cascade on delete | ||
| virtual_bank_account_counters_virtual_bank_account_id_foreign |
|
|
Restrict delete | ||
| bulk_messages_store_id_foreign |
|
|
Restrict delete | ||
| bulk_messages_staff_id_foreign |
|
|
Restrict delete | ||
| arrow_ip_addresses_company_id_foreign |
|
|
Cascade on delete | ||
| store_customers_customer_id_foreign |
|
|
Restrict delete | ||
| store_customers_application_staff_id_foreign |
|
|
Restrict delete | ||
| store_customers_viewing_staff_id_foreign |
|
|
Restrict delete | ||
| store_customers_main_staff_id_foreign |
|
|
Restrict delete | ||
| store_customers_store_id_foreign |
|
|
Restrict delete | ||
| store_customers_contract_staff_id_foreign |
|
|
Restrict delete | ||
| store_customers_customer_status_id_foreign |
|
|
Restrict delete | ||
| store_customers_inquiry_staff_id_foreign |
|
|
Restrict delete | ||
| store_customers_visit_staff_id_foreign |
|
|
Restrict delete | ||
| access_count_urls_customer_id_foreign |
|
|
Restrict delete | ||
| search_histories_staff_id_foreign |
|
|
Restrict delete | ||
| bulk_operation_customer_lists_staff_id_foreign |
|
|
Restrict delete | ||
| bulk_operation_customer_lists_customer_id_foreign |
|
|
Restrict delete | ||
| inquiry_rentals_inquiry_id_foreign |
|
|
Cascade on delete | ||
| store_suggestion_settings_store_id_foreign |
|
|
Restrict delete | ||
| analysis_recounts_store_id_foreign |
|
|
Restrict delete | ||
| reserve_messages_message_id_foreign |
|
|
Restrict delete | ||
| nested_groups_company_id_foreign |
|
|
Restrict delete | ||
| nested_groups_parent_nested_group_id_foreign |
|
|
Restrict delete | ||
| suggestion_rental_details_suggestion_id_foreign |
|
|
Restrict delete | ||
| estimations_approver_id_foreign |
|
|
Restrict delete | ||
| estimations_store_id_foreign |
|
|
Restrict delete | ||
| estimations_template_code_foreign |
|
|
Restrict delete | ||
| estimations_author_id_foreign |
|
|
Restrict delete | ||
| estimations_contractor_id_foreign |
|
|
Restrict delete | ||
| company_addition_items_company_id_foreign |
|
|
Cascade on delete | ||
| suggestions_message_id_foreign |
|
|
Restrict delete | ||
| suggestions_access_count_url_id_foreign |
|
|
Restrict delete | ||
| suggestions_store_customer_id_foreign |
|
|
Restrict delete | ||
| suggestions_staff_id_foreign |
|
|
Restrict delete | ||
| inquiry_definition_items_inquiry_definition_id_foreign |
|
|
Restrict delete | ||
| inquiries_store_customer_id_foreign |
|
|
Restrict delete | ||
| inquiries_advertising_media_id_foreign |
|
|
Restrict delete | ||
| virtual_bank_accounts_company_id_foreign |
|
|
Restrict delete | ||
| company_settings_company_id_foreign |
|
|
Restrict delete | ||
| store_settings_store_id_foreign |
|
|
Restrict delete | ||
| favorite_rentals_store_customer_id_foreign |
|
|
Restrict delete | ||
| inquiry_forwarding_emails_store_id_foreign |
|
|
Restrict delete | ||
| company_questionnaire_configs_company_id_foreign |
|
|
Restrict delete | ||
| bulk_operation_histories_staff_id_foreign |
|
|
Restrict delete | ||
| line_channels_store_id_foreign |
|
|
Cascade on delete | ||
| task_settings_store_customer_id_foreign |
|
|
Restrict delete | ||
| staff_notification_settings_staff_id_foreign |
|
|
Restrict delete | ||
| advertising_media_company_id_foreign |
|
|
Restrict delete | ||
| tasks_store_customer_id_foreign |
|
|
Restrict delete | ||
| tasks_staff_id_foreign |
|
|
Restrict delete | ||
| access_count_logs_staff_id_foreign |
|
|
Restrict delete | ||
| access_count_logs_customer_id_foreign |
|
|
Restrict delete | ||
| access_count_logs_store_id_foreign |
|
|
Restrict delete | ||
| access_count_logs_access_count_url_id_foreign |
|
|
Restrict delete | ||
| stores_company_id_foreign |
|
|
Restrict delete | ||
| stores_nested_group_id_foreign |
|
|
Restrict delete | ||
| message_templates_store_id_foreign |
|
|
Restrict delete | ||
| message_templates_message_template_folder_id_foreign |
|
|
Restrict delete | ||
| aggregations_customer_id_foreign |
|
|
Restrict delete | ||
| aggregations_delete_customer_id_foreign |
|
|
Restrict delete | ||
| staff_operable_nested_groups_nested_group_id_foreign |
|
|
Restrict delete | ||
| staff_operable_nested_groups_staff_id_foreign |
|
|
Restrict delete | ||
| analysis_log_per_rentals_store_customer_id_foreign |
|
|
Restrict delete | ||
| staff_device_tokens_staff_id_foreign |
|
|
Restrict delete | ||
| web_meetings_store_customer_id_foreign |
|
|
Restrict delete | ||
| web_meetings_staff_id_foreign |
|
|
Restrict delete | ||
| staff_settings_staff_id_foreign |
|
|
Restrict delete | ||
| analysis_summaries_company_analysis_config_id_foreign |
|
|
Restrict delete | ||
| analysis_summaries_store_id_foreign |
|
|
Restrict delete | ||
| bulk_operation_history_customer_customer_id_foreign |
|
|
Restrict delete | ||
| bh_bhc_foreign |
|
|
Restrict delete | ||
| staffs_role_id_foreign |
|
|
Restrict delete | ||
| staffs_store_id_foreign |
|
|
Restrict delete | ||
| relationships_customer_id_foreign |
|
|
Restrict delete | ||
| relationships_related_customer_id_foreign |
|
|
Restrict delete | ||
| inquiry_definitions_advertising_medium_id_foreign |
|
|
Restrict delete | ||
| inquiry_definitions_company_id_foreign |
|
|
Restrict delete | ||
| estimation_jsb_costs_estimation_id_foreign |
|
|
Restrict delete | ||
| estimation_approvals_estimation_id_foreign |
|
|
Restrict delete | ||
| estimation_approvals_staff_id_foreign |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|