mngd_svc_defs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ServiceDefinitionID INT 10 null
v_mngd_svc_clients.ServiceDefinitionID Implied ConstraintR
v_mngd_svc_computers.ServiceDefinitionID Implied ConstraintR
v_mngd_svc_contacts.ServiceDefinitionID Implied ConstraintR
v_mngd_svc_locations.ServiceDefinitionID Implied ConstraintR
v_mngd_svc_networkdevices.ServiceDefinitionID Implied ConstraintR
ServiceDefinitionGUID CHAR 36 null
SKU VARCHAR 254 null
Name VARCHAR 254 null
Description TEXT 65535 null
ServiceType INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ServiceDefinitionID
ServiceDefinitionGUID Must be unique Asc ServiceDefinitionGUID
ServiceType Performance Asc ServiceType
SKU Must be unique Asc SKU

Relationships