YCPRadioTelescope / RT-Contracts

Back-end architecture for the Radio Telescope Senior Software Design Project for the 2018-2019 academic year
3 stars 1 forks source link

Change the acceleration table's fields from float(4,3) to int #129

Closed pdnelson closed 1 year ago

pdnelson commented 3 years ago

Presently, the acceleration table's columns are set to be float(4,3), which means the max value is 9.999. This is problematic because when acceleration is saved (and exceeds 9.999), it is set to 9.999.

With the change of making the acceleration table's columns an int, their max value would be 2147483647, allowing a more-useful range of data. Additionally, this data is only ever coming through as short, so we can guarantee we are never going to need to store double values in here.