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 |