SchemaSpy Analysis of SIEM.public - ConstraintsWe recommend you use the Views and not the Tables for any reports you write Generated by
SchemaSpy
88 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
actvy_parm_fk1 actvy_parm.actvy_id actvy.actvy_id Restrict delete 
actvy_ref_fk1 actvy_ref.actvy_id actvy.actvy_id Restrict delete 
actvy_ref_fk2 actvy_ref.refd_actvy_id actvy.actvy_id Restrict delete 
actvy_ref_parm_val_fk1 actvy_ref_parm_val.actvy_parm_id actvy_parm.actvy_parm_id Restrict delete 
actvy_ref_parm_val_fk2 actvy_ref_parm_val.actvy_id
actvy_ref_parm_val.seq_num
actvy_ref.actvy_id
actvy_ref.seq_num
Restrict delete 
adv_nxs_kb_patch_osvdb_id_fkey adv_nxs_kb_patch.osvdb_id adv_nxs_osvdb_details.osvdb_id Restrict delete 
adv_nxs_kb_productsref_osvdb_id_fkey adv_nxs_kb_productsref.osvdb_id adv_nxs_osvdb_details.osvdb_id Restrict delete 
adv_nxs_mappings_source_fkey adv_nxs_mappings.source_product_id
adv_nxs_mappings.source_signature_id
adv_nxs_signatures.product_id
adv_nxs_signatures.signature_id
Restrict delete 
adv_nxs_mappings_target_fkey adv_nxs_mappings.target_product_id
adv_nxs_mappings.target_signature_id
adv_nxs_signatures.product_id
adv_nxs_signatures.signature_id
Restrict delete 
adv_nxs_sign_product_id_fkey adv_nxs_signatures.product_id adv_nxs_products.product_id Restrict delete 
asset_fk1 asset.physical_asset_id physical_asset.physical_asset_id Restrict delete 
asset_fk2 asset.asset_ctgry_id asset_ctgry.asset_ctgry_id Restrict delete 
asset_fk3 asset.asset_val_id asset_val_lkup.asset_val_id Restrict delete 
asset_fk4 asset.crit_id crit_lkup.crit_id Restrict delete 
asset_fk5 asset.sensitivity_id sensitivity_lkup.sensitivity_id Restrict delete 
asset_fk6 asset.prdt_id prdt.prdt_id Restrict delete 
asset_fk7 asset.env_identity_id env_identity_lkup.env_identity_id Restrict delete 
asset_ip_fk1 asset_ip.physical_asset_id physical_asset.physical_asset_id Restrict delete 
asset_x_entity_x_role_fk1 asset_x_entity_x_role.asset_id asset.asset_id Restrict delete 
asset_x_entity_x_role_fk2 asset_x_entity_x_role.person_id person.person_id Restrict delete 
asset_x_entity_x_role_fk3 asset_x_entity_x_role.organization_id organization.organization_id Restrict delete 
asset_x_entity_x_role_fk4 asset_x_entity_x_role.role_cd role_lkup.role_cd Restrict delete 
asset_x_entity_x_role_fk5 asset_x_entity_x_role.entity_typ_cd entity_typ_lkup.entity_typ_cd Restrict delete 
console_slms_user_group_id_fk console_slms.user_group_id user_groups.group_id Null on delete 
corr_act_def_id_fk corr_act_parm.corr_act_def_id corr_act_def.corr_act_def_id Restrict delete 
corr_act_parm_def_fk corr_act_parm_def.corr_act_meta_id corr_act_meta.corr_act_meta_id Restrict delete 
corr_act_parm_def_id_fk corr_act_parm.corr_act_parm_def_id corr_act_parm_def.corr_act_parm_def_id Restrict delete 
corr_deploy_config_fk corr_deploy_config.corr_engine_config_id corr_engine_config.corr_engine_config_id Restrict delete 
corr_engine_config_rule_fk corr_rule_cfg.corr_engine_config_id corr_engine_config.corr_engine_config_id Restrict delete 
corr_rule_cfg_fk corr_rule_cfg.corr_deploy_config_id corr_deploy_config.corr_deploy_config_id Restrict delete 
esec_content_grp_ctrl_id_fk1 esec_content_grp.ctrl_id esec_ctrl.ctrl_id Restrict delete 
esec_content_grp_fk1 esec_content_grp_content.content_grp_id esec_content_grp.content_grp_id Restrict delete 
esec_content_grp_fk2 esec_content_grp_content.content_id
esec_content_grp_content.content_typ
esec_content.content_id
esec_content.content_typ
Restrict delete 
esec_ctrl_cagry_id_fk1 esec_ctrl.ctrl_ctgry_id esec_ctrl_ctgry.ctrl_ctgry_id Restrict delete 
esec_ctrl_cgry_id_fk1 esec_ctrl_ctgry.content_pack_id esec_content_pack.content_pack_id Restrict delete 
esec_protocol_esec_port_fk esec_port_reference.protocol_number esec_protocol_reference.protocol_number Restrict delete 
event_source_id_fk tag_event_source_association.event_source_id evt_src.evt_src_id Restrict delete 
event_source_server_id_fk tag_event_source_server_association.event_source_server_id evt_src_srvr.evt_src_srvr_id Restrict delete 
event_src_manager_id_fk tag_event_src_manager_association.event_src_manager_id evt_src_mgr.evt_src_mgr_id Restrict delete 
evt_src_collector_mgr_id_fk evt_src_collector.evt_src_mgr_id evt_src_mgr.evt_src_mgr_id Restrict delete 
evt_src_collector_plugin_fk evt_src_collector.sentinel_plugin_id sentinel_plugin.sentinel_plugin_id Restrict delete 
evt_src_fk evt_src.evt_src_grp_id evt_src_grp.evt_src_grp_id Restrict delete 
evt_src_grp_collector_id_fk evt_src_grp.evt_src_collector_id evt_src_collector.evt_src_collector_id Restrict delete 
evt_src_grp_evt_src_srvr_fk evt_src_grp.evt_src_srvr_id evt_src_srvr.evt_src_srvr_id Restrict delete 
evt_src_grp_plugin_id_fk evt_src_grp.sentinel_plugin_id sentinel_plugin.sentinel_plugin_id Restrict delete 
evt_src_mgr_fk evt_src_mgr.sentinel_id sentinel.sentinel_id Restrict delete 
evt_src_mgr_sent_host_fk evt_src_mgr.sentinel_host_id sentinel_host.sentinel_host_id Restrict delete 
evt_src_offset_fk evt_src_offset.evt_src_id evt_src.evt_src_id Restrict delete 
evt_src_srvr_mgr_id_fk evt_src_srvr.evt_src_mgr_id evt_src_mgr.evt_src_mgr_id Restrict delete 
evt_src_srvr_plugin_fk evt_src_srvr.sentinel_plugin_id sentinel_plugin.sentinel_plugin_id Restrict delete 
filters_user_owner_id_fk filters.user_owner_id users.usr_id Cascade on delete 
fk_trusttype_trust usr_account_trust.trust_type_id usr_trust_type.trust_type_id Restrict delete 
fk_usridty_extattr usr_identity_ext_attr.identity_guid usr_identity.identity_guid Restrict delete 
fk_usridty_usracct usr_account.identity_guid usr_identity.identity_guid Restrict delete 
global_filter_corr_action_association_filter_id_fk global_filter_corr_action_association.filter_id global_filters.filter_id Restrict delete 
global_filter_corr_action_association_tag_name_fk global_filter_corr_action_association.corr_act_def_id corr_act_def.corr_act_def_id Restrict delete 
inc_inc_evt_fk incidents_events.inc_id incidents.inc_id Restrict delete 
int_ste_fk incidents.stt_id states.stt_id Restrict delete 
integrator_config_plugin_fk integrator_config.plugin_id sentinel_plugin.sentinel_plugin_id Restrict delete 
physical_asset_fk1 physical_asset.loc_id asset_loc.loc_id Restrict delete 
physical_asset_fk2 physical_asset.network_identity_id network_identity_lkup.network_identity_id Restrict delete 
plugin_id_fk tag_plugin_association.plugin_id sentinel_plugin.sentinel_plugin_id Restrict delete 
prdt_fk1 prdt.vndr_id vndr.vndr_id Restrict delete 
ret_pol_id_fk ixlog_part.ret_pol_id md_config.config_id Restrict delete 
sentinel_host_sen_id_fk sentinel_host.sentinel_id sentinel.sentinel_id Restrict delete 
tag_global_filter_association_filter_id_pk tag_global_filter_association.filter_id global_filters.filter_id Restrict delete 
tag_global_filter_association_tag_name_pk tag_global_filter_association.tag_name tags.tag_name Restrict delete 
tag_name_fk tag_event_source_association.tag_name tags.tag_name Restrict delete 
user_group_mappings_user_group_id_fk user_group_mappings.user_group_id user_groups.group_id Cascade on delete 
user_group_mappings_user_id_fk user_group_mappings.user_id users.usr_id Cascade on delete 
user_group_permissions_perm_name_fk user_group_permissions.perm_name permissions.perm_name Cascade on delete 
user_group_permissions_user_group_id_fk user_group_permissions.user_group_id user_groups.group_id Cascade on delete 
user_group_tags_tag_name_fk user_group_tags.tag_name tags.tag_name Cascade on delete 
user_group_tags_user_group_id_fk user_group_tags.user_group_id user_groups.group_id Cascade on delete 
user_report_state_plugin_fk esec_user_report_state.report_id sentinel_plugin.sentinel_plugin_id Cascade on delete 
user_report_state_user_fk esec_user_report_state.user_id users.usr_id Cascade on delete 
user_tag_tag_fk user_tag_state.tag_name tags.tag_name Cascade on delete 
user_tag_user_fk user_tag_state.user_id users.usr_id Cascade on delete 
usr_stt_fk users.stt_id states.stt_id Restrict delete 
vuln_rsrc_vuln_fk vuln.rsrc_id vuln_rsrc.rsrc_id Restrict delete 
vuln_rsrc_vuln_rsrc_scan_fk vuln_rsrc_scan.rsrc_id vuln_rsrc.rsrc_id Restrict delete 
vuln_scan_vuln_rsrc_scan_fk vuln_rsrc_scan.scan_id vuln_scan.scan_id Restrict delete 
vuln_scan_vuln_scan_vuln_fk vuln_scan_vuln.scan_id vuln_scan.scan_id Restrict delete 
vuln_scanner_vuln_rsrc_fk vuln_rsrc.scanner_id vuln_scanner.scanner_id Restrict delete 
vuln_scanner_vuln_scan_fk vuln_scan.scanner_id vuln_scanner.scanner_id Restrict delete 
vuln_vuln_code_fk vuln_code.vuln_id vuln.vuln_id Restrict delete 
vuln_vuln_info_fk vuln_info.vuln_id vuln.vuln_id Restrict delete 
vuln_vuln_scan_vuln_fk vuln_scan_vuln.vuln_id vuln.vuln_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected