Skip to main content
Solved

Why are history system fields BigInt?

  • April 6, 2023
  • 2 replies
  • 55 views

sierd.zuiderveld
Contributor
Forum|alt.badge.img+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

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.

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • Answer
  • April 6, 2023

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.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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