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

From dbscript Online Help
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 20: Line 20:
 
| integer
 
| integer
 
| not null
 
| not null
| nextval('opennmsnxtid'::regclass)
+
|  
 
|  
 
|  
 
|- valign="top"
 
|- valign="top"
Line 61: Line 61:
 
|- valign="top"
 
|- valign="top"
 
| statsdata_unique
 
| statsdata_unique
| Unique
+
|  
 
| reportid, resourceid
 
| reportid, resourceid
 
|}
 
|}

Latest revision as of 10:20, 27 August 2011

wikibot[edit]

Table public.statisticsreportdata

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
reportid integer not null
resourceid integer not null
value double precision not null

Primary Key[edit]

Primary Key Columns
pk_statsdata_id id

Indexes[edit]

Index Type Columns
statsdata_unique reportid, resourceid

Foreign Keys[edit]

Relation Column Referenced Column
public.statisticsreport reportid id
public.resourcereference resourceid id