View netapp_model_view.network_firewall_policy_service_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 firewall policy service. DERIVED from {VserverUUID}.{policy name}.{service}
resourceKey varchar 512
service varchar 255 The name of the network firewall policy service.
vserverId bigint 19
clusterId bigint 19
firewallPolicyId bigint 19
allowedIpAddresses text 65535  √  null Specifies the list of client IPs that are permitted to access the specified service running on LIFs with the specified policy and network service
serviceType enum 10  √  null Specifies the network service that is associated with the firewall policy.
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_firewall_policy_service`.`objid` AS `objid`,`netapp_model`.`network_firewall_policy_service`.`uuid` AS `uuid`,`netapp_model`.`network_firewall_policy_service`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_firewall_policy_service`.`service` AS `service`,`netapp_model`.`network_firewall_policy_service`.`vserverId` AS `vserverId`,`netapp_model`.`network_firewall_policy_service`.`clusterId` AS `clusterId`,`netapp_model`.`network_firewall_policy_service`.`firewallPolicyId` AS `firewallPolicyId`,`netapp_model`.`network_firewall_policy_service`.`allowedIpAddresses` AS `allowedIpAddresses`,`netapp_model`.`network_firewall_policy_service`.`serviceType` AS `serviceType`,`netapp_model`.`network_firewall_policy_service`.`createtime` AS `createTime`,`netapp_model`.`network_firewall_policy_service`.`updatetime` AS `updateTime`,`netapp_model`.`network_firewall_policy_service`.`objState` AS `objState` from `netapp_model`.`network_firewall_policy_service`