View netapp_model_view.network_route 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.
originid bigint 19
uuid varchar 255 A unique identifier of net-vs-route, DERIVED from {destination}.{gateway}.{vserver_uuid}.
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table.
addressFamily enum 10  √  null Address family of the route.
addressFamilyRaw varchar 255  √  null Address family of the route raw value.
destination varchar 255  √  null Specify the route destination.
gateway varchar 255  √  null Specify the route gateway.
metric bigint 19  √  null Specify the route metric.
vserverId bigint 19  √  null Foreign key to vserver table.
createtime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_route`.`objid` AS `objid`,`netapp_model`.`network_route`.`originid` AS `originid`,`netapp_model`.`network_route`.`uuid` AS `uuid`,`netapp_model`.`network_route`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_route`.`clusterId` AS `clusterId`,`netapp_model`.`network_route`.`addressFamily` AS `addressFamily`,`netapp_model`.`network_route`.`addressFamilyRaw` AS `addressFamilyRaw`,`netapp_model`.`network_route`.`destination` AS `destination`,`netapp_model`.`network_route`.`gateway` AS `gateway`,`netapp_model`.`network_route`.`metric` AS `metric`,`netapp_model`.`network_route`.`vserverId` AS `vserverId`,`netapp_model`.`network_route`.`createtime` AS `createtime`,`netapp_model`.`network_route`.`updatetime` AS `updatetime` from `netapp_model`.`network_route` where (`netapp_model`.`network_route`.`objState` = 'LIVE')