ServiceInstances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
ServiceInstanceDepends.requiredInstanceId ServiceInstanceDepends_ibfk_2 R
ServiceInstanceDepends.serviceInstanceId ServiceInstanceDepends_ibfk_1 R
ServiceInstanceProperties.serviceInstanceId ServiceInstanceProperties_ibfk_1 R
ServiceInstanceResources.serviceInstanceId ServiceInstanceResources_ibfk_1 R
serviceInstallationId INT UNSIGNED 10 null
ServiceInstallations.id ServiceInstances_ibfk_1 R
servicePackageId INT UNSIGNED 10 null
Subscriptions.id ServiceInstances_ibfk_2 R
reference VARCHAR 255 √ null
status INT UNSIGNED 10 1
enabled INT UNSIGNED 10 1

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
reference Must be unique Asc/Asc/Asc serviceInstallationId + servicePackageId + reference
servicePackageId Performance Asc servicePackageId

Relationships

Close relationships within degrees of separation