subdomains


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
dom_id INT UNSIGNED 10 0
name VARCHAR 255 null
displayName VARCHAR 255 null
sys_user_id INT UNSIGNED 10 0
sys_users.id subdomains_ibfk_1 R
ssi enum('false', 'true') 6 false
php enum('false', 'true') 6 false
php_handler_type enum('cgi', 'fastcgi', 'module', 'isapi') 7 module
cgi enum('false', 'true') 6 false
perl enum('false', 'true') 6 false
python enum('false', 'true') 6 false
coldfusion enum('false', 'true') 6 false
asp enum('false', 'true') 6 false
asp_dot_net enum('false', 'true') 6 false
ssl enum('false', 'true') 6 false
www_root VARCHAR 255 httpdocs
maintenance_mode enum('false', 'true') 6 false
certificate_id INT UNSIGNED 10 √ 0
fastcgi enum('false', 'true') 6 false
same_ssl enum('false', 'true') 6 true

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dom_id Must be unique Asc/Asc dom_id + name
dom_id_displayName Performance Asc/Asc dom_id + displayName
sys_user_id Performance Asc sys_user_id

Relationships

Close relationships within degrees of separation