Configurations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
name VARCHAR 255 null
serviceNodeId INT UNSIGNED 10 1
IisAppPoolsPolicy.serviceNodeId Implied Constraint R
file BLOB 65535 √ null
version VARCHAR 255 null
objectType VARCHAR 255 null
objectId INT UNSIGNED 10 √ null
status enum('error', 'generation', 'ok') 10 error
active enum('false', 'true') 6 true
description BLOB 65535 √ null
errorFile BLOB 65535 √ null

Table contained 5 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
objectTypeAndId_index Performance Asc/Asc objectType + objectId

Relationships

Close relationships within degrees of separation