<?xml version="1.0"?>
<edsp version="3.1" about_me="http://ycmi.med.yale.edu/EAVCR/EDSP" source="Olfactory Receptors Database">
  <source>
    <type>eav/cr</type>
    <name>Data Store:SenseLab</name>
    <location>ordb.biotech.ttu.edu</location>
    <date>4/16/2026 9:57:42 PM</date>
    <query_method>GET</query_method>
    <query_parameter>o=148632</query_parameter>
  </source>
  <metadata type="partial" time="0">
    <datatypes>
      <datatype id="B" name="Boolean" xml_datatype="xs:boolean" />
      <datatype id="C" name="Object/Ref" xml_datatype="xs:long" />
      <datatype id="D" name="Datetime" xml_datatype="xs:dateTime" />
      <datatype id="F" name="Formula(only)" xml_datatype="xs:anyType" />
      <datatype id="H" name="Hierarchy(p)" xml_datatype="xs:long" />
      <datatype id="I" name="Integer" xml_datatype="xs:long" />
      <datatype id="M" name="Memo" xml_datatype="xs:string" />
      <datatype id="R" name="Real" xml_datatype="xs:double" />
      <datatype id="S" name="String" xml_datatype="xs:string" />
      <datatype id="V" name="Object/Value" xml_datatype="xs:long" />
      <datatype id="W" name="Object/Ref(MC)" xml_datatype="xs:long" />
      <datatype id="Y" name="Binary" xml_datatype="xs:base64Binary" />
    </datatypes>
    <metadata_ontology>
      <sem_type_atts />
      <sem_rel_types />
      <sem_rel_att />
    </metadata_ontology>
    <database id="d2" name="modeldb" caption="ModelDB" caption_long="Model Database" description="ModelDB provides an accessible location for storing and efficiently retrieving compartmental neuron models. ModelDB is tightly coupled with NeuronDB. Models can be coded in any language for any environment, though ModelDB has been initially constructed for use with NEURON and GENESIS. Model code can be viewed before downloading and browsers can be set to auto-launch the models" main_class="19" version="3" version_date="4/12/2002 11:28:19 AM">
      <class id="c73" name="sql_programs" caption="SQL programs" description="These SQL programs are intended to display tables that are useful for administration and development of scripts." object_description_hide="false" type="E" is_concept="false" host_concepts="false" uid="" version="3" version_date="4/27/2003 9:43:11 AM">
        <att id="a229" dt_id="M" sn="1" name="sql_program" caption="SQL Program" description="This stores an SQL program" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="1" version_date="4/27/2003 9:45:32 AM" />
        <att id="a230" dt_id="I" sn="2" name="max_rows" caption="Maximum Rows" description="This variable determines the maximum number of rows that are desired to be displayed. If set to &quot;-1&quot; then all rows are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 9:52:03 AM" />
        <att id="a231" dt_id="I" sn="3" name="max_cols" caption="Maximum Columns" description="This variable determines the maximum number of columns that are desired to be displayed. If set to &quot;-1&quot; then all columns are displayed." width="20" is_concept="false" host_concepts="false" srt_id="s" sra_id="s" version="2" version_date="4/27/2003 10:36:43 AM" />
      </class>
    </database>
  </metadata>
  <data time="0">
    <data_database db_id="d2">
      <data_class class_id="c73" version="3">
        <object id="o148632" name="papers, year, month, with text or citation references to ModelDB" description="Pre-sql server version (oracle): select papers.object_id as OBJECTID,papers.object_name as PAPERNAME, paperusage.object_name as USAGE, year.value_ as pubyear, pub_month.value_ as pubmonth from &#xD;&#xA;eav_string year, objects papers, eav_objects statedusage, objects paperusage,&#xD;&#xA;eav_string pub_month&#xD;&#xA;where papers.object_class=42 and &#xD;&#xA;statedusage.attribute_id=452 and &#xD;&#xA;papers.object_id=statedusage.object_id and &#xD;&#xA;paperusage.object_id=statedusage.value_ AND &#xD;&#xA;year.OBJECT_ID(+) = papers.OBJECT_ID AND &#xD;&#xA;year.ATTRIBUTE_ID(+) = 154 and&#xD;&#xA;pub_month.object_id(+) = papers.object_id and&#xD;&#xA;pub_month.attribute_id(+) = 156&#xD;&#xA;ORDER BY year.VALUE_(+) DESC, pubmonth(+) desc, papers.object_name" uid="" version="2" version_date="3/7/2017 10:54:51 AM">
          <att_value att_id="a229" value="select papers.object_id as OBJECTID,papers.object_name as PAPERNAME, paperusage.object_name as USAGE, year.value_ as pubyear, pub_month.value_ as pubmonth from eav_string year, objects papers, eav_objects statedusage, objects paperusage, eav_string pub_month where papers.object_class=42 and statedusage.attribute_id=452 and papers.object_id=statedusage.object_id and paperusage.object_id=statedusage.value_ AND year.OBJECT_ID = papers.OBJECT_ID AND year.ATTRIBUTE_ID = 154 and pub_month.object_id = papers.object_id and pub_month.attribute_id = 156 ORDER BY year.VALUE_ DESC, pubmonth desc, papers.object_name" />
        </object>
      </data_class>
    </data_database>
  </data>
</edsp>

