Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:log_frame_activity
Table of Contents
Table log\_frame\_activity
Remarks
A log_frame_activity is an activity created in a logical framework. Do not confuse with the table Activity created in order to organize indicators in several groups in the indicator view.
This table has a joint to the table log_frame_element because, in the Java code, the class LogFrameElement is the parent class of the class LogFrameActivity.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_element | integer | X | X | log\_frame\_element(id_element) | This is a foreign key to the parent table log_frame_element. It is also the primary key of this table. |
| advancement | integer | This is the percentage of advancement of this activity. | |||
| enddate | timestamp(0) | This is the date the activity ends. | |||
| startdate | timestamp(0) | This is the date the activity starts. | |||
| title | text | This is the title (or the intervention logic in Sigmah) of the activity. | |||
| id_result | integer | X | log\_frame\_expected\_result(id_element) | This is a foreign key to the table log_frame_expected_result. |
Diagram
model/log_frame_activity.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
