Change History - this file contains all changes
since Version 2.0 (May 28, 2005) until
March 15, 2006.   It is divided into sections showing
change history for each published draft.



Change history of GDPDM from version
March 5, 2006 to version March 15, 2006.
------------------------------------------
- Deprecated div_generation.value.
  Use new fields selfing_number and
  sibbing_number.

- Added definitions for selfing_number
  and sibbing_number in table div_generation.

- Added definitions for cdv_source table
  and fields.

- Previously updated div_allele.value
  definition was incorrect (see below).
  That suggested convention is now added
  to the cdv_marker.ref_seq definition.

- Added definitions for fields accession
  and referencedb in table div_allele.

- Added tables cdv_marker_annotation
  and cdv_marker_annotation_type.

- Previously deprecated div_passport.source
  is no longer deprecated.   It is a
  required field.   The cdv_source stores
  contact information and is not required.



Change history of GDPDM from Version 2.0
(May 28, 2006) to version March 5, 2006.
------------------------------------------
- Clarified documentation on how to enter
  div_locality.latitude and div_locality.longitude
  for East, West, South, and North.

- Added this definition for table div_scoring_tech_type...
  The technology used to generate the data for a
  specific allele assay.

- Added this to div_allele.value definition...
  SNP polymorphisms will be given in alphabetical
  order -- eg.  [A/G]  or {C/T} rather than [G/A] or
  {T/C}. Indels will be indicated by [TCG/] or {CGTA/]
  rather then by [TCG/-] or {CGTA/----}.

- Reordered some fields in the DDL according to
  Ken's proposal...
  "...I propose that the field that
  would contain the string you'd call a record
  from that table be placed just after the primary
  key and any foreign keys, which should
  be grouped first.  Further, I think it would be
  nice to put "comments" fields always at the end
  of the table definition."

- div_treatment and div_treatment_uom tables
  are now deprecated.  div_trait and
  div_trait_uom should be used to store
  data originally intended for div_treatment
  and div_treatment_uom.

- div_stock_parent.recurrent changed to data type
  integer from boolean.   This is new definition
  of recurrent...
  Integer value indicating number of times this parent
  repeatedly crossed.   Default value is 0.
  Example: A = ((B x C) x B) x B.
  Parent B would have recurrent value of 2.
  Parent C would have recurrent value 0.

- Added fields selfing_number and sibbing_number
  to div_generation table.

- Add tables: cdv_source, cdv_map_feature_annotation,
  and cdv_map_feature_annotation_type.   Added
  div_passport.cdv_source_id foreign key to
  point to cdv_source.   Deprecated
  div_passport.source since we now have cdv_source.