Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:indicatorvalue
Table of Contents
Table indicatorvalue
Remarks
This table associates an indicator with a reportingperiod. It corresponds to the indicator value in a given period. The primary key is formed by indicatorid and reportingperiodid.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| indicatorid | integer | X | X | indicator(indicatorid) | This is a foreign key to the table indicator. |
| reportingperiodid | integer | X | X | reportingperiod(reportingperiodid) | This is a foreign key to the table reportingperiod. |
| value | double precision | X | This is the value of the indicator at the given period. |
Diagram
model/indicatorvalue.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
