View netapp_model_view.network_vlan_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
uuid varchar 255 The uuid of the network vlan.
resourceKey varchar 512
vlanId bigint 19 The vlan id.
nodeId bigint 19
portId bigint 19
clusterId bigint 19
interfaceName varchar 255  √  null Name of vlan interface.
isGvrpEnabled bit 0  √  null GVRP is a standard vlan trunking protocol that enables a port to advertise which vlans it trunks, thereby decreasing traffic over the trunk
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_vlan`.`objid` AS `objid`,`netapp_model`.`network_vlan`.`uuid` AS `uuid`,`netapp_model`.`network_vlan`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_vlan`.`vlanId` AS `vlanId`,`netapp_model`.`network_vlan`.`nodeId` AS `nodeId`,`netapp_model`.`network_vlan`.`portId` AS `portId`,`netapp_model`.`network_vlan`.`clusterId` AS `clusterId`,`netapp_model`.`network_vlan`.`interfaceName` AS `interfaceName`,`netapp_model`.`network_vlan`.`isGvrpEnabled` AS `isGvrpEnabled`,`netapp_model`.`network_vlan`.`createtime` AS `createTime`,`netapp_model`.`network_vlan`.`updatetime` AS `updateTime` from `netapp_model`.`network_vlan` where (`netapp_model`.`network_vlan`.`objState` = 'LIVE')