// models.wrm - for AATDB, database release 1-6
// Lisa Lorenzen Version 1.1.6

// ACEDB system models now in sysmodels.wrm

?Allele Name	Correct_name ?Allele XREF Other_name
		Other_name ?Allele XREF Other_name
	Gene ?Gene XREF Allele
	Locus ?Locus XREF Allele 
        Reference_allele ?Text
                         For ?Allele XREF Like_ref_allele
        Like_ref_allele ?Allele XREF For
	Remark	?Text
        Mutagen UNIQUE ?Reagent Text	// Text is dose
        Reference_Germplasm ?Germplasm XREF Allele
        Location ?Colleague  #Lab_Location
	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
        Phenotype       ?Text #Gene_Action
			Image ?Image XREF Allele
	                Interactions    Suppressed_by	?Allele XREF Suppresses
                                        Suppresses 	?Allele XREF  Suppressed_by
	Origin ?Text
        Molecular_nature        Probe ?Probe XREF Allele
                                Sequence ?Sequence
	Reference ?Paper XREF Allele
	Source_of_Information ?Source


?Gene_Action		Recessive
                        Dominant
			Semi-dominant
			Codominant
			Weak
		        Temperature_Sensitive
			Amber
                        Maternal	
                        Paternal


?Gene_Class     Description ?Text
                Gene      ?Gene
		Source_of_Information


?Gene 	Gene
  	Name    Gene_class UNIQUE ?Gene_Class XREF Gene
		Correct_name ?Gene XREF Other_name
                Other_name ?Gene XREF Other_name
        Reference_Allele ?Allele Text
        Molecular_information	Probe   ?Probe XREF Gene
				Sequence ?Sequence XREF Gene
	EC_number ?Text 
	Phenotype ?Text
	Image ?Image XREF Gene
	Origin ?Text
        Allele  ?Allele XREF Gene 
        Germplasm   ?Germplasm XREF Gene
	Map ?Map XREF Gene
        Mapping_information	Locus ?Locus XREF Gene
				Physical bMap UNIQUE ?Contig XREF Gene Int Int
                        	Autopos
                		Genetic  gMap ?Linkage_Group XREF Gene Float Float
                        	In_cluster ?Gene
	Mapping_data	2_point_data ?2_point_data 
                        3Point ?3_point_data
			F2_data ?F2_data
        Related_genes   ?Gene XREF Related_genes
                        Gene_family ?Gene XREF Gene_family
                        Interacting_genes ?Gene XREF Interacting_genes
                        Interacting_alleles ?Allele
	Resistant_to ?Pathology #Resistance_Genes
        Reference ?Paper XREF Gene
	Source_of_Information ?Source


?Rearrangement 


?Locus  Type	RFLP
		Gene
		RAPD
        Mapping_information	Physical bMap UNIQUE ?Contig XREF Locus Int Int //Lisa changed from just Map
                         	Autopos
                		Genetic  gMap ?Linkage_Group XREF Locus Float Float
	Has_Restriction_map	?Locus
	Map ?Map XREF Locus
	Molecular_information	Probe   ?Probe XREF Locus
	Associated_with_Gene ?Gene XREF Locus //Lisa was RFLP
	Associated_with_Allele ?Allele XREF Locus //Lisa was RFLP
	Germplasm ?Germplasm XREF Locus #Pattern
	Image ?Image XREF Locus //Lisa added the XREF
	Data ?F2_data
	Remarks Text
        Polymorphic_for ?Restriction REPEAT //Lisa
	Not_used ?Restriction REPEAT
	Not_polymorphic_for ?Restriction REPEAT
	Source_of_Information ?Source



