BiobankPanel? investigation.name problem with some of the duplicate values in name field.
general population is imported ok , but melanoma is a problem .
name | investigation_name | Category | Subcategory_name | Coordinators_Lastname | Size | Biodata_name | GwaDataNum | GwaComments | GeneralComments |
general_population | LRGP | Core Biobanks | Population development | lal1 | 122 | .. | ... | ... | ... |
general_population | epic-nl | core biobanks | population development | la2 | 100 | .. | .. | . | .. |
melanoma | GenoMEL | Core Biobanks | Population, development, birth and growth | lala | 1200 | dna | 600 | blabla | bla blabla bla |
melanoma | POLYGENE | Core Biobanks | Aging | blabla | 800 | plasma | 197 | blabla | bla |
compare -- diff bbmri_29_march.mysql ~/Desktop/bbmri_gcc_22march_backup.mysql : except from the capitalized constraint in every CONSTRAINT, there are differences that may produce this problem :
added constrain in Measurement entity :
< KEY `targettypeAllowedForRelation` (`targettypeAllowedForRelation`),
< CONSTRAINT `measurement_ibfk_3` FOREIGN KEY (`targettypeAllowedForRelation`) REFERENCES `molgenisentity` (`id`),
< CONSTRAINT `measurement_ibfk_1` FOREIGN KEY (`id`) REFERENCES `observablefeature` (`id`) ON DELETE CASCADE,
< CONSTRAINT `measurement_ibfk_2` FOREIGN KEY (`unit`) REFERENCES `ontologyterm` (`id`)
---
CONSTRAINT `Measurement_ibfk_1` FOREIGN KEY (`id`) REFERENCES `ObservableFeature` (`id`) ON DELETE CASCADE,
CONSTRAINT `Measurement_ibfk_2` FOREIGN KEY (`unit`) REFERENCES `OntologyTerm` (`id`)