> Your database starts to look like git... No, your table archives start to look like git. Which is not a bad thing, version control on data in a database is v

> Your database starts to look like git... No, your table archives start to look like git. Which is not a bad thing, version control on data in a database is very difficult, if not impractical to realize, I would take any history that I can get... "Synthetic" keys are just that, keys for tables that only have meaning within the context of that data. You can of course relate your records to as many other tables as you wish, but you identify records via those keys, nothing more.