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

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

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

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

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

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

                  <value type="string" key="comment">"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point</value>

                </value>

                <value type="object" struct-name="db.mysql.Table" id="be8f67e8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">

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

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

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

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

                      <value _ptr_="0xab397a8" type="list" content-type="string" key="flags"/>

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

                      <value type="int" key="length">767</value>

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

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

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

                      <value _ptr_="0xab39c78" type="list" content-type="string" key="flags"/>

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

                      <value type="int" key="length">767</value>

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

                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="151635b4-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">

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

                        <value type="object" struct-name="db.mysql.IndexColumn" id="151636ea-f6e2-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">

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

                      <link type="object" struct-name="GrtObject" key="owner">15161a3e-f6e2-11e2-b6d1-080027bcf912</link>

                    </value>

                  </value>

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

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

                <value type="real" key="left">5.6e+02</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="int" key="expanded">1</value>

                <value type="real" key="height">1.46e+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">3.53e+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>

              <value type="object" struct-name="workbench.physical.TableFigure" id="6B49544F-8630-4930-B54B-2CD6F6C0C631" struct-checksum="0x3b14eccb">

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

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

                <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">5.67e+02</value>

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

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

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

        <value _ptr_="0x9d366e8" 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="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>

              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>

              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>

              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>

              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>

              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</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>

  KEY `fk_event_party_list1_idx` (`participants`),

  CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

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

  CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of time" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)';

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

/*!40000 ALTER TABLE `geopath_scrub` ENABLE KEYS */;

--

-- Table structure for table `georeferencing`

--

  KEY `fk_georeferencing_party_list1_idx` (`georeferenced_by`),

  CONSTRAINT `fk_georeferencing_geoplace1` FOREIGN KEY (`georeferenced_place`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_georeferencing_party_list1` FOREIGN KEY (`georeferenced_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_geovalidation_record100` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

/*!40000 ALTER TABLE `individual_observation` ENABLE KEYS */;

--

-- Table structure for table `method`

--

/*!40000 ALTER TABLE `party_list_entry` ENABLE KEYS */;

--

-- Table structure for table `place_observation`

--

  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,

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

  CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

  `footprint_geom_WKT` varbinary(767) DEFAULT NULL,

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

  PRIMARY KEY (`id`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

  KEY `fk_specimen_collection2_idx` (`current_collection`),

  KEY `fk_specimen_organization3_idx` (`owner_collection`),

  KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`),

  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='A "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it';

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

  UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`),

  KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`),

  KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),

  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]';

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

  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),

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

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

  /*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/;

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

/*!40000 ALTER TABLE "geopath_scrub" ENABLE KEYS */;

--

-- Table structure for table "georeferencing"

--

  /*KEY "fk_georeferencing_party_list1_idx" ("georeferenced_by")*/CHECK (true),

  /*CONSTRAINT "fk_georeferencing_geoplace1" FOREIGN KEY ("georeferenced_place") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

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

  /*CONSTRAINT "fk_geovalidation_record100" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

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

/*!40000 ALTER TABLE "individual_observation" ENABLE KEYS */;

--

-- Table structure for table "method"

--

/*!40000 ALTER TABLE "party_list_entry" ENABLE KEYS */;

--

-- Table structure for table "place_observation"

--

  /*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),

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

  /*CONSTRAINT "fk_place_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "footprint_geom_WKT" text DEFAULT NULL,

  "dimensions" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

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

  /*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),

  /*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='A "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it'*/;

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

  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),

  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),

  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;

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