From dbscript Online Help
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
|
