I'm wondering if it would make more sense to add a post_id column with a foreign key to tblPosts.id so that it's easier to report on. I'm also considering changing the message format to JSON so I can include more data more easily, like entire error messages.
I should also add a status column to show if a row is referring to a successful action, or a failure of some kind. It would make reporting on that much easier, I think.
Currently tblHistory only has four columns:
I'm wondering if it would make more sense to add a post_id column with a foreign key to tblPosts.id so that it's easier to report on. I'm also considering changing the message format to JSON so I can include more data more easily, like entire error messages.