Data type for numeric fields
Open
data
- Dominant language
- TypeScript
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Currently, all numeric fields are stored as data type of string instead of Int
Last time I researched briefly, string was the recommended way but need to research more.
One problem leaving them as string is that, I can cause duplications due to case.
For eg. If hypothetically, I have an employee with employee number 'matt123' in the database, I will have issues when I try to add a new employee with employee number 'MATT123'.
I guess I can add citext but then again I will have field validations so this shouldn't be allowed.
So, do I need to change string to numeric?
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.