Public.vulnerabilities (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes

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_severity_idx		severity
vulnerabilities_protocol_idx		protocol