Missing foreign keys from 3.1.0 download for database script #78
Description
Hi, thank you for your resource, the data is very valuable for us.
I have encountered some errors attempting to use the database restore as the csv files do not all contain the necessary foreign keys in all files.
For example, errors such as this occur:
ERROR: insert or update on table "product_to_rxnorm" violates foreign key constraint "product_to_rxnorm_rxnorm_product_id_fkey"
DETAIL: Key (rxnorm_product_id)=(2700735) is not present in table "vocab_rxnorm_product".
Upon examination of the data I have found that vocab_meddra_adverse_effect is missing 1902 entries that are referenced by product_adverse_effect and also vocab_rxnorm_product is missing 191 entries referenced by product_to_rxnorm.
Could you confirm if this is an issue with data export to the v3.1.0 release and if it is likely to be resolved in the future?
I have attached a full report of the missing foreign keys