psa.clients

Overview

Column Descriptions

id –
parent_id –
vendor_id –
type –
cr_date –
cname –
pname –
login –
account_id –
status –
phone –
fax –
phone –
address –
city –
state –
pcode –
country –
locale –
limits_id –
params_id –
perm_id –
pool_d –
logo_id –
tmpl_id –
sapp_pool_id –
guid –
external_id –
overuse –

CREATE TABLE `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned DEFAULT NULL,
  `vendor_id` int(10) unsigned DEFAULT NULL,
  `type` enum('client','reseller','admin') NOT NULL DEFAULT 'client',
  `cr_date` date DEFAULT NULL,
  `cname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `pname` varchar(255) CHARACTER SET utf8 NOT NULL,
  `login` varchar(255) CHARACTER SET utf8 NOT NULL,
  `account_id` int(10) unsigned NOT NULL,
  `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` varchar(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',
  `external_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  `overuse` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `parent_id` (`parent_id`),
  KEY `pname` (`pname`),
  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 `vendor_id` (`vendor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1

Related documentation