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

Leave a comment

Your comment