Difference between revisions of "Public.statisticsreport (table)"
| 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 | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | === | + | === Foreign Keys === |
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
| − | | ''' | + | | '''Relation |
| '''Column | | '''Column | ||
| − | | ''' | + | | '''Referenced Column |
|- valign="top" | |- valign="top" | ||
| − | | [[public. | + | | [[public.statisticsreport_(table)|public.statisticsreport]] |
| + | | reportid | ||
| id | | id | ||
| − | |||
|} | |} | ||
Revision as of 10:10, 27 August 2011
wikibot
| Table | public.statisticsreport |
Columns
| 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
| Primary Key | Columns |
| pk_statisticsreport_id | id |
Indexes
| Index | Type | Columns |
| statisticsreport_name | name | |
| statisticsreport_purgedate | purgedate | |
| statisticsreport_startdate | startdate |
Foreign Keys
| Relation | Column | Referenced Column |
| public.statisticsreport | reportid | id |
