Constraints

108 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_attrcidr_collector
attribute_cidr.collector_id
collector.id
Restrict delete
fk_attrcidr_attr
attribute_cidr.attribute_id
attribute.id
Restrict delete
fk_attrcidr_attrtype
attribute_cidr.attributetype_id
attributetype.id
Restrict delete
fk_attrcidr_zone
attribute_cidr.zone_id
zone.id
Restrict delete
fk_trace_zone
path.zone_id
zone.id
Restrict delete
fk_trace_collector
path.collector_id
collector.id
Restrict delete
fk_target_collector
target.collector_id
collector.id
Cascade on delete
fk_target_route
target.route_id
route.id
Cascade on delete
fk_target_scantype
target.scantype_id
scantype.id
Restrict delete
fk_target_cidr
target.cidr_id
attribute_cidr.id
Cascade on delete
fk_target_zone
target.zone_id
zone.id
Restrict delete
fk_target_device
target.device_id
device.id
Cascade on delete
fk_route_zone
route.zone_id
zone.id
Restrict delete
fk_cloudalias_collector
cloudalias.collector_id
collector.id
Restrict delete
fk_cloudalias_zone
cloudalias.zone_id
zone.id
Restrict delete
fk_iftvl_ift
iftable_vlan.iftable_id
iftable.id
Restrict delete
fk_iftvl_zone
iftable_vlan.zone_id
zone.id
Restrict delete
fk_device_match_type
device_match.type_id
type.id
Restrict delete
fk_device_match_device
device_match.device_id
device.id
Cascade on delete
fk_device_match_zone
device_match.zone_id
zone.id
Restrict delete
fk_device_match_attribute
device_match.attribute_id
attribute.id
Restrict delete
fk_mapnode_zone
mapnode.zone_id
zone.id
Restrict delete
fk_pd_pattern_pattern
profiledata_pattern.pattern_id
pattern.id
Cascade on delete
fk_pd_pattern_pd
profiledata_pattern.profiledata_id
profiledata.id
Cascade on delete
fk_zconfig_collector
config.collector_id
collector.id
Restrict delete
fk_zconfig_zone
config.zone_id
zone.id
Restrict delete
fk_interface_tbl
interface.iftable_id
iftable.id
Restrict delete
fk_interface_zone
interface.zone_id
zone.id
Restrict delete
fk_dev_cert_cert
device_certificate.certificate_id
certificate.id
Cascade on delete
fk_dev_cert_dev
device_certificate.device_id
device.id
Cascade on delete
fk_me_zone
edge.zone_id
zone.id
Restrict delete
fk_dev_pd_data
device_profiledata.profiledata_id
profiledata.id
Cascade on delete
fk_dev_pd_dev
device_profiledata.device_id
device.id
Cascade on delete
fk_dev_pd_datat
device_profiledata.type_id
profiledatatype.id
Cascade on delete
fk_attr_zone
attribute.zone_id
zone.id
Restrict delete
fk_attr_attrtype
attribute.attributetype_id
attributetype.id
Restrict delete
fk_nackcandidate_zone
nackcandidate.zone_id
zone.id
Restrict delete
fk_device_device
device.device_id
device.id
Restrict delete
fk_device_zone
device.zone_id
zone.id
Restrict delete
fk_device_macvendor
device.macvendor_id
macvendor.id
Null on delete
fk_device_iftable
device.iftable_id
iftable.id
Restrict delete
fk_device_response_scantype
device_response.scantype_id
scantype.id
Restrict delete
fk_device_response_protocol
device_response.protocol_id
protocol.id
Restrict delete
fk_device_response_zone
device_response.zone_id
zone.id
Restrict delete
fk_device_response_device
device_response.device_id
device.id
Cascade on delete
fk_device_response_collector
device_response.collector_id
collector.id
Restrict delete
fk_map_user
map.user_id
user.id
Cascade on delete
fk_profiledata_type
profiledata.type_id
profiledatatype.id
Restrict delete
fk_profiledata_zone
profiledata.zone_id
zone.id
Restrict delete
fk_cert_subject
certificate.subject_id
certificatepath.id
Restrict delete
fk_certificate_zone
certificate.zone_id
zone.id
Restrict delete
fk_cert_issuer
certificate.issuer_id
certificatepath.id
Restrict delete
fk_ifaddr_intf_intf
interface_address.interface_id
interface.id
Cascade on delete
fk_ifaddr_zone
interface_address.zone_id
zone.id
Restrict delete
fk_ifha_zone
interface_host.zone_id
zone.id
Restrict delete
fk_ifha_intf
interface_host.interface_id
interface.id
Cascade on delete
fk_ifha_dev
interface_host.device_id
device.id
Cascade on delete
fk_profile_translate_type
profile_translation.type_id
type.id
Restrict delete
fk_profile_translate_zone
profile_translation.zone_id
zone.id
Restrict delete
fk_profile_translate_attr
profile_translation.attribute_id
attribute.id
Restrict delete
fk_profile_translate_newattr
profile_translation.newattribute_id
attribute.id
Restrict delete
fk_linkset_zone
linkset.zone_id
zone.id
Restrict delete
fk_wmialias_collector
wmialias.collector_id
collector.id
Restrict delete
fk_wmialias_zone
wmialias.zone_id
zone.id
Restrict delete
fk_devattr_zone
device_attribute.zone_id
zone.id
Restrict delete
fk_devattr_attr
device_attribute.attribute_id
attribute.id
Restrict delete
fk_devattr_dev
device_attribute.device_id
device.id
Cascade on delete
fk_devattr_attrtype
device_attribute.attributetype_id
attributetype.id
Restrict delete
fk_link_dev1
link.device_id1
device.id
Cascade on delete
fk_link_zone
link.zone_id
zone.id
Restrict delete
fk_link_set
link.linkset_id
linkset.id
Restrict delete
fk_link_dev2
link.device_id2
device.id
Cascade on delete
fk_devval_dev
device_values.device_id
device.id
Cascade on delete
fk_devval_zone
device_values.zone_id
zone.id
Restrict delete
fk_acknowledgeddevices_user
acknowledgeddevice.user_id
user.id
Cascade on delete
fk_device_ports_device
device_ports.device_id
device.id
Cascade on delete
fk_device_ports_zone
device_ports.zone_id
zone.id
Restrict delete
fk_macvendor_pattern_pattern
macvendor_pattern.pattern_id
pattern.id
Cascade on delete
fk_macvendor_pattern_macvendor
macvendor_pattern.macvendor_id
macvendor.id
Cascade on delete
fk_device_alias_alias
device_snmpalias.snmpalias_id
snmpalias.id
Cascade on delete
fk_device_alias_device
device_snmpalias.device_id
device.id
Cascade on delete
fk_device_alias_zone
device_snmpalias.zone_id
zone.id
Restrict delete
fk_device_cloud_alias_zone
device_cloudalias.zone_id
zone.id
Restrict delete
fk_device_cloud_alias_device
device_cloudalias.device_id
device.id
Cascade on delete
fk_device_cloud_alias_alias
device_cloudalias.cloudalias_id
cloudalias.id
Cascade on delete
fk_target_hp_device
target_highpriority.device_id
device.id
Cascade on delete
fk_target_hp_route
target_highpriority.route_id
route.id
Cascade on delete
fk_target_hp_target
target_highpriority.target_id
target.id
Cascade on delete
fk_target_hp_zone
target_highpriority.zone_id
zone.id
Restrict delete
fk_target_hp_scantype
target_highpriority.scantype_id
scantype.id
Restrict delete
fk_target_hp_collector
target_highpriority.collector_id
collector.id
Cascade on delete
fk_target_hp_cidr
target_highpriority.cidr_id
attribute_cidr.id
Cascade on delete
fk_certpath_pattern_certpath
certificatepath_pattern.certificatepath_id
certificatepath.id
Cascade on delete
fk_certpath_pattern_pattern
certificatepath_pattern.pattern_id
pattern.id
Cascade on delete
fk_iftable_zone
iftable.zone_id
zone.id
Restrict delete
fk_certificatepath_zone
certificatepath.zone_id
zone.id
Restrict delete
fk_device_wmi_alias_zone
device_wmialias.zone_id
zone.id
Restrict delete
fk_device_wmi_alias_alias
device_wmialias.wmialias_id
wmialias.id
Cascade on delete
fk_device_wmi_alias_device
device_wmialias.device_id
device.id
Cascade on delete
fk_snmpalias_collector
snmpalias.collector_id
collector.id
Restrict delete
fk_snmpalias_zone
snmpalias.zone_id
zone.id
Restrict delete
fk_device_pattern_device
device_pattern.device_id
device.id
Cascade on delete
fk_device_pattern_zone
device_pattern.zone_id
zone.id
Cascade on delete
fk_intf_route_zone
interface_route.zone_id
zone.id
Restrict delete
fk_intf_route_route
interface_route.route_id
route.id
Cascade on delete
fk_intf_route_protocol
interface_route.routeprotocol_id
routeprotocol.id
Restrict delete
fk_intf_route_type
interface_route.routetype_id
routetype.id
Restrict delete
fk_intf_route_interface
interface_route.interface_id
interface.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected