Public.statisticsreport (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Detail Tables

wikibot

Table

public.statisticsreport

Columns

Column	Data Type	Nullable	Default	Description
id	integer	not null	nextval('opennmsnxtid'::regclass)
startdate	timestamp with time zone	not null
enddate	timestamp with time zone	not null
name	varchar(63)	not null
description	varchar(255)	not null
jobstarteddate	timestamp with time zone	not null
jobcompleteddate	timestamp with time zone	not null
purgedate	timestamp with time zone	not null

Primary Key

Primary Key	Columns
pk_statisticsreport_id	id

Indexes

Index	Type	Columns
statisticsreport_name		name
statisticsreport_startdate		startdate
statisticsreport_purgedate		purgedate

Detail Tables

Detail Table	Column	Referencing Column
public.statisticsreportdata	id	reportid