?Locus  Name
        ID#     Int
        Type ?Term
        Fullname Text
        Species ?Species
        Synonym Text #Authority
        Plantwide_Gene_Name Text
        Gene_Products ?Gene_Product
        Linkage_Group ?Linkage_Group ?Term
        Location Map ?Map XREF Loci #map_location
        Length  Float #LocusLength
        Related_Loci  ?Term ?Locus
        Internal_Map ?Map
        Alleles ?Variation
        Phenotypes_of_Mutants ?Phenotype
        Haploalleles ?Variation
        Expression_induced_by ?Term
        Properties ?Term
        DNA_FeaturesRelated_Loci Text
        Detected_By  Probe ?Probe #LocusDetected_By
        Mutations_Carried ?Variation
        Comments  ?Text
        External_DB_Keys  ?Person Text
        Reference ?Reference #RefContents


?Authority      Authority ?Person

?LocusLength    Units ?Term

?LocusDetected_By       Method ?Term

?RefContents    Contents ?Term

?Linkage_Group  Name
                ID#     Int
                Type ?Term
                Morphology ?Term
                Chromosome_Dimensions  Stage_of_observation ?Term #Linkage_GroupChromosome_Dimens
                Total_Length_in_KB Float
                Total_Length_in_cM Float
                Maps ?Map
                Comments Text
                Species ?Species
                Reference ?Reference #RefContents

?Linkage_GroupChromosome_Dimens Arm_ratio Float
                                Length_in_um Float


?Variation      Name
                ID#     Int
                Type ?Term
                Of ?Locus XREF Alleles
                Mutation_Type ?Term
                Synonym Text #Authority
                Phenotypic_Effects ?Phenotype
                Breakpoints  ?Locus #VariationBreakpoints
                Related_Alleles ?Term ?Variation
                At ?Locus
                Viability ?Term
                Properties ?Term
                Progenitor_Stock ?Stock
                Carried_by       ?Stock
                Mapcode Float
                Polymorphisms ?Gel_Pattern
                Comments Text
                External_DB_Keys  ?Person Text
                Reference ?Reference #RefContents

?VariationBreakpoints   ?Linkage_Group ?Term Float

?Karyotypic_Variation   Name
                        ID#     Int
                        Type ?Term
                        Linkage_Group ?Linkage_Group
                        Phenotypic_Effects ?Phenotype
                        Comments Text
                        Reference ?Reference #RefContents

?Species        Name
                ID#     Int
                Nuclear_Genome  Haploid# Int #SpeciesNuclear_Genome
                Chloroplast_Genome  #_of_Chloro_Linkage_Groups Int #SpeciesChloroplast_Genom
                Mitochondrial_Genome  #_of_Mito_Linkage_Groups Int #SpeciesMitochondrial_Gen
                Synonym Text #Authority
                External_DB_Keys  ?Person Text
                Comments Text

?SpeciesNuclear_Genome  DNA_Content Text
                        Supernumeraries Text

?SpeciesChloroplast_Genom       Size Float
                                Error Float
                                Copy_number Text

?SpeciesMitochondrial_Gen       Size Float
                                Error Float
                                Copy_number Text

?Stock  Name
        ID#     Int
        Type ?Term
        Synonym Text #Authority
        Focus_Linkage_Group ?Linkage_Group
        Genotypic_Variations  ?Variation XREF Carried_by #StockGenotypic_Variations
        Karyotypic_Variations ?Karyotypic_Variation
        Molecular_Variations ?Variation
        Phenotypes  Phenotype ?Phenotype #StockPhenotypes
        Available_From ?Person
        Coefficients_of_Parentage  Stock ?Stock #StockCoefficients_of_Parentage
        Pedigree Text
        Species ?Species
        Crop_Science_Stock_Class ?Term
        Market_Class ?Term
        Comments Text
        External_DB_Keys  ?Person Text
        Reference ?Reference #RefContents

?StockGenotypic_Variations      LG ?Linkage_Group

?StockPhenotypes        Attributable_to ?Anything

?StockCoefficients_of_Parentage % Float

?Gene_Product   Name
                ID#     Int
                Type ?Term
                Synonym Text #Authority
                External_DB_Keys  ?Person Text
                EC# Text
                Made_by ?Locus
                Related_Products ?Term ?Gene_Product
                Localization ?Term
                Expression_Induced_By  Condition ?Term #Gene_ProductExpression_Induced
                Metabolic_Pathway ?Metabolic_Pathway
                Metabolic_Process ?Term
                Metabolic_Constituents ?Term
                Reactions ?EnzymeCatalyzed_Reaction
                Holoenzyme_Substructure Text
                Motifs_and_Features  ?Term #Gene_ProductMotifs_and_Feature
                Comments Text
                Reference ?Reference #RefContents

