//This model file has been updated on 7-14-94 by Madhavan Sridhar.

//The info has been taken fron graingenes and acedb.

//Needs updation in Germplasm and Trait Study.


?Allele Reference ?Paper XREF Allele
	Correct_name UNIQUE ?Allele XREF Other_name
	Other_name ?Allele XREF Correct_name ?Paper
	Compound_allele ?Allele XREF Component_allele ?Paper
	Component_allele ?Allele XREF Compound_allele ?Paper
	Gene UNIQUE ?Gene XREF Allele //Put the Reference in the ?Gene record
	Locus UNIQUE ?Locus XREF Associated_Allele 
	Gene_product ?Gene_Product XREF Allele ?Paper
	Cultivaral_stock ?Germplasm XREF Allele ?Paper
	Hexaploid_stock ?Germplasm XREF Allele ?Paper
	Tetraploid_stock ?Germplasm XREF Allele ?Paper
	Diploid_stock ?Germplasm XREF Allele ?Paper
	Near_isogenic_stock ?Germplasm XREF Allele ?Paper
	Homologous_chromosome_substitution_line ?Text ?Paper
	Alien_chromosome_addition_line ?Text ?Paper
	Alien_chromosome_substitution_line ?Text ?Paper
	Translocation_line ?Text ?Paper
	Reference_Germplasm ?Germplasm XREF Allele ?Paper
	Origin ?Text ?Paper	//for non-germplasms like "Ace*4/CS"
	Germplasm ?Germplasm XREF Allele
        Reference_allele ?Text
                         For ?Allele XREF Like_ref_allele
        Like_ref_allele ?Allele XREF For
	Comment	?Text
        Mutagen UNIQUE ?Reagent Text	// Text is dose
        Location ?Colleague  #Lab_Location
	Author	?Author
	Date	Text
        Genetics        gMap UNIQUE ?Linkage_Group XREF Allele Float Float
                        Mapping_data    2Point ?2_point_data
                                        3Point ?3_point_data
                                        Df_Dup ?Df_Dup_data
			Covers Text // for Df's or Dp's with allele names
	Pathology ?Pathology XREF Resistant_allele
        Phenotype       ?Text
			Image ?Image XREF Allele
			Qualifier Text
                        Recessive
			Intragenic_revertant_of_dominant
                        Dominant
			Semi-dominant
			Codominant //Lisa
			Weak
		        Temperature_Sensitive	Thermo_sensitive
						Cryo_sensitive
			Amber
                        Maternal	Strictly_Maternal
					Maternal_and_Zygotic
					With_Maternal_effect
                        Paternal
                        Ease_of_scoring UNIQUE Float
	                Interactions    Suppressed_by	?Gene XREF  Interacting_alleles ?Allele XREF Suppresses
//                                                      	?Allele XREF Suppresses //Bad syntax in v. 1.9
                                        Suppresses 	?Gene XREF  Interacting_alleles ?Allele XREF Suppressed_by
//                                                      	?Allele XREF  Suppressed_by //Bad syntax in v. 1.9
	Other_information ?Text
        Molecular_nature        Probe ?Probe XREF Allele
                                Sequence ?Sequence
				Polymorphism Found  ?Probe XREF Found
				             Absent ?Probe XREF Absent
				RFLP ?Locus XREF Allele
	Numbered_reference Int ?Paper XREF Allele //Int is a numbered reference
						//citation used in a Comment.


//This Text is added to accomodate the seed/yield/fiber text info in all the
//records.This avoids typing same text in all the records.

?Texts  Remark ?Text


//?Gene_Class:  DEM extended, 5/93
//see abbreviation list in Catalogue of Gene Symbols for Wheat, 1988, p.1295
//DEM 9/93 Added Trait_affected
//DEM 11/93 removed (should link to Allele instead, maybe Gene):
//		Gene_product ?Gene_Product
?Gene_Class     Reference ?Paper XREF Gene_class
		Abbreviation ?Text		//eg "Adh"
		Homologous_gene_set ?Gene_Set XREF Gene_class
		Character_affected ?Text
                Gene ?Gene XREF Gene_class
		Comment Text
		Numbered_reference Int ?Paper XREF Gene_class //Int is a  
			//numbered reference citation used in a Comment.

//DEM 11/93 created.  E.g. Aadh-1 is a homologous gene set in the Gene_Class
//Aadh.
?Gene_Set 	Reference ?Paper XREF Gene_Set
		Abbreviation ?Text		//eg "Adh-1"
		Gene_class ?Gene_Class XREF Homologous_gene_set
		Character_affected ?Text
                Gene ?Gene XREF Homologous_gene_set
		Comment Text
		Numbered_reference Int ?Paper XREF Gene_Set //Int is a  
			//numbered reference citation used in a Comment.

//?Gene:  DEM May 93 Modified to load the Catalogue of Gene Symbols for Wheat
//lines removed or changed:
//?Gene Name	Gene_class UNIQUE ?Gene_Class XREF Gene
//		Correct_name ?Gene XREF Other_name
//              Other_name ?Gene XREF Other_name
//      Reference_Allele ?Allele XREF Gene Text
//      Allele  ?Allele XREF Gene
//	Origin ?Text
//    New:
//	Cultivaral_stock ?Germplasm XREF Gene ?Paper, etc.
//10/93 Added link to ?Gene_Product.  Moved Reference to top of model.
// Gary Hart, email of 11/16/93: v, tv, dv, al, and i stocks should be
//	?Germplasm; ad, s, su and tr should be ?Text
?Gene	Reference ?Paper XREF Gene //The standard reference describing the gene
	Gene_class UNIQUE ?Gene_Class XREF Gene
	Homologous_gene_set ?Gene_Set XREF Gene
	Other_name ?Gene XREF Correct_name ?Paper  //Should XREF the Paper too?
	Correct_name ?Gene XREF Other_name ?Paper
	Compound_gene ?Gene XREF Component_gene ?Paper
	Component_gene ?Gene XREF Compound_gene ?Paper
	Gene_product ?Gene_Product XREF Gene ?Paper
	Chromosome ?Text ?Paper
	Chromosome_arm ?Text ?Paper
	Cultivaral_stock ?Germplasm XREF Gene ?Paper
	Hexaploid_stock ?Germplasm XREF Gene ?Paper
	Tetraploid_stock ?Germplasm XREF Gene ?Paper
	Diploid_stock ?Germplasm XREF Gene ?Paper
	Near_isogenic_stock ?Germplasm XREF Gene ?Paper
	Homologous_chromosome_substitution_line ?Text ?Paper
	Alien_chromosome_addition_line ?Text ?Paper
	Alien_chromosome_substitution_line ?Text ?Paper
	Translocation_line ?Text ?Paper
	Origin ?Text ?Paper	//for non-germplasms like "Ace*4/CS"
	Reference_allele UNIQUE ?Allele XREF Gene ?Paper REPEAT
	Allele ?Allele XREF Gene ?Paper
	Comment Text
        Molecular_information	Probe   ?Probe XREF Gene
				Sequence ?Sequence XREF Gene
				RFLP ?Locus XREF Gene
	IUB_number ?Text //Lisa
	EC_number ?Text //Lisa
	Phenotype ?Text	//DEM 9/93 Change to Trait_affected? See Gene_class
	Pathology ?Pathology XREF Resistance_gene //DEM
	Image ?Image XREF Gene
	Other_information ?Text
        Mapping_information	Locus ?Locus XREF Associated_Gene //lisa //lisa also changed Map to Mapping_information
				Physical bMap UNIQUE ?Contig XREF Gene Int Int
                        	Autopos
                		Genetic  gMap UNIQUE ?Linkage_Group XREF Gene Float Float
                        	In_cluster ?Gene
				Marker_gene
				Uncovered_by ?Rearrangement XREF Uncovers
			 	Not_uncovered_by ?Rearrangement XREF Does_not_uncover
				Carried_by ?Rearrangement XREF Carries
			 	Not_carried_by ?Rearrangement XREF Does_not_carry
	Mapping_data	2_point_data ?2_point_data //lisa changed from 2point
                        3Point ?3_point_data
			Df_Dup ?Df_Dup_data
			F2_data ?Map
                	In_situ UNIQUE ?Linkage_Group Float
        Fine_structure_data  2PointFine ?2_point_data
                             3PointFine ?3_point_data
			     Df_DupFine ?Df_Dup_data
        Dosage_effects  Haplo_insufficiency
        Related_genes   ?Gene XREF Related_genes
                        Gene_family ?Gene XREF Gene_family
                        Interacting_genes ?Gene XREF Interacting_genes
                        Interacting_alleles ?Allele
	Numbered_reference Int ?Paper XREF Gene //Int is a numbered reference
						//citation used in a Comment.

