=Table log_frame_element=
This table corresponds to an element of the logical framework view. In Java, the class related is abstract. Each concrete element inherits of the class LogFrameElement. As inheritance doesn’t exist in the SQL format, Hibernate transforms this inheritance into joint (with the strategy InheritanceType.JOINED). So each element has a foreign-key (called id_element) to its parent table so the table log_frame_element. You can notice that these foreign-keys are also primary-keys for these elements.
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_element | integer | X | X | This is the primary key of the table. | |
| assumptions | text | This column corresponds to an assumption | |||
| code | integer | X | The code is the identifier of the element in the group. This code will be formatted in the view according to the type of the element. Do not confuse with the column position : an element will not change its code when its position is updated | ||
| position | integer | This column contains the position of the element in the group. All elements of a group will be ordered according to this column. | |||
| risks | text | All risks of a logical framework are written in this textual field. | |||
| id_group | integer | X | log\_frame\_group(id_group) | This is a foreign key to the table log_frame_group. It corresponds to the group in which the log_frame_element is related. |