====== 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 [[table_types|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 |