?Rearrangement  Name    Correct_name ?Rearrangement XREF Other_name
                	Other_name ?Rearrangement XREF Other_name
	        Reference_germplasm ?Germplasm  Text
		Remark ?Text
		Variant Text
	        Molecular_Information  Polymorphism Found  ?Probe XREF Found
					            Absent ?Probe XREF Absent
		Mutagen ?Reagent Text	// Text is dose
		Phenotype	?Text
	        Dosage_effects  Haplo_insufficiency
		Qualifier Text
		Location ?Colleague  #Lab_Location
		Author Text
		Date Text
		Type    Deletion Uncovers ?Gene XREF Uncovered_by
                                 Does_not_uncover ?Gene XREF Not_uncovered_by
        	        Duplication 	Covers Text
					Carries ?Gene XREF Carried_by
	                                Does_not_carry ?Gene XREF Not_carried_by
			Translocation
			Compound
        	Mapping_information     Physical bMap UNIQUE ?Contig XREF Rearrangement Int Int
                	         	Autopos
	                		Genetic  gMap UNIQUE ?Linkage_Group XREF Rearrangement Float Float // pieces duplicated (in Dp) or deleted (in Df)
				 	gMap2 ?Linkage_Group XREF Rearrangement Float Float // other pieces involved (e.g. 'f')
		Mapping_data	2Point ?2_point_data
				3Point ?3_point_data
				Df_Dup ?Df_Dup_data
	        In_situ  UNIQUE ?Linkage_Group Float Float
	        Germplasm	?Germplasm XREF Rearrangement //approx=line 122
        	        	Transformed_strain ?Germplasm
                		Linked_double ?Germplasm ?Gene
        	Reference ?Paper XREF Rearrangement


// ?Genus_Species added for AGsDB by Madhavan Sridhar.

?Genus_Species	Name UNIQUE Text
		Map ?Map

//?Locus
//DEM 5 Oct 92:
//	New "Type" values: RAPD, Gene
//	Removed:
//	Mapped_bands	Map ?Map //Lisa
//			Enzyme ?Restriction //Lisa
//			A81-356022 float  //Lisa
//			PI468.916 float  //Lisa
//v1.5, Feb 93:
//	"Mapping_information" -> "Map"
//	Data ?F2_data -> Data ?Map
// S.Tanksley 3/93 says Locus_type's should include: RFLP RAPD PCR VNTR
//      Microsatellite Isozyme Gene (Gene includes Morph, Resistance, etc.)
//v1.6: Added: QTL, Linked_QTL, Image
//	Removed:
//	Not_used ?Restriction REPEAT
//      Polymorphic_for ?Restriction REPEAT //Lisa
//	Not_polymorphic_for ?Restriction REPEAT
//Note: Changing "Map Genetic gMap" to "Map gMap" kills all gMap drawing!!

//Locus data added from agsdb10 by madhavan Sridhar on 7/18/94.

?Locus	Name		UNIQUE Text
	Other_name	Text
	Type		UNIQUE Text
	Current_symbol	UNIQUE Text
	Previous_symbol	UNIQUE Text
	Genus_Species	?Genus_Species XREF Locus
	Species_origin	?Text
	Biology		Niche ?Text
			Gene_product ?Text
			Function ?LongText
			Interaction ?Locus
			Allele ?Text
			Phenotype ?LongText
	Location	Map ?Map XREF Locus #map_location
			Chromosome ?Text
			Chromosome_arm ?Text
			Cytogenetic_location ?Text
			Marker_distance Text
			Syntenic_Group	?Text			
			Linkage_Group	?Text
			Assign_mode	Text
			Linkage ?Text
			Main_Marker ?Map XREF Main_Marker
			Inside  Inside_YAC  ?YAC XREF Locus
			Inside_Fragment ?Fragment XREF Locus
			Chrom_Band ?Chrom_Band XREF Locus
	Homologs	Homolog ?Locus
                        Homolog_chromosome ?Text
                        Homolog_cytogenetic_location ?Text
	GDB		GDB_id		UNIQUE ?GDB_id XREF Refers_to
			Annotation	Text
			Polymorphism	UNIQUE Text
			Max_heterozygosity	UNIQUE Float
			Add_date	UNIQUE Text
			Modification_date	UNIQUE Text
			Approval_date	UNIQUE Text
	Links_to	Probe          ?Probe    XREF Locus
                	Sequence       ?Sequence XREF Locus
                	Clone          ?Clone    XREF Locus
	                OMIM_document  ?OMIM     XREF Locus
	       	        EC_enzyme      ?Enzyme   XREF Locus
			GRIN	       ?GRIN
			Swiss_Prot	SP_name ?Text
					SP_AC ?Text
					EC ?Text
			EMBL		EMBL_name ?Text
					EMBL_AC ?Text
			PIR		PIR_name ?Text
					PIR_AC ?Text
			Genbank		GB_name ?Text
					GB_AC ?Text			
			PDB		PDB_name ?Text
	Positive_clone	?Clone
	Remark		?Text
	Abstract	?LongText
	Marker_distance_ref ?Paper
	Reference	?Paper
	Data_source	Text



	//Float is size(s) of restriction bands that were mapped at this locus:
	Mapped_bands ?Restriction ?Germplasm Float 
	QTL UNIQUE ?QTL XREF LOD_peak_location
	Linked_QTL ?QTL XREF Nearest_marker
	Associated_Gene ?Gene XREF Locus //Lisa was RFLP
	Associated_Allele ?Allele XREF Locus //Lisa was RFLP
	Image ?Image XREF Locus //Lisa added the XREF
	Data	?Map XREF Locus //DEM Removed ?Segregation

?Segregation	Locus ?Locus XREF Data
		Data_from	Film Text
				Blot Text
		Plants_scored Int
		Scored Text Int Text
		Chi_square Float
		Probability Float
		Remarks Text

//This has been added to include the provision of getting all the germplasm
// that breed in a perticular location . class added by Madhavan Sridhar.

?Breed_Location_SEED SEED_Germplasm  ?SEED_Germplasm XREF Breed_Location_SEED 
?Breed_Location_YIELD YIELD_Germplasm  ?YIELD_Germplasm XREF Breed_Location_YIELD 
?Breed_Location_FIBER FIBER_Germplasm  ?FIBER_Germplasm XREF Breed_Location_FIBER 
?Breed_Location Germplasm_yr  ?Germplasm_yr XREF Breed_Location 

//TO isolate the trait study for SEED FIBER AND YIELD the foll. are added

?Trait_scores_SEED SEED_Germplasm ?SEED_Germplasm
                   TABLE1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text //Column headings
                   Seed_Rep1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
                   Seed_Rep2 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
                   Seed_Rep3 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                   Seed_Rep4 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
                   Remark ?Texts
 
?Trait_scores_FIBER FIBER_Germplasm ?FIBER_Germplasm
                    TABLE1 ?Text ?Text ?Text ?Text //Column headings
                    Fib_Rep1 Float Float Float Float Float
                    Fib_Rep2 Float Float Float Float Float
                    Fib_Rep3 Float Float Float Float Float
                    Fib_Rep4 Float Float Float Float Float
                    Remark ?Texts 

?Trait_scores_YIELD YIELD_Germplasm ?YIELD_Germplasm
                    TABLE1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text//Column headings
                    Yld_Rep1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep2 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep3 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep4 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep5 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep6 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep7 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep8 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Yld_Rep9 ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                    Remark ?Texts 

//SEED_Germplasm is added to avoid the conflict which arises thro the display 
//of germplsm info for SEED/Yield/Fiber only.
//The regular germplasm shows all three togather in trait_score.