?Gene_ProductExpression_Induced Evidence ?Term

?Gene_ProductMotifs_and_Feature Description Text


?Reaction       Name    // not validated
                ID#     Int
                Reactants  RRole ?Term #ReactionReactants
                Products  PRole ?Term #ReactionProducts
                Enzymes ?EnzymeCatalyzed_Reaction
                EC# Text
                Comments Text
                Reference ?Reference #RefContents

?ReactionReactants      Substance ?Term
                        N Int
                        Km Float

?ReactionProducts       Substance ?Term
                        N Int
                        Km Float

?EnzymeCatalyzed_Reaction       Name // not validated
                                ID#     Int
                                Reaction ?Reaction
                                Enzyme ?Gene_Product
                                Species ?Species
                                Pathway ?Metabolic_Pathway
                                Next_Step ?EnzymeCatalyzed_Reaction
                                Previous_Step ?EnzymeCatalyzed_Reaction
                                Vmax Float
                                Substrate_specificity Text
                                Optimum_pH Float
                                Optimum_temp Float
                                Comments Text
                                Reference ?Reference #RefContents

?Metabolic_Pathway      Name // not validated
                        ID#     Int
                        Metabolic_Process ?Term
                        Steps  Step# ?Term #Metabolic_PathwaySteps
                        Included_in ?Metabolic_Pathway
                        Summary_Reaction ?Reaction
                        Comments Text
                        Reference ?Reference #RefContents

?Metabolic_PathwaySteps Step ?Anything


?Phenotype      Name
                ID#     Int
                Trait ?Term
                Body_Parts ?Term
                Developmental_Stages ?Term
                Intensity ?Term
                Value ?Term
                Genotypic_Variations ?Variation
                Karyotypic_Variations ?Karyotypic_Variation
                Stocks ?Stock
                Metabolic_Pathway ?Metabolic_Pathway
                Genes ?Locus
                Inheritance ?Term
                Comments Text
                Reference ?Reference #RefContents

?Gel_Pattern    Name
                ID#     Int
                Probe ?Probe
                Probed_DNA ?DNARNA_Isolation_Prep
                Enzyme ?Restriction_Enzyme_or_Primer
                Units ?Term
                Haploalleles  Haploallele ?Variation #Gel_PatternHaploalleles
                Bands  Text #Gel_PatternBands
                Schematic Text
                Person ?Person
                Comments Text
                Reference ?Reference #RefContents

?Gel_PatternBands       Float Text

?Gel_PatternHaploalleles        MorphID Text

?Probe  Name
        ID#     Int
        Synonym Text #Authority
        Detects ?Locus
        Amplification_Preps ?Amplified_DNA_Prep #ProbeAmplification_Preps
        Staining_Method  Stain ?Term #ProbeStaining_Method
        Quality Text
        External_DB_Keys  ?Person Text
        Comments Text
        Reference ?Reference #RefContents

?ProbeAmplification_Preps       Procedure       ?Term
                                Derived_From    Text
                                Size            Float

?ProbeStaining_Method   Counterstain ?Term

?Amplified_DNA_Prep     Name
                        ID#     Int
                        Prep_No Text
                        Prep_Date Text
                        Source_of_DNA  ?Term #Amplified_DNA_PrepSource_of_DN
                        Insert_Size Float
                        Derived_From ?Anything
                        Procedure ?Term
                        Source_DNA_Reagent  EnzymePrimer ?Restriction_Enzyme_or_Primer #Amplified_DNA_PrepSource_DNA_R
                        Prepared_By ?Person
                        Vector ?Linkage_Group
                        Vector_Type ?Term
                        Vector_Cutters  Enzyme ?Restriction_Enzyme_or_Primer #Amplified_DNA_PrepVector_Cutte
                        Gel_Patterns ?Gel_Pattern
                        External_DB_Keys  ?Person Text
                        Available_From ?Person
                        Noteworthy_Conditions Text
                        Used_to_Complement ?Locus
                        Used_for_Probes ?Probe
                        Comments Text
                        Reference ?Reference #RefContents

?Amplified_DNA_PrepSource_of_DN Prep ?Anything
                                Ex_Libris ?Clone_Library
                                Tissue ?Term

