SchemaSpy Analysis of ESEC.ESECDBA - ConstraintsSentinel Reporting Views | Generated by SchemaSpy |
71 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_ATTACK_ADV_VULN_PROD_FK | ADV_VULN_PRODUCT.ATTACK_ID | ADV_ATTACK.ATTACK_ID | Restrict delete |
ADV_PROD_ADV_PROD_VER_FK | ADV_PRODUCT_VERSION.PRODUCT_ID | ADV_PRODUCT.PRODUCT_ID | Restrict delete |
ADV_PROD_SP_ADV_ATT_MAP_FK | ADV_ATTACK_MAP.SERVICE_PACK_ID | ADV_PRODUCT_SERVICE_PACK.SERVICE_PACK_ID | Restrict delete |
ADV_PROD_SP_ADV_ATT_PLUGIN_FK | ADV_ATTACK_PLUGIN.SERVICE_PACK_ID | ADV_PRODUCT_SERVICE_PACK.SERVICE_PACK_ID | Restrict delete |
ADV_PROD_SP_ADV_VULN_PROD_FK | ADV_VULN_PRODUCT.SERVICE_PACK_ID | ADV_PRODUCT_SERVICE_PACK.SERVICE_PACK_ID | Restrict delete |
ADV_PROD_VER_ADV_SP_FK | ADV_PRODUCT_SERVICE_PACK.VERSION_ID | ADV_PRODUCT_VERSION.VERSION_ID | Restrict delete |
ADV_VENDOR_ADV_PROD_FK | ADV_PRODUCT.VENDOR_ID | ADV_VENDOR.VENDOR_ID | Restrict delete |
ARCH_LOGS_ARCH_LOG_FILES_FK | ESEC_ARCHIVE_LOG_FILES.ARCH_SEQ | ESEC_ARCHIVE_LOGS.ARCH_SEQ | 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 |
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 |
DATA_TAG_CONFIG_FK | DATA_TAG_CONFIG.DATA_TAG_ID | DATA_TAG.DATA_TAG_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_CGRY_ID_FK1 | ESEC_CTRL_CTGRY.CONTENT_PACK_ID | ESEC_CONTENT_PACK.CONTENT_PACK_ID | Restrict delete |
ESEC_CTRL_CTGRY_ID_FK1 | ESEC_CTRL.CTRL_CTGRY_ID | ESEC_CTRL_CTGRY.CTRL_CTGRY_ID | Restrict delete |
ESEC_PROTOCOL_ESEC_PORT_FK | ESEC_PORT_REFERENCE.PROTOCOL_NUMBER | ESEC_PROTOCOL_REFERENCE.PROTOCOL_NUMBER | 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 |
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 |
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 |
MD_SMRY_STS_FK1 | MD_SMRY_STS.FILE_ID | MD_EVT_FILE_STS.FILE_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 |
PRDT_FK1 | PRDT.VNDR_ID | VNDR.VNDR_ID | Restrict delete |
SENTINEL_HOST_SEN_ID_FK | SENTINEL_HOST.SENTINEL_ID | SENTINEL.SENTINEL_ID | Restrict delete |
SUBPARTITION_CONFIG_FK | SUBPARTITION_CONFIG.DATA_TAG_ID | DATA_TAG.DATA_TAG_ID | Restrict delete |
USR_CNT_FK | USERS.CNT_ID | CONTACTS.CNT_ID | Restrict 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 |