?SEED_Germplasm	Other_name ?SEED_Germplasm XREF Other_name // Put data in only one.
	        Species UNIQUE ?Species	
                Donor_species ?Species 	//For addition chromosomes
		Type #Germplasm_type
		Collection_and_ID ?Collection ?Germplasm XREF Other_name
		Cross_number ?Text	//Identifier used by CIMMYT
		Chromosome_configuration ?Text
		Developed_by ?Colleague //lisa 
		Region Text  //Madhavan Sridhar
		Date_of_release ?Text
		Registration_No ?Text     //lisa
		Remark ?Texts
		Breed_Location_SEED  ?Breed_Location_SEED XREF SEED_Germplasm  //modified by MS to include SEED info
		Source ?Text
		Year UNIQUE Int
                Reference ?Paper XREF Germplasm
		Mapping_data ?Map
		Image ?Image XREF Germplasm
		Data_source ?Colleague  //Text is date, e.g. 93.08.27
		Polymorphism ?Polymorphism //LOAD AS ?POLYMORPHISM XREF, NOT
					   //DIRECTLY. Keep near end of model.

		Trait_scores_SEED ?Trait_scores_SEED //Should be near end of model, 
			//could be a long list.


?YIELD_Germplasm Other_name ?YIELD_Germplasm XREF Other_name // Put data in only one.
	         Species UNIQUE ?Species	
                 Donor_species ?Species 	//For addition chromosomes
	         Type #Germplasm_type
		 Collection_and_ID ?Collection ?Germplasm XREF Other_name
		 Cross_number ?Text	//Identifier used by CIMMYT
		 Chromosome_configuration ?Text
		 Developed_by ?Colleague //lisa 
		 Region Text  //Madhavan Sridhar
		 Date_of_release ?Text
		 Registration_No ?Text     //lisa
		 Remark ?Texts
                 Year UNIQUE Int
		 Breed_Location_YIELD  ?Breed_Location_YIELD XREF YIELD_Germplasm  //modified by MS to include SEED info
		 Source ?Text
		 Reference ?Paper XREF Germplasm
		 Mapping_data ?Map
		 Image ?Image XREF Germplasm
		 Data_source ?Colleague  //Text is date, e.g. 93.08.27
		 Polymorphism ?Polymorphism //LOAD AS ?POLYMORPHISM XREF, NOT
					   //DIRECTLY. Keep near end of model.

		 Trait_scores_YIELD ?Trait_scores_YIELD //Should be near end of model, 
			//could be a long list.


?FIBER_Germplasm Other_name ?FIBER_Germplasm XREF Other_name // Put data in only one.
	         Species UNIQUE ?Species	
                 Donor_species ?Species 	//For addition chromosomes
		 Type #Germplasm_type
		 Collection_and_ID ?Collection ?Germplasm XREF Other_name
		 Cross_number ?Text	//Identifier used by CIMMYT
		 Chromosome_configuration ?Text
		 Developed_by ?Colleague //lisa 
		 Region Text  //Madhavan Sridhar
		 Date_of_release ?Text
		 Registration_No ?Text     //lisa
		 Remark ?Texts
                 Year UNIQUE Int
		 Breed_Location_FIBER  ?Breed_Location_FIBER XREF FIBER_Germplasm  //modified by MS to include SEED info
		 Source ?Text
		 Reference ?Paper XREF Germplasm
		 Mapping_data ?Map
		 Image ?Image XREF Germplasm
		 Data_source ?Colleague  //Text is date, e.g. 93.08.27
		 Polymorphism ?Polymorphism //LOAD AS ?POLYMORPHISM XREF, NOT
					   //DIRECTLY. Keep near end of model.
		 Trait_scores_FIBER ?Trait_scores_FIBER //Should be near end of model, 
			//could be a long list.


//  Added this to sort the Germ info by year
?Germplasm_yr 	other_name ?Germplasm_yr XREF Other_name // modified to avoid looping.
		Species UNIQUE ?Species
		Donor_species ?Species 	//For addition chromosomes
		Type #Germplasm_type
		Collection_and_ID ?Collection ?Germplasm XREF Other_name
		Cross_number ?Text	//Identifier used by CIMMYT
		Chromosome_configuration ?Text
		Abbreviation ?Text
		Female_Parent UNIQUE ?Germplasm
		Male_Parent UNIQUE ?Germplasm
		Generation_derived UNIQUE Text
		Selection_method ?Text
		Maturity_group ?Text
		Market_Class ?Text
		Trait_study ?Trait_Study
		Pathology ?Pathology XREF Resistant_line
		Phenotype UNIQUE ?Text  //DEM: Delete?
		Derived_from ?Germplasm  //DEM: should XREF?
		Developed_by ?Colleague //lisa 
		Development_site ?Text  //lisa
		Date_of_release ?Text
		Registration_No ?Text     //lisa
		Remark ?Texts //Sridhar .NOTE this goes to ?Texts not ?Text
                Year UNIQUE ?Text 
		Breed_Location  ?Breed_Location XREF Germplasm_yr  //modified by MS to include SEED info
		Source ?Text
                Region ?Text XREF Germplasm
		Reference ?Paper XREF Germplasm
		Mapping_data ?Map
		Image ?Image XREF Germplasm
		Data_source ?Colleague ?Text //Text is date, e.g. 93.08.27
		Polymorphism ?Polymorphism //LOAD AS ?POLYMORPHISM XREF, NOT
					   //DIRECTLY. Keep near end of model.
		Trait_scores ?Trait_scores XREF Year //Should be near end of model, 
			//could be a long list.
		Coefficient_of_parentage ?Germplasm Float //Must be at end of
			//model; this could be a Long list.  Should XREF, or
			//let folks query for the other matrix direction?
		Trait_score_Loc ?Trait_score_Loc  //Should be near end of model, 
		Trait_score_year ?Trait_score_year  //Should be near end of model, 
		Trait_score_Germ ?Trait_score_Germ  //Should be near end of model, 
//DEM 5/93: Old tags expunged:
//		Traits ?Trait #Trait_Information 
//    9/93: Changed 'Remark General_remark' to 'Remark'

//?Germplasm
//DEM 25 Feb 93 Removed the dumb "Pedigree" indentation pseudotag, but no
//  effect on data display even after "Read models",quit,restart; must 
//  rebuild database.
//  Added tags for describing genetic stocks.
//  Removed the XREF from Collection_and_ID ?Collection
//  Added XREF for Other_name
//  Changed Summary_pedigree to Pedigree, and made UNIQUE
//  Made Species ?Species instead of ?Text
//v1.6:
//  Added Image, Trait, Trait_scores
?Germplasm 	Other_name ?Germplasm XREF Other_name // Put data in only one.
		Species UNIQUE ?Species
		Donor_species ?Species 	//For addition chromosomes
		Type #Germplasm_type
		Collection_and_ID ?Collection ?Germplasm XREF Other_name
		Cross_number ?Text	//Identifier used by CIMMYT
		Chromosome_configuration ?Text
		Abbreviation ?Text
		Pairing_configuration ?Text
		Chromosome_number ?Text //Not Int. "42tt" = ditelosomic substn.
		Female_Parent UNIQUE ?Germplasm
		Male_Parent UNIQUE ?Germplasm
		Parent1 UNIQUE ?Germplasm
		Parent2 UNIQUE ?Germplasm
		Parents1 UNIQUE Text
		Parents2 UNIQUE Text
		Pedigree UNIQUE Text
		Generation_derived UNIQUE Text
		CS_Reg Text
		Exp.Designation Text
		Reference_Pedigree ?Text
		Maturity_group ?Text
		Market_Class ?Text
		Trait_study ?Trait_Study
		Pathology ?Pathology XREF Resistant_line
		Phenotype UNIQUE ?Text  //DEM: Delete?
		Allele ?Allele XREF Germplasm //Bad idea. Load from Allele side
		Gene ?Gene //...so we can specify Hexaploid_stock, Tetra-, etc.
		Linkage_Group ?Linkage_Group
		Rearrangement	 ?Rearrangement XREF Germplasm
		Reference_Allele Text
		Genotype Text	
		Growth_Req UNIQUE Text
		Mutagen UNIQUE ?Reagent
		Derived_from ?Germplasm  //DEM: should XREF?
		Developed_by ?Colleague //lisa 
		Development_site ?Text  //lisa
		Date_of_release ?Text
		Registration_No ?Text     //lisa
		Remark ?Texts //Sridhar .NOTE this goes to ?Texts not ?Text
                Year ?Text
                Germplasm_yr ?Germplasm_yr 
		Breed_Location  ?Breed_Location XREF Germplasm  //modified by MS to include SEED info
		Source ?Text
                Region ?Text XREF Germplasm
		Reference ?Paper XREF Germplasm
		Mapping_data ?Map
		Image ?Image XREF Germplasm
		Data_source ?Colleague ?Text //Text is date, e.g. 93.08.27
		Polymorphism ?Polymorphism //LOAD AS ?POLYMORPHISM XREF, NOT
					   //DIRECTLY. Keep near end of model.
		Trait_scores ?Trait_scores  //Should be near end of model, 
			//could be a long list.
		Coefficient_of_parentage ?Germplasm Float //Must be at end of
			//model; this could be a Long list.  Should XREF, or
			//let folks query for the other matrix direction?