?Segregation

      
?Germplasm 	Name ?Germplasm XREF Other_name
		Other_name ?Germplasm XREF Name //Lisa start
		PVP ?PVP XREF Variety
		Species UNIQUE ?Species
		Collection_and_ID# ?Collection XREF Entries ?Germplasm XREF Other_name
		Originator ?Text
		Legal_status ?Text
		Year_released Int
		Cultivar_info Cultivar ?Cultivar 
		Generation_derived UNIQUE Text
		Selection_method ?Text
		Maturity_group ?Text
		Market_Class ?Text
		Traits ?Trait #Trait_Information  //Lisa End
		Phenotype UNIQUE ?Text
		Gene ?Gene XREF Germplasm
		Allele    ?Allele XREF Germplasm
		Locus ?Locus
		Mutagen UNIQUE ?Reagent
		Developed_by ?Colleague //lisa 
		Development_site ?Text  //lisa
		Registration# ?Text     //lisa
		Molecular_information	Probe ?Probe
		Source ?Text
		Notes ?Text
		Reference ?Paper XREF Germplasm
		Source_of_Information ?Source

?PVP	Variety ?Germplasm XREF PVP

?Trait	Name ?Trait XREF Other_name
	Other_name ?Trait XREF Name
	Description ?Text
	Source_of_Information ?Source

?Trait_Information	Trait_value ?Text
			Environment ?Environment

?Environment	Evaluator ?Colleague
		Institute ?Text
		Env._Type UNIQUE ?Text
		Env._Design UNIQUE ?Text
		Location	Latitude UNIQUE Text
				Longitude UNIQUE Text
				Elevation UNIQUE Text
				Topography UNIQUE Text
				Drainage UNIQUE Text
				Soil_texture UNIQUE Text
		Irrigation 	Type UNIQUE ?Text
				Days  UNIQUE Int
				Total_amount UNIQUE Float
		Planting_date UNIQUE Text
		Testing_date	Text
		Source_of_Information  ?Source

?Linkage_Group	Non_graphic  // Prevents a graphic display of a chromosome //Lisa changed Chromosome to Linkage_Group
            	Centre Float Float  // Overrules default Initial centre and width
	    	Map ?Map XREF gMap 
            	Gene ?Gene 
            	Locus ?Locus 
		Source_of_Information ?Source

?Reagent

?Probe  Type	#Probe_Type
	Gene    ?Gene XREF Probe
        Locus   ?Locus XREF Probe
        Position  pMap UNIQUE ?Contig XREF Probe Int Int // bands pMap units
		  bMap UNIQUE Int Int	// base units
		  Autopos
	PCR_primers ?Sequence
	Amplification_conditions ?Text
	Sequence	?Sequence XREF Probe
	Insert	Size Int //Lisa
		Insert_sequence ?Sequence //Lisa
	Polymorphism	Present	?Restriction //Lisa
			Absent	?Restriction //Lisa
       	Map ?Map 
	Linkage_Group ?Linkage_Group
	Germplasm ?Germplasm XREF Probe #Pattern
	Origin	Vector   ?Text //Lisa changed this from ?Probe
		Vector_enzyme ?Restriction //Lisa
		Insert_enzyme ?Restriction //Lisa
		Excision_enzyme ?Restriction //Lisa  I removed Cutter_used
		cDNA //boolian
		Genomic //boolian
		Derived_from ?Germplasm
		Tissue_source ?Text
		Vector_PCR_primers ?Sequence  //lisa
	Subcloned_in ?Probe XREF Subclone_of
	Subclone_of ?Probe XREF Subcloned_in
	Location ?Colleague
	Image ?Image XREF Probe //Lisa
	Source_of_Information ?Source

?Probe_Type	RFLP
		SSCP
		RAPD
		VNTR

?Pattern	Enzyme ?Restriction #Bands

?Bands	Bands_detected Text

?Probe_Grid

?Contig bMap	

?2_point_data	Gene1 ?Gene XREF 2_point_data Unique Int
		Gene2 ?Gene XREF 2_point_data Unique Int //Lisa Start
		Allele1 ?Allele XREF 2_point_data Int //removed Unique before Int
		Allele2 ?Allele XREF 2_point_data Int
		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
		Results	Min Float
     			Distance Float
			Independent
                        Max Float
                        Error Float
		  	Standard_error Float
		Reference ?Paper XREF 2_point_data
		Remark Text             
		Flag Text
		Source_of_Information ?Source

