Talk:Chado Post-Composed Phenotypes

Jump to: navigation, search

Older proposals

An example of an EQ statement and two options for how it could be stored in the proposed revised Phenotype Module are shown below. Both examples used the proposed Group Module. New and modified tables relative to Chado version 1.23 are indicated in green.

Option 1: Group Module is an intrinsic part of the phenotype_cvterm table


Option 2: Group Module is decoupled from the phenotype_cvterm table

Chado phenotype proposal.op2.png Sample SQL for loading and querying this structure is here.

Alternative: Represented directly in Group Module

This option separates the post-composed term completely from the phenotype table, permitting a particular statement to be re-used and to be attached to different types of data objects.

Chado phenotype proposal.v4.png