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

From dbscript Online Help
Jump to: navigation, search
Line 20: Line 20:
 
| integer
 
| integer
 
| not null
 
| not null
| nextval('opennmsnxtid'::regclass)
+
|  
 
|  
 
|  
 
|- valign="top"
 
|- valign="top"

Revision as of 11:10, 27 August 2011

wikibot

Table public.statisticsreportdata

Columns

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

Primary Key Columns
pk_statsdata_id id

Indexes

Index Type Columns
statsdata_unique Unique reportid, resourceid

Foreign Keys

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