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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.pollresults
 
| public.pollresults
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| id
 
| id
 
| integer
 
| integer
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| pollid
 
| pollid
 
| integer
 
| integer
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| nodeid
 
| nodeid
 
| integer
 
| integer
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ipaddr
 
| ipaddr
 
| varchar(16)
 
| varchar(16)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| ifindex
 
| ifindex
 
| integer
 
| integer
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| serviceid
 
| serviceid
 
| integer
 
| integer
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| statuscode
 
| statuscode
 
| integer
 
| integer
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| statusname
 
| statusname
 
| varchar(32)
 
| varchar(32)
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| reason
 
| reason
 
| varchar(128)
 
| varchar(128)
Line 79: Line 77:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pollresult_pkey
 
| pollresult_pkey
 
| id
 
| id
Line 90: Line 88:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 +
| pollresults_poll_id
 +
|
 +
| pollid
 +
|- valign="top"
 
| pollresults_service
 
| pollresults_service
 
|  
 
|  
 
| nodeid, ipaddr, ifindex, serviceid
 
| nodeid, ipaddr, ifindex, serviceid
|-
 
| pollresults_poll_id
 
|
 
| pollid
 
 
|}
 
|}
  
Line 107: Line 105:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[public.demandpolls_(table)|public.demandpolls]]
 
| [[public.demandpolls_(table)|public.demandpolls]]
 
| pollid
 
| pollid
 
| id
 
| id
 
|}
 
|}

Latest revision as of 10:09, 27 August 2011

wikibot[edit]

Table public.pollresults

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
pollid integer null
nodeid integer null
ipaddr varchar(16) null
ifindex integer null
serviceid integer null
statuscode integer null
statusname varchar(32) null
reason varchar(128) null

Primary Key[edit]

Primary Key Columns
pollresult_pkey id

Indexes[edit]

Index Type Columns
pollresults_poll_id pollid
pollresults_service nodeid, ipaddr, ifindex, serviceid

Foreign Keys[edit]

Relation Column Referenced Column
public.demandpolls pollid id