Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:amendment
Table of Contents
Table amendment
Remarks
An amendment corresponds to a version of project. It can be used if the project roughly change and modify the main idea or how the project will be accomplished.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_amendment | integer | X | X | This is the primary key of the table. | |
| history_date | timestamp(0) | This is the date the amendment was created. | |||
| revision | integer | This is the revision number of the amendment. | |||
| status | character varying(255) | It defines the state of the amendment. It corresponds to a Java enumeration (DRAFT, LOCKED, ACTIVE, REJECTED or ARCHIVED). | |||
| version | integer | This is the version number of the revision number of the amendment. | |||
| id_log_frame | integer | X | log\_frame(id_log_frame) | This is a foreign key to the table log_frame. The related logical framework belongs to this amendment. | |
| id_project | integer | X | project(databaseid) | This is a foreign key to the table project. |
Diagram
model/amendment.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
