Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:projectreport
Table of Contents
Table projectreport
Remarks
This table corresponds to a concrete report based on a report model (contained in the table ProjectReportModel).
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id | integer | X | X | This is the primary key of the table. | |
| datedeleted | timestamp(0) | This is the date the report was deleted. | |||
| name | character varying(255) | This is the human readable name of the report. | |||
| currentversion_id | integer | X | projectreportversion(id) | This is a foreign key to the table projectreportversion. It corresponds to the current version of the report. | |
| flexibleelement_id_flexible_element | bigint | X | flexible\_element(id_flexible_element) | This is a foreign key to the table flexible_element. This is the flexible element that contains this report. | |
| model_id | integer | X | projectreportmodel(id) | This is a foreign key to the table ProjectReportModel. This report follow the same architecture than this model. | |
| orgunit_partnerid | integer | X | partner(partnerid) | This is a foreign key to the table partner. In Sigmah, this column is not used. | |
| project_databaseid | integer | X | project(databaseid) | This is a foreign key to the table userdatabase. |
Diagram
model/projectreport.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