//DEM 5/93: Old tags expunged:
//		Traits ?Trait #Trait_Information 
//    9/93: Changed 'Remark General_remark' to 'Remark'

//?Germplasm_type
// DEM 2/93  Controlled vocabulary for ?Germplasm Type tag.
?Germplasm_type	Cultivar
		Substitution
		Amphiploid
		Aneuploid
		Germplasm
		Deletion
		Alien_addition
		Mutation
		Marker
		Alloplasmic_line
		Elite_germplasm

//?Linkage_Group
//Lisa changed Chromosome to Linkage_Group
?Linkage_Group	Non_graphic  // Prevents a graphic display of a chromosome 
            	Centre Float Float  // Overrules default Initial centre, width
	    	Mapping_data ?Map XREF gMap //lisa
		Chrom_Band ?Chrom_Band
	    	Contig ?Contig 
            	Gene ?Gene 
            	Locus ?Locus 
	    	Rearrangement ?Rearrangement
	    	Allele ?Allele

?Reagent	Other_name ?Text
		Description Text
		Remark Text
		Reference ?Paper
		Source ?Source
		Contact ?Colleague

//DEM 8/27/93: Added Data_source, changed Derived_from to Source_germplasm
//DEM 12/16/93: Removed the following unused and undesired tags:
//	Type	#Probe_Type	//Replaced with local booleans under Origin
//		Y_Remark Text
//		PCR_Remark ?Text
//		  Hybridizes_to_YAC ?Probe XREF Positive_probe REPEAT//obselete
//		  Vaxmap UNIQUE Float
//		Insert_sequence ?Sequence //Lisa
//	Length		Seq_length UNIQUE Int
//			Gel_length Float Float	// Kb
//			HindIII_sites UNIQUE Int
//       Map ?Map 
//        FingerPrint     Gel_number UNIQUE Int
//                        Approximate_match_to UNIQUE ?Probe XREF Canonical_for
//                        Exact_match_to UNIQUE ?Probe XREF Canonical_for
//                        Funny_match_to UNIQUE ?Probe XREF Canonical_for
//                        Canonical_for ?Probe
//                        Bands   UNIQUE Int Int
//		        Flag    UNIQUE Int
//	Calcul	Session Int
//		Neighbours ?Probe UNIQUE Float
//		Cor   Int
//		Common_bands  FREE
?Probe  Gene    ?Gene XREF Probe
        Locus   ?Locus XREF Probe
	Reference ?Paper  //DEM Added
        Remark  General_Remark ?Text
        Position  In_situ  UNIQUE Int Int
		  Chrom_Band ?Chrom_Band XREF Probe
                  pMap UNIQUE ?Contig XREF Probe Int Int // bands pMap units
		  bMap UNIQUE Int Int	// base units
		  Autopos
		  Hybridizes_to ?Probe_Grid ?Probe XREF Positive_probe ?Text
		  Positive_probe ?Probe
		  Positive_pool_probe ?Pool
	PCR_primers ?Text
	Amplification_conditions ?Text
	Sequence	?Sequence XREF Probe
	Insert	Size Float //Lisa  ...DEM changed from Int
	// Band sizes for this probe, a different ?Bands for each
	//  restriction enzyme.  Each one contains data for all germplasms.
	// ?Text is "Polymorphic", "Not", "Maybe", "Mapped"
	Polymorphism ?Polymorphism XREF Probe ?Text
	Gel ?Gel XREF Probe   //Electrophoretogram, autoradiogram...
	Linkage_Group ?Text  //To be removed (800 records use it)
	Germplasm ?Germplasm XREF Probe #Pattern //DEM 8/93: REMOVE this!
			//But note it has (inappropriate) data in it.
			//Must be corrected and moved to Source_germplasm
	//DEM: Insert_enzyme is the enzyme used to cut the insert DNA before
	//  inserting into the vector.  Is there a better name?  "Cloning_
	//  enzyme"?  "DNA_enzyme"?
	//DEM 8/93: Don't use REPEAT for enzyme combinations: hard to convert
	//	    to PGD.
	Origin	Insert_enzyme ?Restriction REPEAT
		Vector   ?Text 	//Lisa changed this from ?Probe
		Vector_enzyme ?Restriction REPEAT
		Excision_enzyme ?Restriction REPEAT
		cDNA 		//boolean = 'Type' of this probe
		Genomic 	//boolean = 'Type' of this probe. Add PCR too.
		DNA_Origin ?Text //eg Hydroxylapatite-PERT-genomic (Bad label)
		Source_germplasm ?Germplasm
		Species ?Species  	
		Tissue_source ?Text
		Vector_PCR_primers ?Sequence  //lisa
	Subcloned_in ?Probe XREF Subclone_of
	Subclone_of ?Probe XREF Subcloned_in
	Location ?Colleague #Lab_Location
	Authority ?Colleague
	In_pool ?Pool XREF Probe
        Gridded ?Probe_Grid
		//Cosmid_grid		//DEM dropped these
      		//Plate Text Text
	        //Canon_for_cosmid
                //YAC_polytene Int
	Sent_to  ?Author  Text
	Image ?Image XREF Probe //Lisa
	Data_source ?Colleague ?Text //Text is date, e.g. 93.08.27

// 3/30/93 S.Tanksley says RFLP etc are **Locus** types.  Probe types would
// be: cDNA genomic_DNA  (already available in ?Probe under Origin).
?Probe_Type	RFLP
		SSCP
		RAPD
		VNTR

//DEM 8/93 Obsoleted
?Pattern	Enzyme ?Restriction #Bands

//DEM 8/93 Restructured
//Information describing an electophoretic polymorphism: RFLP, PCR, isozyme,
//seed proteins, etc.
//DEM 11/93 removed old version of table:
//	      TABLE ?Text //Column headings for the Size table, e.g.
//			  //"    Germplasm    Gel Number   Size (kb) Intensity"
//	      // Float is in Kb, ?Text is "Faint", "Medium", "Dark":
//	      Size ?Germplasm XREF Polymorphism ?Gel XREF Polymorphism Float ?Text 
?Polymorphism Probe UNIQUE ?Probe XREF Polymorphism
	      Enzyme UNIQUE ?Restriction  // For RFLPs; omit for PCR probes.
	      Locus_mapped ?Locus	  // no XREF; give ?Locus Mapped_bands
	      TABLE ?Text //Column headings for the Size table, e.g.
			  //"    Gel Number   Size (kb) Intensity    Germplasm"
	      // Float is in Kb, ?Text is "Faint", "Medium", "Dark":
	      Size ?Gel XREF Polymorphism Float ?Text ?Germplasm XREF Polymorphism 
	      Image ?Image		    // Autoradiogram, gel photo

