Differences

This shows you the differences between two versions of the page.

--- technical:versioning [2022/12/19 22:44] – created admin
+++ technical:versioning [2022/12/27 00:21] (current) – 92.8.125.195
@@ Line 3: / Line 3: @@
 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.
+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 ^