View netapp_model_view.iscsi_portal_group 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-port-get-iter.net-port-info
uuid varchar 255 Globally unique ID of the iSCSI Portal Group equivalent to "{clusterUUID}.{VserverUUID}.{portalGroupName}". This is not returned from ZAPI
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
name varchar 255 Textual name
tag int 10  √  null
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`iscsi_portal_group`.`objid` AS `objid`,`netapp_model`.`iscsi_portal_group`.`uuid` AS `uuid`,`netapp_model`.`iscsi_portal_group`.`resourceKey` AS `resourceKey`,`netapp_model`.`iscsi_portal_group`.`clusterId` AS `clusterId`,`netapp_model`.`iscsi_portal_group`.`vserverId` AS `vserverId`,`netapp_model`.`iscsi_portal_group`.`name` AS `name`,`netapp_model`.`iscsi_portal_group`.`tag` AS `tag`,`netapp_model`.`iscsi_portal_group`.`createtime` AS `createTime`,`netapp_model`.`iscsi_portal_group`.`updatetime` AS `updateTime` from `netapp_model`.`iscsi_portal_group` where (`netapp_model`.`iscsi_portal_group`.`objState` = 'LIVE')