Difference between revisions of "Public.demandpolls (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
 
|  
 
|  
| demandpoll_pkey
 
 
|  
 
|  
 
|-
 
|-
Line 31: Line 30:
 
|  
 
|  
 
|  
 
|  
| demandpoll_request_time
 
 
|-
 
|-
 
| username
 
| username
 
| varchar(32)
 
| varchar(32)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
Line 43: Line 40:
 
| varchar(128)
 
| varchar(128)
 
| null
 
| null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| demandpoll_pkey
 +
| id
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| demandpoll_request_time
 +
|
 +
| requesttime
 +
|}
  
 +
=== Detail Tables ===
 
{| 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"

Revision as of 08:31, 11 February 2010

wikibot

Table public.demandpolls


Columns

Column Data Type Nullable Default Description
id integer not null
requesttime timestamp with time zone null
username varchar(32) null
description varchar(128) null

Primary Key

Primary Key Columns
demandpoll_pkey id

Indexes

Index Type Columns
demandpoll_request_time requesttime

Detail Tables

Detail Table Column Referencing Column
public.pollresults id pollid