//DEM 8/93 New
//Information about a gel electrophoretogram or autoradiogram (DNA, protein...)
//A blot or film is also a ?Gel.
//Better name for this class?  "Phoretogram"?
?Gel	Probe ?Probe XREF Gel	
	Date ?Text  // Date of gel or blot or autorad, then what procedure
		    // E.g. "93.08.05 DNA extraction"
		    // Standard date format: "93.08.05" (5 Aug 93)
	Run_by ?Colleague	// Who did the lab work
	Conditions ?Text	// Stringency, exposure time,...
	Polymorphism ?Polymorphism  //LOAD AS ?POLYMORPHISM XREF, NOT DIRECTLY
	Germplasm ?Germplasm	// Source of sample.
	Image ?Image		

//This version is too complicated for now.  Should treat all films as totally
//separate, not tied to a real gel.  Scratch it:
////Information about a gel electrophoretogram or autoradiogram (DNA, protein...)
////A blot or film is also a ?Gel. Connect a gel to its autorads  via Film, Gel
////"**G": field used for gels or blots only, not films.
////"**F": field used for films (autoradiograms) only.
////Other fields are for either.
////Better name for this class?  "Phoretogram"?
//?Gel	Film ?Gel XREF Gel	// **G
//	Gel ?Gel XREF Film	// **F
//	Date ?Text  // Date of gel or blot or autorad, then what procedure
//		    // E.g. "93.08.05 DNA extraction"
//		    // Standard date format: "93.08.05" (5 Aug 93)
//	Run_by ?Colleague	// Who did the lab work
//	Conditions ?Text	// Stringency, exposure time,...
//	Polymorphism ?Polymorphism  //LOAD AS ?POLYMORPHISM XREF, NOT DIRECTLY
//	Germplasm ?Germplasm	// Source of sample. **G
//	Image ?Image		// If picture is of an autorad, **F
//	Probe ?Probe XREF Gel	// **F

?Probe_Grid	Title	?Text
		Layout	Columns	Int
			Lines_at	Int Int	// x, y spacing
			Space_at	Int Int	// x, y spacing
			No_stagger	// default is with alternate lines staggered
			A1_labelling	// label spaced blocks a-h down LHS, 1-12 across top
		Row Int ?Probe XREF Gridded REPEAT


?Contig bMap	Length UNIQUE Int	// in base units
		Position UNIQUE Int	// left extremity in bases
		b2g	UNIQUE	Float Float // gMap = ax + b
	gMap	UNIQUE ?Linkage_Group XREF Contig Float Float	// extremities on gMap
        pMap    UNIQUE Int Int         // extremities in pMap units
	Probe	?Probe XREF Contig
        Locus	?Locus XREF bMap

?2_point_data          Gene  ?Gene XREF 2_point_data //Lisa Start
		       Female_Parent ?Germplasm	Allele ?Allele XREF Paper
                       				Species ?Text
		       Male_Parent ?Germplasm	Allele.	?Allele XREF 2_point_data
                       				Species. ?Text
                       Phase UNIQUE  Text
		       Map ?Map
                       Linkage_Group ?Linkage_Group
                       Generation UNIQUE Text
                       Number_of_individuals UNIQUE Int
                       Method UNIQUE ?Text //Lisa end
                       Temperature UNIQUE Text
                       Date  UNIQUE Text
                       Mapper ?Author
                       Laboratory UNIQUE ?Colleague
                       Genotype UNIQUE Text
                       Results   Min      Float
                                 Distance text  //Lisa changed to text to include 'independent'
                                 Max      Float
                                 Error    Float
		                 Standard_error Float
                                 Linkage  Text
                       Reference ?Paper XREF 2_point_data 
		       Remark Text             
                       Flag Text
                       AATDB   Note UNIQUE Text
                               Counts UNIQUE Int Text Int Text Int Text Int Text
         		       Total UNIQUE  Int
                               AATDB_Dist    UNIQUE Float Float
		               Autopos  UNIQUE Float Float Float Float

?Df_Dup_data 	       Rearrangement ?Rearrangement XREF Df_Dup
		       Allele1 Text  // when the def is also known as allele	
		       Gene UNIQUE ?Gene XREF Df_Dup
                       Allele UNIQUE  ?Allele XREF Df_Dup
                       Linkage_Group ?Linkage_Group
                       Temperature UNIQUE Text
                       Date  UNIQUE Text
                       Mapper ?Author
                       Genotype UNIQUE Text
                       Results UNIQUE Text
                       CGC   Flag Text
                             Laboratory UNIQUE ?Colleague
			     Linkage Text
                       AATDB   Note UNIQUE Text
         		       Total UNIQUE  Int
		               A_deletes_B  UNIQUE Text Text
         		       A_does_not_delete_B UNIQUE  Text Text
		               A_includes_B UNIQUE  Text Text
         		       A_does_not_include_B UNIQUE   Text Text

?3_point_data          Gene1 UNIQUE ?Gene XREF 3Point ?Allele XREF 3Point
                       Allele1 UNIQUE  ?Allele XREF 3point
                       Gene2 UNIQUE ?Gene XREF 3Point ?Allele XREF 3Point
                       Allele2 UNIQUE  ?Allele XREF 3point
                       Gene3 UNIQUE ?Gene XREF 3Point ?Allele XREF 3Point
                       Allele3 UNIQUE  ?Allele XREF 3point
		       Linker ?3_point_data XREF Linker
                       Linkage_group ?Linkage_Group
                       Temperature UNIQUE Text
                       Date  UNIQUE Text
                       Mapper ?Author
                       Genotype  Text
                       Results Text
                       Result_type ABC
                                   AB_C
                                   A_BC
                       Recombinant_1 Text
                       Recombinant_2 Text
                       Recombinant_3 Text
                       Counts UNIQUE Int Text Int Text Int Text Int Text
                       CGC   Laboratory UNIQUE ?Colleague

//?Colleague
// New version from Edie Paul, 3/93
// DEM 10/93 Added Image
?Colleague      Position    Text
                Profession  Text
                Institution Text //Modified by Sridhar on jul 28 94 to accomadate the ins.name .
                Department  Text
                Address Mail Text //EMP: for Street,City,State,Zip together
                        Street Text //EMP - separate out address
                        City   ?Text //EMP - separate city, make text object
                        State       ?Text //EMP - separate, make text object
                        Postal_code ?Text //EMP - separate, make text object
                        Country     ?Text //EMP - make text object
                        Phone       Text
                        Fax Text
                        E_mail Text //EMP - deleted bitnet and internet
                        Telex Text
                Research_interest ?Text
		Image ?Image XREF Colleague
                Keyword ?Keyword
                Publishes_as ?Author XREF Full_name
                Associate ?Colleague XREF Associate
                Last_update Text
                Obtained_from ?Source

//?Author
//DEM: On R.Durbin's advice, 11 Mar 93 (~/Mail/acedb), removed the 
//    "XREF Author" after "Paper ?Paper".  To avoid scrambled Author orders
//    in papers loaded from dump files.
?Author Full_name ?Colleague XREF Publishes_as
        Paper ?Paper

?Journal Paper ?Paper XREF Journal

//?Paper
//DEM Jan 94 Added Agricola_code, Gene_Catalogue_number, Cited_in.
//	     With misgivings, added Proceedings, Book (perhaps temporarily).
?Paper  Reference       Title UNIQUE ?Text
                        Original_title Text
			Journal UNIQUE ?Journal XREF Paper			
                        Publisher UNIQUE Text
			So UNIQUE Text	//Vague, should change. (But has data)
			Proceedings UNIQUE ?Text //Or should we do this...
			Book UNIQUE ?Text	 // with Contained_in instead?
			DNAL Text
			Contained_in ?Paper XREF Contains
                        Year UNIQUE Text 
                        Volume UNIQUE Text Text
                        Page  UNIQUE Text Text 
	Institution Text
	Adviser ?Author XREF Paper
        Author ?Author XREF Paper
	Type UNIQUE Text
	Language Text
	Image ?Image XREF Reference
	Abstract Text
	Contains ?Paper XREF Contained_in
        Refers_to	Gene_class ?Gene_Class XREF Reference	
			Gene_set ?Gene_Set XREF Reference
			Gene ?Gene XREF Reference
			Allele ?Allele XREF Reference
			Rearrangement ?Rearrangement XREF Reference
			Sequence ?Sequence XREF Reference
			Search_Method ?Search_Method XREF Reference
			Germplasm ?Germplasm XREF Reference
			Mapping_data ?Map XREF Reference
			2_point_data ?2_point_data //Lisa
			Trait_study ?Trait_Study XREF Reference
        Keyword ?Keyword
	Agricola_code ?Text
	Gene_Catalogue_number Int	//Ref number in 1993 Wheat Gene Catalog
	Cited_in ?Text		//Shouldn't this be ?Paper?
        Remark Text


