Templates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
clients.tmpl_id clients_ibfk_6 R
PlanServiceInstallations.planId PlanServiceInstallations_ibfk_1 R
PlansSubscriptions.plan_id PlansSubscriptions_ibfk_2 R
TmplData.tmpl_id TmplData_ibfk_1 R
name VARCHAR 255 null
owner_id INT UNSIGNED 10 null
clients.id Templates_ibfk_1 R
type enum('reseller', 'client', 'domain', 'domain_addon') 12 null
uuid VARCHAR 36 null
external_id VARCHAR 255 null
BlUpgrades.id Implied Constraint R
note_id INT UNSIGNED 10 null
Notes.id Templates_ibfk_2 R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
note_id Performance Asc note_id
owner_id Performance Asc owner_id
uuid Must be unique Asc uuid

Relationships