Observation table has incorrect data type for provider_id

OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)

https://ohdsi.github.io/CommonDataModel

877 stars 448 forks source link

Observation table has incorrect data type for provider_id #304

Closed mseal-cherokeehealth closed 3 years ago

mseal-cherokeehealth commented 4 years ago

In OMOP CDM sql server ddl.txt, observation.provider_id has the data type of INTEGER. This should be BIGINT as this causes the foreign key fpk_observation_provider, which points to provider.provider_id, to break.

clairblacketer commented 4 years ago

Thanks for noticing! I will be sure to fix it

stephanieshong commented 3 years ago

@clairblacketer -Does this mean that all the places where the provider_id is referenced should be now changed to bigint?

clairblacketer commented 3 years ago

@stephanieshong no, this is an old issue related to v6.0