Why are history system fields BigInt?

Userlevel 3
Badge +1

I am curious why system fields like SCD is Current & SCD is TombStone are datatype bigint. 


Is there a way to change them to tinyint? As far as I know they can only be 0 or 1. 


Best answer by rory.smith 6 April 2023, 16:35

View original

2 replies

Userlevel 6
Badge +7

Hi @sierd.zuiderveld ,


I have suggested using a smaller int type to TimeXtender in the past; tinyint has the drawback that it does not support negative numbers making calculations based on that field a bit more tricky. It would be nice to have a choice to make it a bit smaller anyhow.

Userlevel 6
Badge +5

Hi @sierd.zuiderveld currently this is not possible. Please see the idea Rory posted here, and feel free to upvote