public vulnerabilities (table)

wikibot

Tablepublic.vulnerabilities

Columns

ColumnData TypeNullableDefaultDescription
vulnerabilityidintegernot null  
nodeidintegernull  
ipaddrvarchar(16)null  
serviceidintegernull  
creationtimetimestamp with time zonenot null  
lastattempttimetimestamp with time zonenot null  
lastscantimetimestamp with time zonenot null  
resolvedtimetimestamp with time zonenull  
severityintegernot null  
pluginidintegernot null  
pluginsubidintegernot null  
logmsgvarchar(256)null  
descrtextnull  
portintegernull  
protocolvarchar(32)null  
cveentryvarchar(255)null  

Primary Key

Primary KeyColumns
pk_vulnerabilityidvulnerabilityid

Indexes

IndexTypeColumns
vulnerabilities_ipaddr_idx ipaddr
vulnerabilities_nodeid_idx nodeid
vulnerabilities_port_idx port
vulnerabilities_protocol_idx protocol
vulnerabilities_severity_idx severity