View netapp_model_view.network_failover_group_network_port_relationship 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 relationship identifier.
originid bigint 19
uuid varchar 255 The uuid of this relationship. DERIVED:{NetworkFailoverGroupUUID}.{NetworkPortUUID}
resourceKey varchar 512
clusterId bigint 19
networkFailoverGroupId bigint 19
networkPortId bigint 19
createTime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_failover_group_network_port_relationship`.`objid` AS `objid`,`netapp_model`.`network_failover_group_network_port_relationship`.`originid` AS `originid`,`netapp_model`.`network_failover_group_network_port_relationship`.`uuid` AS `uuid`,`netapp_model`.`network_failover_group_network_port_relationship`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_failover_group_network_port_relationship`.`clusterId` AS `clusterId`,`netapp_model`.`network_failover_group_network_port_relationship`.`networkFailoverGroupId` AS `networkFailoverGroupId`,`netapp_model`.`network_failover_group_network_port_relationship`.`networkPortId` AS `networkPortId`,`netapp_model`.`network_failover_group_network_port_relationship`.`createtime` AS `createTime`,`netapp_model`.`network_failover_group_network_port_relationship`.`updatetime` AS `updatetime` from `netapp_model`.`network_failover_group_network_port_relationship` where (`netapp_model`.`network_failover_group_network_port_relationship`.`objState` = 'LIVE')