psa.clients

Overview
The clients table is the root table where the most basic details about a client are stored.

Column Descriptions
id – primary key that is linked to many other tables as client_id
cr_date – date the client was created (YYYY-MM-DD)
cname – client’s company name
pname – client’s actual name
login – login username for Plesk access
account_id – links to id in accounts table
status0 if enabled or 16 if disabled
phone – client’s phone number
fax – client’s fax number
email – client’s e-mail address
address – client’s physical address
city – client’s city
state – client’s state
pcode – client’s postal code
country – client’s country
locale – localization for the client (defaults to en-US)
limits_id – links to id in Limits table
params_id – links to id in Parameters table
perm_id – links to id in Permissions table
pool_id – links to rep_id in Repository table (and then Repository.component_id links to id in IP_Addresses table)
logo_id – links to id in Logos table
tmpl_id – links to id in Templates table
sapp_pool_id – currently unknown, but most likely relates to site applications in the Application Vault
guid – unique identifier assigned by Plesk for the client

Table Structure

CREATE TABLE `clients` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `cr_date` date default NULL,
 `cname` varchar(255) character set utf8 default NULL,
 `pname` varchar(255) character set utf8 NOT NULL default '',
 `login` varchar(20) character set utf8 NOT NULL default '',
 `account_id` int(10) unsigned NOT NULL default '0',
 `status` bigint(20) unsigned NOT NULL default '0',
 `phone` varchar(255) character set ascii collate ascii_bin default NULL,
 `fax` varchar(255) character set ascii collate ascii_bin default NULL,
 `email` varchar(255) character set utf8 default NULL,
 `address` varchar(255) character set utf8 default NULL,
 `city` varchar(255) character set utf8 default NULL,
 `state` varchar(255) character set utf8 default NULL,
 `pcode` varchar(10) character set ascii collate ascii_bin default NULL,
 `country` char(2) character set ascii collate ascii_bin default NULL,
 `locale` varchar(17) character set ascii collate ascii_bin NOT NULL default 'en-US',
 `limits_id` int(10) unsigned default NULL,
 `params_id` int(10) unsigned default NULL,
 `perm_id` int(10) unsigned default NULL,
 `pool_id` int(10) unsigned default NULL,
 `logo_id` int(10) unsigned default NULL,
 `tmpl_id` int(10) unsigned default NULL,
 `sapp_pool_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 `login` (`login`),
 KEY `account_id` (`account_id`),
 KEY `limits_id` (`limits_id`),
 KEY `params_id` (`params_id`),
 KEY `perm_id` (`perm_id`),
 KEY `pool_id` (`pool_id`),
 KEY `logo_id` (`logo_id`),
 KEY `tmpl_id` (`tmpl_id`),
 KEY `sapp_pool_id` (`sapp_pool_id`),
 KEY `pname` (`pname`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1

Related documentation