?Amplified_DNA_PrepSource_DNA_R End Text

?Amplified_DNA_PrepVector_Cutte End Text

?DNARNA_Isolation_Prep  Name
                        ID#     Int
                        Stock ?Stock
                        Panel_of_Stocks Text
                        Species ?Species
                        Tissue ?Term
                        Prepared_By ?Person
                        Available_From ?Person
                        Date Text
                        Used_for_Amplification_Preps ?Amplified_DNA_Prep
                        Used_for_Mapping ?Map_Scores
                        Noteworthy_Conditions Text
                        Comments Text
                        Reference ?Reference #RefContents

?Clone_Library  Name
                ID#     Int
                Made_by ?Person
                Vector ?Linkage_Group
                Host_Strain Text
                Medium Text
                Source_DNA ?Anything
                Available_From ?Person
                Comments Text
                Reference ?Reference #RefContents

?Restriction_Enzyme_or_Primer   Name
                                ID#     Int
                                Type ?Term
                                Sequence Text
                                Reference ?Reference #RefContents

?Map    Name
        ID#     Int
        Source ?Person
        Coordinates Text
        Panels_of_Stocks ?Panel_of_Stocks
        Linkage_Group ?Linkage_Group
        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
        Reference ?Reference #RefContents
 	Main_Marker Main_Locus ?Locus XREF Main_Marker // Appear left of scroll bar
	Symbol Text UNIQUE Text  // Class Tag, if present, use tag content as name for class
        Contains Loci ?Locus XREF Map
                 Includes_Maps ?Map XREF Includes_Maps #map_location

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

?map_error Error UNIQUE Float



?Map_Scores     Name
                ID#     Int
                Submitted_by ?Person
                Date Text
                Probe ?Probe
                Probed_Site ?Locus
                Other_Marker ?Locus
                Probed_DNA ?DNARNA_Isolation_Prep
                Enzyme ?Restriction_Enzyme_or_Primer
                Scores Text
                Panel_of_Stocks ?Panel_of_Stocks
                Include_in_maps ?Map
                Parent1_Pattern ?Anything
                Parent2_Pattern ?Anything
                Seed_Source_Code Text
                Filter_Info Text
                Comments Text


?Panel_of_Stocks        Name
                        ID#     Int
                        Panel_Type ?Term
                        Parent1_Role ?Term
                        Parent1 ?Stock
                        Parent2 ?Stock
                        N Int
                        Comments Text
                        Reference ?Reference #RefContents

?QTL_Study      Name // not validated
                ID#     Int
                Reference ?Reference
                Included_by ?Person
                Date Text
                Traits_Analyzed  Trait ?Term #QTL_StudyTraits_Analyzed
                QTL_in_Env_Scores ?QTL_in_Env_Scores
                EnvironmentSpecific_Results ?EnvironmentSpecific_Results
                #_QTL's_LOD2 Int
                #_QTL's_LOD3 Int
                Parents  Stock ?Stock #QTL_StudyParents
                Population_Comment Text
                Parent1_Trait_Values  Trait1 ?Term #QTL_StudyParent1_Trait_Values
                Parent2_Trait_Values  Trait2 ?Term #QTL_StudyParent2_Trait_Values
                Source_of_Positive_Allele  PTrait ?Term #QTL_StudySource_of_Positive_Al
                F1_Description Text
                F2_Description Text
                F3_Description Text
                Phenotypic_Evaluation_Populati  Population Text #QTL_StudyPhenotypic_Evaluation
                Phenotypic_Scores  SPopulation Text #QTL_StudyPhenotypic_Scores
                Genotypic_Evaluation_Populatio  Description Text #QTL_StudyGenotypic_Evaluation_
                Marker_Summary Text
                GenoEvalMarker_Scores ?Map_Scores
                Method ?Term
                Genetic_Model_in_Analysis Text
                Model_Construction Text
                Methods_Comment Text
                ANOVA_design_for_Phenotypic_Ef  ESource Text #QTL_StudyANOVA_design_for_Phen
                ANOVA_design_for_Variance_due_  VSource Text #QTL_StudyANOVA_design_for_Vari
                ANOVA_design_for_Genetic_Varia  GSource Text #QTL_StudyANOVA_design_for_Gene
                R2_Measured_by Text
                Comments Text

?QTL_StudyTraits_Analyzed       #QTL Int
                                Trait_Results ?TraitSpecific_Results

?QTL_StudyParents       Designation ?Term
                        Role ?Term
                        Seed_Source_Codes Text

