PlanServiceInstallations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
PlanServiceProperties.planServiceId PlanServiceProperties_ibfk_1 R
planId INT UNSIGNED 10 null
Templates.id PlanServiceInstallations_ibfk_1 R
serviceInstallationId INT UNSIGNED 10 null
ServiceInstallations.id PlanServiceInstallations_ibfk_2 R
assigned INT UNSIGNED 10 1

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc id + planId + serviceInstallationId
planId Performance Asc planId
serviceInstallationId Performance Asc serviceInstallationId

Relationships

Close relationships within degrees of separation