?Df_Dup_data 	      

?3_point_data         

?Colleague	Position Text
		Profession Text
		Address Mail Text
			Country Text
                        Phone Text
                        E_mail Text
			       Bitnet Text
                               Internet Text
			Fax Text
			Telex Text
		Research_interest ?Text
		Keyword ?Keyword
     		Publishes_as ?Author XREF Full_name
		Associate ?Colleague XREF Associate
		Last_update Text
		Source_of_Information ?Source


?Author Full_name ?Colleague XREF Publishes_as
        Paper ?Paper XREF Author

?Journal Paper ?Paper XREF Journal

?Paper  Reference       Title UNIQUE ?Text
                        Original_title ?Text
			Source ?Text
			Journal UNIQUE ?Journal XREF Paper
			Book ?Text
			Editor ?Colleague
			Publisher UNIQUE Text
                        Year UNIQUE Int
                        Volume UNIQUE Int Text
                        Page  UNIQUE Int Int
			Cited_in Text
	Institution Text
        Author ?Author XREF Paper
	Type UNIQUE Text
	Language Text
	Abstract Text
        Refers_to	Gene ?Gene XREF Reference
			Allele ?Allele XREF Reference
			Sequence ?Sequence XREF Reference
			Germplasm ?Germplasm
			2_point_data ?2_point_data //Lisa
			Gene_Product ?Gene_Product
        Keyword ?Keyword
	Source_of_Information ?Source

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

?Protein   Title UNIQUE ?Text

?Sequence 

?Gene_Product	Other_name ?Text #Reference
		Type ?Text #Reference //Enzyme, Protein, etc
		Function ?Text #Reference
		RNA_type
		EC_number UNIQUE ?Text #Reference
		Gene ?Gene #Reference
		Pathway ?Pathway XREF Gene_Product #Reference	
		Isozymes ?Gene_Product #Reference
		Information_on #Info

?Info	Source_of ?Source 
	Regulation_of ?Regulators
	Structure_of ?Structure
	Clones_of  ?Clone_info
	Probes_for ?Probe_info
	Mutations_of ?Mutation_info	 
		
?Pathway	Reference ?Paper
		Comment Text
		Reaction ?Reaction #Components	
		Substrate_specificity Text #Reference
		pH_optimum Float #Reference
		Temp_optimum(C) Text #Reference
		Catalytic_mechanism #Mechanism
		Activator ?Text #Km 
		Cooperativity //boolian #Reference
		Inhibitor ?Text #Km
		Active_site_inhibitor ?Text #Reference
		

?Structure	Native_Mr Float #Reference
		Prosthetic_group ?Text #Reference
		Subunitation_type ?Text #Subunit._type
		3D_structure #Reference
		Purification Text #Reference
		Isoelectric_point Float #Reference

?Clone_info	cDNA_Clone #Reference 
		Heterologous_cDNA #Reference
		Genomic_Clone #Reference
		Heterologous_Clone #Reference

?Probe_info	DNA_Probe #Reference  
		Heterologous_Probe #Reference
		RFLP_Probe #Reference
		Antibody_Probe #Reference
		Heterologous_Antibody #Reference

?Mutation_info 	Mutants #Reference
		Heterologous_Mutation #Reference
		Het._Mutation_Gene_Symbol ?Gene #Reference
 
?Subunit._type	Subunit_Mr Float #Reference

?Regulators	Developmental #Reference
		Hormonal #Reference
		Environmental #Reference
		Genetic Text #Reference
		Inducer Text #Reference
		Repressor Text #Reference
		Ancillary_enzyme ?Gene_Product #Reference

?Mechanism	Ping_Pong #Reference

?Components	Reference ?Paper
		Comment Text
		Reactant Text #Km 	
		Product Text #Reference

?Km	Km Text #Reference
	Ki Text #Reference
	Vmax Text #Reference
	Reference ?Paper
	Comment 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
		Species UNIQUE ?Text #Reference //GeneProd
		Cultivar ?Cultivar #Reference //GeneProd
		Tissue ?Text #Reference         //GeneProd
		Organelle ?Text #Reference	//GeneProd
		Membrane_Associated #Reference //   GeneProd

