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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.reportlocator |- |} {| border="1" cellpadding="5" cellspacing="0" sty...)
 
 
(2 intermediate revisions 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.reportlocator
 
| public.reportlocator
|-
 
 
|}
 
|}
  
 
+
=== 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 14:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
+
 
+
|- valign="top"
|-
 
 
| reportid
 
| reportid
|  
+
| integer
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reportcategory
 
| reportcategory
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reportdate
 
| reportdate
|  
+
| timestamp with time zone
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reportformat
 
| reportformat
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reporttype
 
| reporttype
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reportlocation
 
| reportlocation
|  
+
| varchar(256)
 
| not null
 
| not null
 
|  
 
|  
 
|  
 
|  
|
+
|- valign="top"
|-
 
 
| reportavailable
 
| reportavailable
|  
+
| boolean
 
| not null
 
| not null
|
 
 
|  
 
|  
 
|  
 
|  
 
|}
 
|}

Latest revision as of 00:39, 25 June 2010

wikibot[edit]

Table public.reportlocator

Columns[edit]

Column Data Type Nullable Default Description
reportid integer not null
reportcategory varchar(256) not null
reportdate timestamp with time zone not null
reportformat varchar(256) not null
reporttype varchar(256) not null
reportlocation varchar(256) not null
reportavailable boolean not null