<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="comment"></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>

                  <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="string" key="name"></value>

            </value>

            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">

            </value>

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

            <value type="real" key="width">1.6215e+03</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="5a8a530a-1dca-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1</value>

              <value type="string" key="5a8a54cc-1dca-11e3-b98c-080027bcf912">orig_observation</value>

              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>

              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>

              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>

              <value type="string" key="61c193a8-1dee-11e3-b571-080027bcf912">fk_source_party_list1</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>

CREATE TABLE `specimen` (

  `id` varbinary(767) NOT NULL,

  `individual_observation` varbinary(767) DEFAULT NULL COMMENT 'the plant the specimen was collected from and any observations about it',

  `orig_collection` varbinary(767) DEFAULT NULL,

  `barcode` varbinary(767) DEFAULT NULL,

  `accession_number` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

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

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

  KEY `fk_specimen_collection1_idx` (`orig_collection`),

  KEY `fk_specimen_collection2_idx` (`current_collection`),

  KEY `fk_specimen_organization3_idx` (`owner_collection`),

  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_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`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.';

CREATE TABLE "specimen" (

  "id" text NOT NULL,

  "individual_observation" text DEFAULT NULL /*COMMENT 'the plant the specimen was collected from and any observations about it'*/,

  "orig_collection" text DEFAULT NULL,

  "barcode" text DEFAULT NULL,

  "accession_number" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

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

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

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

  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/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_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("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.'*/;