?QTL_StudyParent1_Trait_Values  Value ?Term

?QTL_StudyParent2_Trait_Values  Value ?Term

?QTL_StudySource_of_Positive_Al Source ?Anything

?QTL_StudyPhenotypic_Evaluation Description Text

?QTL_StudyPhenotypic_Scores     Trait ?Term
                                Scores ?Trait_Scores

?QTL_StudyGenotypic_Evaluation_ Panel_of_Stocks ?Panel_of_Stocks

?QTL_StudyANOVA_design_for_Phen df Int

?QTL_StudyANOVA_design_for_Vari df Int

?QTL_StudyANOVA_design_for_Gene df Int


?TraitSpecific_Results  Name // not validated
                        ID#     Int
                        QTL_Study ?QTL_Study
                        Trait ?Term
                        QTL_Detected  Population Text #TraitSpecific_ResultsQTL_Detec
                        All_QTL_in_Population  APopulation Text #TraitSpecific_ResultsAll_QTL_i
                        Residual_Error Float
                        Global_Type_I_error_rate Float
                        Number_of_Environments Int
                        Number_of_Replications Int
                        GxE_Interaction_Score Float
                        GxE_Evaluation_Method Text

?TraitSpecific_ResultsQTL_Detec Nearest_Marker ?Locus
                                Linkage_Group ?Linkage_Group
                                Statistics ?StatTable
                                QTL ?Locus

?TraitSpecific_ResultsAll_QTL_i i_R2 Float
                                Total_Effects Float
                                Units ?Term


?StatTable      Name // not validated
                ID#     Int
                SingleMarker_Analyses  Population Text #StatTableSingleMarker_Analyses
                Summed_SingleMarkers  SPopulation Text #StatTableSummed_SingleMarkers
                Residual_Error Float
                Global_Type_I_error_rate Float
                Intervalmapping_Analyses  IPopulation Text #StatTableIntervalmapping_Analy
                Statistical_Tests  QTL ?Locus #StatTableStatistical_Tests

?StatTableSingleMarker_Analyses s_R2 Float
                                s1_R2 Float
                                Effect Float
                                Units ?Term

?StatTableSummed_SingleMarkers  AllQTL_i_R2 Float
                                AllQTL_Total_effects Float

?StatTableIntervalmapping_Analy PeakLOD Float
                                i_R2 Float
                                1_QTL_Effect Float
                                NQTL_Effect Float
                                Comments Text

?StatTableStatistical_Tests     TestAlpha Text
                                Near_Mkr_Score Float
                                ML_Pos_Score Float
                                Type_I_Error_Rate Float


?EnvironmentSpecific_Results    Name
                                ID#     Int
                                QTL_Study ?QTL_Study
                                ReplicationsEnvironment Int
                                Results_for_Environment  Environment ?Environment #EnvironmentSpecific_ResultsRes
                                Summary_over_Environments  Trait ?Term #EnvironmentSpecific_ResultsSum
                                QTL_Summary  SEnvironment ?Environment #EnvironmentSpecific_ResultsQTL

?EnvironmentSpecific_ResultsRes Trait ?Term
                                Mean Float
                                SE Float
                                Units ?Term

?EnvironmentSpecific_ResultsSum Population Text
                                Mean Float
                                SE Float
                                Units ?Term

?EnvironmentSpecific_ResultsQTL Trait ?Term
                                #_QTL's_LOD2 Int
                                #_QTL's_LOD3 Int


?QTL_in_Env_Scores      Name // not validated
                        ID#     Int
                        QTL_Study ?QTL_Study
                        Environment ?Environment
                        TraitSpecific_Results ?TraitSpecific_Results
                        Trait ?Term
                        QTL_Detected  QTL ?Locus #QTL_in_Env_ScoresQTL_Detected

?QTL_in_Env_ScoresQTL_Detected  Near ?Locus
                                PeakLOD Float
                                Statistics ?StatTable


?Environment    Name // not validated
                ID#     Int
                Planting_Date Text
                Location Text
                Conditions ?Term
                Comments Text


?Trait_Scores   Name // not validated
                ID#     Int
                TraitSpecific_Results ?TraitSpecific_Results
                Environment ?Environment
                Scores  Stock# Int #Trait_ScoresScores
                Panel_of_Stocks ?Panel_of_Stocks
                Comments Text

?Trait_ScoresScores     Value Float
                        SE Float

