From dbscript Online Help
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
