Difference between revisions of "Public.vulnerabilities (table)"

From dbscript Online Help
Jump to: navigation, search
Line 9: Line 9:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 16:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 23:
 
| not null
 
| not null
 
|  
 
|  
| pk_vulnerabilityid
 
 
|  
 
|  
 
|-
 
|-
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
| vulnerabilities_nodeid_idx
 
 
|-
 
|-
 
| ipaddr
 
| ipaddr
Line 38: Line 36:
 
|  
 
|  
 
|  
 
|  
| vulnerabilities_ipaddr_idx
 
 
|-
 
|-
 
| serviceid
 
| serviceid
 
| integer
 
| integer
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 50: Line 46:
 
| timestamp with time zone
 
| timestamp with time zone
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 57: Line 52:
 
| timestamp with time zone
 
| timestamp with time zone
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 64: Line 58:
 
| timestamp with time zone
 
| timestamp with time zone
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 71: Line 64:
 
| timestamp with time zone
 
| timestamp with time zone
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 80: Line 72:
 
|  
 
|  
 
|  
 
|  
| vulnerabilities_severity_idx
 
 
|-
 
|-
 
| pluginid
 
| pluginid
 
| integer
 
| integer
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 92: Line 82:
 
| integer
 
| integer
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
Line 99: Line 88:
 
| varchar(256)
 
| varchar(256)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 106: Line 94:
 
| text
 
| text
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 115: Line 102:
 
|  
 
|  
 
|  
 
|  
| vulnerabilities_port_idx
 
 
|-
 
|-
 
| protocol
 
| protocol
Line 122: Line 108:
 
|  
 
|  
 
|  
 
|  
| vulnerabilities_protocol_idx
 
 
|-
 
|-
 
| cveentry
 
| cveentry
Line 129: Line 114:
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| pk_vulnerabilityid
 +
| vulnerabilityid
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| vulnerabilities_ipaddr_idx
 +
|
 +
| ipaddr
 +
|-
 +
| vulnerabilities_nodeid_idx
 +
|
 +
| nodeid
 +
|-
 +
| vulnerabilities_port_idx
 +
|
 +
| port
 +
|-
 +
| vulnerabilities_severity_idx
 
|  
 
|  
 +
| severity
 +
|-
 +
| vulnerabilities_protocol_idx
 +
|
 +
| protocol
 
|}
 
|}

Revision as of 08:33, 11 February 2010

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