We are in an ETL (OMOP CDM 6.0) process. Our next step is the database creation. We are working on SQL Server.
There are 86 BIGINT in the sqlserver DDL scripts.
But I don’t find the reason why is it necessary except in a few case (eg.: https://github.com/OHDSI/CommonDataModel/issues/198).
As everyone knows
BIGINT is two time bigger than
Can I modify these data types in our case?
I’m sure that in our use case the
person_id is unnecessary we have around 1million person in our source system.
So my questions:
BIGINT necessary except a few column?
2.) Can I modify these columns data types? - can it hurt me in the future if I do this? (eg. compatibility with other systems)
Thank you for your answers!