Tables


SchemaSpy Analysis of psa

Generated on Sat Dec 29 17:08 NOVT 2018

XML Representation
Insertion Order Deletion Order
TABLES 196
VIEWS 0
COLUMNS 1159
Constraints 180
Anomalies 68
Routines 0

Database Properties

Database Type: MySQL - 5.7.24

Tables

Table / View Children Parents Columns Rows Type Comments
smb_generalPermissions 1 0 2 0 Table
smb_apsProvisionEnvironments 0 2 4 0 Table
smb_apsInstanceErrors 0 1 4 0 Table
smb_apsResourceParameters 0 2 4 0 Table
GL_remote_domains 0 1 3 0 Table
smb_apsPackageUpdates 0 1 9 0 Table
certificates 3 1 8 0 Table
domain_aliases 0 4 14 0 Table
spamfilter_preferences 0 1 4 0 Table
mail_resp 2 1 15 0 Table
web_users 0 2 15 0 Table
key_history_params 0 0 3 0 Table
admin_aliases 2 1 7 0 Table
DatabaseUserRemoteAccessRules 0 1 6 0 Table
upgrade_history 0 0 5 0 Table
smb_servicePermissionAccounts 0 2 4 0 Table
DomainOutgoingMessagesPeaks 0 1 4 0 Table
spamfilter 1 1 4 0 Table
DomainsTraffic 0 1 10 0 Table
smb_roleServicePermissions 0 2 3 0 Table
apscategories 0 1 3 0 Table
ServiceNodeEnvironment 0 1 4 0 Table
mass_mail 2 1 13 0 Table
Webmails 0 3 8 0 Table
SitePagesStat 0 0 2 0 Table
IisAppPoolsPolicy 2 1 2 0 Table
smb_locales 0 0 4 0 Table
apsInstancesParameters 0 1 3 0 Table
smtp_poplocks 0 1 4 0 Table
DatabaseCustomHosts 0 1 2 0 Table
IpCollections 2 0 1 0 Table
Logos 1 1 4 0 Table
domains 34 11 26 0 Table
smb_userServicePermissions 0 2 3 0 Table
TraceFailedRequestsRules 1 1 5 0 Table
externalWebmails 0 1 4 0 Table
exp_event 0 1 9 0 Table
smb_apsResources 1 1 3 0 Table
TraceFailedRequestsProviderAreas 0 2 3 0 Table
PlanItemProperties 0 1 3 0 Table
PackageUpdateNotifications 0 1 5 0 Table
stat 0 0 3 0 Table
MailLists 0 2 4 0 Table
Repository 1 0 2 0 Table
smb_apsSettings 0 1 4 0 Table
SBConfig 0 1 2 0 Table
report_auto 0 3 8 0 Table
smb_settings 0 1 3 0 Table
smb_apsContexts 5 1 5 0 Table
webalizer_hidden_referrer 0 1 3 0 Table
Cards 0 0 11 0 Table
Modules 1 2 11 0 Table
SessionContexts 0 1 3 0 Table
IisAppPoolDomains 0 2 2 0 Table
secret_keys 0 3 5 0 Table
RestrictedDomains 0 1 2 0 Table
apsContexts 1 1 5 0 Table
suspend_handler_history 0 2 2 0 Table
accounts 6 0 3 0 Table
smb_componentUpdates 0 0 5 0 Table
ApsTokens 0 0 5 0 Table
DatabaseServers 2 1 9 0 Table
longtasks 1 0 13 0 Table
TmplData 0 1 3 0 Table
SubscriptionOutgoingMessagesPeaks 0 1 4 0 Table
smb_apsCategories 1 1 2 0 Table
log_components 0 1 4 0 Table
protected_dirs 1 1 8 0 Table
hotlink_friends 0 1 3 0 Table
Skins 0 1 3 0 Table
misc 0 0 2 0 Table
mail_aliases 0 1 4 0 Table
PlansSubscriptions 0 2 3 0 Table
PhpSettings 2 1 2 0 Table
IpAddressesCollections 0 2 2 0 Table
Notes 3 0 2 0 Table
smb_apsProvisions 1 1 3 0 Table
SBResellers 0 2 4 0 Table
anon_ftp 0 1 11 0 Table
sys_users 5 2 8 0 Table
smb_apsInstances 2 3 6 0 Table
BlUpgrades 17 0 2 0 Table
Subscriptions 5 1 8 0 Table
WebServerSettings 1 0 1 0 Table
report 2 2 6 0 Table
IP_Addresses 2 3 11 0 Table
GL_settings 0 1 3 0 Table
sessions 1 0 8 0 Table
MailOutgoingMessagesPeaks 0 1 4 0 Table
db_users 2 5 10 0 Table
smb_servicePermissions 4 2 6 0 Table
cp_access 0 0 4 0 Table
subdomains 0 2 20 0 Table
IisAppPools 1 1 18 0 Table
event_handlers 0 1 5 0 Table
mail_redir 0 1 4 0 Table
DomainOutgoingMessagesStats 0 1 5 0 Table
smb_roleGeneralPermissions 0 2 4 0 Table
badmailfrom 0 1 3 0 Table
APSCatalogUpdates 0 2 12 0 Table
ModuleSettings 0 1 3 0 Table
SubscriptionProperties 0 1 3 0 Table
smb_users 5 3 29 0 Table
resp_attach 0 1 3 0 Table
avstatistics 0 1 5 0 Table
Templates 3 4 7 0 Table
disk_usage 0 1 16 0 Table
webalizer_group_referrer 0 2 4 0 Table
APSLicenseTypes 0 1 6 0 Table
dom_level_usrs 0 2 8 0 Table
ServiceNodeCertificates 0 2 4 0 Table
key_history 0 1 7 0 Table
dns_recs_t 0 1 9 0 Table
PersistentCache 0 0 4 0 Table
APSClientApplicationItems 0 0 5 0 Table
dns_refs 2 0 5 0 Table
hosting 0 4 26 0 Table
hotlink_prot 0 1 3 0 Table
actions 45 0 2 0 Table
fileSharingUsers 0 1 4 0 Table
smb_serviceProviders 2 0 2 0 Table
BackupsScheduled 0 1 22 0 Table
DomainServices 0 3 6 0 Table
Notifications 0 1 10 0 Table
smb_serviceInstances 1 1 4 0 Table
admin_aliases_param 0 1 3 0 Table
log_actions 1 1 6 0 Table
log_rotation 0 0 7 0 Table
PleskStats 0 0 2 0 Table
smb_apsPackages 3 1 14 0 Table
TraceFailedRequestsProviders 1 2 3 0 Table
smb_apsMetas 1 2 6 0 Table
SiteAppsHitsStat 0 1 3 0 Table
ServiceNodes 17 0 6 0 Table
ServiceNodeCache 0 1 4 0 Table
Configurations 0 2 11 0 Table
smb_apsBundleFilters 1 0 2 0 Table
smb_apsBundleFilterItems 0 1 4 0 Table
MailOutgoingMessagesStats 0 1 5 0 Table
Permissions 3 0 3 0 Table
mass_mail_domains 0 2 2 0 Table
apsResourcesParameters 0 2 4 0 Table
BackupsSettings 0 0 4 0 Table
resp_forward 0 1 3 0 Table
report_section 0 2 4 0 Table
ApiRpcCallsStat 0 0 9 0 Table
mail 6 5 19 0 Table
APSApplicationItems 0 0 4 0 Table
SubscriptionOutgoingMessagesStats 0 1 5 0 Table
smb_serviceEntryPoints 0 1 9 0 Table
PleskPagesStat 0 0 3 0 Table
LimitsReservation 0 0 5 0 Table
dom_param 0 1 3 0 Table
MailMessagesStat 0 0 2 0 Table
dsn 0 3 8 0 Table
dns_recs 0 2 10 0 Table
WebServerSettingsParameters 0 1 3 0 Table
CliCallsStat 0 0 5 0 Table
SchemaVersions 0 0 1 0 Table
resp_freq 0 0 5 0 Table
Parameters 3 0 3 0 Table
pd_users 0 2 4 0 Table
APSLicenses 0 0 8 0 Table
DynamicIpSecurity 0 1 6 0 Table
EmailActivations 0 3 6 0 Table
ClientsTraffic 0 1 10 0 Table
ScheduledTasks 0 2 20 0 Table
BackendCache 0 0 2 0 Table
custom_buttons 0 1 11 0 Table
ip_pool 1 1 3 0 Table
BlUpgradeActions 0 0 4 0 Table
Limits 2 0 3 0 Table
apsResources 1 0 4 0 Table
longtaskparams 0 1 3 0 Table
smb_apsPackagesCategories 0 2 3 0 Table
mn_param 0 1 3 0 Table
smb_roles 3 2 5 0 Table
locales 0 0 2 0 Table
ftp_users 0 3 5 0 Table
apsContextsApplications 1 1 3 0 Table
data_bases 2 4 7 0 Table
forwarding 0 1 3 0 Table
dns_zone 3 2 21 0 Table
PlanItems 1 1 8 0 Table
password_secrets 0 0 4 0 Table
PhpSettingsCustom 0 1 2 0 Table
BackupExcludeFiles 1 0 2 0 Table
PackageUpdateLocks 0 1 3 0 Table
smb_productUpgrades 0 0 6 0 Table
ComposerInstances 0 2 4 0 Table
PhpSettingsParameters 0 1 3 0 Table
ServiceNodeConfiguration 0 1 4 0 Table
cl_param 0 1 3 0 Table
mass_mail_clients 0 2 2 0 Table
smb_fileSharingUnlistedFiles 0 1 6 0 Table
clients 15 9 32 0 Table