A flexible_element in an available project can have a value stored in the table value. But when a flexible element has its value replaced by another one, the old value is sent to the table history\_token.
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_history_token | integer | X | X | This is the primary key of the table. | |
| history_date | timestamp(0) | X | This is the date of the action archived. | ||
| id_element | bigint | X | This is a foreign key to the table flexible_element. This history_token belong to this flexible_element. | ||
| id_project | integer | X | This column is linked to either the table project or the table partner. | ||
| change_type | character varying(255) | This column is like a java enum that can contains either ADD, REMOVE or EDIT. | |||
| value | text | X | This columns contains an old value of the flexible element in a string representation | ||
| id_user | integer | X | userlogin(userid) | This is a foreign key to the table userlogin. This user corresponds to the contributor on the flexible element associated. |