Open kzollove opened 11 months ago
These data types are holdovers from the prototype of the data model. Some of them (varchar(x) in particular) go against some best practices for postgres. In general, they should be more simple unless they provide some benefit of being complex.
Data model can be viewed here
Consider:
This shouldnt be a hard problem. This will be a win if the data types used are more uniform.
@tibbben would love your input on this
Hi @kzollove While these considerations may not be new, they are still relevant. In the context of OMOP convention with PostgreSQL:
These data types are holdovers from the prototype of the data model. Some of them (varchar(x) in particular) go against some best practices for postgres. In general, they should be more simple unless they provide some benefit of being complex.
Data model can be viewed here
Consider:
This shouldnt be a hard problem. This will be a win if the data types used are more uniform.