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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
rsrc_id uuid 2147483647
vuln
vuln_rsrc_scan
Resource identifier
scanner_id uuid 2147483647
vuln_scanner
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
rsrc_id Primary key Asc
criticality Performance Asc
department Performance Asc
host_name Performance Asc
ip Performance Asc
location Performance Asc
operational_environment Performance Asc
regulation Performance Asc
scanner_id Performance Asc

Close relationships  within of separation: