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