# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_allele_curated_allele'
# 
CREATE TABLE `cdv_allele_curated_allele` (
  `cdv_allele_curated_allele_id` bigint(20) NOT NULL auto_increment,
  `cdv_curated_allele_id` bigint(20) default NULL,
  `div_allele_id` bigint(20) default NULL,
  `cdv_curation_id` bigint(20) default NULL,
  PRIMARY KEY  (`cdv_allele_curated_allele_id`),
  KEY `cdv_allele_curated_allele_id` (`cdv_allele_curated_allele_id`),
  KEY `cdv_curated_allele_id` (`cdv_curated_allele_id`),
  KEY `cdv_curation_id` (`cdv_curation_id`),
  KEY `div_allele_id` (`div_allele_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_curated_allele'
# 
CREATE TABLE `cdv_curated_allele` (
  `cdv_curated_allele_id` bigint(20) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`cdv_curated_allele_id`),
  KEY `cdv_curated_allele_id` (`cdv_curated_allele_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_curation'
# 
CREATE TABLE `cdv_curation` (
  `cdv_curation_id` bigint(20) NOT NULL auto_increment,
  `cdv_reason_id` bigint(20) default NULL,
  `curator` varchar(50) default NULL,
  `curation_date` datetime default NULL,
  `comments` varchar(50) default NULL,
  PRIMARY KEY  (`cdv_curation_id`),
  KEY `cdv_curation_id` (`cdv_curation_id`),
  KEY `cdv_reason_id` (`cdv_reason_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_map_feature'
# 
CREATE TABLE `cdv_map_feature` (
  `cdv_map_feature_id` bigint(20) NOT NULL auto_increment,
  `chromosome_number` bigint(20) default NULL,
  `comments` varchar(50) default NULL,
  `genetic_bin` varchar(50) default NULL,
  `xref_map_id` varchar(50) default NULL,
  `genetic_map` varchar(50) default NULL,
  `genetic_position` double default NULL,
  `locus_type` varchar(50) default NULL,
  `name` varchar(50) default NULL,
  `physical_position` double default NULL,
  PRIMARY KEY  (`cdv_map_feature_id`),
  KEY `locusID` (`cdv_map_feature_id`),
  KEY `xref_map_id` (`xref_map_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_marker'
# 
CREATE TABLE `cdv_marker` (
  `cdv_marker_id` bigint(20) NOT NULL auto_increment,
  `cdv_map_feature_id` bigint(20) default NULL,
  `name` varchar(50) default NULL,
  `ref_seq` varchar(50) default NULL,
  `div_ref_stock_id` bigint(20) default NULL,
  `marker_aid` varchar(50) default NULL,
  PRIMARY KEY  (`cdv_marker_id`),
  KEY `diversity_locus_id` (`cdv_map_feature_id`),
  KEY `diversity_maker_id` (`cdv_marker_id`),
  KEY `marker_aid` (`marker_aid`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_passport_group'
# 
CREATE TABLE `cdv_passport_group` (
  `cdv_passport_group_id` bigint(20) NOT NULL auto_increment,
  `group_name` varchar(50) default NULL,
  PRIMARY KEY  (`cdv_passport_group_id`),
  KEY `div_passport_group_id` (`cdv_passport_group_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_passport_set'
# 
CREATE TABLE `cdv_passport_set` (
  `cdv_passport_set_id` bigint(20) NOT NULL auto_increment,
  `div_passport_id` bigint(20) default NULL,
  `cdv_passport_group_id` bigint(20) default NULL,
  PRIMARY KEY  (`cdv_passport_set_id`),
  KEY `div_passport_group_id` (`cdv_passport_group_id`),
  KEY `div_passport_set_id` (`cdv_passport_set_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'cdv_reason'
# 
CREATE TABLE `cdv_reason` (
  `cdv_reason_id` bigint(20) NOT NULL auto_increment,
  `description` varchar(50) default NULL,
  PRIMARY KEY  (`cdv_reason_id`),
  KEY `cdv_reason_id` (`cdv_reason_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_aa_annotation'
# 
CREATE TABLE `div_aa_annotation` (
  `div_aa_annotation_id` bigint(20) NOT NULL auto_increment,
  `div_annotation_type_id` bigint(20) default NULL,
  `div_allele_assay_id` bigint(20) default NULL,
  `annotation_value` text,
  PRIMARY KEY  (`div_aa_annotation_id`),
  KEY `div_aa_annotationdiv_annotation_type_id` (`div_annotation_type_id`),
  KEY `genotypeExpAnnotationID` (`div_aa_annotation_id`),
  KEY `genotypeExpID` (`div_allele_assay_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_accession_collecting'
# 
CREATE TABLE `div_accession_collecting` (
  `div_accession_collecting_id` bigint(20) NOT NULL auto_increment,
  `div_locality_id` bigint(20) default NULL,
  `collector` varchar(50) default NULL,
  `collnumb` varchar(50) default NULL,
  `collsrc` varchar(50) default NULL,
  `collcode` varchar(50) default NULL,
  PRIMARY KEY  (`div_accession_collecting_id`),
  KEY `collcode` (`collcode`),
  KEY `div_accession_collecting_id` (`div_accession_collecting_id`),
  KEY `div_locality_id` (`div_locality_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_allele'
# 
CREATE TABLE `div_allele` (
  `div_allele_id` bigint(20) NOT NULL auto_increment,
  `div_obs_unit_sample_id` bigint(20) default NULL,
  `div_allele_assay_id` bigint(20) default NULL,
  `allele_num` bigint(20) default NULL,
  `quality` text,
  `value` text,
  `proportion` bigint(20) default NULL,
  `total_n` bigint(20) default NULL,
  PRIMARY KEY  (`div_allele_id`),
  KEY `allele_num` (`allele_num`),
  KEY `div_allele_assay_id` (`div_allele_assay_id`),
  KEY `div_stock_sample_id` (`div_obs_unit_sample_id`),
  KEY `genotypeID` (`div_allele_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_allele_assay'
# 
CREATE TABLE `div_allele_assay` (
  `div_allele_assay_id` bigint(20) NOT NULL auto_increment,
  `div_source_assay_id` bigint(20) default NULL,
  `div_poly_type_id` bigint(20) default NULL,
  `cdv_marker_id` bigint(20) default NULL,
  `comments` varchar(50) default NULL,
  `assay_date` datetime default NULL,
  `name` varchar(50) default NULL,
  `producer` varchar(50) default NULL,
  `position` varchar(50) default NULL,
  `ref_seq` varchar(50) default NULL,
  `div_ref_stock_id` bigint(20) default NULL,
  `length` bigint(20) default NULL,
  PRIMARY KEY  (`div_allele_assay_id`),
  KEY `div_marker_id` (`cdv_marker_id`),
  KEY `div_poly_type_id` (`div_poly_type_id`),
  KEY `div_ref_stock_id` (`div_ref_stock_id`),
  KEY `div_source_assay_id` (`div_source_assay_id`),
  KEY `genotypeExpID` (`div_allele_assay_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_annotation_type'
# 
CREATE TABLE `div_annotation_type` (
  `div_annotation_type_id` bigint(20) NOT NULL auto_increment,
  `anno_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_annotation_type_id`),
  KEY `annotationTypeID` (`div_annotation_type_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_experiment'
# 
CREATE TABLE `div_experiment` (
  `div_experiment_id` bigint(20) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `design` varchar(50) default NULL,
  `originator` varchar(50) default NULL,
  `comments` varchar(50) default NULL,
  PRIMARY KEY  (`div_experiment_id`),
  KEY `phenotype_exp_id` (`div_experiment_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_generation'
# 
CREATE TABLE `div_generation` (
  `div_generation_id` bigint(20) NOT NULL auto_increment,
  `value` varchar(50) default NULL,
  `remarks` varchar(50) default NULL,
  `icis_id` varchar(50) default NULL,
  PRIMARY KEY  (`div_generation_id`),
  KEY `div_generation_id` (`div_generation_id`),
  KEY `icis_id` (`icis_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_locality'
# 
CREATE TABLE `div_locality` (
  `div_locality_id` bigint(20) NOT NULL auto_increment,
  `elevation` bigint(20) default NULL,
  `city` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `origcty` varchar(50) default NULL,
  `latitude` double default NULL,
  `longitude` double default NULL,
  `locality_name` varchar(50) default NULL,
  `state_province` varchar(50) default NULL,
  PRIMARY KEY  (`div_locality_id`),
  KEY `localityID` (`div_locality_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_obs_unit'
# 
CREATE TABLE `div_obs_unit` (
  `div_obs_unit_id` bigint(20) NOT NULL auto_increment,
  `div_experiment_id` bigint(20) default NULL,
  `div_stock_id` bigint(20) default NULL,
  `div_locality_id` bigint(20) default NULL,
  `name` varchar(50) default NULL,
  `coord_x` bigint(20) default NULL,
  `coord_y` bigint(20) default NULL,
  `rep` varchar(50) default NULL,
  `block` varchar(50) default NULL,
  `plot` varchar(50) default NULL,
  `plant` varchar(50) default NULL,
  `planting_date` datetime default NULL,
  `harvest_date` datetime default NULL,
  `summary` varchar(255) default NULL,
  PRIMARY KEY  (`div_obs_unit_id`),
  KEY `div_experiment_id` (`div_experiment_id`),
  KEY `div_stock_id` (`div_stock_id`),
  KEY `locality_id` (`div_locality_id`),
  KEY `obs_unit_id` (`div_obs_unit_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_obs_unit_sample'
# 
CREATE TABLE `div_obs_unit_sample` (
  `div_obs_unit_sample_id` bigint(20) NOT NULL auto_increment,
  `div_obs_unit_id` bigint(20) default NULL,
  `sample_date` datetime default NULL,
  `name` varchar(50) default NULL,
  `producer` varchar(50) default NULL,
  `comments` varchar(50) default NULL,
  PRIMARY KEY  (`div_obs_unit_sample_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_stock_sample_id` (`div_obs_unit_sample_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_passport'
# 
CREATE TABLE `div_passport` (
  `div_passport_id` bigint(20) NOT NULL auto_increment,
  `div_taxonomy_id` bigint(20) default NULL,
  `div_accession_collecting_id` bigint(20) default NULL,
  `accename` varchar(50) default NULL,
  `remarks` varchar(50) default NULL,
  `germplasm_type` varchar(50) default NULL,
  `source` varchar(50) default NULL,
  `accenumb` varchar(50) default NULL,
  `sampstat` varchar(50) default NULL,
  PRIMARY KEY  (`div_passport_id`),
  KEY `div_accession_collecting_id` (`div_accession_collecting_id`),
  KEY `div_taxonomy_id` (`div_taxonomy_id`),
  KEY `passportID` (`div_passport_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_poly_type'
# 
CREATE TABLE `div_poly_type` (
  `div_poly_type_id` bigint(20) NOT NULL auto_increment,
  `poly_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_poly_type_id`),
  KEY `div_poly_type_id` (`div_poly_type_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_statistic_type'
# 
CREATE TABLE `div_statistic_type` (
  `div_statistic_type_id` bigint(20) NOT NULL auto_increment,
  `stat_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_statistic_type_id`),
  KEY `div_statistic_type_id` (`div_statistic_type_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_stock'
# 
CREATE TABLE `div_stock` (
  `div_stock_id` bigint(20) NOT NULL auto_increment,
  `div_generation_id` bigint(20) default NULL,
  `div_passport_id` bigint(20) default NULL,
  `seed_lot` varchar(50) default NULL,
  `stock_source` varchar(50) default NULL,
  `remarks` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_id`),
  KEY `div_generation_id` (`div_generation_id`),
  KEY `div_passport_id` (`div_passport_id`),
  KEY `div_stock_id` (`div_stock_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_stock_parent'
# 
CREATE TABLE `div_stock_parent` (
  `div_stock_parent_id` bigint(20) NOT NULL auto_increment,
  `div_stock_id` bigint(20) default NULL,
  `div_parent_id` bigint(20) default NULL,
  `recurrent` tinyint(4) default NULL,
  `role` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_parent_id`),
  KEY `parentID` (`div_parent_id`),
  KEY `stockID` (`div_stock_id`),
  KEY `stockParentID` (`div_stock_parent_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_synonym'
# 
CREATE TABLE `div_synonym` (
  `div_synonym_id` bigint(20) NOT NULL auto_increment,
  `div_passport_id` bigint(20) default NULL,
  `synonym` varchar(50) default NULL,
  `remarks` varchar(50) default NULL,
  PRIMARY KEY  (`div_synonym_id`),
  KEY `div_passport_id` (`div_passport_id`),
  KEY `div_synonym_id` (`div_synonym_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_taxonomy'
# 
CREATE TABLE `div_taxonomy` (
  `div_taxonomy_id` bigint(20) NOT NULL auto_increment,
  `genus` varchar(50) default NULL,
  `species` varchar(50) default NULL,
  `subspecies` varchar(50) default NULL,
  `subtaxa` varchar(50) default NULL,
  `race` varchar(50) default NULL,
  `population` varchar(50) default NULL,
  PRIMARY KEY  (`div_taxonomy_id`),
  KEY `div_taxonomy_id` (`div_taxonomy_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_trait'
# 
CREATE TABLE `div_trait` (
  `div_trait_id` bigint(20) NOT NULL auto_increment,
  `div_trait_uom_id` bigint(20) default NULL,
  `div_statistic_type_id` bigint(20) default NULL,
  `div_obs_unit_id` bigint(20) default NULL,
  `date_measured` datetime default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_statistic_type_id` (`div_statistic_type_id`),
  KEY `div_trait_uom_id` (`div_trait_uom_id`),
  KEY `phenotypeID` (`div_trait_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_trait_uom'
# 
CREATE TABLE `div_trait_uom` (
  `div_trait_uom_id` bigint(20) NOT NULL auto_increment,
  `to_accession` bigint(20) default NULL,
  `div_unit_of_measure_id` bigint(20) default NULL,
  `local_trait_name` varchar(50) default NULL,
  `trait_protocol` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_uom_id`),
  KEY `div_trait_uom_id` (`div_trait_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`),
  KEY `qtl_trait_ontology_id` (`to_accession`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_treatment'
# 
CREATE TABLE `div_treatment` (
  `div_treatment_id` bigint(20) NOT NULL auto_increment,
  `div_treatment_uom_id` bigint(20) default NULL,
  `div_obs_unit_id` bigint(20) default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_id`),
  KEY `div_entry_treatment_id` (`div_treatment_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_treatment_uom_id` (`div_treatment_uom_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_treatment_uom'
# 
CREATE TABLE `div_treatment_uom` (
  `div_treatment_uom_id` bigint(20) NOT NULL auto_increment,
  `eo_accession` bigint(20) default NULL,
  `div_unit_of_measure_id` bigint(20) default NULL,
  `local_treatment_name` varchar(50) default NULL,
  `treatment_protocol` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_uom_id`),
  KEY `div_treatment_id` (`eo_accession`),
  KEY `div_treatment_uom_id` (`div_treatment_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`)
) TYPE=InnoDB; 

# Host: 192.168.0.3
# Database: gdpdm_20040824
# Table: 'div_unit_of_measure'
# 
CREATE TABLE `div_unit_of_measure` (
  `div_unit_of_measure_id` bigint(20) NOT NULL auto_increment,
  `unit_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_unit_of_measure_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`)
) TYPE=InnoDB;