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.
| 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. |