SchemaSpy Analysis of ESEC.ESECDBA - ConstraintsSentinel Reporting Views Generated by
SchemaSpy
71 Foreign Key Constraints:
SourceForge.net

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