Public.vulnerabilities (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table public.vulnerabilities

Columns

Column Data Type Nullable Default Description
vulnerabilityid integer not null
nodeid integer null
ipaddr varchar(16) null
serviceid integer null
creationtime timestamp with time zone not null
lastattempttime timestamp with time zone not null
lastscantime timestamp with time zone not null
resolvedtime timestamp with time zone null
severity integer not null
pluginid integer not null
pluginsubid integer not null
logmsg varchar(256) null
descr text null
port integer null
protocol varchar(32) null
cveentry varchar(255) null

Primary Key

Primary Key Columns
pk_vulnerabilityid vulnerabilityid

Indexes

Index Type Columns
vulnerabilities_ipaddr_idx ipaddr
vulnerabilities_nodeid_idx nodeid
vulnerabilities_port_idx port
vulnerabilities_protocol_idx protocol
vulnerabilities_severity_idx severity