?Restriction	Site UNIQUE Text
		Offset Text
		Cleavage Text
		Overhang Text
		Isoschizomers ?Restriction REPEAT
		Company ?Source
		Reference ?Paper
		Remark Text

?Protein   Title UNIQUE ?Text

?Sequence Title UNIQUE ?Text
	  Other_name ?Text	// for repeats
	  DNA UNIQUE ?DNA	// only one or the other of these
	  Peptide UNIQUE ?Peptide	// if there is DNA then derive from that
          RNA			// if this tag is set display AUGC
	  Length UNIQUE Int
	  Library	?Source Text Text // ID  Accession_number
	  Subsequence_of	Source UNIQUE ?Sequence
				Source_Exons Int Int // sequence of positions in genomic
	  Origin  From_Library ?Source
		  From_Author ?Author
		  From_Laboratory ?Colleague
		  Date Text
	  General	cDNA
		  	Probe ?Probe XREF Sequence 
			Gene ?Gene XREF Sequence
			Gene_product ?Gene_Product XREF Sequence
          	        Locus    ?Locus XREF Sequence
		        Related_Sequence ?Sequence XREF Related_Sequence
			Keyword ?Keyword
	  		Remark ?Text
			DB_remark ?Text
	  		Reference ?Paper XREF Sequence
			DB_searched ?Source Int // number of homologues found
	  Properties    Pseudogene Text
			Transposon
			Coding	CDS UNIQUE Int Int
				CDS_predicted_by ?Search_Method Float // score of method
				Precursor
			Transcript	End_not_found
				 	Start_not_found Int // Int is frame of base 1
					mRNA	Processed_mRNA
						Unprocessed_mRNA
					tRNA Text
					rRNA Text
					snRNA Text
	  Contains	Has_CDS ?Sequence XREF Source Int Int
			Has_Transcript ?Sequence XREF Source Int Int
			Has_Pseudogene ?Sequence XREF Source Int Int
			Has_Structural_RNA ?Sequence XREF Source Int Int
			Has_Transposon ?Sequence XREF Source Int Int
			Has_Subsequence ?Sequence XREF Source Int Int
			Has_Other_Subsequence ?Sequence XREF Source Int Int
	  Features	polyA_signal Int Int // putative
			Possible_exon Int Int Int ?Search_Method Float // 3rd Int is frame
			promoter Int Int ?Text
			polyA_site Int Int Text
			misc_signal Int Int ?Text
			misc_feature Int Int ?Text
			repeat_region Int Int Text
			repeat_unit Int Int Text
			mutation Int Int ?Text
			sig_peptide Int Int Text
			mat_peptide Int Int Text
			old_sequence Int Int Text
			protein_bind Int Int Text
			modified_base Int Int Text
	  Structure	Pep_homol ?Sequence ?Search_Method Float Int Int Int Int Text Text
			DNA_homol ?Sequence ?Search_Method Float Int Int Int Int Text Text

?Gene_Product	Other_name ?Text
		Type ?Text ?Paper Text //Enzyme, Protein, etc
		Function ?Text
		RNA_type
		IUB_number UNIQUE ?Text ?Paper
		EC_number UNIQUE ?Text
		Gene ?Gene XREF Gene_product
		Allele ?Allele XREF Gene_product
		Source	Species UNIQUE ?Text ?Paper
			Cultivar ?Germplasm ?Paper ?Text
			Tissue ?Text ?Paper ?Text
			Organelle ?Text ?Paper ?Text
			Membrane_Associated ?Paper //boolian +ref.
		Pathway ?Pathway #Components
		Substrate_specificity ?Text ?Paper ?Text
		pH_optimum Float ?Paper ?Text
		Temp_optimum(C) Text ?Paper ?Text
		Regulation #Regulators	
		Ancillary_enzyme ?Gene_Product
		Catalytic_mechanism #Mechanism
		Prosthetic_group ?Text
		Isozymes ?Gene_Product
		Structure	Native_Mr Float
				Subunitation #Subunit._type
				3D_structure Text //boolian with comment
				Purification Text 
				Isoelectric_point Float
		Clones #Clone_info
		Probes #Probe_info
		Mutants #Mutation_info
		Biochemistry Text //
		Remarks Text //
		Reference ?Paper //
		Contact ?Colleague //
		Sequence ?Sequence //

?Clone_info	cDNA_Clone ?Paper Text //boolian + reference +comment
		Heterologous_cDNA ?Paper Text
		Genomic_Clone ?Paper Text
		Heterologous_Clone ?Paper Text

?Probe_info	DNA_Probe ?Paper Text  //boolian +reference + comment
		Heterologous_Probe ?Paper Text
		RFLP_Probe ?Paper Text
		Antibody_Probe ?Paper Text
		Heterologous_Antibody ?Paper Text

?Mutation_info 	Mutants ?Paper Text
		Heterologous_Mutation ?Paper Text
		Het._Mutation_Gene_Symbol ?Gene ?Paper Text
 
?Subunit._type	Subunitation_type ?Text
		Subunit_Mr Float

?Regulators	Activator ?Text
		Vmax Text
		Cooperativity //boolian
		Inhibitor ?Text
		Ki Text
		Developmental ?Paper Text
		Hormonal Text
		Environmental ?Paper Text
		Genetic ?Paper Text
		Inducer ?Text
		Repressor ?Text

?Mechanism	Ping_Pong

?Components	Reaction ?Reaction
		Reactant ?Text
		Km Text
		Product ?Text

?Source		Other_name ?Text // Full name
		Contents Text // Description of collection
		Remarks Text // other descriptions
		Reference ?Paper
		Contact ?Colleague
		Address Mail Text
                        Phone Text
                        E_mail Text
			Fax Text


?Search_Method	Function ?Text	// what does it do?
		Variant_of UNIQUE ?Search_Method XREF Variant
		Variant ?Search_Method
		Version	Text
		Parameters 	Float_Params UNIQUE Text Float REPEAT 
				Int_Params UNIQUE Text Int REPEAT
				Text_Params UNIQUE Text Text REPEAT
		Min_score	UNIQUE	Float	// used in plotting
		Unix_command // probably infeasible to use this
		Remark ?Text
		Reference ?Paper XREF Search_Method
	   

?Homology   Title UNIQUE ?Text

?Seg_Set	Sequence ?Sequence Int Int
		Table	Frequency ?Octamer_Table XREF Frequency
			Other_Table ?Octamer_Table
		Derivation Top  ?Octamer_Table ?Seg_Set

?Octamer_Table	Tab_array ?Tab_Array
		Type	Frequency ?Seg_Set XREF Table
			Smeared ?Octamer_Table XREF Smear Float
			Normalized
			Octamer
			Hexamer
		Score	?Octamer_Table Float
		Derivatives	Top ?Seg_Set ?Seg_Set Int
				Smear ?Octamer_Table

// DEM v1.5: Added Pathology, Probe, Caption
//     v1.6: Added Germplasm, Species, Map, Trait; changed Paper to Reference
//   	     Added Locus, QTL
?Image  Gene ?Gene XREF Image
	Locus ?Locus XREF Image 
	Pathology ?Pathology XREF Image 
	Probe ?Probe XREF Image 
	//A QTL link is for an image of a particular QTL, e.g. an autorad of 
	//bulked segregant analysis of the linked marker.  See also Trait.
	QTL ?QTL XREF Image
	Germplasm ?Germplasm XREF Image
	Species ?Species XREF Image
	Map ?Map XREF Image
	Colleague ?Colleague XREF Image	//For pix of people.  cf Author, below.
	Trait_study ?Trait_Study XREF Image
	Caption Text //DEM
	Author ?Author
	Reference ?Paper XREF Image
	Pick_me_to_call  UNIQUE Text Text   // A program name followed by a file name
