View netapp_model_view.network_firewall_policy 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 firewall policy. DERIVED from {VserverUUID}.{policy name}
resourceKey varchar 512
name varchar 255 The name of the network firewall policy.
vserverId bigint 19
clusterId bigint 19
ipspace varchar 255  √  null Specifies the ipspace of the vserver for which the policy is defined.
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_firewall_policy`.`objid` AS `objid`,`netapp_model`.`network_firewall_policy`.`uuid` AS `uuid`,`netapp_model`.`network_firewall_policy`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_firewall_policy`.`name` AS `name`,`netapp_model`.`network_firewall_policy`.`vserverId` AS `vserverId`,`netapp_model`.`network_firewall_policy`.`clusterId` AS `clusterId`,`netapp_model`.`network_firewall_policy`.`ipspace` AS `ipspace`,`netapp_model`.`network_firewall_policy`.`createtime` AS `createTime`,`netapp_model`.`network_firewall_policy`.`updatetime` AS `updateTime` from `netapp_model`.`network_firewall_policy` where (`netapp_model`.`network_firewall_policy`.`objState` = 'LIVE')