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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| public.statisticsreport
 
| public.statisticsreport
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 17: Line 15:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| id
 
| id
 
| integer
 
| integer
 
| not null
 
| not null
| nextval('opennmsnxtid'::regclass)
 
 
|  
 
|  
|-
+
|
 +
|- valign="top"
 
| startdate
 
| startdate
 
| timestamp with time zone
 
| timestamp with time zone
Line 30: Line 28:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| enddate
 
| enddate
 
| timestamp with time zone
 
| timestamp with time zone
Line 36: Line 34:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| name
 
| name
 
| varchar(63)
 
| varchar(63)
Line 42: Line 40:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| description
 
| description
 
| varchar(255)
 
| varchar(255)
Line 48: Line 46:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| jobstarteddate
 
| jobstarteddate
 
| timestamp with time zone
 
| timestamp with time zone
Line 54: Line 52:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| jobcompleteddate
 
| jobcompleteddate
 
| timestamp with time zone
 
| timestamp with time zone
Line 60: Line 58:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| purgedate
 
| purgedate
 
| timestamp with time zone
 
| timestamp with time zone
Line 73: Line 71:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| pk_statisticsreport_id
 
| pk_statisticsreport_id
 
| id
 
| id
Line 84: Line 82:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| statisticsreport_name
 
| statisticsreport_name
 
|  
 
|  
 
| name
 
| name
|-
+
|- valign="top"
 +
| statisticsreport_purgedate
 +
|
 +
| purgedate
 +
|- valign="top"
 
| statisticsreport_startdate
 
| statisticsreport_startdate
 
|  
 
|  
 
| startdate
 
| startdate
|-
 
| statisticsreport_purgedate
 
|
 
| purgedate
 
 
|}
 
|}
  
Line 105: Line 103:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[public.statisticsreportdata_(table)|public.statisticsreportdata]]
 
| [[public.statisticsreportdata_(table)|public.statisticsreportdata]]
 
| id
 
| id
 
| reportid
 
| reportid
 
|}
 
|}

Latest revision as of 10:26, 27 August 2011

wikibot[edit]

Table public.statisticsreport

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
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[edit]

Primary Key Columns
pk_statisticsreport_id id

Indexes[edit]

Index Type Columns
statisticsreport_name name
statisticsreport_purgedate purgedate
statisticsreport_startdate startdate

Detail Tables[edit]

Detail Table Column Referencing Column
public.statisticsreportdata id reportid