//	Secret  Text  // If set prevents display except by owner (uid == Text).                         DEM deactivated.


//?F2_data: to contain marker segregation data for entire mapping population
//DEM:	Need a better name, since not all mapping populations are F2.  
//	   How about "?Mapping_data"?
//	Changed parents from Text to ?Germplasm.
//v1.5: Moved this all into ?Map.  Only ?Gene is still connected to ?F2_data
?F2_data	Map ?Map XREF Mapping_data
		Maternal_parent ?Germplasm XREF Mapping_data
		Paternal_parent ?Germplasm XREF Mapping_data
		Parent1 ?Germplasm XREF Mapping_data
		Parent2 ?Germplasm XREF Mapping_data
		Reference ?Paper XREF Mapping_data
		Contact ?Colleague
		Remarks Text
		Locus ?Locus XREF Data Text //Text is raw data as string without whitespace
		Gene ?Gene XREF F2_data Text  //same as above; use for real genes

?Pool	Contains	Probe ?Probe XREF In_pool
			Subpool ?Pool XREF In_pool
	In_pool ?Pool
	Map	Hybridizes_to ?Probe_Grid ?Probe XREF Positive_pool_probe ?Text
		Chrom_Band ?Chrom_Band XREF Positive_pool_probe
	Location ?Colleague  #Lab_Location
	Reference ?Paper

?Chrom_Band	Map	gMap UNIQUE ?Linkage_Group XREF Chrom_Band Float Float
			Positive_probe	?Probe	XREF Chrom_Band
			Positive_pool_probe	?Pool XREF Chrom_Band
		Colour	#Colour
		Dark
		NOR
		Centromere	// special flag for waisted drawing
		Contains ?Chrom_Band XREF Contained_in
		Contained_in ?Chrom_Band XREF Contains

?Lab_Location	Freezer		Text
		LiquidN2	Text
		Minus70		Text
		Remark		?Text

//?Collection     lisa added the Collection class
// DEM removed the  "Collection_and_ID ?Collection XREF Entries" from 
//     ?Germplasm, so ?Collection no longer contains an automatic list of
//     all its entries.
?Collection	Curator ?Colleague
		Description ?Text
		Entries ?Germplasm XREF Collection 
		
//?Pathology   Lisa added the pathology class
// 2/93 Dave extended
// 11/93 Added fields for Ken Kephart
// 1/95 Weeds
?Pathology	Other_name ?Pathology XREF Other_name //Choose one, 
						      //put the data in that.
		Type	Fungus
			Bacterium
			Virus
			Nematode
			Insect
			Abiotic
			Mycoplasma
			Parasitic_plant
			Mollusk
			Weed_plant
		Host_species ?Species XREF Disease
		Causal_organism ?Species XREF Causes
		Vector ?Species XREF Vector_of
		Trait ?Trait XREF Pathology
		Evaluation ?Trait_Study XREF Pathology
		Resistance_gene ?Gene XREF Pathology
		Resistant_allele ?Allele XREF Pathology
		Resistant_line ?Germplasm XREF Pathology
		Symptoms Text
		Image ?Image XREF Pathology

//?Species 2/93 DEM, based on the PGD schema
//         3/6/93 KDK,DEM refined
// Object's id is of the form "T. turgidum var. durum", no authority.
// Correct_name is not XREF'd as Synonym.  This allows two classes of wrong
// names: dumb ones like "A. squarrosa" that aren't even listed as Synonyms,
// and valid (common or historical) ones like "Ae. squarrosa L.".
//v1.6:
//  Added Image
?Species   Correct_name UNIQUE ?Species //If object is a Synonym, say only this
           Full_name UNIQUE ?Text //Genus not abbreviated, with Authority
           Genus UNIQUE ?Text
           Species ?Text
	   Variety ?Text
           Authority ?Text
           Synonym ?Species XREF Correct_name
           Common_name ?Text
           Genome UNIQUE ?Text //E.g. "D", "ABD"
           Haploid_chromosome_number UNIQUE Int
	   Mapping_data ?Map
	   Disease ?Pathology XREF Host_species // diseases of this species
	   Causes ?Pathology XREF Causal_organism // diseases caused by it
	   Vector_of ?Pathology XREF Vector // diseases vectored by it
	   Reference ?Paper
	   Image ?Image XREF Species

//?Map:  A result of a particular mapping study, or perhaps a summary map.
// Added by Lisa, extended by Dave Matthews
// v1.5: Now contains what used to be ?F2_data
//v1.6:
//  Added Image, Trait, QTL
?Map	Type UNIQUE Genetic  // this flag can be used to define subclasses
                    Cytogenetic // Chromosome could be Map, filtered Cytogenetic
                    Physical
	Genus_Species ?Genus_Species XREF Map
        Display Non_graphic  // Prevents a graphic display 
                Title UNIQUE ?Text
                Remark Text // Will appear in top right corner  
		Flipped // Then coordinates go upwards
                Unit   Text // i.e. kb, centiMorgan, MegaParsec
		Centre UNIQUE Float UNIQUE Float  // centre, width - else 0, 10
	    	Extent UNIQUE Float UNIQUE Float  // min, max - else min, max gene/locus
                Error_scale UNIQUE Float  // To position loci on x axis, default = 10
        Inherits  From_map ?Map 	  // To loaclly edit
		  Author Text             // login name of who edited it
		  Date Text
 	Main_Marker ANY       // Appear left of scroll bar
        Contains Locus ?Locus XREF Map
		 Marker_distance ?Text
                 YAC ?YAC XREF Map
                 Fragment ?Fragment XREF Map
                 Clone ?Clone XREF Map
                 Chrom_Band ?Chrom_Band XREF Map
                 Map ?Map XREF Map #map_location

?map_error Error UNIQUE Float

?map_location UNIQUE Position UNIQUE Float #map_error
                     Multi_Position  Float #map_error
                     Ends Left UNIQUE Float #map_error
                          Right UNIQUE Float #map_error


// Bug: The Linkage_Groups get listed, but double clicking on one brings up
// a new Map window instead of the gMap.  (Clicking once and menuing Tree
// gives the correct Linkage_Group tree window as expected.)
// Workaround: Must add the Float after ?Linkage_Group.  Value will be 
// where the gMap is centered.  [Note: the special tag "gMap" must be used.]
// 10 Mar 93: RDurbin fixed.  (in xace2.0, I guess)

// Lisa's, not used by DEM
?Trait_Information	Trait_value ?Text
			Environment ?Environment

//?Trait:  A property of ?Germplasms, affected by ?Gene_Classes and ?QTLs, 
//    evaluated in ?Trait_Studies.
// DEM 9/93 Created
//	    ?Germplasms are not directly linked, only via ?Trait_Studies
?Trait	Description ?Text		//Brief explanation of the trait name
	Pathology ?Pathology XREF Trait //If trait is related to a disease
	QTL ?QTL XREF Trait_affected
	Evaluation ?Trait_Study XREF Trait //HUH?  For some reason, this isn't
					   //creating the backreference.
// DEM 11/93 removed, changed to ?Gene_Class Character_affected ?Text
//	Affected_by ?Gene_Class XREF Trait_affected 

