View netapp_model_view.nvmf_fc_lif 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: net-interface-get-iter.net-interface-info
uuid varchar 255 Globally unique ID of this LIF.
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
vserverId bigint 19
currentNodeId bigint 19  √  null
currentPortId bigint 19  √  null
homeNodeId bigint 19  √  null
homePortId bigint 19  √  null
isAutoRevert bit 0  √  null If true, data LIF will revert to its home node under certain circumstances such as startup, and load balancing migration is disabled automatically
isHome bit 0  √  null True if LIF is currently on home node and home port
portName varchar 255  √  null World Wide Port Name (WWPN) of the LIF
operationalStatus enum 10  √  null State of aggregate
operationalStatusRaw varchar 255  √  null
administrativeStatus enum 10  √  null State of aggregate
administrativeStatusRaw varchar 255  √  null
role enum 12  √  null Specifies the role associated with the LIF
roleRaw varchar 255  √  null
dataProtocols varchar 255  √  null Specifies the list of data protocols configured on the LIF. This can be comma separated. Possible values: nfs, cifs, iscsi, fcp, fc_nvme, fcache, none
failoverGroupId bigint 19  √  null failover group for this lif
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `fl`.`objid` AS `objid`,`fl`.`uuid` AS `uuid`,`fl`.`resourceKey` AS `resourceKey`,`l`.`name` AS `name`,`fl`.`clusterId` AS `clusterId`,`fl`.`vserverId` AS `vserverId`,`l`.`currentNodeId` AS `currentNodeId`,`fl`.`currentPortId` AS `currentPortId`,`l`.`homeNodeId` AS `homeNodeId`,`fl`.`homePortId` AS `homePortId`,`l`.`isAutoRevert` AS `isAutoRevert`,`l`.`isHome` AS `isHome`,`fl`.`portName` AS `portName`,`l`.`operationalStatus` AS `operationalStatus`,`l`.`operationalStatusRaw` AS `operationalStatusRaw`,`l`.`administrativeStatus` AS `administrativeStatus`,`l`.`administrativeStatusRaw` AS `administrativeStatusRaw`,`l`.`role` AS `role`,`l`.`roleRaw` AS `roleRaw`,`l`.`dataProtocols` AS `dataProtocols`,`l`.`failoverGroupId` AS `failoverGroupId`,`fl`.`createtime` AS `createTime`,`fl`.`updatetime` AS `updateTime` from (`netapp_model`.`nvmf_fc_lif` `fl` join `netapp_model`.`lif` `l` on((`fl`.`objid` = `l`.`objid`))) where (`fl`.`objState` = 'LIVE')