Change History - this file contains all changes since Version 2.0 (May 28, 2005) until Version 4.0 (April 22, 2009). Change history of GDPDM from Version 2.2 (February 7, 2008) to Version 4.0 (April 22, 2009). ------------------------------------------ - Removed unique constraint from div_passport.accename. - Added these fields for the Haplotype Packing Design: div_allele.binary_value, div_allele_assay.binary_position div_allele_assay.binary_annotation Change history of GDPDM from version November 20, 2006 to Version 2.2 (February 7, 2008). ------------------------------------------ - cdv_map_feature.chromosome_name changed to not required. - Documented suggested cdv_map_feature_annotation_type.anno_type values. values: ref_seq_cDNA, _chr, - Added another field to every table in the schema that acts as a global identifier across database instances. These fields are named _acc. - Added field lo_accession to the div_locality table. - Updated definitions for the following fields... div_locality.lo_accession, div_trait_uom.to_accession, div_trait_uom.eo_accession, div_taxonomy.term_accession - Removed div_treatment and div_treatment_uom from the documentation. These were deprecated. - In the DDL SQL script that creates an empty GDPDM database... Made div_trait_uom.local_trait_name unique NOT NULL. - Changed datatype of div_allele.proportion from int to double. Both in documentation and DDL SQL script. - Added div_sampstat table. This translates the sampstat codes into user friendly strings. Didn't use div_sampstat_id foreign key in div_passport to avoid compatability problems. - Removed following deprecated items from .sql database creation script... In table div_allele_assay, div_ref_stock_id, length, position, and ref_seq. Also div_generation.value, div_passport.germplasm_type. November 20, 2006 - Documentation changes since frozen on April 4, 2006. ------------------------------------------ - Added these codes to div_passport.sampstat docs. 114) Inbred line developed from wild material 314) Inbred line developed from a landrace - Clarified use of cdv_marker_annotation and div_aa_annotation to be only used to annotation the records intended. - Added standards for div_annotation_type, cdv_map_feature_annotation_type, and cdv_marker_annotation_type. - Updated cdv_marker table definition. Change history of GDPDM from version March 15, 2006 to Version 2.1 (April 4, 2006). ------------------------------------------ - Updated div_trait_uom.trait_protocol definition. Changed word brief to thorough. _ Added field eo_accession to table div_trait_uom. This was moved there from div_treatment_uom since div_treatment_uom is now deprecated. 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, 2005) 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.