Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:reportingperiod
Table of Contents
Table reportingperiod
Remarks
The table reportingperiod is created for defining period. These periods is needed for the indicators because an indicator change over the time. The period commonly used on Sigmah corresponds to a month of the year. So, the period begin usally the first day of a month and it ends at the last day of the month.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| reportingperiodid | integer | X | X | This is the primary key of the table. | |
| comments | text | This column contains some comments on the element. In Sigmah, this column is not used. | |||
| date1 | date | X | The period starts at this date. | ||
| date2 | date | X | The period ends at this date. | ||
| datecreated | timestamp(0) | X | This is the ate the reportingperiod was created. | ||
| datedeleted | timestamp(0) | This is the date the reportingperiod was deleted. | |||
| dateedited | timestamp(0) | X | This is the date the reportingperiod was updated. | ||
| monitoring | bool | X | This column indicates if it is monitored. | ||
| siteid | integer | X | site(siteid) | This is a foreign key to the table site. |
Diagram
model/reportingperiod.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
