SchemaSpy Analysis of ESEC.ESECDBASentinel Reporting Views Generated by
SchemaSpy
Generated by SchemaSpy on Mon May 24 11:29 EDT 2010
Database Type: Oracle - Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

141 Tables and 120 Views:

Table Children Parents Columns Comments
ACTVY 3 14
ACTVY_PARM 1 1 14
ACTVY_PARM_RPT_V 14
ACTVY_REF 2 2 7
ACTVY_REF_PARM_VAL 3 8
ACTVY_REF_PARM_VAL_RPT_V 8
ACTVY_REF_RPT_V 7
ACTVY_RPT_V 14
ADV_ATTACK 1 21
ADV_ATTACK_MAP 1 10
ADV_ATTACK_MAP_RPT_V 10
ADV_ATTACK_PLUGIN 1 10
ADV_ATTACK_PLUGIN_RPT_V 10
ADV_ATTACK_RPT_V 21
ADV_ATTACK_SIGNATURES 4
ADV_ATTACK_SIGNATURES_RPT_V 4
ADV_FEED 7
ADV_FEED_RPT_V 7
ADV_MASTER 12
ADV_MASTER_RPT_V 12
ADV_PRODUCT 1 1 15
ADV_PRODUCT_RPT_V 15
ADV_PRODUCT_SERVICE_PACK 3 1 12
ADV_PRODUCT_SERVICE_PACK_RPT_V 12
ADV_PRODUCT_VERSION 1 1 10
ADV_PRODUCT_VERSION_RPT_V 10
ADV_VENDOR 1 23
ADV_VENDOR_RPT_V 23
ADV_VULN_KB 10
ADV_VULN_KB_RPT_V 10
ADV_VULN_PRODUCT 2 6
ADV_VULN_PRODUCT_RPT_V 6
ADV_VULN_SIGNATURES 4
ADV_VULN_SIGNATURES_RPT_V 4
ANNOTATIONS 7
ANNOTATIONS_RPT_V 7
ASSET 1 7 15
ASSET_CATEGORY_RPT_V 6
ASSET_CTGRY 1 6
ASSET_HOSTNAME 8
ASSET_HOSTNAME_RPT_V 8
ASSET_IP 1 8
ASSET_IP_RPT_V 8
ASSET_LOC 1 13
ASSET_LOCATION_RPT_V 13
ASSET_RPT_V 15
ASSET_VAL_LKUP 1 6
ASSET_VALUE_RPT_V 6
ASSET_X_ENTITY_X_ROLE 5 10
ASSET_X_ENTITY_X_ROLE_RPT_V 10
ASSOCIATIONS 8
ASSOCIATIONS_RPT_V 8
ATTACHMENTS 12
ATTACHMENTS_RPT_V 12
AUDIT_RECORD 16
AUDIT_RECORD_NP 16
AUDIT_RECORD_RPT_V 16
CONFIGS 9
CONFIGS_RPT_V 9
CONTACTS 1 13
CONTACTS_RPT_V 13
CORR_ACT_DEF 1 7
CORR_ACT_META 1 7
CORR_ACT_PARM 2 9
CORR_ACT_PARM_DEF 1 1 8
CORR_DEPLOY_CONFIG 1 1 8
CORR_ENGINE_CONFIG 2 9
CORR_RULE 12
CORR_RULE_CFG 2 10
CORRELATED_EVENTS 8
CORRELATED_EVENTS_RPT_V 8
CORRELATED_EVENTS_RPT_V1 8
CRIT_LKUP 1 6
CRITICALITY_RPT_V 6
CUST 1 6 Holds information about multiple customers from which event and context data is collected
CUST_HIERARCHY 10
CUST_HIERARCHY_V 10
CUST_RPT_V 6
DATA_TAG 2 7
DATA_TAG_CONFIG 1 8
ENTITY_TYP_LKUP 1 6
ENTITY_TYPE_RPT_V 6
ENV_IDENTITY_LKUP 1 6
ENV_IDENTITY_RPT_V 6
ESEC_ARCHIVE_CONFIG 8
ESEC_ARCHIVE_LOG_FILES 1 4
ESEC_ARCHIVE_LOGS 1 10
ESEC_CONTENT 2 11
ESEC_CONTENT_GRP 1 1 9
ESEC_CONTENT_GRP_CONTENT 3 8
ESEC_CONTENT_GRP_CONTENT_RPT_V 8
ESEC_CONTENT_GRP_RPT_V 9
ESEC_CONTENT_PACK 1 8
ESEC_CONTENT_PACK_RPT_V 8
ESEC_CONTENT_RPT_V 11
ESEC_CTRL 1 1 11
ESEC_CTRL_CTGRY 1 1 9
ESEC_CTRL_CTGRY_RPT_V 9
ESEC_CTRL_RPT_V 11
ESEC_DB_PATCHES 4
ESEC_DB_VERSION 4
ESEC_DISPLAY 15
ESEC_DISPLAY_RPT_V 15
ESEC_JOB_CONFIG 4
ESEC_JOB_STS 6
ESEC_NAMESPACE 7
ESEC_NAMESPACE_LEAF 7
ESEC_PARTITION_CONFIG 4
ESEC_PARTITION_TEMP_INFO 4
ESEC_PORT_REFERENCE 1 8
ESEC_PORT_REFERENCE_RPT_V 8
ESEC_PROTOCOL_REFERENCE 1 7
ESEC_PROTOCOL_REFERENCE_RPT_V 7
ESEC_SDM_LOCK 1
ESEC_SEQUENCE 7
ESEC_SEQUENCE_RPT_V 7
ESEC_TABLE_GROUPS 2
ESEC_TEMP_PART_INFO 33
ESEC_UUID_UUID_ASSOC 8
ESEC_UUID_UUID_ASSOC_RPT_V 8
EVENTS 2 330 Main Sentinel event view
EVENTS_ALL_RPT_V 199
EVENTS_ALL_RPT_V1 199
EVENTS_ALL_V 199
EVENTS_RPT_V 199
EVENTS_RPT_V1 199
EVENTS_RPT_V2 214
EVENTS_RPT_V3 295
EVENTS_SUB 330
EVT_AGENT 14
EVT_AGENT_RPT_V 14
EVT_AGENT_RPT_V3 14
EVT_ASSET 30
EVT_ASSET_RPT_V 29
EVT_ASSET_RPT_V3 29
EVT_DEST_EVT_NAME_SMRY_1 14
EVT_DEST_EVT_NAME_SMRY_1_RPT_V 14
EVT_DEST_SMRY_1 20
EVT_DEST_SMRY_1_RPT_V 20
EVT_DEST_TXNMY_SMRY_1 13
EVT_DEST_TXNMY_SMRY_1_RPT_V 13
EVT_NAME 6
EVT_NAME_RPT_V 6
EVT_PORT_SMRY_1 9
EVT_PORT_SMRY_1_RPT_V 9
EVT_PRTCL 6
EVT_PRTCL_RPT_V 6
EVT_PRTCL_RPT_V3 6
EVT_RSRC 8
EVT_RSRC_RPT_V 8
EVT_SEV_SMRY_1 8
EVT_SEV_SMRY_1_RPT_V 8
EVT_SRC 1 1 10
EVT_SRC_COLLECTOR 1 2 11
EVT_SRC_COLLECTOR_RPT_V 11
EVT_SRC_GRP 1 3 12
EVT_SRC_GRP_RPT_V 12
EVT_SRC_MGR 2 2 10
EVT_SRC_MGR_RPT_V 10
EVT_SRC_OFFSET 1 7
EVT_SRC_OFFSET_RPT_V 7
EVT_SRC_RPT_V 10
EVT_SRC_SMRY_1 20
EVT_SRC_SMRY_1_RPT_V 20
EVT_SRC_SRVR 1 2 10
EVT_SRC_SRVR_RPT_V 10
EVT_TXNMY 10
EVT_TXNMY_RPT_V 10
EVT_USR 8
EVT_USR_RPT_V 8
EVT_XDAS_TXNMY 13
EVT_XDAS_TXNMY_RPT_V 13
EXT_DATA 9
EXTERNAL_DATA_RPT_V 9
HIST_CORRELATED_EVENTS_RPT_V 8
HIST_EVENTS_RPT_V 199
IMAGES 7
IMAGES_RPT_V 7
INCIDENTS 1 15
INCIDENTS_ASSETS 6
INCIDENTS_ASSETS_RPT_V 6
INCIDENTS_EVENTS 7
INCIDENTS_EVENTS_RPT_V 7
INCIDENTS_RPT_V 15
INCIDENTS_VULN 6
INCIDENTS_VULN_RPT_V 6
INTEGRATOR_CONFIG 1 10
L_STAT 4
L_STAT_RPT_V 4
LOGS 4
LOGS_RPT_V 4
MD_CONFIG 12
MD_EVT_FILE_STS 1 14
MD_SMRY_STS 1 12
MD_VIEW_CONFIG 10
MSSP_ASSOCIATIONS 8
MSSP_ASSOCIATIONS_V 8
NETWORK_IDENTITY_LKUP 1 6
NETWORK_IDENTITY_RPT_V 6
NLS_CONFIG 4
NLS_MSG_TRANSLATION 4
NORM_ATTACK_CD_MAP 6
OBJ_STORE 10
OFFLINE_QRY_STS 17
ORGANIZATION 1 7
ORGANIZATION_RPT_V 7
PERSON 1 10
PERSON_RPT_V 10
PHYSICAL_ASSET 2 2 13
PHYSICAL_ASSET_RPT_V 13
PRDT 1 1 8
PRODUCT_RPT_V 8
ROLE_LKUP 1 6
ROLE_RPT_V 6
RPT_LABELS_RPT_V 36
RPT_TRANSLATION 38
SENSITIVITY_LKUP 1 6
SENSITIVITY_RPT_V 6
SENTINEL 2 9
SENTINEL_HOST 1 1 11
SENTINEL_HOST_RPT_V 11
SENTINEL_PLUGIN 4 11
SENTINEL_PLUGIN_RPT_V 11
SENTINEL_RPT_V 9
STATES 2 8
STATES_RPT_V 8
SUBPARTITION_CONFIG 1 8
TEMP_ADVISOR 5
TXNMY_NODE 8
UNASSIGNED_INCIDENTS_RPT_V 15
USERS 2 13
USERS_RPT_V 13
USR_ACCOUNT 1 14
USR_ACCOUNT_RPT_V 14
USR_IDENTITY 3 20
USR_IDENTITY_EXT_ATTR 1 3
USR_IDENTITY_EXT_ATTR_RPT_V 3
USR_IDENTITY_RPT_V 20
VENDOR_RPT_V 6
VNDR 1 6
VULN 3 1 27
VULN_CALC_SEVERITY_RPT_V 7
VULN_CODE 1 9
VULN_CODE_RPT_V 9
VULN_INFO 1 8
VULN_INFO_RPT_V 8
VULN_RPT_V 27
VULN_RSRC 2 1 15
VULN_RSRC_RPT_V 15
VULN_RSRC_SCAN 2 6
VULN_RSRC_SCAN_RPT_V 6
VULN_SCAN 2 1 11
VULN_SCAN_RPT_V 11
VULN_SCAN_VULN 2 6
VULN_SCAN_VULN_RPT_V 6
VULN_SCANNER 2 10
VULN_SCANNER_RPT_V 10
WORKFLOW_DEF 6
WORKFLOW_DEF_RPT_V 6
WORKFLOW_INFO 7
WORKFLOW_INFO_RPT_V 7

Columns: 4,886