Constraints

189 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
smb_apsProvisionEnvironments_ibfk_1
smb_apsProvisionEnvironments.provisionId
smb_apsProvisions.id
Restrict delete
smb_apsInstanceErrors_ibfk_1
smb_apsInstanceErrors.instanceId
smb_apsInstances.id
Restrict delete
smb_apsResourceParameters_ibfk_1
smb_apsResourceParameters.resourceId
smb_apsResources.id
Restrict delete
GL_remote_domains_ibfk_1
GL_remote_domains.serviceNodeId
ServiceNodes.id
Restrict delete
smb_apsPackageUpdates_ibfk_1
smb_apsPackageUpdates.packageId
smb_apsPackages.id
Restrict delete
WebApps_ibfk_1
WebApps.domain_service_id
DomainServices.id
Restrict delete
domain_aliases_ibfk_1
domain_aliases.dom_id
domains.id
Restrict delete
domain_aliases_ibfk_2
domain_aliases.dns_zone_id
dns_zone.id
Restrict delete
spamfilter_preferences_ibfk_1
spamfilter_preferences.spamfilter_id
spamfilter.id
Restrict delete
mail_resp_ibfk_1
mail_resp.mn_id
mail.id
Restrict delete
web_users_ibfk_1
web_users.dom_id
domains.id
Restrict delete
web_users_ibfk_2
web_users.sys_user_id
sys_users.id
Restrict delete
admin_aliases_ibfk_1
admin_aliases.account_id
accounts.id
Restrict delete
DatabaseUserRemoteAccessRules_ibfk_2
DatabaseUserRemoteAccessRules.firewallRuleId
Restrict delete
DatabaseUserRemoteAccessRules_ibfk_1
DatabaseUserRemoteAccessRules.databaseUserId
db_users.id
Restrict delete
PlanServiceInstallations_ibfk_2
PlanServiceInstallations.serviceInstallationId
ServiceInstallations.id
Restrict delete
PlanServiceInstallations_ibfk_1
PlanServiceInstallations.planId
Templates.id
Restrict delete
smb_servicePermissionAccounts_ibfk_1
smb_servicePermissionAccounts.userId
smb_users.id
Restrict delete
smb_servicePermissionAccounts_ibfk_2
smb_servicePermissionAccounts.servicePermissionId
smb_servicePermissions.id
Restrict delete
DomainOutgoingMessagesPeaks_ibfk_1
DomainOutgoingMessagesPeaks.domainId
domains.id
Restrict delete
spamfilter_ibfk_1
spamfilter.serviceNodeId
ServiceNodes.id
Restrict delete
DomainsTraffic_ibfk_1
DomainsTraffic.dom_id
domains.id
Restrict delete
smb_roleServicePermissions_ibfk_2
smb_roleServicePermissions.servicePermissionId
smb_servicePermissions.id
Restrict delete
smb_roleServicePermissions_ibfk_1
smb_roleServicePermissions.roleId
smb_roles.id
Restrict delete
ServiceNodeEnvironment_ibfk_1
ServiceNodeEnvironment.serviceNodeId
ServiceNodes.id
Restrict delete
IisAppPoolsPolicy_ibfk_1
IisAppPoolsPolicy.serviceNodeId
ServiceNodes.id
Restrict delete
apsInstancesParameters_ibfk_1
apsInstancesParameters.instanceId
apsContextsApplications.id
Restrict delete
smtp_poplocks_ibfk_1
smtp_poplocks.serviceNodeId
ServiceNodes.id
Restrict delete
idkey
DatabaseCustomHosts.id
data_bases.id
Cascade on delete
ServiceInstanceProperties_ibfk_1
ServiceInstanceProperties.serviceInstanceId
ServiceInstances.id
Restrict delete
domains_ibfk_9
domains.permissions_id
Permissions.id
Restrict delete
domains_ibfk_3
domains.cert_rep_id
Repository.rep_id
Restrict delete
domains_ibfk_4
domains.limits_id
Limits.id
Restrict delete
domains_ibfk_1
domains.dns_zone_id
dns_zone.id
Restrict delete
domains_ibfk_2
domains.cl_id
clients.id
Restrict delete
domains_ibfk_7
domains.webspace_id
domains.id
Restrict delete
domains_ibfk_8
domains.parentDomainId
domains.id
Restrict delete
domains_ibfk_5
domains.params_id
Parameters.id
Restrict delete
domains_ibfk_6
domains.vendor_id
clients.id
Restrict delete
smb_userServicePermissions_ibfk_2
smb_userServicePermissions.servicePermissionId
smb_servicePermissions.id
Restrict delete
smb_userServicePermissions_ibfk_1
smb_userServicePermissions.userId
smb_users.id
Restrict delete
TraceFailedRequestsRules_ibfk_1
TraceFailedRequestsRules.domainId
domains.id
Restrict delete
smb_apsResources_ibfk_1
smb_apsResources.contextId
smb_apsContexts.id
Restrict delete
TraceFailedRequestsProviderAreas_ibfk_1
TraceFailedRequestsProviderAreas.providerId
TraceFailedRequestsProviders.id
Restrict delete
PlanItemProperties_ibfk_1
PlanItemProperties.plan_item_id
PlanItems.id
Restrict delete
serviceNodeId1
PackageUpdateNotifications.serviceNodeId
ServiceNodes.id
Cascade on delete
MailLists_ibfk_1
MailLists.dom_id
domains.id
Restrict delete
report_auto_ibfk_1
report_auto.report_id
report.id
Restrict delete
report_auto_ibfk_3
report_auto.domain
domains.id
Restrict delete
report_auto_ibfk_2
report_auto.client
clients.id
Restrict delete
smb_apsContexts_ibfk_1
smb_apsContexts.packageId
smb_apsPackages.id
Restrict delete
webalizer_hidden_referrer_ibfk_1
webalizer_hidden_referrer.dom_id
domains.id
Restrict delete
ServiceInstanceDepends_ibfk_1
ServiceInstanceDepends.serviceInstanceId
ServiceInstances.id
Restrict delete
ServiceInstanceDepends_ibfk_2
ServiceInstanceDepends.requiredInstanceId
ServiceInstances.id
Restrict delete
SessionContexts_ibfk_1
SessionContexts.sessionId
sessions.sess_id
Restrict delete
IisAppPoolDomains_ibfk_2
IisAppPoolDomains.poolId
IisAppPools.id
Restrict delete
IisAppPoolDomains_ibfk_1
IisAppPoolDomains.domainId
domains.id
Restrict delete
secret_keys_ibfk_1
secret_keys.client_id
clients.id
Restrict delete
apsContexts_ibfk_1
apsContexts.subscriptionId
Subscriptions.id
Restrict delete
suspend_handler_history_ibfk_1
suspend_handler_history.dom_id
domains.id
Restrict delete
DatabaseServers_ibfk_1
DatabaseServers.parameters_id
Parameters.id
Restrict delete
TmplData_ibfk_1
TmplData.tmpl_id
Templates.id
Restrict delete
SubscriptionOutgoingMessagesPeaks_ibfk_1
SubscriptionOutgoingMessagesPeaks.subscriptionId
Subscriptions.id
Restrict delete
log_components_ibfk_1
log_components.action_id
log_actions.id
Restrict delete
protected_dirs_ibfk_1
protected_dirs.dom_id
domains.id
Restrict delete
hotlink_friends_ibfk_1
hotlink_friends.dom_id
domains.id
Restrict delete
mail_aliases_ibfk_1
mail_aliases.mn_id
mail.id
Restrict delete
PlansSubscriptions_ibfk_1
PlansSubscriptions.subscription_id
Subscriptions.id
Restrict delete
PlansSubscriptions_ibfk_2
PlansSubscriptions.plan_id
Templates.id
Restrict delete
PhpSettings_ibfk_1
PhpSettings.noteId
Notes.id
Restrict delete
IpAddressesCollections_ibfk_1
IpAddressesCollections.ipCollectionId
IpCollections.id
Restrict delete
IpAddressesCollections_ibfk_2
IpAddressesCollections.ipAddressId
IP_Addresses.id
Restrict delete
smb_apsProvisions_ibfk_1
smb_apsProvisions.contextId
smb_apsContexts.id
Restrict delete
SBResellers_ibfk_1
SBResellers.client_id
clients.id
Restrict delete
anon_ftp_ibfk_1
anon_ftp.dom_id
domains.id
Restrict delete
sys_users_ibfk_1
sys_users.serviceNodeId
ServiceNodes.id
Restrict delete
sys_users_ibfk_2
sys_users.account_id
accounts.id
Restrict delete
smb_apsInstances_ibfk_2
smb_apsInstances.contextId
smb_apsContexts.id
Restrict delete
smb_apsInstances_ibfk_1
smb_apsInstances.parentContextId
smb_apsContexts.id
Restrict delete
smb_apsInstances_ibfk_3
smb_apsInstances.metaId
smb_apsMetas.id
Restrict delete
report_ibfk_1
report.user_id
clients.id
Restrict delete
IP_Addresses_ibfk_1
IP_Addresses.ssl_certificate_id
certificates.id
Restrict delete
IP_Addresses_ibfk_2
IP_Addresses.default_domain_id
domains.id
Restrict delete
IP_Addresses_ibfk_3
IP_Addresses.serviceNodeId
ServiceNodes.id
Restrict delete
GL_settings_ibfk_1
GL_settings.serviceNodeId
ServiceNodes.id
Restrict delete
MailOutgoingMessagesPeaks_ibfk_1
MailOutgoingMessagesPeaks.mailId
mail.id
Restrict delete
db_users_ibfk_1
db_users.account_id
accounts.id
Restrict delete
db_users_ibfk_2
db_users.db_id
data_bases.id
Restrict delete
db_users_ibfk_3
db_users.dom_id
domains.id
Restrict delete
db_users_ibfk_4
db_users.db_server_id
DatabaseServers.id
Restrict delete
smb_servicePermissions_ibfk_2
smb_servicePermissions.serviceProviderId
smb_serviceProviders.id
Restrict delete
smb_servicePermissions_ibfk_1
smb_servicePermissions.serviceInstanceId
smb_serviceInstances.id
Restrict delete
subdomains_ibfk_1
subdomains.sys_user_id
sys_users.id
Restrict delete
IisAppPools_ibfk_1
IisAppPools.serviceNodeId
ServiceNodes.id
Restrict delete
event_handlers_ibfk_1
event_handlers.action_id
actions.id
Restrict delete
mail_redir_ibfk_1
mail_redir.mn_id
mail.id
Restrict delete
DomainOutgoingMessagesStats_ibfk_1
DomainOutgoingMessagesStats.domainId
domains.id
Restrict delete
smb_roleGeneralPermissions_ibfk_1
smb_roleGeneralPermissions.roleId
smb_roles.id
Restrict delete
smb_roleGeneralPermissions_ibfk_2
smb_roleGeneralPermissions.generalPermissionId
smb_generalPermissions.id
Restrict delete
ServiceInstallations_ibfk_1
ServiceInstallations.serviceNodeId
ServiceNodes.id
Restrict delete
badmailfrom_ibfk_1
badmailfrom.serviceNodeId
ServiceNodes.id
Restrict delete
ModuleSettings_ibfk_1
ModuleSettings.module_id
Modules.id
Restrict delete
SubscriptionProperties_ibfk_1
SubscriptionProperties.subscription_id
Subscriptions.id
Restrict delete
smb_users_ibfk_3
smb_users.subscriptionDomainId
domains.id
Restrict delete
smb_users_ibfk_1
smb_users.roleId
smb_roles.id
Restrict delete
smb_users_ibfk_2
smb_users.ownerId
clients.id
Restrict delete
resp_attach_ibfk_1
resp_attach.rn_id
mail_resp.id
Restrict delete
Templates_ibfk_2
Templates.note_id
Notes.id
Restrict delete
Templates_ibfk_1
Templates.owner_id
clients.id
Restrict delete
disk_usage_ibfk_1
disk_usage.dom_id
domains.id
Restrict delete
webalizer_group_referrer_ibfk_1
webalizer_group_referrer.dom_id
domains.id
Restrict delete
dom_level_usrs_ibfk_1
dom_level_usrs.dom_id
domains.id
Restrict delete
ServiceNodeCertificates_ibfk_2
ServiceNodeCertificates.certificateId
certificates.id
Restrict delete
ServiceNodeCertificates_ibfk_1
ServiceNodeCertificates.serviceNodeId
ServiceNodes.id
Restrict delete
hosting_ibfk_2
hosting.sys_user_id
sys_users.id
Restrict delete
hosting_ibfk_3
hosting.certificate_id
certificates.id
Restrict delete
hosting_ibfk_1
hosting.dom_id
domains.id
Restrict delete
hotlink_prot_ibfk_1
hotlink_prot.dom_id
domains.id
Restrict delete
fileSharingUsers_ibfk_1
fileSharingUsers.userId
smb_users.id
Restrict delete
backupExcludeFilesId
BackupsScheduled.backupExcludeFilesId
BackupExcludeFiles.id
Cascade on delete
DomainServices_ibfk_2
DomainServices.parameters_id
Parameters.id
Restrict delete
DomainServices_ibfk_3
DomainServices.ipCollectionId
IpCollections.id
Restrict delete
DomainServices_ibfk_1
DomainServices.dom_id
domains.id
Restrict delete
Notifications_ibfk_1
Notifications.note_id
Notes.id
Restrict delete
smb_serviceInstances_ibfk_1
smb_serviceInstances.serviceProviderId
smb_serviceProviders.id
Restrict delete
admin_aliases_param_ibfk_1
admin_aliases_param.alias_id
admin_aliases.id
Restrict delete
log_actions_ibfk_1
log_actions.action_id
actions.id
Restrict delete
TraceFailedRequestsProviders_ibfk_1
TraceFailedRequestsProviders.ruleId
TraceFailedRequestsRules.id
Restrict delete
smb_apsMetas_ibfk_1
smb_apsMetas.contextId
smb_apsContexts.id
Restrict delete
ServiceInstallationProperties_ibfk_1
ServiceInstallationProperties.serviceInstallationId
ServiceInstallations.id
Restrict delete
ServiceNodeCache_ibfk_1
ServiceNodeCache.serviceNodeId
ServiceNodes.id
Restrict delete
smb_apsBundleFilterItems_ibfk_1
smb_apsBundleFilterItems.filterId
smb_apsBundleFilters.id
Restrict delete
MailOutgoingMessagesStats_ibfk_1
MailOutgoingMessagesStats.mailId
mail.id
Restrict delete
mass_mail_domains_ibfk_1
mass_mail_domains.mm_id
mass_mail.id
Restrict delete
mass_mail_domains_ibfk_2
mass_mail_domains.dom_id
domains.id
Restrict delete
apsResourcesParameters_ibfk_1
apsResourcesParameters.apsResourceId
apsResources.id
Restrict delete
resp_forward_ibfk_1
resp_forward.rn_id
mail_resp.id
Restrict delete
PlanServiceProperties_ibfk_1
PlanServiceProperties.planServiceId
PlanServiceInstallations.id
Restrict delete
report_section_ibfk_1
report_section.report_id
report.id
Restrict delete
mail_ibfk_2
mail.account_id
accounts.id
Restrict delete
mail_ibfk_1
mail.userId
smb_users.id
Restrict delete
mail_ibfk_4
mail.apsServiceAccountInstanceId
smb_apsInstances.id
Restrict delete
mail_ibfk_3
mail.dom_id
domains.id
Restrict delete
mail_ibfk_5
mail.perm_id
Permissions.id
Restrict delete
SubscriptionOutgoingMessagesStats_ibfk_1
SubscriptionOutgoingMessagesStats.subscriptionId
Subscriptions.id
Restrict delete
smb_serviceEntryPoints_ibfk_1
smb_serviceEntryPoints.servicePermissionId
smb_servicePermissions.id
Restrict delete
dom_param_ibfk_1
dom_param.dom_id
domains.id
Restrict delete
dsn_ibfk_1
dsn.dom_id
domains.id
Restrict delete
dsn_ibfk_2
dsn.serviceNodeId
ServiceNodes.id
Restrict delete
dns_recs_ibfk_1
dns_recs.dns_zone_id
dns_zone.id
Restrict delete
WebServerSettingsParameters_ibfk_1
WebServerSettingsParameters.webServerSettingsId
WebServerSettings.id
Restrict delete
pd_users_ibfk_2
pd_users.pd_id
protected_dirs.id
Restrict delete
pd_users_ibfk_1
pd_users.account_id
accounts.id
Restrict delete
DynamicIpSecurity_ibfk_1
DynamicIpSecurity.dom_id
domains.id
Restrict delete
ClientsTraffic_ibfk_1
ClientsTraffic.cl_id
clients.id
Restrict delete
ScheduledTasks_ibfk_1
ScheduledTasks.serviceNodeId
ServiceNodes.id
Restrict delete
ScheduledTasks_ibfk_2
ScheduledTasks.sysUserId
sys_users.id
Restrict delete
ip_pool_ibfk_1
ip_pool.ip_address_id
IP_Addresses.id
Restrict delete
longtaskparams_ibfk_1
longtaskparams.task_id
longtasks.id
Restrict delete
smb_apsPackagesCategories_ibfk_1
smb_apsPackagesCategories.categoryId
smb_apsCategories.id
Restrict delete
smb_apsPackagesCategories_ibfk_2
smb_apsPackagesCategories.packageId
smb_apsPackages.id
Restrict delete
mn_param_ibfk_1
mn_param.mn_id
mail.id
Restrict delete
smb_roles_ibfk_1
smb_roles.ownerId
clients.id
Restrict delete
ftp_users_ibfk_2
ftp_users.sys_user_id
sys_users.id
Restrict delete
ftp_users_ibfk_1
ftp_users.dom_id
domains.id
Restrict delete
apsContextsApplications_ibfk_1
apsContextsApplications.apsContextId
apsContexts.id
Restrict delete
data_bases_ibfk_3
data_bases.default_user_id
db_users.id
Restrict delete
data_bases_ibfk_1
data_bases.dom_id
domains.id
Restrict delete
data_bases_ibfk_2
data_bases.db_server_id
DatabaseServers.id
Restrict delete
forwarding_ibfk_1
forwarding.dom_id
domains.id
Restrict delete
PhpSettingsCustom_ibfk_1
PhpSettingsCustom.id
PhpSettings.id
Restrict delete
serviceNodeId
PackageUpdateLocks.serviceNodeId
ServiceNodes.id
Cascade on delete
ComposerInstances_ibfk_1
ComposerInstances.webspaceId
domains.id
Restrict delete
PhpSettingsParameters_ibfk_1
PhpSettingsParameters.id
PhpSettings.id
Restrict delete
ServiceNodeConfiguration_ibfk_1
ServiceNodeConfiguration.serviceNodeId
ServiceNodes.id
Restrict delete
ServiceInstances_ibfk_1
ServiceInstances.serviceInstallationId
ServiceInstallations.id
Restrict delete
ServiceInstances_ibfk_2
ServiceInstances.servicePackageId
Subscriptions.id
Restrict delete
ServiceInstanceResources_ibfk_1
ServiceInstanceResources.serviceInstanceId
ServiceInstances.id
Restrict delete
cl_param_ibfk_1
cl_param.cl_id
clients.id
Restrict delete
mass_mail_clients_ibfk_2
mass_mail_clients.cl_id
clients.id
Restrict delete
mass_mail_clients_ibfk_1
mass_mail_clients.mm_id
mass_mail.id
Restrict delete
clients_ibfk_3
clients.perm_id
Permissions.id
Restrict delete
clients_ibfk_2
clients.limits_id
Limits.id
Restrict delete
clients_ibfk_5
clients.logo_id
Logos.id
Restrict delete
clients_ibfk_4
clients.pool_id
ip_pool.id
Restrict delete
clients_ibfk_7
clients.parent_id
clients.id
Restrict delete
clients_ibfk_6
clients.tmpl_id
Templates.id
Restrict delete
clients_ibfk_8
clients.vendor_id
clients.id
Restrict delete
clients_ibfk_1
clients.account_id
accounts.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected