View netapp_model_view.disk_path_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: storage-disk-get-iter.storage-disk-info.disk-paths.disk-path-info
uuid varchar 255 UUID of the Disk Path equivalent to "{diskUUID}.{initiatorName}.{targetWWN}". This is not returned from ZAPI
resourceKey varchar 512
clusterId bigint 19
nodeId bigint 19
diskId bigint 19
initiatorPortId bigint 19  √  null Reference to initiator storage adapter in the cluster
arrayName varchar 255  √  null Name of the array providing the LUN
diskPort varchar 255  √  null Disk port associated with this path. Possible values are "A" or "B". Omitted for non-disk target
diskPortName varchar 255  √  null Disk port name associated with this path. This has the form {attachment-style}:{disk-port}, where <attachment-style> is either "FC" for FibreChannel, or "SA" for SAS, and <disk-port> is either "A" or "B". Omitted for non-disk target
initiatorSideSwitchPort varchar 255  √  null The name of the switch connected to the controller initiator port, or N/A when using direct attach
lun int 10  √  null Logical Unit Number. Range: [0..65535]
lunPathUseState enum 10  √  null ONTAP use of this path: In Use, Ready, High Error, Quiescing
lunPathUseStateRaw varchar 255  √  null Raw value of ONTAP use of this path
targetWWPN varchar 255 World Wide Port Name of target port providing the disk
targetWWNN varchar 255  √  null World Wide Node Name of the target device
targetSideSwitchPort varchar 255 Name of the switch port connected to the target array, or UNKNOWN if direct attached
tpgn bigint 19  √  null The Target Port Group Number of the array target port. Range: [0..2^64-1]
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`.`disk_path`.`objid` AS `objid`,`netapp_model`.`disk_path`.`uuid` AS `uuid`,`netapp_model`.`disk_path`.`resourceKey` AS `resourceKey`,`netapp_model`.`disk_path`.`clusterId` AS `clusterId`,`netapp_model`.`disk_path`.`nodeId` AS `nodeId`,`netapp_model`.`disk_path`.`diskId` AS `diskId`,`netapp_model`.`disk_path`.`initiatorPortId` AS `initiatorPortId`,`netapp_model`.`disk_path`.`arrayName` AS `arrayName`,`netapp_model`.`disk_path`.`diskPort` AS `diskPort`,`netapp_model`.`disk_path`.`diskPortName` AS `diskPortName`,`netapp_model`.`disk_path`.`initiatorSideSwitchPort` AS `initiatorSideSwitchPort`,`netapp_model`.`disk_path`.`lun` AS `lun`,`netapp_model`.`disk_path`.`lunPathUseState` AS `lunPathUseState`,`netapp_model`.`disk_path`.`lunPathUseStateRaw` AS `lunPathUseStateRaw`,`netapp_model`.`disk_path`.`targetWWPN` AS `targetWWPN`,`netapp_model`.`disk_path`.`targetWWNN` AS `targetWWNN`,`netapp_model`.`disk_path`.`targetSideSwitchPort` AS `targetSideSwitchPort`,`netapp_model`.`disk_path`.`tpgn` AS `tpgn`,`netapp_model`.`disk_path`.`createtime` AS `createTime`,`netapp_model`.`disk_path`.`updatetime` AS `updateTime`,`netapp_model`.`disk_path`.`objState` AS `objState` from `netapp_model`.`disk_path`
 
Possibly Referenced Tables/Views:
lun