View netapp_model_view.fcp_lif_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: net-interface-get-iter.net-interface-info
uuid varchar 255 Globally unique ID of this LIF. For ONTAP 8.2 and later ZAPI: net-interface-get-iter net-interface-info.lif-uuid. For ONTAP 8.1: Not available in ZAPI. Uses {VserverUUID}.{LIFName}
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
nodeName varchar 255  √  null World Wide Node Name (WWNN) of the LIF. All LIFs in a Vserver have the same WWNN as the Vserver FCP service
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
updateTime bigint 19
createTime bigint 19
objState enum 5 LIVE Internal object state

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`.`nodeName` AS `nodeName`,`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`.`updatetime` AS `updateTime`,`fl`.`createtime` AS `createTime`,`fl`.`objState` AS `objState` from (`netapp_model`.`fcp_lif` `fl` join `netapp_model`.`lif` `l` on((`fl`.`objid` = `l`.`objid`)))