psa.domains
Overview
The domains table is the root table where the most basic details about a domain are stored.
Column Descriptions
id - primary key that is linked to in many other tables as dom_id
cr_date - date the domain was created (YYYY-MM-DD)
name - domain name as it appears on the filesystem and DNS (should match displayName)
displayName - domain name as it appears in Plesk (should match name)
dns_zone_id - links to id in dns_zone table
status - determines whether a domain is enabled or disabled
htype - hosting type (can be: none, vrt_hst, std_fwd, frm_fwd)
real_size - size of the entire domain in bytes when Plesk’s statistics scripts last ran
cl_id - links to id in clients table
cert_rep_id - links to rep_id in Repository table (and then Repository.component_id links to id in the certificates table)
limits_id - links to id in Limits table
params_id - links to id in Parameters table
guid - unique identifier assigned by Plesk for the domain
Table Structure
CREATE TABLE `domains` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cr_date` DATE DEFAULT NULL, `name` VARCHAR(255) character SET ASCII NOT NULL DEFAULT '', `displayName` VARCHAR(255) character SET utf8 NOT NULL DEFAULT '', `dns_zone_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `status` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `htype` ENUM('none','vrt_hst','std_fwd','frm_fwd') NOT NULL DEFAULT 'none', `real_size` BIGINT(20) UNSIGNED DEFAULT '0', `cl_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `cert_rep_id` INT(10) UNSIGNED DEFAULT NULL, `limits_id` INT(10) UNSIGNED DEFAULT NULL, `params_id` INT(10) UNSIGNED DEFAULT NULL, `guid` VARCHAR(36) character SET ASCII COLLATE ascii_bin NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `cl_id` (`cl_id`), KEY `cert_rep_id` (`cert_rep_id`), KEY `limits_id` (`limits_id`), KEY `params_id` (`params_id`), KEY `displayName` (`displayName`) ) ENGINE=INNODB AUTO_INCREMENT=151 DEFAULT CHARSET=latin1