observer Database

65 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_trace_collector

path.collector_id

collector.id

Restrict delete

fk_target_collector

target.collector_id

collector.id

Cascade on delete

fk_target_scantype

target.scantype_id

scantype.id

Restrict delete

fk_target_route

target.route_id

route.id

Cascade on delete

fk_target_cidr

target.cidr_id

attribute_cidr.id

Cascade on delete

fk_target_device

target.device_id

device.id

Cascade on delete

fk_profiledata_type

profiledata.type_id

profiledatatype.id

Restrict delete

fk_cloudalias_collector

cloudalias.collector_id

collector.id

Restrict delete

fk_iftvl_ift

iftable_vlan.iftable_id

iftable.id

Cascade on delete

fk_device_match_device

device_match.device_id

device.id

Cascade on delete

fk_cert_subject

certificate.subject_id

certificatepath.id

Restrict delete

fk_cert_issuer

certificate.issuer_id

certificatepath.id

Restrict delete

fk_pd_pattern_pd

profiledata_pattern.profiledata_id

profiledata.id

Cascade on delete

fk_ifaddr_intf_intf

interface_address.interface_id

interface.id

Cascade on delete

fk_zconfig_collector

config.collector_id

collector.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_wmialias_collector

wmialias.collector_id

collector.id

Restrict delete

fk_interface_tbl

interface.iftable_id

iftable.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_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_link_dev1

link.device_id1

device.id

Cascade on 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_acknowledgeddevices_user

acknowledgeddevice.user_id

user.id

Cascade on 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_device_ports_device

device_ports.device_id

device.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_attr_attrtype

attribute.attributetype_id

attributetype.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_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_device_device

device.device_id

device.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_certpath_pattern_certpath

certificatepath_pattern.certificatepath_id

certificatepath.id

Cascade on delete

fk_rspdscn_iftable_id

response_decision.iftable_id

iftable.id

Cascade on 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_device

device_response.device_id

device.id

Cascade on delete

fk_device_response_collector

device_response.collector_id

collector.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_device_pattern_device

device_pattern.device_id

device.id

Cascade on delete

fk_map_user

map.user_id

user.id

Cascade on 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