View netapp_model_view.service_processor_full Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19
uuid varchar 255 Globally unique ID of the ServiceProcessor. DERIVED from {clusterUUID}.{macAddress}.
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
clusterId bigint 19
nodeId bigint 19  √  null
macAddress varchar 255  √  null MAC address of the device.
ipAddress varchar 255  √  null Ordered list of Public addresses of the device, comma separated.
type enum 10  √  null Type of device.
typeRaw varchar 255  √  null Type of device - raw zapi value.
status enum 17  √  null Current status of the device.
statusRaw varchar 255  √  null Current status of the device - raw zapi value.
isIpConfigured bit 0 Is network configured on the device to have at least one public IP address
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`service_processor`.`objid` AS `objid`,`netapp_model`.`service_processor`.`UUID` AS `uuid`,`netapp_model`.`service_processor`.`resourceKey` AS `resourceKey`,`netapp_model`.`service_processor`.`clusterId` AS `clusterId`,`netapp_model`.`service_processor`.`nodeId` AS `nodeId`,`netapp_model`.`service_processor`.`macAddress` AS `macAddress`,`netapp_model`.`service_processor`.`ipAddress` AS `ipAddress`,`netapp_model`.`service_processor`.`type` AS `type`,`netapp_model`.`service_processor`.`typeRaw` AS `typeRaw`,`netapp_model`.`service_processor`.`status` AS `status`,`netapp_model`.`service_processor`.`statusRaw` AS `statusRaw`,`netapp_model`.`service_processor`.`isIpConfigured` AS `isIpConfigured`,`netapp_model`.`service_processor`.`createtime` AS `createTime`,`netapp_model`.`service_processor`.`updatetime` AS `updateTime`,`netapp_model`.`service_processor`.`objState` AS `objState` from `netapp_model`.`service_processor`