Welcome Guest, you are in: <root> • Login

Page History: public statisticsreport (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:24

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