User Tools

Site Tools


technical:versioning

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
technical:versioning [2022/12/27 00:19] – Added description of partitioning 92.8.125.195technical: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. 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''.+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 ^ ^ field ^ Data Type ^ NULL ^
technical/versioning.1672100340.txt.gz · Last modified: 2022/12/27 00:19 by 92.8.125.195

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki