185 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| fk_workspace_transform_creator_id |
|
|
Null on delete | ||||||
| fk_workspace_transform_collection_id |
|
|
Null on delete | ||||||
| fk_workspace_transform_workspace_id |
|
|
Cascade on delete | ||||||
| fk_workspace_transform_global_id |
|
|
Null on delete | ||||||
| fk_document_bookmark_document_id |
|
|
Cascade on delete | ||||||
| fk_document_bookmark_user_id |
|
|
Cascade on delete | ||||||
| fk_field_usage_field_id_metabase_field_id |
|
|
Cascade on delete | ||||||
| fk_field_usage_query_execution_id |
|
|
Cascade on delete | ||||||
| fk_collection_bookmark_collection_id |
|
|
Cascade on delete | ||||||
| fk_collection_bookmark_user_id |
|
|
Cascade on delete | ||||||
| fk_transform_transform_tag_tag_id |
|
|
Cascade on delete | ||||||
| fk_transform_transform_tag_transform_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_favorite_user_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_favorite_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_model_index_creator_id |
|
|
Cascade on delete | ||||||
| fk_model_index_model_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_tab_ref_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_snippet_creator_id |
|
|
Cascade on delete | ||||||
| fk_snippet_collection_id |
|
|
Null on delete | ||||||
| fk_metabot_message_conversation_id |
|
|
Restrict delete | ||||||
| fk_workspace_output_ref_id |
|
|
Cascade on delete | ||||||
| fk_workspace_output_workspace_id |
|
|
Cascade on delete | ||||||
| fk_notification_subscription_notification_id |
|
|
Cascade on delete | ||||||
| fk_document_made_public_by_id |
|
|
Cascade on delete | ||||||
| fk_document_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_document_ref_collection_id |
|
|
Null on delete | ||||||
| fk_data_permissions_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_data_permissions_ref_db_id |
|
|
Cascade on delete | ||||||
| fk_data_permissions_ref_permissions_group |
|
|
Cascade on delete | ||||||
| fk_notification_recipient_notification_handler_id |
|
|
Cascade on delete | ||||||
| fk_notification_recipient_user_id |
|
|
Cascade on delete | ||||||
| fk_notification_recipient_permissions_group_id |
|
|
Cascade on delete | ||||||
| fk_metabase_table_transform_id |
|
|
Null on delete | ||||||
| fk_metabase_table_collection_id |
|
|
Restrict delete | ||||||
| fk_table_ref_database_id |
|
|
Cascade on delete | ||||||
| fk_workspace_merge_transform_workspace_id |
|
|
Null on delete | ||||||
| fk_workspace_merge_transform_workspace_merge_id |
|
|
Cascade on delete | ||||||
| fk_workspace_merge_transform_transform_id |
|
|
Cascade on delete | ||||||
| fk_workspace_merge_transform_merging_user_id |
|
|
Restrict delete | ||||||
| fk_comment_reaction_comment_id |
|
|
Cascade on delete | ||||||
| fk_comment_reaction_user_id |
|
|
Cascade on delete | ||||||
| fk_permissions_group_membership_user_id |
|
|
Cascade on delete | ||||||
| fk_permissions_group_group_id |
|
|
Cascade on delete | ||||||
| fk_core_user_tenant_id |
|
|
Restrict delete | ||||||
| fk_implicit_action_action_id |
|
|
Cascade on delete | ||||||
| fk_metabot_prompt_metabot_id |
|
|
Cascade on delete | ||||||
| fk_metabot_prompt_card_id |
|
|
Cascade on delete | ||||||
| fk_db_router_database_id |
|
|
Restrict delete | ||||||
| fk_workspace_log_workspace_id |
|
|
Cascade on delete | ||||||
| fk_workspace_merge_workspace_id |
|
|
Null on delete | ||||||
| fk_workspace_merge_creator_id |
|
|
Restrict delete | ||||||
| fk_recent_views_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_card_bookmark_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_card_bookmark_user_id |
|
|
Cascade on delete | ||||||
| fk_secret_ref_user_id |
|
|
Restrict delete | ||||||
| fk_persisted_info_ref_creator_id |
|
|
Restrict delete | ||||||
| fk_persisted_info_card_id |
|
|
Null on delete | ||||||
| fk_persisted_info_database_id |
|
|
Cascade on delete | ||||||
| fk_transform_run_cancelation_transform_run_run_id |
|
|
Cascade on delete | ||||||
| fk_workspace_graph_workspace_id |
|
|
Cascade on delete | ||||||
| fk_qrtz_triggers_job_details |
|
|
Restrict delete | ||||||
| fk_glossary_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_parameter_card_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_comment_creator_id |
|
|
Cascade on delete | ||||||
| fk_comment_parent_comment_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_bookmark_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_bookmark_user_id |
|
|
Cascade on delete | ||||||
| fk_api_key_updated_by_id_user_id |
|
|
Restrict delete | ||||||
| fk_api_key_user_id |
|
|
Restrict delete | ||||||
| fk_api_key_created_by_user_id |
|
|
Restrict delete | ||||||
| fk_pulse_card_ref_pulse_card_id |
|
|
Cascade on delete | ||||||
| fk_pulse_card_ref_pulse_id |
|
|
Cascade on delete | ||||||
| fk_pulse_card_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_made_public_by_id |
|
|
Cascade on delete | ||||||
| fk_dashboard_collection_id |
|
|
Null on delete | ||||||
| fk_dashboard_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_report_dashboardcard_ref_action_id |
|
|
Cascade on delete | ||||||
| fk_dashboardcard_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_dashboardcard_ref_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_report_dashboardcard_ref_dashboard_tab_id |
|
|
Cascade on delete | ||||||
| fk_workspace_input_external_workspace_id |
|
|
Cascade on delete | ||||||
| fk_query_table_table_id |
|
|
Cascade on delete | ||||||
| fk_query_table_card_id |
|
|
Cascade on delete | ||||||
| fk_session_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_session_auth_identity |
|
|
Cascade on delete | ||||||
| fk_segment_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_segment_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_fieldvalues_ref_field_id |
|
|
Cascade on delete | ||||||
| fk_pulse_channel_channel_id |
|
|
Cascade on delete | ||||||
| fk_pulse_channel_ref_pulse_id |
|
|
Cascade on delete | ||||||
| fk_card_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_card_made_public_by_id |
|
|
Cascade on delete | ||||||
| fk_report_card_source_card_id_ref_report_card_id |
|
|
Null on delete | ||||||
| fk_card_collection_id |
|
|
Null on delete | ||||||
| fk_report_card_ref_database_id |
|
|
Cascade on delete | ||||||
| fk_report_card_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_report_card_document_id |
|
|
Cascade on delete | ||||||
| fk_report_card_ref_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_conn_impersonation_group_id |
|
|
Cascade on delete | ||||||
| fk_conn_impersonation_db_id |
|
|
Cascade on delete | ||||||
| fk_field_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_field_parent_ref_field_id |
|
|
Restrict delete | ||||||
| fk_task_history_run_id |
|
|
Null on delete | ||||||
| fk_notification_creator_id |
|
|
Cascade on delete | ||||||
| fk_permissions_revision_user_id |
|
|
Cascade on delete | ||||||
| fk_remote_sync_task_initiated_by |
|
|
Null on delete | ||||||
| fk_notification_handler_notification_id |
|
|
Cascade on delete | ||||||
| fk_notification_handler_channel_id |
|
|
Cascade on delete | ||||||
| fk_notification_handler_template_id |
|
|
Null on delete | ||||||
| fk_database_creator_id |
|
|
Null on delete | ||||||
| fk_metabase_database_metabase_database_id |
|
|
Restrict delete | ||||||
| fk_collection_personal_owner_id |
|
|
Cascade on delete | ||||||
| fk_collection_workspace_id |
|
|
Cascade on delete | ||||||
| fk_permissions_ref_collection_id |
|
|
Cascade on delete | ||||||
| fk_permissions_group_id |
|
|
Cascade on delete | ||||||
| fk_transform_run_user_id |
|
|
Null on delete | ||||||
| fk_transform_run_transform_id |
|
|
Null on delete | ||||||
| fk_measure_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_measure_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_view_log_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_support_access_grant_log_revoked_by_user_id |
|
|
Null on delete | ||||||
| fk_support_access_grant_log_user_id |
|
|
Null on delete | ||||||
| fk_auth_identity_core_user_id |
|
|
Cascade on delete | ||||||
| fk_qrtz_simprop_triggers_triggers |
|
|
Restrict delete | ||||||
| fk_field_user_setting_field_id |
|
|
Cascade on delete | ||||||
| fk_dimension_displayfk_ref_field_id |
|
|
Cascade on delete | ||||||
| fk_dimension_ref_field_id |
|
|
Cascade on delete | ||||||
| fk_security_advisory_acknowledged_by |
|
|
Null on delete | ||||||
| fk_metric_important_field_metabase_field_id |
|
|
Cascade on delete | ||||||
| fk_metric_important_field_metric_id |
|
|
Cascade on delete | ||||||
| fk_transform_owner_user_id |
|
|
Null on delete | ||||||
| fk_tranform_source_database_id |
|
|
Restrict delete | ||||||
| fk_transform_collection_id |
|
|
Restrict delete | ||||||
| fk_transform_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_transform_target_db_id |
|
|
Null on delete | ||||||
| fk_workspace_output_external_workspace_id |
|
|
Cascade on delete | ||||||
| fk_workspace_output_external_transform_id |
|
|
Cascade on delete | ||||||
| fk_user_parameter_value_user_id |
|
|
Cascade on delete | ||||||
| fk_user_parameter_value_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_timeline_collection_id |
|
|
Cascade on delete | ||||||
| fk_timeline_creator_id |
|
|
Cascade on delete | ||||||
| fk_user_key_value_user_id |
|
|
Restrict delete | ||||||
| fk_workspace_input_table_id |
|
|
Null on delete | ||||||
| fk_workspace_input_workspace_id |
|
|
Cascade on delete | ||||||
| fk_table_privileges_table_id |
|
|
Cascade on delete | ||||||
| fk_metabot_conversation_user_id |
|
|
Restrict delete | ||||||
| fk_card_label_ref_label_id |
|
|
Cascade on delete | ||||||
| fk_card_label_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_http_action_ref_action_id |
|
|
Cascade on delete | ||||||
| fk_events_timeline_id |
|
|
Cascade on delete | ||||||
| fk_event_creator_id |
|
|
Cascade on delete | ||||||
| fk_model_index_value_model_id |
|
|
Cascade on delete | ||||||
| fk_revision_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_gtap_card_id |
|
|
Cascade on delete | ||||||
| fk_gtap_group_id |
|
|
Cascade on delete | ||||||
| fk_gtap_table_id |
|
|
Cascade on delete | ||||||
| fk_qrtz_blob_triggers_triggers |
|
|
Restrict delete | ||||||
| fk_transform_job_transform_tag_tag_id |
|
|
Cascade on delete | ||||||
| fk_transform_job_transform_tag_job_id |
|
|
Cascade on delete | ||||||
| fk_notification_card_card_id |
|
|
Cascade on delete | ||||||
| fk_dashboardcard_series_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_dashboardcard_series_ref_dashboardcard_id |
|
|
Cascade on delete | ||||||
| fk_qrtz_cron_triggers_triggers |
|
|
Restrict delete | ||||||
| fk_bookmark_ordering_user_id |
|
|
Cascade on delete | ||||||
| fk_pulse_channel_recipient_ref_pulse_channel_id |
|
|
Cascade on delete | ||||||
| fk_pulse_channel_recipient_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_cardfavorite_ref_user_id |
|
|
Cascade on delete | ||||||
| fk_cardfavorite_ref_card_id |
|
|
Cascade on delete | ||||||
| fk_metric_ref_table_id |
|
|
Cascade on delete | ||||||
| fk_metric_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_general_permissions_revision_user_id |
|
|
Restrict delete | ||||||
| fk_qrtz_simple_triggers_triggers |
|
|
Restrict delete | ||||||
| fk_action_creator_id |
|
|
Restrict delete | ||||||
| fk_action_made_public_by_id |
|
|
Cascade on delete | ||||||
| fk_action_model_id |
|
|
Cascade on delete | ||||||
| fk_login_history_user_id |
|
|
Cascade on delete | ||||||
| fk_login_history_session_id |
|
|
Null on delete | ||||||
| fk_collection_revision_user_id |
|
|
Cascade on delete | ||||||
| fk_pulse_ref_dashboard_id |
|
|
Cascade on delete | ||||||
| fk_pulse_ref_creator_id |
|
|
Cascade on delete | ||||||
| fk_pulse_collection_id |
|
|
Null on delete | ||||||
| fk_query_field_field_id |
|
|
Cascade on delete | ||||||
| fk_query_field_card_id |
|
|
Cascade on delete | ||||||
| fk_query_action_database_id |
|
|
Cascade on delete | ||||||
| fk_query_action_ref_action_id |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| permissions_group | permissions_group_id_not_null1 | id IS NOT NULL |