domains


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
anon_ftp.dom_id anon_ftp_ibfk_1 R
ComposerInstances.webspaceId ComposerInstances_ibfk_1 R
data_bases.dom_id data_bases_ibfk_1 R
db_users.dom_id db_users_ibfk_3 R
disk_usage.dom_id disk_usage_ibfk_1 R
dom_level_usrs.dom_id dom_level_usrs_ibfk_1 R
dom_param.dom_id dom_param_ibfk_1 R
domain_aliases.dom_id domain_aliases_ibfk_1 R
DomainOutgoingMessagesPeaks.domainId DomainOutgoingMessagesPeaks_ibfk_1 R
DomainOutgoingMessagesStats.domainId DomainOutgoingMessagesStats_ibfk_1 R
domains.parentDomainId domains_ibfk_8 R
domains.webspace_id domains_ibfk_7 R
DomainServices.dom_id DomainServices_ibfk_1 R
DomainsTraffic.dom_id DomainsTraffic_ibfk_1 R
dsn.dom_id dsn_ibfk_1 R
DynamicIpSecurity.dom_id DynamicIpSecurity_ibfk_1 R
forwarding.dom_id forwarding_ibfk_1 R
ftp_users.dom_id ftp_users_ibfk_1 R
hosting.dom_id hosting_ibfk_1 R
hotlink_friends.dom_id hotlink_friends_ibfk_1 R
hotlink_prot.dom_id hotlink_prot_ibfk_1 R
IisAppPoolDomains.domainId IisAppPoolDomains_ibfk_1 R
IP_Addresses.default_domain_id IP_Addresses_ibfk_2 R
mail.dom_id mail_ibfk_3 R
MailLists.dom_id MailLists_ibfk_1 R
mass_mail_domains.dom_id mass_mail_domains_ibfk_2 R
protected_dirs.dom_id protected_dirs_ibfk_1 R
report_auto.domain report_auto_ibfk_3 R
smb_users.subscriptionDomainId smb_users_ibfk_3 R
suspend_handler_history.dom_id suspend_handler_history_ibfk_1 R
TraceFailedRequestsRules.domainId TraceFailedRequestsRules_ibfk_1 R
web_users.dom_id web_users_ibfk_1 R
webalizer_group_referrer.dom_id webalizer_group_referrer_ibfk_1 R
webalizer_hidden_referrer.dom_id webalizer_hidden_referrer_ibfk_1 R
cr_date DATE 10 √ null
name VARCHAR 255 null
actions.name Implied Constraint R
displayName VARCHAR 255 null
dns_zone_id INT UNSIGNED 10 √ null
dns_zone.id domains_ibfk_1 R
status BIGINT UNSIGNED 20 0
htype enum('none', 'vrt_hst', 'std_fwd', 'frm_fwd') 7 none
real_size BIGINT UNSIGNED 20 √ 0
cl_id INT UNSIGNED 10 0
clients.id domains_ibfk_2 R
cert_rep_id INT UNSIGNED 10 √ 0
Repository.rep_id domains_ibfk_3 R
limits_id INT UNSIGNED 10 0
Limits.id domains_ibfk_4 R
params_id INT UNSIGNED 10 0
Parameters.id domains_ibfk_5 R
guid VARCHAR 255 00000000-0000-0000-0000-000000000000
overuse enum('false', 'true') 6 false
vendor_id INT UNSIGNED 10 0
clients.id domains_ibfk_6 R
webspace_id INT UNSIGNED 10 0
domains.id domains_ibfk_7 R
parentDomainId INT UNSIGNED 10 0
domains.id domains_ibfk_8 R
webspace_status BIGINT UNSIGNED 20 0
permissions_id INT UNSIGNED 10 0
Permissions.id domains_ibfk_9 R
external_id VARCHAR 255 √ null
BlUpgrades.id Implied Constraint R
adminDescription VARCHAR 255 √ null
resellerDescription VARCHAR 255 √ null
description VARCHAR 255 √ null
gl_filter enum('on', 'off') 3 on
icpStatus INT 10 0
icpPermit VARCHAR 255 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cert_rep_id Performance Asc cert_rep_id
cl_id Performance Asc cl_id
displayName Performance Asc displayName
dns_zone_id Performance Asc dns_zone_id
external_id Performance Asc external_id
limits_id Performance Asc limits_id
name Must be unique Asc name
params_id Performance Asc params_id
parentDomainId Performance Asc parentDomainId
permissions_id Performance Asc permissions_id
vendor_id Performance Asc vendor_id
webspace_id Performance Asc webspace_id

Relationships

Close relationships within degrees of separation