So, I have a web app based on PHP and a DB based on MySQL.
The app registers employees (table name: colaboradores)
and items (Table name: ativos)
(like computers and stuff like that) and then on the app it has the users
table (that basically is for permissions like create and delete records).
The point is, I want every action performed by any user to be registered on a log file (I was thinking on creating a new table on the BD called log
maybe? ) and show a text field on the page of every item that is register all the life's cycle of that item (For exemple, register on the log
that the user mike added an Iphone to the employee Sam today).
Any tips of how can I do that?