Table SIEM.public.vuln_scan
A list of each scan operation a scanner performed.

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
scan_id uuid 2147483647
vuln_rsrc_scan.scan_id vuln_scan_vuln_rsrc_scan_fk R
vuln_rsrc_scan_rpt_v.scan_id Implied Constraint R
vuln_scan_rpt_v.scan_id Implied Constraint R
vuln_scan_vuln.scan_id vuln_scan_vuln_scan_vuln_fk R
vuln_scan_vuln_rpt_v.scan_id Implied Constraint R
Vulnerability scan identifier
scanner_id uuid 2147483647
vuln_scanner.scanner_id vuln_scanner_vuln_scan_fk R
Vulnerability scanner identifier
scan_type varchar 10  √  null Vulnerability scan type
scan_start_date timestamptz 35,6  √  null Scan start date
scan_end_date timestamptz 35,6  √  null Scan end date
consolidation_server varchar 64  √  null Consolidation server
load_status varchar 64  √  null Vulnerability Load status
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
scan_id Primary key Asc vuln_scan_pk
scanner_id Performance Asc vuln_scan_scanner_id_idx

Close relationships  within of separation: