Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:projectreportversion
Table of Contents
Table projectreportversion
Remarks
Each time an user edits a project, a version of the report is created. Older versions are kept in the database.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id | integer | X | X | This is the primary key of the table. | |
| editdate | timestamp(0) | This is the date the version was created. | |||
| phasename | character varying(255) | This is the phase the report belongs. | |||
| version | integer | It corresponds to the version number of this report. | |||
| editor_userid | integer | userlogin(userid) | This is a foreign key to the table userlogin. It corresponds to the author of this version. | ||
| report_id | integer | projectreport(id) | This is a foreign key to the table ProjectReport. |
Diagram
model/projectreportversion.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
