clients


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
cl_param.cl_id cl_param_ibfk_1 R
clients.parent_id clients_ibfk_7 R
clients.vendor_id clients_ibfk_8 R
ClientsTraffic.cl_id ClientsTraffic_ibfk_1 R
domains.cl_id domains_ibfk_2 R
domains.vendor_id domains_ibfk_6 R
mass_mail_clients.cl_id mass_mail_clients_ibfk_2 R
report.user_id report_ibfk_1 R
report_auto.client report_auto_ibfk_2 R
SBResellers.client_id SBResellers_ibfk_1 R
secret_keys.client_id secret_keys_ibfk_1 R
smb_roles.ownerId smb_roles_ibfk_1 R
smb_users.ownerId smb_users_ibfk_2 R
Templates.owner_id Templates_ibfk_1 R
cr_date DATE 10 √ null
cname VARCHAR 255 √ null
pname VARCHAR 255 null
login VARCHAR 255 null
account_id INT UNSIGNED 10 null
accounts.id clients_ibfk_1 R
status BIGINT UNSIGNED 20 0
phone VARCHAR 255 √ null
fax VARCHAR 255 √ null
email VARCHAR 255 √ null
address VARCHAR 255 √ null
city VARCHAR 255 √ null
state VARCHAR 255 √ null
pcode VARCHAR 10 √ null
country VARCHAR 2 √ null
locale VARCHAR 17 en-US
description VARCHAR 255 √ null
limits_id INT UNSIGNED 10 √ 0
Limits.id clients_ibfk_2 R
params_id INT UNSIGNED 10 0
perm_id INT UNSIGNED 10 0
Permissions.id clients_ibfk_3 R
pool_id INT UNSIGNED 10 0
ip_pool.id clients_ibfk_4 R
logo_id INT UNSIGNED 10 0
Logos.id clients_ibfk_5 R
tmpl_id INT UNSIGNED 10 0
Templates.id clients_ibfk_6 R
sapp_pool_id INT UNSIGNED 10 0
ownership enum('false', 'true') 6 true
guid VARCHAR 36 00000000-0000-0000-0000-000000000000
parent_id INT UNSIGNED 10 0
clients.id clients_ibfk_7 R
type enum('admin', 'reseller', 'client') 8 client
overuse enum('false', 'true') 6 false
vendor_id INT UNSIGNED 10 √ null
clients.id clients_ibfk_8 R
external_id VARCHAR 255 √ null
BlUpgrades.id Implied Constraint R
passwd VARCHAR 20 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_id Performance Asc account_id
limits_id Performance Asc limits_id
login Must be unique Asc login
logo_id Performance Asc logo_id
params_id Performance Asc params_id
parent_id Performance Asc parent_id
perm_id Performance Asc perm_id
pname Performance Asc pname
pool_id Performance Asc pool_id
sapp_pool_id Performance Asc sapp_pool_id
tmpl_id Performance Asc tmpl_id
type Performance Asc type
vendor_id Performance Asc vendor_id

Relationships

Close relationships within degrees of separation