snpr icon indicating copy to clipboard operation
snpr copied to clipboard

add unique key constraint on Phenotype table

Open raivivek opened this issue 8 years ago • 5 comments

Following from discussion on gitter.

raivivek avatar Jun 15 '16 18:06 raivivek

@gedankenstuecke I am going to assume that since we have a validation step at the controller stage there will be no duplicate entries in the Phenotype table right now. If not, then one may have to operate on the table and merge duplicate entries...

raivivek avatar Jun 15 '16 21:06 raivivek

@vivekiitkgp I think there were like 2-3 duplicate phenotypes which would have to be manually dealt with before. Thanks for the work on it so far!

gedankenstuecke avatar Jun 16 '16 08:06 gedankenstuecke

I'd prefer that we deal with it through a reviewable and testable migration over fiddeling around with it manually. ;)

tsujigiri avatar Jun 16 '16 08:06 tsujigiri

Fair enough :p

gedankenstuecke avatar Jun 16 '16 08:06 gedankenstuecke

@tsujigiri On it!

raivivek avatar Jun 17 '16 07:06 raivivek