View netapp_model_view.fcp_lif_derived 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
clusterId bigint 19
vserverId bigint 19
currentPortId bigint 19  √  null
homePortId bigint 19  √  null
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
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`fcp_lif`.`objid` AS `objid`,`netapp_model`.`fcp_lif`.`uuid` AS `uuid`,`netapp_model`.`fcp_lif`.`resourceKey` AS `resourcekey`,`netapp_model`.`fcp_lif`.`clusterId` AS `clusterId`,`netapp_model`.`fcp_lif`.`vserverId` AS `vserverId`,`netapp_model`.`fcp_lif`.`currentPortId` AS `currentPortId`,`netapp_model`.`fcp_lif`.`homePortId` AS `homePortId`,`netapp_model`.`fcp_lif`.`nodeName` AS `nodeName`,`netapp_model`.`fcp_lif`.`portName` AS `portName`,`netapp_model`.`fcp_lif`.`createtime` AS `createTime`,`netapp_model`.`fcp_lif`.`updatetime` AS `updateTime` from `netapp_model`.`fcp_lif` where (`netapp_model`.`fcp_lif`.`objState` = 'LIVE')