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

Related documentation