<value type="string" key="oldName">place</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="d2b2ccf6-a794-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">

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

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

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

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

                  <value _ptr_="0xbb41028" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">

                      </value>

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

                      <value type="string" key="deleteRule">CASCADE</value>

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

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

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

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

                      </value>

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

                      <value type="string" key="updateRule">CASCADE</value>

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

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

                    </value>

                  </value>

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

                    <value type="object" struct-name="db.mysql.Index" id="be8f416e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">

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

                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8f43a8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">

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

                      <link type="object" struct-name="GrtObject" key="owner">be8f387c-a6e0-11e2-95e9-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="name"></value>

                        </value>

                      </value>

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

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

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

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

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

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

                    </value>

                  </value>

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

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

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

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

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="a841ba7e-f6c0-11e2-af44-080027bcf912" struct-checksum="0x783b5183">

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

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

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

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

                  <value _ptr_="0xbb62250" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">

                    <value type="object" struct-name="db.mysql.ForeignKey" id="7f177512-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="b774c534-2985-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">

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

                        <value type="object" struct-name="db.mysql.IndexColumn" id="b774c728-2985-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">

                <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">c4391d16-006c-11e3-895c-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">dda7bbf8-0072-11e3-906b-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">7afec93a-0075-11e3-906b-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">2d3c42f6-0078-11e3-906b-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="813e8be6-1de9-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">

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

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

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

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

              </value>

            </value>

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

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

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

                <value type="real" key="height">1.69e+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">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="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">9.e+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">7.19e+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="int" key="locked">0</value>

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

                <value type="real" key="top">8.72e+02</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="top">1.144e+03</value>

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

                <value type="real" key="height">5.4e+01</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">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="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">6.29e+02</value>

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

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

                <value type="real" key="width">1.71e+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.32e+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="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="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.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>

              <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="d2855d46-1df2-11e3-bbb6-080027bcf912">fk_source_party1_idx</value>

              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>

              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>

              <value type="string" key="db4e8988-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1</value>

              <value type="string" key="db4e8bea-1dc6-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>

              <value type="string" key="db4ea800-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1_idx</value>

              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>

              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>

              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>

              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>

              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>

              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>

              <value type="string" key="f15726c2-011f-11e3-9f3a-080027bcf912">aggregate_observation</value>

              <value type="string" key="f1572a5a-011f-11e3-9f3a-080027bcf912">id</value>

              <value type="string" key="f1572d5c-011f-11e3-9f3a-080027bcf912">occurrence_status</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 `place_observation` (

  `id` varbinary(767) NOT NULL,

  `place` varbinary(767) NOT NULL,

  `elevation_m` double DEFAULT NULL,

  `slope_incline_deg` double DEFAULT NULL,

  `slope_direction_deg_N` double DEFAULT NULL,

  KEY `fk_place_observation_place1_idx` (`place`),

  KEY `fk_place_observation_geological_context1_idx` (`geological_context`),

  KEY `fk_place_observation_community1_idx` (`community`),

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

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]';

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

CREATE TABLE `taxa_sampling_event` (

  `id` varbinary(767) NOT NULL,

  `place_observation` varbinary(767) NOT NULL,

  `method` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_sampling_event_method1_idx` (`method`),

  KEY `taxa_sampling_event_id_fkey1_idx` (`place_observation`),

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

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them';

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

CREATE TABLE "place_observation" (

  "id" text NOT NULL,

  "place" text NOT NULL,

  "elevation_m" double precision DEFAULT NULL,

  "slope_incline_deg" double precision DEFAULT NULL,

  "slope_direction_deg_N" double precision DEFAULT NULL,

  /*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),

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

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

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/;

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

CREATE TABLE "taxa_sampling_event" (

  "id" text NOT NULL,

  "place_observation" text NOT NULL,

  "method" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),

  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_observation")*/CHECK (true),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them'*/;

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