Change history of GDPDM from version April 25, 2005 to version April 29, 2005. --------------------------------------------- - Moved reference to div_scoring_tech_type to table div_allele_assay instead of div_aa_annotation. - Corrected div_taxa_family to reflect levels for plant instead of animals. - Added field common_name to the div_taxonomy table. - Changed all primary and foreign keys to be unsigned integers. Effectively doubling the range of values as keys generally are not negative. - Changed data type of div_trait_uom.to_accession and div_treatment_uom.eo_accession to varchar instead of int. Necessary for integration with Gramene. - For consistency, changed the following field names to "comments": div_passport.remarks div_stock.remarks div_synonym.remarks div_generation.remarks div_obs_unit.summary Change history of GDPDM from version August 24, 2004 (frozen) to version April 25, 2005. ------------------------------------------ - Changed all numbers to default to NULL instead of zero. - In table: cdv_map_feature, changed field chromosome_number to chromosome_name and changed data type to text. - Updated the documentation for table: div_poly_type field: poly_type to have "Categorical" instead of "Mobility". - Added fields referencedb and accession to table div_allele. - Changed data type of these fields from varchar to text. div_obs_unit_sample.comments cdv_marker.ref_seq cdv_allele_assay.ref_seq div_passport.remarks div_stock.remarks div_synonym.remarks div_trait_uom.trait_protocol cdv_curation.comments cdv_map_feature.comments cdv_reason.description div_allele_assay.comments div_experiment.comments div_obs_unit_summary - Added table div_scoring_tech_type which is referenced by table div_aa_annotation. - Added field season to table div_obs_unit. - Added div_taxa_family table to further specify the Taxonomy. The div_taxonomy table references this new table. - Updated descriptions to reflect actual mySQL data types for each field. - Fields div_experiment.originator and div_trait.div_statistic_type changed to required. - Updated description for: table: div_accession_collecting field: div_passport.accename table: div_experiment table: div_generation table: div_obs_unit table: div_passport table: div_stock table: div_stock_parent field: div_stock_parent.div_parent_id table: div_synonym table: div_trait table: div_trait_uom field: div_trait_uom.trait_protocol table: div_treatment table: div_treatment_uom