Table SIEM.public.vuln
Vulnerability details

 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
vuln_id uuid 2147483647
incidents_vuln.vuln_id Implied Constraint R
incidents_vuln_rpt_v.vuln_id Implied Constraint R
vuln_code.vuln_id vuln_vuln_code_fk R
vuln_code_rpt_v.vuln_id Implied Constraint R
vuln_info.vuln_id vuln_vuln_info_fk R
vuln_info_rpt_v.vuln_id Implied Constraint R
vuln_rpt_v.vuln_id Implied Constraint R
vuln_scan_vuln.vuln_id vuln_vuln_scan_vuln_fk R
vuln_scan_vuln_rpt_v.vuln_id Implied Constraint R
Vulnerability identifier
rsrc_id uuid 2147483647
vuln_rsrc.rsrc_id vuln_rsrc_vuln_fk R
Resource identifier
port_name varchar 64  √  null Port Name
port_number int4 10  √  null Port Number
network_protocol int4 10  √  null Network Protocol
application_protocol varchar 64  √  null Application Protocol
assigned_vuln_severity int4 10  √  null Vulnerability Severity assigned
computed_vuln_severity int4 10  √  null Vulnerability Severity computed
vuln_description text 2147483647  √  null Vulnerability description
vuln_solution text 2147483647  √  null Vulnerability solution
vuln_summary varchar 1000  √  null Vulnerability summary
begin_effective_date timestamptz 35,6  √  null Date from which the entry is valid
end_effective_date timestamptz 35,6  √  null Date until which the entry is valid
detected_os varchar 64  √  null Operating system of scanned machine
detected_os_version varchar 64  √  null Operating system version of scanned machine
scanned_app varchar 64  √  null Application scanned for vulnerability
scanned_app_version varchar 64  √  null Version of Application scanned for vulnerability
vuln_user_name varchar 64  √  null Username used by scanner
vuln_user_domain varchar 64  √  null Domain of user used by scanned
vuln_taxonomy varchar 1000  √  null Vulnerability Taxanomy
scanner_classification varchar 255  √  null Scanner classification
vuln_name varchar 300  √  null Vulnerability Name
vuln_module varchar 64  √  null Vulnerability Module
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
vuln_id Primary key Asc vuln_pk
end_effective_date + begin_effective_date Performance Asc/Asc vuln_end_begin_eff_date_idx
port_number + network_protocol + rsrc_id Performance Asc/Asc/Asc vuln_port_protocol_rsrc_idx
rsrc_id Performance Asc vuln_rsrc_id_idx

Close relationships  within of separation: