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 |