Public.statisticsreportdata (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Foreign Keys

wikibot

Table

public.statisticsreportdata

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null	nextval('opennmsnxtid'::regclass)
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