ServiceNodes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
badmailfrom.serviceNodeId badmailfrom_ibfk_1 R
dsn.serviceNodeId dsn_ibfk_2 R
GL_remote_domains.serviceNodeId GL_remote_domains_ibfk_1 R
GL_settings.serviceNodeId GL_settings_ibfk_1 R
IisAppPools.serviceNodeId IisAppPools_ibfk_1 R
IisAppPoolsPolicy.serviceNodeId IisAppPoolsPolicy_ibfk_1 R
IP_Addresses.serviceNodeId IP_Addresses_ibfk_3 R
PackageUpdateLocks.serviceNodeId serviceNodeId C
PackageUpdateNotifications.serviceNodeId serviceNodeId1 C
ScheduledTasks.serviceNodeId ScheduledTasks_ibfk_1 R
ServiceInstallations.serviceNodeId ServiceInstallations_ibfk_1 R
ServiceNodeCache.serviceNodeId ServiceNodeCache_ibfk_1 R
ServiceNodeCertificates.serviceNodeId ServiceNodeCertificates_ibfk_1 R
ServiceNodeConfiguration.serviceNodeId ServiceNodeConfiguration_ibfk_1 R
ServiceNodeEnvironment.serviceNodeId ServiceNodeEnvironment_ibfk_1 R
smtp_poplocks.serviceNodeId smtp_poplocks_ibfk_1 R
spamfilter.serviceNodeId spamfilter_ibfk_1 R
sys_users.serviceNodeId sys_users_ibfk_1 R
ipAddress VARCHAR 255 local
description VARCHAR 255 null
type VARCHAR 255 plesk
accessKey TEXT 65535 √ null
externalId VARCHAR 255 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ipAddress Must be unique Asc ipAddress

Relationships

Close relationships within degrees of separation