<value type="string" key="oldName">id</value>

                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="2ebd5a70-238c-11e3-a6f3-080027bcf912" struct-checksum="0x783b5183">

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                      <value type="string" key="name">fk_dataset_source2</value>

                      <value type="string" key="oldName">fk_dataset_source2</value>

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="7e2aa84c-1dfb-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>

                      <value _ptr_="0xbbe5420" type="list" content-type="object" content-struct-name="db.Column" key="columns">

                      <value type="string" key="oldName">fk_dataset_source2_idx</value>

                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                    </value>

                  </value>

                  <value type="string" key="maxRows"></value>

                  <value type="string" key="mergeInsert"></value>

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-16 14:58</value>

                  <value _ptr_="0xb401dc8" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <value type="string" key="name">dataset</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

                      <value type="string" key="oldName">name</value>

                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="afc4158e-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">

                      <value type="int" key="autoIncrement">0</value>

                      <value type="string" key="characterSetName"></value>

                  <value type="string" key="defaultCharacterSetName">utf8</value>

                  <value type="string" key="defaultCollationName">utf8_bin</value>

                  <value type="int" key="delayKeyWrite">0</value>

                  <value _ptr_="0xbc856d8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">

                    <value type="object" struct-name="db.mysql.Index" id="afc41fc0-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">

                      <value _ptr_="0xbc87048" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="afc422b8-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">

                      <value _ptr_="0xbc87428" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">

                        <value type="object" struct-name="db.mysql.IndexColumn" id="afc424f2-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">

                          <value type="int" key="columnLength">0</value>

                          <value type="string" key="comment"></value>

                      <value type="string" key="oldName">source_unique</value>

                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>

                    </value>

                  </value>

                  <value type="string" key="maxRows"></value>

                  <value type="string" key="mergeInsert"></value>

                <value type="int" key="visible">1</value>

                <value type="string" key="name"></value>

              </value>

              <value type="object" struct-name="workbench.physical.Connection" id="34ed2e2a-1dfb-11e3-bbb6-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_record_source1</value>

                <value type="real" key="captionXOffs">0.e+00</value>

                <value type="real" key="extraCaptionXOffs">0.e+00</value>

                <value type="real" key="extraCaptionYOffs">0.e+00</value>

                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6a2c268a-1dfc-11e3-bbb6-080027bcf912</link>

                <value type="real" key="startCaptionXOffs">0.e+00</value>

                <value type="real" key="startCaptionYOffs">0.e+00</value>

                <value type="int" key="drawSplit">0</value>

                <value type="int" key="visible">1</value>

                <value type="string" key="name"></value>

              </value>

            </value>

            <value type="string" key="description"></value>

            <value _ptr_="0xbc8d138" type="list" content-type="object" content-struct-name="model.Figure" key="figures">

                <value type="int" key="triggersExpanded">0</value>

                <value type="string" key="color">#99ccff</value>

                <value type="int" key="expanded">1</value>

                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">1.06e+02</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="real" key="left">1.2e+01</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">8.1e+01</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="real" key="left">8.e+00</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">1.21e+02</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="real" key="left">1.87e+02</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">1.03e+02</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="real" key="left">1.46e+02</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">1.39e+02</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="int" key="expanded">1</value>

                <value type="real" key="height">1.e+02</value>

                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">1.06e+02</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="int" key="triggersExpanded">0</value>

                <value type="string" key="color">#99ccff</value>

                <value type="int" key="expanded">1</value>

                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>

                <value type="real" key="left">1.e+01</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">8.9e+01</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>

        <value _ptr_="0xbbde3b8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xa949130" type="dict" key="syncProfiles">

              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>

              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>

              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>

              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>

              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>

              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>

              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>

              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>

              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>

              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>

              <value type="string" key="afc401d4-1df9-11e3-bbb6-080027bcf912">source</value>

              <value type="string" key="afc4053a-1df9-11e3-bbb6-080027bcf912">id</value>

              <value type="string" key="afc40c10-1df9-11e3-bbb6-080027bcf912">name</value>

              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>

              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>

              <value type="string" key="afc422b8-1df9-11e3-bbb6-080027bcf912">source_unique</value>

              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>

              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>

              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>

    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">

      <value type="string" key="author">Aaron Marcuse-Kubitza</value>

      <value type="string" key="caption">New Model</value>

      <value type="string" key="dateCreated">2012-01-19 14:06</value>

      <value type="string" key="description"></value>

      <value type="string" key="project">Name of the project</value>

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `dataset` (

  `id` varbinary(767) NOT NULL,

  `metadata_source` varbinary(767) DEFAULT NULL COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)',

  `first_publisher` varbinary(767) DEFAULT NULL,

  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',

  KEY `fk_source_party_list1_idx` (`data_owners`),

  KEY `fk_source_party1_idx` (`contacts`),

  KEY `fk_dataset_source2_idx` (`metadata_source`),

  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`metadata_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

CREATE TABLE `source` (

  `id` varbinary(767) NOT NULL,

  `name` varbinary(767) NOT NULL,

  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference';

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "dataset" (

  "id" text NOT NULL,

  "metadata_source" text DEFAULT NULL /*COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)'*/,

  "first_publisher" text DEFAULT NULL,

  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,

  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),

  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),

  /*KEY "fk_dataset_source2_idx" ("metadata_source")*/CHECK (true),

  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("metadata_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

CREATE TABLE "source" (

  "id" text NOT NULL,

  "name" text NOT NULL,

  "info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference'*/;

/*!40101 SET character_set_client = @saved_cs_client */;