From dbscript Online Help
wikibot
| Table
|
public.vulnerabilities
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| vulnerabilityid
|
integer
|
not null
|
|
pk_vulnerabilityid
|
|
| nodeid
|
integer
|
null
|
|
|
vulnerabilities_nodeid_idx
|
| ipaddr
|
varchar(16)
|
null
|
|
|
vulnerabilities_ipaddr_idx
|
| 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
|
|
|
vulnerabilities_severity_idx
|
| pluginid
|
integer
|
not null
|
|
|
|
| pluginsubid
|
integer
|
not null
|
|
|
|
| logmsg
|
varchar(256)
|
null
|
|
|
|
| descr
|
text
|
null
|
|
|
|
| port
|
integer
|
null
|
|
|
vulnerabilities_port_idx
|
| protocol
|
varchar(32)
|
null
|
|
|
vulnerabilities_protocol_idx
|
| cveentry
|
varchar(255)
|
null
|
|
|
|
