Constraints

200 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
application_oauth_scopes_fk_1
application_oauth_scopes.applications_id
applications.id
Restrict delete
entity_types_fk_1
entity_types.access_token_signing_keys_id
keys.id
Restrict delete
groups_fk_1
groups.tenants_id
tenants.id
Restrict delete
user_action_logs_applications_fk_1
user_action_logs_applications.applications_id
applications.id
Cascade on delete
user_action_logs_applications_fk_2
user_action_logs_applications.user_action_logs_id
user_action_logs.id
Cascade on delete
application_daily_active_users_fk_1
application_daily_active_users.applications_id
applications.id
Restrict delete
previous_passwords_fk_1
previous_passwords.users_id
users.id
Restrict delete
entity_type_permissions_fk_1
entity_type_permissions.entity_types_id
entity_types.id
Cascade on delete
user_comments_fk_1
user_comments.users_id
users.id
Restrict delete
user_comments_fk_2
user_comments.commenter_id
users.id
Restrict delete
entity_entity_grant_permissions_fk_2
entity_entity_grant_permissions.entity_type_permissions_id
entity_type_permissions.id
Cascade on delete
entity_entity_grant_permissions_fk_1
entity_entity_grant_permissions.entity_entity_grants_id
entity_entity_grants.id
Cascade on delete
identity_provider_links_fk_3
identity_provider_links.users_id
users.id
Restrict delete
identity_provider_links_fk_2
identity_provider_links.tenants_id
tenants.id
Restrict delete
identity_provider_links_fk_1
identity_provider_links.identity_providers_id
identity_providers.id
Restrict delete
user_action_logs_fk_1
user_action_logs.actioner_users_id
users.id
Restrict delete
user_action_logs_fk_2
user_action_logs.actionee_users_id
users.id
Restrict delete
user_action_logs_fk_3
user_action_logs.user_actions_id
user_actions.id
Restrict delete
webhooks_fk_2
webhooks.signing_keys_id
keys.id
Restrict delete
webhooks_fk_1
webhooks.ssl_certificate_keys_id
keys.id
Restrict delete
user_registrations_application_roles_fk_1
user_registrations_application_roles.user_registrations_id
user_registrations.id
Restrict delete
user_registrations_application_roles_fk_2
user_registrations_application_roles.application_roles_id
application_roles.id
Restrict delete
identity_providers_tenants_fk_1
identity_providers_tenants.tenants_id
tenants.id
Restrict delete
identity_providers_tenants_fk_2
identity_providers_tenants.identity_providers_id
identity_providers.id
Restrict delete
families_fk_1
families.users_id
users.id
Restrict delete
group_application_roles_fk_1
group_application_roles.groups_id
groups.id
Restrict delete
group_application_roles_fk_2
group_application_roles.application_roles_id
application_roles.id
Restrict delete
group_members_fk_2
group_members.groups_id
groups.id
Restrict delete
group_members_fk_1
group_members.users_id
users.id
Restrict delete
entities_fk_3
entities.tenants_id
tenants.id
Cascade on delete
entities_fk_2
entities.parent_id
entities.id
Cascade on delete
entities_fk_1
entities.entity_types_id
entity_types.id
Cascade on delete
webhooks_tenants_fk_1
webhooks_tenants.webhooks_id
webhooks.id
Restrict delete
webhooks_tenants_fk_2
webhooks_tenants.tenants_id
tenants.id
Restrict delete
user_actions_fk_4
user_actions.start_email_templates_id
email_templates.id
Restrict delete
user_actions_fk_2
user_actions.end_email_templates_id
email_templates.id
Restrict delete
user_actions_fk_3
user_actions.modify_email_templates_id
email_templates.id
Restrict delete
user_actions_fk_1
user_actions.cancel_email_templates_id
email_templates.id
Restrict delete
breached_password_metrics_fk_1
breached_password_metrics.tenants_id
tenants.id
Restrict delete
entity_user_grants_fk_1
entity_user_grants.entities_id
entities.id
Cascade on delete
entity_user_grants_fk_2
entity_user_grants.users_id
users.id
Cascade on delete
identities_fk_1
identities.tenants_id
tenants.id
Restrict delete
identities_fk_2
identities.users_id
users.id
Restrict delete
form_steps_fk_2
form_steps.form_fields_id
form_fields.id
Restrict delete
form_steps_fk_1
form_steps.forms_id
forms.id
Restrict delete
user_consents_email_plus_fk_1
user_consents_email_plus.user_consents_id
user_consents.id
Restrict delete
instance_fk_1
instance.tenant_manager_applications_id
applications.id
Restrict delete
scim_external_id_groups_fk_1
scim_external_id_groups.entities_id
entities.id
Restrict delete
scim_external_id_groups_fk_2
scim_external_id_groups.groups_id
groups.id
Restrict delete
external_identifiers_fk_1
external_identifiers.users_id
users.id
Restrict delete
external_identifiers_fk_2
external_identifiers.applications_id
applications.id
Restrict delete
external_identifiers_fk_3
external_identifiers.tenants_id
tenants.id
Restrict delete
users_fk_1
users.tenants_id
tenants.id
Restrict delete
connectors_tenants_fk_1
connectors_tenants.connectors_id
connectors.id
Restrict delete
connectors_tenants_fk_2
connectors_tenants.tenants_id
tenants.id
Restrict delete
identity_providers_applications_fk_1
identity_providers_applications.applications_id
applications.id
Restrict delete
identity_providers_applications_fk_2
identity_providers_applications.identity_providers_id
identity_providers.id
Restrict delete
identity_providers_applications_fk_3
identity_providers_applications.keys_id
keys.id
Restrict delete
raw_logins_fk_2
raw_logins.users_id
users.id
Restrict delete
raw_logins_fk_1
raw_logins.applications_id
applications.id
Restrict delete
identity_providers_fk_4
identity_providers.tenants_id
tenants.id
Restrict delete
identity_providers_fk_2
identity_providers.reconcile_lambdas_id
lambdas.id
Restrict delete
identity_providers_fk_3
identity_providers.request_signing_keys_id
keys.id
Restrict delete
identity_providers_fk_1
identity_providers.keys_id
keys.id
Restrict delete
webauthn_credentials_fk_2
webauthn_credentials.users_id
users.id
Restrict delete
webauthn_credentials_fk_1
webauthn_credentials.tenants_id
tenants.id
Restrict delete
entity_user_grant_permissions_fk_2
entity_user_grant_permissions.entity_type_permissions_id
entity_type_permissions.id
Cascade on delete
entity_user_grant_permissions_fk_1
entity_user_grant_permissions.entity_user_grants_id
entity_user_grants.id
Cascade on delete
applications_fk_30
applications.login_id_in_use_on_update_email_templates_id
email_templates.id
Restrict delete
applications_fk_33
applications.two_factor_method_remove_email_templates_id
email_templates.id
Restrict delete
applications_fk_34
applications.self_service_registration_validation_lambdas_id
lambdas.id
Restrict delete
applications_fk_31
applications.password_update_email_templates_id
email_templates.id
Restrict delete
applications_fk_32
applications.two_factor_method_add_email_templates_id
email_templates.id
Restrict delete
applications_fk_26
applications.password_reset_success_email_templates_id
email_templates.id
Restrict delete
applications_fk_7
applications.access_token_signing_keys_id
keys.id
Restrict delete
applications_fk_27
applications.ui_ip_access_control_lists_id
ip_access_control_lists.id
Restrict delete
applications_fk_6
applications.samlv2_populate_lambdas_id
lambdas.id
Restrict delete
applications_fk_24
applications.login_new_device_email_templates_id
email_templates.id
Restrict delete
applications_fk_9
applications.forms_id
forms.id
Restrict delete
applications_fk_25
applications.login_suspicious_email_templates_id
email_templates.id
Restrict delete
applications_fk_8
applications.id_token_signing_keys_id
keys.id
Restrict delete
applications_fk_28
applications.email_update_email_templates_id
email_templates.id
Restrict delete
applications_fk_29
applications.login_id_in_use_on_create_email_templates_id
email_templates.id
Restrict delete
applications_fk_1
applications.verification_email_templates_id
email_templates.id
Restrict delete
applications_fk_3
applications.access_token_populate_lambdas_id
lambdas.id
Restrict delete
applications_fk_2
applications.tenants_id
tenants.id
Restrict delete
applications_fk_5
applications.samlv2_keys_id
keys.id
Restrict delete
applications_fk_4
applications.id_token_populate_lambdas_id
lambdas.id
Restrict delete
applications_fk_22
applications.themes_id
themes.id
Restrict delete
applications_fk_23
applications.email_verified_email_templates_id
email_templates.id
Restrict delete
applications_fk_20
applications.multi_factor_sms_message_templates_id
message_templates.id
Restrict delete
applications_fk_21
applications.self_service_user_forms_id
forms.id
Restrict delete
applications_fk_15
applications.admin_registration_forms_id
forms.id
Restrict delete
applications_fk_16
applications.samlv2_logout_keys_id
keys.id
Restrict delete
applications_fk_13
applications.set_password_email_templates_id
email_templates.id
Restrict delete
applications_fk_14
applications.samlv2_default_verification_keys_id
keys.id
Restrict delete
applications_fk_19
applications.multi_factor_email_message_templates_id
email_templates.id
Restrict delete
applications_fk_17
applications.samlv2_logout_default_verification_keys_id
keys.id
Restrict delete
applications_fk_18
applications.samlv2_single_logout_keys_id
keys.id
Restrict delete
applications_fk_50
applications.multi_factor_requirement_lambdas_id
lambdas.id
Restrict delete
applications_fk_11
applications.forgot_password_email_templates_id
email_templates.id
Restrict delete
applications_fk_12
applications.passwordless_email_templates_id
email_templates.id
Restrict delete
applications_fk_10
applications.email_verification_email_templates_id
email_templates.id
Restrict delete
applications_fk_48
applications.phone_configuration_two_factor_method_add_templates_id
message_templates.id
Restrict delete
applications_fk_49
applications.phone_configuration_two_factor_method_remove_templates_id
message_templates.id
Restrict delete
applications_fk_46
applications.phone_configuration_password_reset_success_templates_id
message_templates.id
Restrict delete
applications_fk_47
applications.phone_configuration_password_update_templates_id
message_templates.id
Restrict delete
applications_fk_40
applications.phone_configuration_set_password_templates_id
message_templates.id
Restrict delete
applications_fk_41
applications.phone_configuration_identity_update_templates_id
message_templates.id
Restrict delete
applications_fk_44
applications.phone_configuration_login_new_device_templates_id
message_templates.id
Restrict delete
applications_fk_45
applications.phone_configuration_login_suspicious_templates_id
message_templates.id
Restrict delete
applications_fk_42
applications.phone_configuration_login_id_in_use_on_create_templates_id
message_templates.id
Restrict delete
applications_fk_43
applications.phone_configuration_login_id_in_use_on_update_templates_id
message_templates.id
Restrict delete
applications_fk_37
applications.phone_configuration_verification_templates_id
message_templates.id
Restrict delete
applications_fk_38
applications.phone_configuration_verification_complete_templates_id
message_templates.id
Restrict delete
applications_fk_35
applications.userinfo_populate_lambdas_id
lambdas.id
Restrict delete
applications_fk_36
applications.phone_configuration_passwordless_templates_id
message_templates.id
Restrict delete
applications_fk_39
applications.phone_configuration_forgot_password_templates_id
message_templates.id
Restrict delete
authentication_keys_fk_1
authentication_keys.tenants_id
tenants.id
Restrict delete
authentication_keys_fk_2
authentication_keys.ip_access_control_lists_id
ip_access_control_lists.id
Restrict delete
tenants_fk_8
tenants.failed_authentication_user_actions_id
user_actions.id
Restrict delete
tenants_fk_9
tenants.themes_id
themes.id
Restrict delete
tenants_fk_4
tenants.passwordless_email_templates_id
email_templates.id
Restrict delete
tenants_fk_29
tenants.scim_enterprise_user_request_converter_lambdas_id
lambdas.id
Restrict delete
tenants_fk_5
tenants.confirm_child_email_templates_id
email_templates.id
Restrict delete
tenants_fk_28
tenants.scim_client_entity_types_id
entity_types.id
Restrict delete
tenants_fk_6
tenants.family_request_email_templates_id
email_templates.id
Restrict delete
tenants_fk_27
tenants.ui_ip_access_control_lists_id
ip_access_control_lists.id
Restrict delete
tenants_fk_26
tenants.two_factor_method_remove_email_templates_id
email_templates.id
Restrict delete
tenants_fk_7
tenants.parent_registration_email_templates_id
email_templates.id
Restrict delete
tenants_fk_25
tenants.two_factor_method_add_email_templates_id
email_templates.id
Restrict delete
tenants_fk_24
tenants.password_update_email_templates_id
email_templates.id
Restrict delete
tenants_fk_23
tenants.password_reset_success_email_templates_id
email_templates.id
Restrict delete
tenants_fk_22
tenants.login_suspicious_email_templates_id
email_templates.id
Restrict delete
tenants_fk_21
tenants.login_new_device_email_templates_id
email_templates.id
Restrict delete
tenants_fk_20
tenants.login_id_in_use_on_update_email_templates_id
email_templates.id
Restrict delete
tenants_fk_1
tenants.forgot_password_email_templates_id
email_templates.id
Restrict delete
tenants_fk_2
tenants.set_password_email_templates_id
email_templates.id
Restrict delete
tenants_fk_3
tenants.verification_email_templates_id
email_templates.id
Restrict delete
tenants_fk_19
tenants.login_id_in_use_on_create_email_templates_id
email_templates.id
Restrict delete
tenants_fk_18
tenants.email_verified_email_templates_id
email_templates.id
Restrict delete
tenants_fk_17
tenants.email_update_email_templates_id
email_templates.id
Restrict delete
tenants_fk_16
tenants.client_credentials_access_token_populate_lambdas_id
lambdas.id
Restrict delete
tenants_fk_15
tenants.multi_factor_sms_messengers_id
messengers.id
Restrict delete
tenants_fk_14
tenants.multi_factor_sms_message_templates_id
message_templates.id
Restrict delete
tenants_fk_13
tenants.multi_factor_email_message_templates_id
email_templates.id
Restrict delete
tenants_fk_12
tenants.admin_user_forms_id
forms.id
Restrict delete
tenants_fk_11
tenants.id_token_signing_keys_id
keys.id
Restrict delete
tenants_fk_10
tenants.access_token_signing_keys_id
keys.id
Restrict delete
tenants_fk_52
tenants.multi_factor_requirement_lambdas_id
lambdas.id
Restrict delete
tenants_fk_51
tenants.phone_configuration_two_factor_method_remove_templates_id
message_templates.id
Restrict delete
tenants_fk_49
tenants.phone_configuration_password_update_templates_id
message_templates.id
Restrict delete
tenants_fk_48
tenants.phone_configuration_password_reset_success_templates_id
message_templates.id
Restrict delete
tenants_fk_47
tenants.phone_configuration_login_suspicious_templates_id
message_templates.id
Restrict delete
tenants_fk_46
tenants.phone_configuration_login_new_device_templates_id
message_templates.id
Restrict delete
tenants_fk_45
tenants.phone_configuration_login_id_in_use_on_update_templates_id
message_templates.id
Restrict delete
tenants_fk_44
tenants.phone_configuration_login_id_in_use_on_create_templates_id
message_templates.id
Restrict delete
tenants_fk_43
tenants.phone_configuration_identity_update_templates_id
message_templates.id
Restrict delete
tenants_fk_42
tenants.phone_configuration_set_password_templates_id
message_templates.id
Restrict delete
tenants_fk_41
tenants.phone_configuration_forgot_password_templates_id
message_templates.id
Restrict delete
tenants_fk_40
tenants.phone_configuration_verification_complete_templates_id
message_templates.id
Restrict delete
tenants_fk_50
tenants.phone_configuration_two_factor_method_add_templates_id
message_templates.id
Restrict delete
tenants_fk_39
tenants.phone_configuration_verification_templates_id
message_templates.id
Restrict delete
tenants_fk_38
tenants.phone_configuration_passwordless_templates_id
message_templates.id
Restrict delete
tenants_fk_37
tenants.phone_configuration_messengers_id
messengers.id
Restrict delete
tenants_fk_36
tenants.login_validation_lambdas_id
lambdas.id
Restrict delete
tenants_fk_35
tenants.scim_user_response_converter_lambdas_id
lambdas.id
Restrict delete
tenants_fk_34
tenants.scim_user_request_converter_lambdas_id
lambdas.id
Restrict delete
tenants_fk_33
tenants.scim_server_entity_types_id
entity_types.id
Restrict delete
tenants_fk_32
tenants.scim_group_response_converter_lambdas_id
lambdas.id
Restrict delete
tenants_fk_31
tenants.scim_group_request_converter_lambdas_id
lambdas.id
Restrict delete
tenants_fk_30
tenants.scim_enterprise_user_response_converter_lambdas_id
lambdas.id
Restrict delete
refresh_tokens_fk_2
refresh_tokens.applications_id
applications.id
Restrict delete
refresh_tokens_fk_1
refresh_tokens.users_id
users.id
Restrict delete
refresh_tokens_fk_3
refresh_tokens.tenants_id
tenants.id
Restrict delete
webhook_attempt_logs_fk_1
webhook_attempt_logs.webhook_event_logs_id
webhook_event_logs.id
Restrict delete
webhook_attempt_logs_fk_2
webhook_attempt_logs.webhooks_id
webhooks.id
Restrict delete
consents_fk_1
consents.consent_email_templates_id
email_templates.id
Restrict delete
consents_fk_2
consents.email_plus_email_templates_id
email_templates.id
Restrict delete
application_roles_fk_1
application_roles.applications_id
applications.id
Restrict delete
application_monthly_active_users_fk_1
application_monthly_active_users.applications_id
applications.id
Restrict delete
user_registrations_fk_1
user_registrations.applications_id
applications.id
Restrict delete
user_registrations_fk_2
user_registrations.users_id
users.id
Restrict delete
asynchronous_tasks_fk_1
asynchronous_tasks.nodes_id
nodes.id
Restrict delete
scim_external_id_users_fk_2
scim_external_id_users.users_id
users.id
Restrict delete
scim_external_id_users_fk_1
scim_external_id_users.entities_id
entities.id
Restrict delete
connectors_fk_2
connectors.reconcile_lambdas_id
lambdas.id
Restrict delete
connectors_fk_1
connectors.ssl_certificate_keys_id
keys.id
Restrict delete
clean_speak_applications_fk_1
clean_speak_applications.applications_id
applications.id
Restrict delete
hourly_logins_fk_1
hourly_logins.applications_id
applications.id
Restrict delete
request_frequencies_fk_1
request_frequencies.tenants_id
tenants.id
Restrict delete
form_fields_fk_1
form_fields.consents_id
consents.id
Restrict delete
entity_entity_grants_fk_1
entity_entity_grants.recipient_id
entities.id
Cascade on delete
entity_entity_grants_fk_2
entity_entity_grants.target_id
entities.id
Cascade on delete
application_registration_counts_fk_1
application_registration_counts.applications_id
applications.id
Restrict delete
user_consents_fk_3
user_consents.users_id
users.id
Restrict delete
user_consents_fk_2
user_consents.giver_users_id
users.id
Restrict delete
user_consents_fk_1
user_consents.consents_id
consents.id
Restrict delete
federated_domains_fk_2
federated_domains.tenants_id
tenants.id
Restrict delete
federated_domains_fk_1
federated_domains.identity_providers_id
identity_providers.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
authentication_keys authentication_keys_chk_1 (((key_format <> 1) OR (name IS NOT NULL)))