Constraints

25 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_attrcidr_attr

attribute_cidr.attribute_id

attribute.id

Restrict delete

fk_attrcidr_attrtype

attribute_cidr.attributetype_id

attributetype.id

Restrict delete

fk_dataviewlinks_dv

dataview_link.dataview_id

dataview.id

Restrict delete

fk_dataviewlinks_ln

dataview_link.link_id

dataview.id

Restrict delete

fk_zone_org

zone.organization_id

organization.id

Restrict delete

fk_apikey_user

user_apikey.user_id

user.id

Cascade on delete

fk_ad_role

admap.role_id

role.id

Cascade on delete

fk_role_org

role.organization_id

organization.id

Cascade on delete

fk_interface_system

interface.system_id

system.id

Cascade on delete

fk_dashboard_user

dashboard.user_id

user.id

Cascade on delete

fk_dataview_user

dataview.user_id

user.id

Cascade on delete

fk_feed_id

feed_config.feed_id

feed.id

Restrict delete

fk_displayinfo_system

displayinfo.system_id

system.id

Cascade on delete

fk_attr_attrtype

attribute.attributetype_id

attributetype.id

Restrict delete

fk_nsubscription_policy

notificationsubscription.notificationpolicy_id

notificationpolicy.id

Restrict delete

fk_nsubscription_zone

notificationsubscription.zone_id

zone.id

Cascade on delete

fk_nsubscription_user

notificationsubscription.user_id

user.id

Cascade on delete

fk_session_user

session.user_id

user.id

Cascade on delete

fk_cert_user

user_certificate.user_id

user.id

Cascade on delete

fk_collector_extdnsintf

collector.externaldnsinterface_id

interface.id

Null on delete

fk_collector_leakintf

collector.leakinterface_id

interface.id

Null on delete

fk_collector_intf

collector.interface_id

interface.id

Null on delete

fk_collector_zone

collector.zone_id

zone.id

Restrict delete

fk_ur_user

user_role.user_id

user.id

Cascade on delete

fk_ur_role

user_role.role_id

role.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
None detected