Table SIEM.public.vuln_rsrc
Contains each resource (e.g., a host) scanned by a particular scanner

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
rsrc_id uuid 2147483647
vuln.rsrc_id vuln_rsrc_vuln_fk R
vuln_calc_severity_rpt_v.rsrc_id Implied Constraint R
vuln_rpt_v.rsrc_id Implied Constraint R
vuln_rsrc_rpt_v.rsrc_id Implied Constraint R
vuln_rsrc_scan.rsrc_id vuln_rsrc_vuln_rsrc_scan_fk R
vuln_rsrc_scan_rpt_v.rsrc_id Implied Constraint R
Resource identifier
scanner_id uuid 2147483647
vuln_scanner.scanner_id vuln_scanner_vuln_rsrc_fk R
Scanner identifier
ip varchar 32 IP address
host_name varchar 255  √  null Host name
location varchar 128  √  null Location identifier
department varchar 128  √  null Department Name
business_system varchar 128  √  null Business System
operational_environment varchar 64  √  null Operational environment
criticality int4 10  √  null Criticality
regulation varchar 128  √  null Regulation
regulation_rating varchar 64  √  null Regulation rating
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Indexes:
Column(s) Type Sort Constraint Name
rsrc_id Primary key Asc vuln_rsrc_pk
criticality Performance Asc vuln_rsrc_criticality_idx
department Performance Asc vuln_rsrc_department_idx
host_name Performance Asc vuln_rsrc_host_name
ip Performance Asc vuln_rsrc_ip_idx
location Performance Asc vuln_rsrc_location_idx
operational_environment Performance Asc vuln_rsrc_op_env_idx
regulation Performance Asc vuln_rsrc_regulation_idx
scanner_id Performance Asc vuln_rsrc_scanner_id_idx

Close relationships  within of separation: