View netapp_model_view.lun_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 Locally unique object identifier. ZAPIs: lun-get-iter.lun-info
uuid varchar 255 Globally unique ID of the LUN
resourceKey varchar 255  √  null
qtreeId bigint 19  √  null
volumeId bigint 19
vserverId bigint 19
clusterId bigint 19
qosPolicyGroupId bigint 19  √  null
path varchar 255  √  null Path of the LUN
isOnline bit 0  √  null Is LUN online?
size bigint 19  √  null Size of the LUN in bytes
sizeUsed bigint 19  √  null Used bytes in the LUN
isSpaceReservationEnabled bit 0  √  null Whether or not the LUN has space reservation enabled
isSpaceAllocEnabled bit 0  √  null Whether or not the LUN has space allocation enabled
isMapped bit 0  √  null Is the LUN mapped to any initiator?
serialNumber varchar 255  √  null Serial number of the LUN
multiProtocolType varchar 255  √  null The OS type of the LUN
alignment enum 19  √  null Alignment state of the LUN
alignmentRaw varchar 255  √  null Alignment state of the LUN - ZAPI raw value
prefixSize bigint 19  √  null Size of the prefix stream for this LUN in bytes
suffixSize bigint 19  √  null Size of the suffix stream for this LUN in bytes
lunClass enum 16  √  null The class of the LUN
lunClassRaw varchar 255  √  null The class of the LUN - ZAPI raw value
comment varchar 255  √  null User defined comments on LUN
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`.`lun`.`objid` AS `objid`,`netapp_model`.`lun`.`uuid` AS `uuid`,`netapp_model`.`lun`.`resourceKey` AS `resourceKey`,`netapp_model`.`lun`.`qtreeId` AS `qtreeId`,`netapp_model`.`lun`.`volumeId` AS `volumeId`,`netapp_model`.`lun`.`vserverId` AS `vserverId`,`netapp_model`.`lun`.`clusterId` AS `clusterId`,`netapp_model`.`lun`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`netapp_model`.`lun`.`path` AS `path`,`netapp_model`.`lun`.`isOnline` AS `isOnline`,`netapp_model`.`lun`.`size` AS `size`,`netapp_model`.`lun`.`sizeUsed` AS `sizeUsed`,`netapp_model`.`lun`.`isSpaceReservationEnabled` AS `isSpaceReservationEnabled`,`netapp_model`.`lun`.`isSpaceAllocEnabled` AS `isSpaceAllocEnabled`,`netapp_model`.`lun`.`isMapped` AS `isMapped`,`netapp_model`.`lun`.`serialNumber` AS `serialNumber`,`netapp_model`.`lun`.`multiProtocolType` AS `multiProtocolType`,`netapp_model`.`lun`.`alignment` AS `alignment`,`netapp_model`.`lun`.`alignmentRaw` AS `alignmentRaw`,`netapp_model`.`lun`.`prefixSize` AS `prefixSize`,`netapp_model`.`lun`.`suffixSize` AS `suffixSize`,`netapp_model`.`lun`.`lunClass` AS `lunClass`,`netapp_model`.`lun`.`lunClassRaw` AS `lunClassRaw`,`netapp_model`.`lun`.`comment` AS `comment`,`netapp_model`.`lun`.`createtime` AS `createTime`,`netapp_model`.`lun`.`updatetime` AS `updateTime`,`netapp_model`.`lun`.`objState` AS `objState` from `netapp_model`.`lun`