//?Trait_Study:  Evaluation of a particular set of germplasms in a particular
//   experiment.  Other experiments measuring the "same" trait should have
//   different trait_study identifiers, e.g. "Yield, Smith93b"
//   Omit Species, Parents.  They're in Mapping_data if this is an evaluation
//   of a QTL mapping population, and not germane here if it's just a bunch of
//   random germplasms being compared.
//   For uniformity through database, always give R-squared as proportion 
//   (fraction of 1.00), rather than as percentage.
//   DEM 5/93
//   5/20: Added Type_I_error_rate_per_locus, Number_of_markers
//   6/8 : Changed Number_of_markers to Number_of_markers_tested
//   9/14: Changed name from ?Trait to ?Trait_Study
?Trait_Study Germplasm ?Germplasm
	     Pathology ?Pathology XREF Evaluation //If trait is disease-related
             Protocol Text	//Description of the trait and how measured
       	     Parental_description ?Germplasm ?Text   //Qualitative description
             Parental_Mean_SD ?Germplasm XREF Trait_study Float Float 
			//Value of mean and standard deviation for each parent
             Mapping_data ?Map XREF Trait_study      //Info about parents, loci
             Population_size UNIQUE Int //Number of individuals in population
             Population_type Text	//Kind of mapping population, eg F5 RIs
             QTL_analysis_method ?Text  //Methods used, eg Single-factor ANOVA
             Statistics Text		//ANOVA table, etc. for this trait
             Heritability Float Text    //Value and basis, 
					// e.g. 0.84 "line mean basis"
             Type_I_error_rate_per_locus Float 	//Alpha, 
			// probability of calling locus significant by chance
             Number_of_markers_tested Int  //Number of loci in the Mapping_data
             QTLs_found UNIQUE Int	//How many QTLs were detected?
             Phenotypic_R2 UNIQUE Float //Phenotypic variance explained by 
					// all QTLs
             Genetic_R2 UNIQUE Float	//Genetic       "         "     "  "  "
             R2_definition Text	   //Exact definition of "R-squared" used above
             Breed_Location  ?Breed_Location   //modified by MS to include SEED info
             Plant_Height Text
             Maturity Text
             Productivity Text
             Pubescene Text
             Seed_type Text
             Lint_color Text
             Pet_color Text
             Comment Text
             Image ?Image XREF Trait_study  //Photos of the rating scale, eg
             QTL ?QTL XREF Trait_study	//Location, significance, for each QTL
             Trait_scores ?Trait_scores XREF Trait_study 
					//For either a mapping population 
                                        //or individual named germplasms

//?Environment:  Location and experimental conditions for a (field) test of
//    a trait.
// DEM 5/93, built on Lisa's version

?Environment Year UNIQUE Int            //eg 1993
             Location UNIQUE ?Text
             Region UNIQUE Text      //eg "Ketola Farm, Ithaca, NY, USA"
             Latitude UNIQUE Text
             Longitude UNIQUE Text
             Elevation UNIQUE Text
             Experimental_design ?Text  //eg "Randomized Complete Block"
             Replications UNIQUE Int    //How many replications here?
             Evaluator ?Colleague
             Institute ?Text
             Topography UNIQUE Text
             Drainage UNIQUE Text
             Soil_texture UNIQUE Text
             Irrigation Text            //Type, number of days, total amount
             Moisture Text              //Amount, units; eg 455 mm
             Planting_date UNIQUE Text  //Format: 88.04.16
             Harvest_date UNIQUE Text
             Testing_date Text
             N_applied Text             //Nitrogen fertilizer used, units
             P2O5_applied Text          //Phosphorus, in units of P2O5
             K2O_applied Text           //Potassium, in units of K2O
             Remarks Text               //Special conditions or events here
             Trait_scores ?Trait_scores XREF Environment //Scores obtained here
 
 


//?QTL:  An individual Quantitative Trait Locus for a particular trait.  
//  DEM 5/93
//  5/20: Changed Type_I_error_per_locus to Significance_level
//		  Effect_on_score to Size_of_allelic_effect
//		  Positive_allele_from to Higher_scoring_allele_from
//		  Type_I_error_x_Environment to Significance_x_Environment
//  6/8:  Changed Size_of_allelic_effect to Effect_of_allele_substitution
//  6/24: Added Image

?QTL Trait_affected UNIQUE ?Trait XREF QTL	
     Trait_study ?Trait_Study XREF QTL
     Mapping_data UNIQUE ?Map XREF QTL  //Molecular markers used to map the QTL
     Chromosome_arm ?Text		//eg 3BL, long arm of chromosome 3B
     Nearest_marker UNIQUE ?Locus XREF Linked_QTL 
     Significance_level UNIQUE Float    //Significance of marker. P < 0.what?
     LOD_peak_location UNIQUE ?Locus XREF QTL //? Or gMap position?
     LOD_peak_height Float 		//LOD value at this position
     Significant_LOD_interval gMap ?Linkage_Group Float Float //Endpoints of
 		//region (eg in cM) where LOD exceeds value of LOD_threshold.
     LOD_threshold Float        //Threshold value for Significant_LOD_interval
     Phenotypic_R2 UNIQUE Float	//Phenotypic variance explained by this QTL
     Genetic_R2 UNIQUE Float	//Genetic       "         "     "   "    "
     Effect_of_allele_substitution UNIQUE Float //Magnitude of allelic effect
     Additivity_Dominance_ratio UNIQUE Float
     Higher_scoring_allele_from ?Germplasm //Which parent's allele gives higher
				 	   //scores
     Interactions Text		     //Epistasis, interaction with environment
     Significance_x_Environment Float ?Environment //QTL x Env.  P < 0.what?
     Comment Text		     //Eg R-squared of nearby markers
     Image ?Image XREF QTL	     //Eg for blot of bulk segregant analysis.


?Trait_score_year Trait_scores ?Trait_scores

?Trait_score_Loc   Trait_scores ?Trait_scores

?Trait_score_Germ   Trait_scores ?Trait_scores

?Trait_score_Fib_HVI Germplasm ?Germplasm 
                     Region UNIQUE Text      //eg :Plains... 
                     TABLE1 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts
                     Fib_Rep1a ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                     Fib_Rep2a ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                     Fib_Rep3a ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
                     Fib_Rep4a ?Text ?Text ?Text ?Text ?Text ?Text ?Text
                     TABLE2 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts//Column headings
                     Fib_Rep1b ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep2b ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep3b ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep4b ?Text ?Text ?Text ?Text ?Text ?Text 
                     TABLE3 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts//Column headings
                     Fib_Rep1c ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep2c ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep3c ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep4c ?Text ?Text ?Text ?Text ?Text ?Text 
                     TABLE4 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts//Column headings
                     Fib_Rep1d ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep2d ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep3d ?Text ?Text ?Text ?Text ?Text ?Text
                     Fib_Rep4d ?Text ?Text ?Text ?Text ?Text ?Text 
                     Remark ?Texts
 
//?Trait_scores:  Values measured for a particular trait in a particular
//    environment
// Scores = Value of trait for each member of mapping population, in the 
//   same order as listed for the molecular markers in ?Trait Mapping_data
// Germplasm_Mean_SD = Mean and SD for each germplasm (for a comparison
//   that is not a mapping study)
// Environment is not UNIQUE, to allow an averaged-over-evironments record.
// DEM 5/93
?Trait_scores Trait_study  ?Trait_Study XREF Trait_scores
	      Environment ?Environment XREF Trait_scores
              Other_name ?Trait_scores
	      Comment Text
	//For QTLs:
	      Scores Text          //If only have means, list all on one line.
	      Score_Mean_SD Float Float	 //If (mean, SD) pairs, separate lines.
	//For trials of named germplasms:
	      Germplasm_Mean_SD ?Germplasm XREF Trait_scores Float Float
	      Germplasm_score Float ?Germplasm XREF Trait_scores 
			//If only have means, give number first for better
			//visual alignment.
	//For one-record-per-datum, e.g. ISWYN24:
	      Germplasm ?Germplasm 
              Region UNIQUE Text      //eg :Plains...
              Trait_scores ?Trait_scores
	      Score Float
	      Standard_deviation Float
	      Replications Int
              Percent_of_local_check Float
	      Difference_from_local_check Float //When many values are Zero.
              TABLE1 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts  ?Texts ?Texts ?Texts
              Seed_Rep1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Seed_Rep2 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Seed_Rep3 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Seed_Rep4 ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
              Rep1a. ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              TABLE2 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts //Column headings
              Yld_Rep1 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep2 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep3 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep4 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep5 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep6 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep7 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep8 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Yld_Rep9 ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Rep1b. ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              TABLE3 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts //Column headings
              Fib_Rep1a ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
              Fib_Rep2a ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Fib_Rep3a ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Fib_Rep4a ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              TABLE4 ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts ?Texts //Column headings
              Fib_Rep1b ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text 
              Fib_Rep2b ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Fib_Rep3b ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Fib_Rep4b ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text ?Text
              Trait_score_Fib_HVI ?Trait_score_Fib_HVI
              Remark ?Texts