Difference between revisions of "Public.statisticsreportdata (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 61: | Line 61: | ||
|- valign="top" | |- valign="top" | ||
| statsdata_unique | | statsdata_unique | ||
| − | | | + | | |
| reportid, resourceid | | reportid, resourceid | ||
|} | |} | ||
Latest revision as of 10:20, 27 August 2011
wikibot[edit]
| Table | public.statisticsreportdata |
Columns[edit]
| Column | Data Type | Nullable | Default | Description |
| id | integer | not null | ||
| reportid | integer | not null | ||
| resourceid | integer | not null | ||
| value | double precision | not null |
Primary Key[edit]
| Primary Key | Columns |
| pk_statsdata_id | id |
Indexes[edit]
| Index | Type | Columns |
| statsdata_unique | reportid, resourceid |
Foreign Keys[edit]
| Relation | Column | Referenced Column |
| public.statisticsreport | reportid | id |
| public.resourcereference | resourceid | id |