<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">parent</value>

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

                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>

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

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

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

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

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

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="be8f3ca0-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183">

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

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8f4e98-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f1784-a6e0-11e2-95e9-080027bcf912</link>

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

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

                      <link type="object" struct-name="GrtObject" key="owner">be8f387c-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_="0xb9ee508" type="dict" key="customData"/>

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

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

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

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

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

              </value>

            </value>

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

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

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

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

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

                <value type="real" key="width">9.3e+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="int" key="triggersExpanded">0</value>

                <value type="string" key="color">#66ffff</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">3.74e+02</value>

                <value type="int" key="locked">0</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="width">1.45e+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.58e+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.14e+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">5.67e+02</value>

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

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

                <value type="real" key="width">9.4e+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">6.88e+02</value>

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

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

                <value type="real" key="width">1.09e+02</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_="0xb986d58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xb1a9c10" 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="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>

              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>

              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>

              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>

              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</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="84258ee2-3129-11e3-ac9d-080027bcf912">authors</value>

              <value type="string" key="8425b926-3129-11e3-ac9d-080027bcf912">traceable_id_fkey1_idx</value>

              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>

              <value type="string" key="86be7be2-29ad-11e3-a980-080027bcf912">id_by_source</value>

              <value type="string" key="86e5a7d8-23ec-11e3-ab7c-080027bcf912">organization_unique</value>

              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>

              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>

              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>

              <value type="string" key="8cef30ce-3119-11e3-84d1-080027bcf912">data_owner</value>

              <value type="string" key="8cef351a-3119-11e3-84d1-080027bcf912">id</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 `place_visit` (

  `id` varbinary(767) NOT NULL,

  `subject` varbinary(767) NOT NULL,

  `project` varbinary(767) DEFAULT NULL,

  `elevation_m` double DEFAULT NULL,

  KEY `fk_place_observation_geological_context1_idx` (`geological_context`),

  KEY `fk_place_observation_community1_idx` (`community`),

  KEY `place_observation_id_fkey1_idx` (`project`),

  CONSTRAINT `place_observation_id_fkey1` FOREIGN KEY (`project`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_place_observation_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `taxon_observation` (

  `id` varbinary(767) NOT NULL,

  `subject` varbinary(767) DEFAULT NULL,

  `taxon_occurrence` varbinary(767) NOT NULL COMMENT 'when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation',

  `sampling_event` varbinary(767) NOT NULL COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation',

  KEY `taxon_observation__unique` (`sampling_event`,`primary_collector`,`collector_number`),

  KEY `taxon_observation_id_fkey2_idx` (`parent`),

  KEY `taxon_observation_id_fkey3_idx` (`subject`),

  CONSTRAINT `taxon_observation_id_fkey2` FOREIGN KEY (`parent`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`all_collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)';

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "place_visit" (

  "id" text NOT NULL,

  "subject" text NOT NULL,

  "project" text DEFAULT NULL,

  "elevation_m" double precision DEFAULT NULL,

  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),

  /*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),

  /*KEY "place_observation_id_fkey1_idx" ("project")*/CHECK (true),

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

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

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

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "taxon_observation" (

  "id" text NOT NULL,

  "subject" text DEFAULT NULL,

  "taxon_occurrence" text NOT NULL /*COMMENT 'when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation'*/,

  "sampling_event" text NOT NULL /*COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation'*/,

  /*KEY "taxon_observation__unique" ("sampling_event","primary_collector","collector_number")*/CHECK (true),

  /*KEY "taxon_observation_id_fkey2_idx" ("parent")*/CHECK (true),

  /*KEY "taxon_observation_id_fkey3_idx" ("subject")*/CHECK (true),

  /*CONSTRAINT "taxon_observation_id_fkey2" FOREIGN KEY ("parent") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

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

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)'*/;

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