Versioning

It is essential to be able to look back at the core data and see when it was changed and by whom.

Tables that are versioned will have SYSTEM VERSIONING enabled. Plus, they will have these three fields immediately after the primary key and check key if included. They will be partitioned to separate the current and historical data. Historical data will go into a part_history partition and the current date into part_current.

field	Data Type	NULL
modifiedAt	TIMESTAMP	NO	The time of the modification. As this is the first `TIMESTAMP` field in the table, MariaDB will automatically populate it with the current time when the row is created and updated
modifiedBy	INT	NO	The ID of the Person who changed the data. `idPerson` in the Person table
modifyReason	VARCHAR(200)	YES	A user-supplied optional reason for the change