Exactly. You might have one group say that allele X "causes" some trait, whereas another group might report a more precise increase in odds ratio (for example) for the same genotype/phenotype.Is an association, for example, an experiment that establishes a dependent relationship? So could there be multiple associations between variant and phenotype?
Not the number of joins, but the number of association subclasses. If I have Nv variant subclasses and Np phenotype subclasses, I'd need Nv * Np association subclasses. Multiply that by the number of association subclasses.Is your concern that the number of joins will grow exponentially in the number of variants and phenotypes?
Thanks. I had considered that too and that's probably what I'll end up using.So all variants would be stored in the variants table, all phenotypes are in the phenotypes table, and you join through association.
-Reece
