View netapp_model_view.network_route_lif 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-routes-lif, DERIVED from {network_route_uuid}.{lif_uuid}
resourceKey varchar 255
clusterId bigint 19 Foreign key to the cluster table.
networkRouteId bigint 19  √  null Foregin key to network-route table.
lifId bigint 19 Foreign key to lif table.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_route_lif`.`objid` AS `objid`,`netapp_model`.`network_route_lif`.`originid` AS `originid`,`netapp_model`.`network_route_lif`.`uuid` AS `uuid`,`netapp_model`.`network_route_lif`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_route_lif`.`clusterId` AS `clusterId`,`netapp_model`.`network_route_lif`.`networkRouteId` AS `networkRouteId`,`netapp_model`.`network_route_lif`.`lifId` AS `lifId`,`netapp_model`.`network_route_lif`.`createtime` AS `createTime`,`netapp_model`.`network_route_lif`.`updatetime` AS `updateTime` from `netapp_model`.`network_route_lif` where (`netapp_model`.`network_route_lif`.`objState` = 'LIVE')