GDPDM pending issues as of April 22, 2009
---------------------------------------------------


- How do we need to handle "phase determined"?  This was
  a field in the div_allele_assay table, but phase matters
  over mulitple assays.

- Need to make sure assignment of required/not required
  fields are appropriate.

- Do we need something to code crosses in the
  div_passport table?  Have standard nomenclature
  for div_generation?

- Should there be a way to keep track of "dominant
  allele_assays?"  Scoring tech type table may cover this.

- How do we handle synonyms with biological confidence
  at the passport level?

- rename cdv_marker to cdv_ref_genomic_sequence?
  many to many relationship between div_marker and
  div_map_feature?

- Should div_experiment also group allele assays?
  Maybe another grouping table for div_allele_assays?
  And a third to group "groups of experiments" and
  "groups of allele assays"?

- Do we need fields to manage owner of records?

- [Ken] Allow a many-to-many relationship between
  div_passport and cdv_source:  According to Isaak,
  germplasms may be available from more than one source.
  Also, I would prefer to deprecate the
  "div_passport.source" field and move this info to the
  normalized "cdv_source" table.

- [Ken] Allow for annotations/xrefs on germplasm names/synonyms:
  This is a combination of ideas.  First off, it would be
  nice to attribute a germplasm's synonyms, e.g., to say that
  "IRGC 3575" is an IRRI synonym.  This could be accomplished
  by adding a "synonym_type" table with a FK to "div_synonym":

  CREATE TABLE div_synonym_type (
    div_synonym_type_id int PK,
    synonym_type varchar(50), -- e.g., "IRRI"
    xref_url text             -- e.g., sprintf-type URL template,
    -- "http://www.iris.irri.org/action/gms?method=getGmsList&search=%s"
  );

  This would be even more useful if ALL germplasm names could
  be attributed and xref'd, so you'd remove the
  "div_passport.accename" and add a "div_display_synonym_id" field
  instead to indicate which synonym is used for the display.  It
  creates a somewhat bizarre circular reference (no worse than others
  already in GDPDM, like those that reference other records in the
  same table [div_parent_id]), but it makes for a very flexible way
  to both search just one table for germplasm names and to put their
  sources into the db.  It's possible some sort of "annotation" table
  could also be used, but this way just makes everything explicit.