domains


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
cr_date DATE 10 √ null
name VARCHAR 255 null
displayName VARCHAR 255 null
dns_zone_id INT UNSIGNED 10 null
status BIGINT UNSIGNED 20 0
htype enum('none', 'vrt_hst', 'std_fwd', 'frm_fwd') 7 null
real_size BIGINT UNSIGNED 20 √ 0
cl_id INT UNSIGNED 10 null
cert_rep_id INT UNSIGNED 10 √ null
limits_id INT UNSIGNED 10 √ null
params_id INT UNSIGNED 10 √ null
guid VARCHAR 255 00000000-0000-0000-0000-000000000000
external_id VARCHAR 255 √ null
adminDescription VARCHAR 255 √ null
resellerDescription VARCHAR 255 √ null
description VARCHAR 255 √ null
overuse enum('false', 'true') 6 false
gl_filter enum('on', 'off') 3 on
vendor_id INT UNSIGNED 10 √ null
webspace_id INT UNSIGNED 10 0
webspace_status BIGINT UNSIGNED 20 0
parentDomainId INT UNSIGNED 10 0
permissions_id INT UNSIGNED 10 0

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cert_rep_id Performance Asc cert_rep_id
cl_id Performance Asc cl_id
displayName Performance Asc displayName
external_id Performance Asc external_id
limits_id Performance Asc limits_id
name Must be unique Asc name
params_id Performance Asc params_id
parentDomainId Performance Asc parentDomainId
permissions_id Performance Asc permissions_id
vendor_id Performance Asc vendor_id
webspace_id Performance Asc webspace_id