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

From dbscript Online Help
Jump to: navigation, search
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.distpoller
 
| public.distpoller
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| dpname
 
| dpname
 
| varchar(12)
 
| varchar(12)
Line 24: Line 22:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dpip
 
| dpip
 
| varchar(16)
 
| varchar(16)
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dpcomment
 
| dpcomment
 
| varchar(256)
 
| varchar(256)
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dpdisclimit
 
| dpdisclimit
 
| numeric(5, 2)
 
| numeric(5, 2)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dplastnodepull
 
| dplastnodepull
 
| timestamp with time zone
 
| timestamp with time zone
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dplasteventpull
 
| dplasteventpull
 
| timestamp with time zone
 
| timestamp with time zone
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dplastpackagepush
 
| dplastpackagepush
 
| timestamp with time zone
 
| timestamp with time zone
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dpadminstate
 
| dpadminstate
 
| integer
 
| integer
Line 66: Line 64:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| dprunstate
 
| dprunstate
 
| integer
 
| integer
Line 79: Line 77:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_dpname
 
| pk_dpname
 
| dpname
 
| dpname
Line 90: Line 88:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[public.node_(table)|public.node]]
 
| [[public.node_(table)|public.node]]
 
| dpname
 
| dpname
 
| dpname
 
| dpname
 
|}
 
|}

Revision as of 00:38, 25 June 2010

wikibot

Table public.distpoller

Columns

Column Data Type Nullable Default Description
dpname varchar(12) not null
dpip varchar(16) not null
dpcomment varchar(256) null
dpdisclimit numeric(5, 2) null
dplastnodepull timestamp with time zone null
dplasteventpull timestamp with time zone null
dplastpackagepush timestamp with time zone null
dpadminstate integer null
dprunstate integer null

Primary Key

Primary Key Columns
pk_dpname dpname

Detail Tables

Detail Table Column Referencing Column
public.node dpname dpname