?EC_Number	EC_number ?EC_Number
		Corresponds_to	IUB_number ?Text

?Search_Method	

?Homology 

?Seg_Set

?Octamer_Table	

?Image  Probe ?Probe XREF Image
	Locus ?Locus XREF Image
	Pathology ?Pathology XREF Image
	Author ?Author XREF Image
	Paper  ?Paper  XREF Image
	Gene   ?Gene 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)
	Source_of_Information ?Source
	Comment ?Text

//experimental class to contain F2 data for entire population

?F2_data

?Pool	

?Chrom_Band

?Lab_Location

?Collection	Curator ?Colleague
		Description ?Text
		Entries ?Germplasm XREF Collection 
		
?Map	Name ?Map  
	Linkage_Group	gMap ?Linkage_Group XREF Map  UNIQUE Float
	Locus ?Locus XREF Map 
	Gene ?Gene XREF Map

?Pathology	Other_name ?Pathology 	
		Organism_type #Organism_type
		Genus_Species UNIQUE ?Species 
		Virus_group ?Text
		Forma_specialis ?Text
		Authority ?Colleague
		Differential_information_for ?Differentials
		Races ?Race REPEAT
		Strain_groups ?Race REPEAT
		Reference ?Paper
		Disease ?Disease
		Soybean_Defense ?Pathology_reactions
		Resistance_Locus ?Gene REPEAT
		Image ?Image XREF Pathology
		Source_of_Information ?Source
		Reviewed_by ?Colleague
?Organism_type  Nematode
		Disease
		Virus
		Bacterial
		Fungus

?Race	Differential_value ?Germplasm #Differential_Value
	Soybean_Resistance ?Text
	Contact ?Colleague
	Source_of_Resistance ?Germplasm
	Resistance_Gene ?Allele
	Reference ?Paper
	Comment Text
	Source_of_Information ?Source

?Differential_Value	Susceptible
			Resistant
			?
			Symptomless
			Necrotic
			Mosaic
			Not_tested
		     	            		
?Disease 	Diagnostic_symptom ?Text
		Geographical_distr._(USA_&_Canada) Text #Reference
		Geographical_distr._(World) Text #Reference
		Species_host_range Text #Reference
		Genus_host_range Text #Reference
		Family_host_range Text #Reference
		Reference ?Paper

?Pathology_reactions	Resistance_type ?Text
			Resistance_reaction ?Text
			Tolerance_Description ?Text #Reference
			Location ?Text #Tolerance
			Protocol ?Text #Reference
			Reference ?Paper

?Tolerance	Protocol ?Text
		Tolerance_Rating ?Text
		Reference ?Paper

?Resistance_Genes	Allele ?Allele #Resistance_Source

?Resistance_Source	Source ?Germplasm
			Reference ?Paper

?Species	Name ?Species

?Reference	Reference ?Paper
		Comment Text

?Differentials	Differential_Reaction Text
		Differentials ?Germplasm XREF Differential_for 
		Standard_Suscept._Germplasm ?Germplasm
		Protocol  Text #Reference
		Reference ?Paper
		Source_of_Information ?Source

?Cultivar	Cultivar Name
		Pedigree Text
                Germplasm ?Germplasm XREF Cultivar
		Market_Class Text
		Seed_Size Float
		Days_To_Maturity Text
		Plant_Architecture Text
		Reaction_Halo_Blight Text
		Reaction_Common_Blight Text
		Reaction_White_Mold Text
		Reaction_Fusarium_Root_Rot Text
		Reaction_Rhizoctonia_Root_Rot Text
		Reaction_Air_Pollution Text
		Reaction_Zinc_Deficiency Text
		Reaction_Iron_Deficiency Text
		Reaction_Bacterial_Brown_Spot Text
		Reaction_Potato_Leafhopper Text
		Reaction_Bean_Golden_Mosaic_Virus Text