View netapp_model_view.flash_device_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 FlashDevice
resourceKey varchar 512 DERIVED. A structured key that may be used to uniquely identify this resource globally.
clusterId bigint 19
nodeId bigint 19
slotNumber int 10  √  null The name of routing group.
serialNumber varchar 255  √  null 10-digit serial number of the flash device
modelName varchar 255  √  null Model name of the flash device in XXXXXX-XX format.
firmwareRevision varchar 255  √  null Firmware revision of FPGA on the flash device.
capacityGB int 10  √  null Advertised capacity of the device, in gigabytes.
percentOnline int 10  √  null Percentage of device capacity that is currently online.
status enum 17  √  null The current status of the device
statusRaw varchar 255  √  null The current status of the device - ZAPI raw value
serviceTime int 10  √  null Total number of hours the device was operational.
thresholdProfile varchar 255  √  null The name of the threshold profile being used for this flash device.
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`.`flash_device`.`objid` AS `objid`,`netapp_model`.`flash_device`.`uuid` AS `uuid`,`netapp_model`.`flash_device`.`resourceKey` AS `resourceKey`,`netapp_model`.`flash_device`.`clusterId` AS `clusterId`,`netapp_model`.`flash_device`.`nodeId` AS `nodeId`,`netapp_model`.`flash_device`.`slotNumber` AS `slotNumber`,`netapp_model`.`flash_device`.`serialNumber` AS `serialNumber`,`netapp_model`.`flash_device`.`modelName` AS `modelName`,`netapp_model`.`flash_device`.`firmwareRevision` AS `firmwareRevision`,`netapp_model`.`flash_device`.`capacityGB` AS `capacityGB`,`netapp_model`.`flash_device`.`percentOnline` AS `percentOnline`,`netapp_model`.`flash_device`.`status` AS `status`,`netapp_model`.`flash_device`.`statusRaw` AS `statusRaw`,`netapp_model`.`flash_device`.`serviceTime` AS `serviceTime`,`netapp_model`.`flash_device`.`thresholdProfile` AS `thresholdProfile`,`netapp_model`.`flash_device`.`createtime` AS `createTime`,`netapp_model`.`flash_device`.`updatetime` AS `updateTime`,`netapp_model`.`flash_device`.`objState` AS `objState` from `netapp_model`.`flash_device`