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

                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="7cd35394-1168-11e3-8d7f-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

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

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

                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

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

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

                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="c6731a52-a7a0-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672a8d8-a7a0-11e2-b667-080027bcf912</link>

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

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="415f1a26-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">

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

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

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

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

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

                          <link type="object" struct-name="GrtObject" key="owner">415f1a26-ad15-11e2-9617-080027bcf912</link>

                        </value>

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

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="c6612660-ad10-11e2-b309-080027bcf912" struct-checksum="0x309b847a">

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

                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6615c2a-ad10-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">

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

                  <value type="string" key="createDate">2013-04-17 13:52</value>

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

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

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

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

                <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">be8e8fe4-a6e0-11e2-95e9-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="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">f62bfaf6-a797-11e2-8681-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="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">c6731a52-a7a0-11e2-b667-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 type="object" struct-name="workbench.physical.Connection" id="9b6b743c-ad0c-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_parsed_taxon_assertion_taxon_name1</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">67fa5b28-f6c1-11e2-af44-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="real" key="middleSegmentOffset">0.e+00</value>

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

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

                <link type="object" struct-name="model.Figure" key="endFigure">D1965EDA-481F-496B-9C24-79553E7891E8</link>

                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>

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

                <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">07e2f24c-1dde-11e3-bd5f-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="real" key="left">8.54e+02</value>

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

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

                <value type="real" key="width">1.68e+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.23e+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="top">4.4e+01</value>

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

                <value type="string" key="color">#CCCC33</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.42e+03</value>

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

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

                <value type="real" key="width">1.57e+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="visible">1</value>

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

            </value>

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

            <value type="real" key="width">1.6215e+03</value>

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

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

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

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

              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>

              <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="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>

              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>

              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>

              <value type="string" key="7255cc48-1beb-11e3-8de9-080027bcf912">specimen_unique_in_individual_observation</value>

              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>

              <value type="string" key="760751d2-2324-11e3-a5a2-080027bcf912">fk_dataset_traceable1</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 `specimen` (

  `id` varbinary(767) NOT NULL,

  `collection_event` varbinary(767) DEFAULT NULL,

  `orig_collection` varbinary(767) DEFAULT NULL,

  `barcode` varbinary(767) DEFAULT NULL,

  `current_collection` varbinary(767) DEFAULT NULL,

  `owner_collection` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `specimen_unique_by_collection_event` (`collection_event`),

  UNIQUE KEY `specimen_unique_in_collection_by_barcode` (`orig_collection`,`barcode`),

  UNIQUE KEY `specimen_unique_in_collection_by_accession_number` (`orig_collection`,`accession_number`),

  UNIQUE KEY `specimen_unique_in_individual_observation` (`individual_observation`,`code_in_individual`),

  KEY `fk_specimen_collection1_idx` (`orig_collection`),

  KEY `fk_specimen_taxon_observation1_idx` (`collection_event`),

  KEY `fk_specimen_collection2_idx` (`current_collection`),

  KEY `fk_specimen_organization3_idx` (`owner_collection`),

  KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`),

  KEY `fk_specimen_individual_observation1_idx` (`individual_observation`),

  CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.';

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "specimen" (

  "id" text NOT NULL,

  "collection_event" text DEFAULT NULL,

  "orig_collection" text DEFAULT NULL,

  "barcode" text DEFAULT NULL,

  "current_collection" text DEFAULT NULL,

  "owner_collection" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "specimen_unique_by_collection_event" */UNIQUE ("collection_event"),

  /*CONSTRAINT "specimen_unique_in_collection_by_barcode" */UNIQUE ("orig_collection","barcode"),

  /*CONSTRAINT "specimen_unique_in_collection_by_accession_number" */UNIQUE ("orig_collection","accession_number"),

  /*CONSTRAINT "specimen_unique_in_individual_observation" */UNIQUE ("individual_observation","code_in_individual"),

  /*KEY "fk_specimen_collection1_idx" ("orig_collection")*/CHECK (true),

  /*KEY "fk_specimen_taxon_observation1_idx" ("collection_event")*/CHECK (true),

  /*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),

  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),

  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),

  /*KEY "fk_specimen_individual_observation1_idx" ("individual_observation")*/CHECK (true),

  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.'*/;

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