?Recombination_Data     Name // not validated (buggy)
                        ID#     Int
                        Reference ?Reference
                        #_of_Markers Int
                        Cross_Type ?Term
                        Loci  Ord# ?Term #Recombination_DataLoci
                        Alleles  Parent Int #Recombination_DataAlleles
                        Class_Frequencies  Genotype Text #Recombination_DataClass_Freque
                        Recombination_Frequencies  Before ?Locus  #Recombination_DataRecombinatio
                        Total_Progeny Int
                        Quality Int
                        Data_Overlaps_With  Recombination_Data ?Recombination_Data #Recombination_DataData_Overlap

?Recombination_DataLoci Locus ?Locus
                        Symbols Text

?Recombination_DataAlleles      Chromosome ?Linkage_Group
                                Allele ?Variation
                                Locus ?Locus

?Recombination_DataClass_Freque Frequency Float
                                N Int

?Recombination_DataRecombinatio After ?Locus
                                Frequency Float
                                SE Float
                                Kosambi Float
                                Haldane Float

?Recombination_DataData_Overlap Uncertain Text


?Journal        Name
                ID#     Int
                Synonyms Text
                Editors ?Person


?Reference      Name
                ID#     Int
                Title Text
                Authors  ?Person
                Type ?Term
                Year Int
                In ?Anything
                Volume Text
                Pages Text
                Number Text
                Publisher ?Person
                Institution ?Person
                To ?Person
                Comments Text
                Describes	Locus ?Locus #RefContents
				Variation ?Variation  #RefContents
				Linkage_Group ?Linkage_Group  #RefContents
				Karyotypic_Variation ?Karyotypic_Variation  #RefContents
				Stock ?Stock #RefContents
				Gene_Product ?Gene_Product #RefContents
				Reaction ?Reaction #RefContents
				Enzyme-Catalyzed_Reaction ?EnzymeCatalyzed_Reaction #RefContents
				Metabolic_Pathway ?Metabolic_Pathway #RefContents
				Phenotype ?Phenotype #RefContents
				Gel_Pattern ?Gel_Pattern #RefContents
				Probe ?Probe #RefContents
				AmplifiedDNAPrep ?Amplified_DNA_Prep #RefContents
				Term ?Term #RefContents
				Recombination_Data ?Recombination_Data #RefContents
				Map ?Map #RefContents
				Clone_Library ?Clone_Library #RefContents
				Panel_of_Stocks ?Panel_of_Stocks #RefContents
				Species ?Species #RefContents
				Restriction_Enzyme_or_Primer ?Restriction_Enzyme_or_Primer #RefContents
				Person ?Person #RefContents
				DNA/RNA_Isolation_Prep ?DNARNA_Isolation_Prep #RefContents
				Map_Scores ?Map_Scores #RefContents
				Reference ?Reference #RefContents
				Field ?Field #RefContents
                Abstract Text
                Author_Description Text


?Term   Name
        ID#     Int
        Type ?Term
        Synonym Text #Authority
        Related_Terms  ?Term ?Term
        Comments Text

?Person Name
        ID#     Int
        Last_Name Text
        First_Name Text
        Initials Text
        Suffix Text
        Synonyms Text
        Attributes ?Term
        Institution ?Person
        DepartmentMailstop Text
        Address Text
        City Text
        State Text
        Country Text
        Postal_Code Text
        Phone_Nos Text
        EMail_Addresses Text
        Comments Text

 // not validated below here

?Entity Name
        ID#     Int
        Documentation Text
        Fields  Ord# Text #EntityFields
        Menuline Text
        Type Text
        Form Text
        Menu ?Entity
        Menu_Position Int
        Main_Table ?Table
        Synonym_Table ?Table
        Unique_Names Text

?EntityFields   Field ?Field
                Datatype Text


?Field  Name
        ID#     Int
        Path Text
        Type Text
        Setof Text
        Entity ?Entity
        Group ?Field
        Range ?Anything
        Subtypes ?Anything
        Datatype Text
        Documentation Text
        Options  Int #FieldOptions
        Fields  Int #FieldFields
        Table ?Table
        Column ?Column
        Ord# Int

?FieldOptions   Option Text

?FieldFields    Column ?Field


?Table  Name
        ID#     Int
        Columns  Ord#  #TableColumns

?TableColumns   Column ?Column
                Datatype Text
                NULL Text


?Column Name
        ID#     Int
        Table ?Table
        Ord# Int
        Datatype Text
        NULL Text
        Fields ?Field
        Joins ?Column
        Type Text