title: Create an history object with database data and external datas
body: <p>I face a complicated problem by creating an history for my mysql tables.
  My mysql database look like this:</p>
  <p><a href="https://i.stack.imgur.com/UgQaA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UgQaA.png" alt="my database" /></a></p>
  <p>So basically, i want to create a tuple SiteHistory for each creation, update and delete of <code>Site</code>.</p>
  <p>First I tryed to do it with a trigger but the field <code>agent_name</code> is provided from an external windows active directory and I can't access it from mysql.</p>
  <p>The other option is to do an insert in <code>SiteHistory</code> in my app for each create, update or delete but for maintenance reason, that can happen to insert, update or delete tuples directely in the database.</p>
  <p>If you have a better solution to offer, thanks to you.</p>