Difference between revisions of "Public.statisticsreport (table)"
| (One intermediate revision by the same user not shown) | |||
| Line 20: | Line 20: | ||
| integer | | integer | ||
| not null | | not null | ||
| − | | | + | | |
| | | | ||
|- valign="top" | |- valign="top" | ||
| Line 87: | Line 87: | ||
| | | | ||
| name | | name | ||
| + | |- valign="top" | ||
| + | | statisticsreport_purgedate | ||
| + | | | ||
| + | | purgedate | ||
|- valign="top" | |- valign="top" | ||
| statisticsreport_startdate | | statisticsreport_startdate | ||
| | | | ||
| startdate | | startdate | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
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 |
