View ocum.routinggrouproutesview 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
id bigint 19
route varchar 255  √  null The IP address and subnet mask of destination
gateway varchar 255  √  null The IP address and subnet mask of destination
routingGroupId bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryroutes`.`objid` AS `id`,`inventoryroutes`.`destinationAddress` AS `route`,`inventoryroutes`.`gatewayAddress` AS `gateway`,`inventoryroutinggroup`.`objid` AS `routingGroupId` from (`netapp_model_view`.`routing_group_destination` `inventoryroutes` left join `netapp_model_view`.`routing_group` `inventoryroutinggroup` on((`inventoryroutinggroup`.`objid` = `inventoryroutes`.`routingGroupId`)))