How to keep a chronology of events using PHP and DB?

Question

PHP

Good afternoon! I'm going to make a small CMS for my company, started with database design and ran into a problem. The fact is that I will have a deal, and it will need to be carried out at different stages. So here's the problem:
How can I implement the log of this transaction? That is, let's say the user transferred a deal from one stage to another, and in viewing this deal, I need to display information about such movements, etc.
How can this be done with PHP?

Answer 1

Create a table for the log with a foreign key referring to the deal. When moving from one stage to another, add an entry to the log.