Table log\_frame\_prerequisite

Remarks

A log_frame_prerequisite indicates what are the prerequisites of a logical framework.

Name	Type	Not Null	Primary Key	Foreign Key	Remarks
:———	:———	:————-	:—————-	:—————-	:————
id_prerequisite	integer	X	X		This is the primary key of the table.
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
content	text				The content corresponds to a text that will be written in a textual field in the logical framework view.
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.
id_group	integer			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_prerequisite is related.
id_log_frame	integer	X		log\_frame(id_log_frame)	This is a foreign key to the table log_frame. The log_frame_prerequisite belongs to the log_frame related.