View netapp_model_view.portset_to_port_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: portset-get-iter.portset-info.portset-port-info
portsetId bigint 19 Locally unique object identifier. ZAPIs: portset-get-iter.portset-info
portsetUUID varchar 255 Globally unique ID of the portset. DERIVED as the {vserverUUID}.{portset name}
clusterId bigint 19
vserverId bigint 19
portName varchar 255 String representing a member of a portset. In Data ONTAP Cluster-Mode, the port name is the name of an FCP data lif or iSCSI target portal group
fcpLifId bigint 19  √  null for fcp port, show objid in fcp_lif table; otherwise show null
iSCSIPortalGroupId bigint 19  √  null for iscsi port, show objid in iscsi_portal_group table; otherwise show null
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 `p`.`objid` AS `objid`,`ps`.`objid` AS `portsetId`,`ps`.`uuid` AS `portsetUUID`,`ps`.`clusterId` AS `clusterId`,`ps`.`vserverId` AS `vserverId`,`p`.`name` AS `portName`,`p`.`fcpLifId` AS `fcpLifId`,`p`.`iSCSIPortalGroupId` AS `iSCSIPortalGroupId`,`p`.`createtime` AS `createTime`,`p`.`updatetime` AS `updateTime`,`p`.`objState` AS `objState` from (`netapp_model`.`portset` `ps` join `netapp_model`.`portset_port` `p` on((`ps`.`objid` = `p`.`portsetId`)))