View netapp_model_view.iscsi_portal_group_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: iscsi-tpgroup-get-iter.iscsi-tpgroup-list-entry-info
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
targetPortalGroupId bigint 19
lifId bigint 19
interfaceName varchar 255  √  null Name of the interface
ipAddress varchar 255  √  null iSCSI target portal IP address
ipPort varchar 255  √  null iSCSI target portal TCP port
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`.`iscsi_portal_group_lif`.`objid` AS `objid`,`netapp_model`.`iscsi_portal_group_lif`.`resourceKey` AS `resourceKey`,`netapp_model`.`iscsi_portal_group_lif`.`clusterId` AS `clusterId`,`netapp_model`.`iscsi_portal_group_lif`.`vserverId` AS `vserverId`,`netapp_model`.`iscsi_portal_group_lif`.`targetPortalGroupId` AS `targetPortalGroupId`,`netapp_model`.`iscsi_portal_group_lif`.`lifId` AS `lifId`,`netapp_model`.`iscsi_portal_group_lif`.`interfaceName` AS `interfaceName`,`netapp_model`.`iscsi_portal_group_lif`.`ipAddress` AS `ipAddress`,`netapp_model`.`iscsi_portal_group_lif`.`ipPort` AS `ipPort`,`netapp_model`.`iscsi_portal_group_lif`.`createtime` AS `createTime`,`netapp_model`.`iscsi_portal_group_lif`.`updatetime` AS `updateTime`,`netapp_model`.`iscsi_portal_group_lif`.`objState` AS `objState` from `netapp_model`.`iscsi_portal_group_lif`