Change History - this file contains all changes since Version 2.0 (May 28, 2005) until March 5, 2006. It is divided into sections showing change history for each published draft. 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. -