View netapp_model_view.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. Not available in ZAPI. Uses {VserverUUID}.{LIFName}
name varchar 255 Textual name
clusterId bigint 19
vserverId bigint 19
currentNodeId bigint 19  √  null
homeNodeId bigint 19  √  null
lifType enum 12 Lif type
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
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
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`lif`.`objid` AS `objid`,`netapp_model`.`lif`.`uuid` AS `uuid`,`netapp_model`.`lif`.`name` AS `name`,`netapp_model`.`lif`.`clusterId` AS `clusterId`,`netapp_model`.`lif`.`vserverId` AS `vserverId`,`netapp_model`.`lif`.`currentNodeId` AS `currentNodeId`,`netapp_model`.`lif`.`homeNodeId` AS `homeNodeId`,`netapp_model`.`lif`.`lifType` AS `lifType`,`netapp_model`.`lif`.`isAutoRevert` AS `isAutoRevert`,`netapp_model`.`lif`.`isHome` AS `isHome`,`netapp_model`.`lif`.`operationalStatus` AS `operationalStatus`,`netapp_model`.`lif`.`operationalStatusRaw` AS `operationalStatusRaw`,`netapp_model`.`lif`.`administrativeStatus` AS `administrativeStatus`,`netapp_model`.`lif`.`administrativeStatusRaw` AS `administrativeStatusRaw`,`netapp_model`.`lif`.`role` AS `role`,`netapp_model`.`lif`.`roleRaw` AS `roleRaw`,`netapp_model`.`lif`.`dataProtocols` AS `dataProtocols`,`netapp_model`.`lif`.`failoverGroupId` AS `failoverGroupId`,`netapp_model`.`lif`.`createtime` AS `createTime`,`netapp_model`.`lif`.`updatetime` AS `updateTime`,`netapp_model`.`lif`.`objState` AS `objState` from `netapp_model`.`lif`