wiki:DespoinaLog/2011/03/29

Version 3 (modified by antonak, 14 years ago) (diff)

--

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`)