A flexible_element in an available project can have a value. This table corresponds to the current value of the flexible_element. Old values are sent to the table history\_token.
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
id_value | bigint | X | X | This is the primary key of the table. | |
id_project | integer | X | This column is linked to either the table project or the table partner. | ||
action_last_modif | bpchar | X | This column contains a character that corresponds to the last action made on the flexible_element linked. | ||
date_last_modif | timestamp(0) | X | This column correspond to the date of the last action made on the flexible_element linked. | ||
value | text | This columns contains the value of the flexible element in a string representation | |||
id_flexible_element | bigint | X | flexible\_element(id_flexible_element) | This is a foreign key to the table flexible_element. This value belong to this flexible_element. | |
id_user_last_modif | integer | X | userlogin(userid) | This is a foreign key to the table userlogin. This user corresponds to the last contributor on the flexible element associated. |