<?xml version=“1.0” encoding=“UTF-8” ?> <schema>
<chado version="1.23"> <modules> <module id="general" requires=""> <tables> <table id="db" primary_key="db_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> <field id="description" type="string" not_null="" default="" foreign_key=""/> <field id="urlprefix" type="string" not_null="" default="" foreign_key=""/> <field id="url" type="string" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> <table id="dbxref" primary_key="dbxref_id"> <fields> <field id="db_id" type="integer" not_null="1" default="" foreign_key="db"/> <field id="accession" type="string" not_null="1" default="" foreign_key=""/> <field id="version" type="string" not_null="1" default="0" foreign_key=""/> <field id="description" type="string" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="db_id,accession,version" unique="1"/> <index columns="db_id" unique=""/> <index columns="accession" unique=""/> <index columns="version" unique=""/> </indexes> </table> <table id="project" primary_key="project_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> <field id="description" type="string" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> <table id="tableinfo" primary_key="tableinfo_id"> <fields> <field id="name" type="string" not_null="" default="" foreign_key=""/> <field id="primary_key_column" type="string" not_null="" default="" foreign_key=""/> <field id="is_view" type="integer" not_null="1" default="" foreign_key=""/> <field id="view_on_table_id" type="integer" not_null="" default="" foreign_key=""/> <field id="superclass_table_id" type="integer" not_null="" default="" foreign_key=""/> <field id="is_updateable" type="integer" not_null="1" default="1" foreign_key=""/> <field id="modification_date" type="timestamp" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> </tables> </module> <module id="cv" requires="general"> <tables> <table id="cv" primary_key="cv_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> <field id="definition" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> <table id="cvterm" primary_key="cvterm_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> <field id="definition" type="text" not_null="" default="" foreign_key=""/> <field id="is_obsolete" type="integer" not_null="1" default="0" foreign_key=""/> <field id="is_relationshiptype" type="integer" not_null="1" default="0" foreign_key=""/> <field id="cv_id" type="integer" not_null="1" default="" foreign_key="cv"/> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> </fields> <indexes> <index columns="cv_id" unique=""/> <index columns="name" unique=""/> <index columns="dbxref_id" unique=""/> <index columns="cv_id,name,is_obsolete" unique="1"/> <index columns="dbxref_id" unique="1"/> </indexes> </table> <table id="cvterm_dbxref" primary_key="cvterm_dbxref_id"> <fields> <field id="cvterm_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> <field id="is_for_definition" type="integer" not_null="1" default="0" foreign_key=""/> </fields> <indexes> <index columns="cvterm_id" unique=""/> <index columns="dbxref_id" unique=""/> <index columns="cvterm_id,dbxref_id" unique="1"/> </indexes> </table> <table id="cvterm_relationship" primary_key="cvterm_relationship_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="subject_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="object_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="subject_id" unique=""/> <index columns="object_id" unique=""/> <index columns="type_id,subject_id,object_id" unique="1"/> </indexes> </table> <table id="cvtermpath" primary_key="cvtermpath_id"> <fields> <field id="type_id" type="integer" not_null="" default="" foreign_key="cvterm"/> <field id="subject_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="object_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="cv_id" type="integer" not_null="1" default="" foreign_key="cv"/> <field id="pathdistance" type="integer" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="subject_id" unique=""/> <index columns="object_id" unique=""/> <index columns="cv_id" unique=""/> <index columns="type_id,subject_id,object_id,pathdistance" unique="1"/> </indexes> </table> <table id="cvtermprop" primary_key="cvtermprop_id"> <fields> <field id="cvterm_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="0" foreign_key=""/> <field id="value" type="text" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="cvterm_id" unique=""/> <index columns="type_id" unique=""/> <index columns="value" unique=""/> <index columns="cvterm_id,type_id,rank,value" unique="1"/> </indexes> </table> <table id="cvtermsynonym" primary_key="cvtermsynonym_id"> <fields> <field id="cvterm_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="synonym" type="text" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="type_id,synonym" unique="1"/> </indexes> </table> <table id="dbxrefprop" primary_key="dbxrefprop_id"> <fields> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="dbxref_id" unique=""/> <index columns="type_id" unique=""/> <index columns="value" unique=""/> <index columns="dbxref_id,type_id,rank" unique="1"/> </indexes> </table> </tables> </module> <module id="contact" requires="cv"> <tables> <table id="contact" primary_key="contact_id"> <fields> <field id="type_id" type="integer" not_null="" default="" foreign_key="cvterm"/> <field id="name" type="string" not_null="1" default=""/> <field id="description" type="string" not_null="" default=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> <table id="contact_relationship" primary_key="contact_relationship_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="subject_id" type="integer" not_null="1" default="" foreign_key="contact"/> <field id="object_id" type="integer" not_null="1" default="" foreign_key="contact"/> </fields> <indexes> <index columns="type_id,subject_id,object_id" unique="1"/> <index columns="type_id" unique="0"/> <index columns="subject_id" unique="0"/> <index columns="object_id" unique="0"/> </indexes> </table> </tables> </module> <module id="pub" requires="general,cv"> <tables> <table id="pub" primary_key="pub_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="title" type="text" not_null="" default="" foreign_key=""/> <field id="series_name" type="string" not_null="" default="" foreign_key=""/> <field id="volumetitle" type="text" not_null="" default="" foreign_key=""/> <field id="volume" type="string" not_null="" default="" foreign_key=""/> <field id="issue" type="string" not_null="" default="" foreign_key=""/> <field id="pages" type="string" not_null="" default="" foreign_key=""/> <field id="pyear" type="string" not_null="" default="" foreign_key=""/> <field id="uniquename" type="text" not_null="1" default="" foreign_key=""/> <field id="publisher" type="string" not_null="" default="" foreign_key=""/> <field id="miniref" type="string" not_null="" default="" foreign_key=""/> <field id="is_obsolete" type="boolean" not_null="" default="FALSE" foreign_key=""/> <field id="pubplace" type="string" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="uniquename" unique="1"/> </indexes> </table> <table id="pub_dbxref" primary_key="pub_dbxref_id"> <fields> <field id="is_current" type="boolean" not_null="" default="TRUE" foreign_key=""/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> </fields> <indexes> <index columns="pub_id,dbxref_id" unique="1"/> <index columns="pub_id" unique=""/> <index columns="dbxref_id" unique=""/> </indexes> </table> <table id="pub_relationship" primary_key="pub_relationship_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="subject_id" type="integer" not_null="1" default="" foreign_key="pub"/> <field id="object_id" type="integer" not_null="1" default="" foreign_key="pub"/> </fields> <indexes> <index columns="type_id,subject_id,object_id" unique="1"/> <index columns="type_id" unique=""/> <index columns="subject_id" unique=""/> <index columns="object_id" unique=""/> </indexes> </table> <table id="pubauthor" primary_key="pubauthor_id"> <fields> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="surname" type="string" not_null="1" default="" foreign_key=""/> <field id="givennames" type="string" not_null="" default="" foreign_key=""/> <field id="suffix" type="string" not_null="" default="" foreign_key=""/> <field id="editor" type="boolean" not_null="" default="FALSE" foreign_key=""/> </fields> <indexes> <index columns="pub_id,rank" unique="1"/> <index columns="pub_id" unique=""/> </indexes> </table> <table id="pubprop" primary_key="pubprop_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> <field id="rank" type="integer" not_null="" default="" foreign_key=""/> <field id="value" type="text" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id,pub_id,rank" unique="1"/> <index columns="type_id" unique=""/> <index columns="pub_id" unique=""/> </indexes> </table> </tables> </module> <module id="stock" requires="general,cv,pub,organism,genotype,contact"> <tables> <table id="stock" primary_key="stock_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="organism_id" type="integer" not_null="1" default="" foreign_key="organism"/> <field id="name" type="string" not_null="" default="" foreign_key=""/> <field id="uniquename" type="text" not_null="1" default="" foreign_key=""/> <field id="description" type="text" not_null="" default="" foreign_key=""/> <field id="is_obsolete" type="boolean" not_null="1" default="FALSE" foreign_key=""/> <field id="dbxref_id" type="integer" not_null="" default="" foreign_key="dbxref"/> </fields> <indexes> <index columns="uniquename,type_id,organism_id" unique="1"/> <index columns="type_id" unique=""/> <index columns="organism_id" unique=""/> <index columns="dbxref_id" unique=""/> <index columns="uniquename" unique=""/> </indexes> </table> <table id="stock_cvterm" primary_key="stock_cvterm_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="cvterm_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="cvterm_id" unique=""/> <index columns="pub_id" unique=""/> <index columns="stock_id,cvterm_id,pub_id" unique="1"/> </indexes> </table> <table id="stock_dbxref" primary_key="stock_dbxref_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> <field id="is_current" type="boolean" not_null="1" default="TRUE" foreign_key=""/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="dbxref_id" unique=""/> <index columns="stock_id,dbxref_id" unique="1"/> </indexes> </table> <table id="stock_genotype" primary_key="stock_genotype_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="genotype_id" type="integer" not_null="1" default="" foreign_key="genotype"/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="genotype_id" unique=""/> <index columns="stock_id,genotype_id" unique="1"/> </indexes> </table> <table id="stock_pub" primary_key="stock_pub_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="pub_id" unique=""/> <index columns="stock_id,pub_id" unique="1"/> </indexes> </table> <table id="stock_relationship" primary_key="stock_relationship_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="subject_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="object_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="subject_id" unique=""/> <index columns="object_id" unique=""/> <index columns="type_id,subject_id,object_id,rank" unique="1"/> </indexes> </table> <table id="stock_relationship_pub" primary_key="stock_relationship_pub_id"> <fields> <field id="stock_relationship_id" type="integer" not_null="1" default="" foreign_key="stock_relationship"/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> </fields> <indexes> <index columns="stock_relationship_id" unique=""/> <index columns="pub_id" unique=""/> <index columns="stock_relationship_id,pub_id" unique="1"/> </indexes> </table> <table id="stockcollection" primary_key="stockcollection_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="name" type="string" not_null="" default="" foreign_key=""/> <field id="uniquename" type="text" not_null="1" default="" foreign_key=""/> <field id="contact_id" type="integer" not_null="" default="" foreign_key="contact"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="contact_id" unique=""/> <index columns="uniquename" unique=""/> <index columns="type_id,uniquename" unique="1"/> </indexes> </table> <table id="stockcollection_stock" primary_key="stockcollection_stock_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="stockcollection_id" type="integer" not_null="1" default="" foreign_key="stockcollection"/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="stockcollection_id" unique=""/> <index columns="stock_id,stockcollection_id" unique="1"/> </indexes> </table> <table id="stockcollectionprop" primary_key="stockcollectionprop_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="stockcollection_id" type="integer" not_null="1" default="" foreign_key="stockcollection"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="stockcollection_id" unique=""/> <index columns="type_id,stockcollection_id,rank" unique="1"/> </indexes> </table> <table id="stockprop" primary_key="stockprop_id"> <fields> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="stock_id" unique=""/> <index columns="type_id" unique=""/> <index columns="stock_id,type_id,rank" unique="1"/> </indexes> </table> <table id="stockprop_pub" primary_key="stockprop_pub_id"> <fields> <field id="stockprop_pub_id" type="integer" not_null="1" default="" foreign_key="stockprop_pub"/> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> </fields> <indexes> <index columns="stockprop_pub_id" unique=""/> <index columns="pub_id" unique=""/> <index columns="stockprop_pub_id,pub_id" unique="1"/> </indexes> </table> </tables> </module> <module id="organism" requires="general,cv,pub,organism,genotype,contact"> <tables> <table id="organism" primary_key="organism_id"> <fields> <field id="abbreviation" type="string" not_null="" default="" foreign_key=""/> <field id="genus" type="string" not_null="1" default="" foreign_key=""/> <field id="species" type="string" not_null="1" default="" foreign_key=""/> <field id="common_name" type="string" not_null="" default="" foreign_key=""/> <field id="comment" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="genus,species" unique="1"/> </indexes> </table> <table id="organism_dbxref" primary_key="organism_dbxref_id"> <fields> <field id="organism_id" type="integer" not_null="1" default="" foreign_key="organism"/> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> </fields> <indexes> <index columns="organism_id" unique=""/> <index columns="dbxref_id" unique=""/> <index columns="organism_id,dbxref_id" unique="1"/> </indexes> </table> <table id="organismprop" primary_key="organismprop_id"> <fields> <field id="organism_id" type="integer" not_null="1" default="" foreign_key="organism"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="organism_id" unique=""/> <index columns="type_id" unique=""/> <index columns="organism_id,type_id,rank" unique="1"/> </indexes> </table> </tables> </module> <module id="nd" requires="general,cv,stock,contact,genotype,phenotype"> <tables> <table id="nd_experiment" primary_key="nd_experiment_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="nd_geolocation_id" type="integer" not_null="1" default="" foreign_key="nd_geolocation"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="nd_geolocation_id" unique=""/> </indexes> </table> <table id="nd_experiment_contact" primary_key="nd_experiment_contact_id"> <fields> <field id="contact_id" type="integer" not_null="1" default="" foreign_key="contact"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="contact_id" unique=""/> <index columns="nd_experiment_id" unique=""/> </indexes> </table> <table id="nd_experiment_dbxref" primary_key="nd_experiment_dbxref_id"> <fields> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="dbxref_id" unique=""/> <index columns="nd_experiment_id" unique=""/> </indexes> </table> <table id="nd_experiment_genotype" primary_key="nd_experiment_genotype_id"> <fields> <field id="genotype_id" type="integer" not_null="1" default="" foreign_key="genotype"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="genotype_id" unique=""/> <index columns="nd_experiment_id" unique=""/> <index columns="genotype_id,nd_experiment_id" unique="1"/> </indexes> </table> <table id="nd_experiment_phenotype" primary_key="nd_experiment_phenotype_id"> <fields> <field id="phenotype_id" type="integer" not_null="1" default="" foreign_key="phenotype"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="phenotype_id" unique=""/> <index columns="nd_experiment_id" unique=""/> <index columns="phenotype_id,nd_experiment_id" unique="1"/> </indexes> </table> <table id="nd_experiment_project" primary_key="nd_experiment_project_id"> <fields> <field id="project_id" type="integer" not_null="1" default="" foreign_key="project"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="project_id" unique=""/> <index columns="nd_experiment_id" unique=""/> </indexes> </table> <table id="nd_experiment_protocol" primary_key="nd_experiment_protocol_id"> <fields> <field id="protocol_id" type="integer" not_null="1" default="" foreign_key="protocol"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="protocol_id" unique=""/> <index columns="nd_experiment_id" unique=""/> </indexes> </table> <table id="nd_experiment_pub" primary_key="nd_experiment_pub_id"> <fields> <field id="pub_id" type="integer" not_null="1" default="" foreign_key="pub"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="pub_id" unique=""/> <index columns="nd_experiment_id" unique=""/> <index columns="pub_id,nd_experiment_id" unique="1"/> </indexes> </table> <table id="nd_experiment_stock" primary_key="nd_experiment_stock_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="stock_id" type="integer" not_null="1" default="" foreign_key="stock"/> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="stock_id" unique=""/> <index columns="nd_experiment_id" unique=""/> </indexes> </table> <table id="nd_experiment_stock_dbxref" primary_key="nd_experiment_stock_dbxref_id"> <fields> <field id="dbxref_id" type="integer" not_null="1" default="" foreign_key="dbxref"/> <field id="nd_experiment_stock_id" type="integer" not_null="1" default="" foreign_key="nd_experiment_stock"/> </fields> <indexes> <index columns="dbxref_id" unique=""/> <index columns="nd_experiment_stock_id" unique=""/> </indexes> </table> <table id="nd_experiment_stockprop" primary_key="nd_experiment_stockprop_id"> <fields> <field id="nd_experiment_stock_id" type="integer" not_null="1" default="" foreign_key="nd_experiment_stock"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="nd_experiment_stock_id" unique=""/> <index columns="type_id" unique=""/> <index columns="nd_experiment_stock_id,type_id,rank" unique="1"/> </indexes> </table> <table id="nd_experimentprop" primary_key="nd_experimentprop_id"> <fields> <field id="nd_experiment_id" type="integer" not_null="1" default="" foreign_key="nd_experiment"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="nd_experiment_id" unique=""/> <index columns="type_id" unique=""/> <index columns="nd_experiment_id,type_id,rank" unique="1"/> </indexes> </table> <table id="nd_geolocation" primary_key="nd_geolocation_id"> <fields> <field id="description" type="string" not_null="" default="" foreign_key=""/> <field id="latitude" type="float" not_null="" default="" foreign_key=""/> <field id="longitude" type="float" not_null="" default="" foreign_key=""/> <field id="geodetic_datum" type="string" not_null="" default="" foreign_key=""/> <field id="altitude" type="float" not_null="" default="" foreign_key=""/> </fields> <indexes> </indexes> </table> <table id="nd_geolocationprop" primary_key="nd_geolocationprop_id"> <fields> <field id="nd_geolocation_id" type="integer" not_null="1" default="" foreign_key="nd_geolocation"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="nd_geolocation_id" unique=""/> <index columns="type_id" unique=""/> <index columns="nd_geolocation_id,type_id,rank" unique="1"/> </indexes> </table> <table id="nd_protocol" primary_key="nd_protocol_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> </fields> <indexes> <index columns="name" unique="1"/> </indexes> </table> <table id="nd_protocol_reagent" primary_key="nd_protocol_reagent_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="nd_protocol_id" type="integer" not_null="1" default="" foreign_key="nd_protocol"/> <field id="reagent_id" type="integer" not_null="1" default="" foreign_key="reagent"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="nd_protocol_id" unique=""/> <index columns="reagent_id" unique=""/> </indexes> </table> <table id="nd_protocolprop" primary_key="nd_protocolprop_id"> <fields> <field id="nd_protocol_id" type="integer" not_null="1" default="" foreign_key="nd_protocol"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="nd_protocol_id" unique=""/> <index columns="type_id" unique=""/> <index columns="nd_protocol_id,type_id,rank" unique="1"/> </indexes> </table> <table id="nd_reagent" primary_key="nd_reagent_id"> <fields> <field id="name" type="string" not_null="1" default="" foreign_key=""/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="feature_id" type="integer" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="feature_id" unique=""/> </indexes> </table> <table id="nd_reagent_relationship" primary_key="nd_reagent_relationship_id"> <fields> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="subject_reagent_id" type="integer" not_null="1" default="" foreign_key="nd_reagent"/> <field id="object_reagent_id" type="integer" not_null="1" default="" foreign_key="nd_reagent"/> </fields> <indexes> <index columns="type_id" unique=""/> <index columns="subject_reagent_id" unique=""/> <index columns="object_reagent_id" unique=""/> </indexes> </table> <table id="nd_reagentprop" primary_key="nd_reagentprop_id"> <fields> <field id="nd_reagent_id" type="integer" not_null="1" default="" foreign_key="nd_reagent"/> <field id="type_id" type="integer" not_null="1" default="" foreign_key="cvterm"/> <field id="rank" type="integer" not_null="1" default="" foreign_key=""/> <field id="value" type="text" not_null="" default="" foreign_key=""/> </fields> <indexes> <index columns="nd_reagent_id" unique=""/> <index columns="type_id" unique=""/> <index columns="nd_reagent_id,type_id,rank" unique="1"/> </indexes> </table> </tables> </module> </modules> </chado>
</schema>