How to guarantee the immutability of the data in the table if there is a FK?

Question

MySQL

There is a table of user requests and you need to somehow guarantee the immutability of the data after inserting it into the table so that no one can change the data. Here you can make the signature a hash, but the problem is that this table has FK for directories (i.e. if someone changes the directory, then the hash will be the same)
Is it reasonable in this situation to store values ​​​​instead of id directories most get rid of FK?

Answer 1

A simple, but data-increasing method is copying values ​​from reference books into an application at the time of its creation.
A more complicated way is to add additional tables-registers to the directories that store changes in the directories (time, id_in_the_ directory, value) and take the values ​​from the register at the time of the request.

Answer 2

dev.mysql.com/doc/refman/5.7/en/create-table-forei...
ON DELETE RESTRICT
ON UPDATE RESTRICT
And still it is possible to select from the user access to record in this table.