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

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

                    </value>

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

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

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

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

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

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

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

                      <value type="int" key="length">767</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="comment"></value>

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

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="58b0d99a-ad00-11e2-b309-080027bcf912" struct-checksum="0x783b5183">

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="16538808-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">

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

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="21b40060-f680-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="db4ea800-1dc6-11e3-838b-410b6ef2c3ca" struct-checksum="0x309b847a">

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

                        <value type="object" struct-name="db.mysql.IndexColumn" id="db4ea9ea-1dc6-11e3-838b-410b6ef2c3ca" struct-checksum="0x62630b3c">

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

                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-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-17 13:52</value>

                  <value _ptr_="0xbaf4058" 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="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">7e2aa84c-1dfb-11e3-bbb6-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>

            <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="triggersExpanded">0</value>

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

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

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

                <value type="real" key="width">1.63e+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">5.36e+02</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.042e+03</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="string" key="b922fa5a-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1_idx</value>

              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>

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

              <value type="string" key="bae73e3e-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1</value>

              <value type="string" key="bae73ff6-2996-11e3-a80d-080027bcf912">current_collection</value>

              <value type="string" key="bae812be-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1_idx</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>

  `occurrence_status` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_aggregate_observation_taxa_sampling_event1_idx` (`sampling_event`),

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

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

  KEY `fk_dataset_source2_idx` (`data_source`),

  KEY `fk_dataset_dataset1_idx` (`parent`),

  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

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

  `count` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),

  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon_presence`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_individual_count_taxon_presence1` FOREIGN KEY (`id`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

  KEY `fk_individual_observation_individual1_idx` (`individual`),

  KEY `fk_individual_observation_place1_idx` (`place_observed_at`),

  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),

  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_individual_observation_place1` FOREIGN KEY (`place_observed_at`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]';

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

  `accession_number` varbinary(767) DEFAULT NULL,

  `defining_data` set('hstore') COLLATE utf8_bin DEFAULT NULL COMMENT 'of the observations made about the specimen in individual_observation.traits, this stores the subset that can be used to make a taxonomic redetermination. for a digital-only specimen, this would be the information that comprises the specimen (e.g. a photo, a sketch, or a description that is detailed enough to be able to make a redetermination). note that a taxon_presence without a physical voucher can still qualify as reobservable if a detailed description of it is provided here.',

  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`),

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

  KEY `fk_specimen_collection1_idx` (`orig_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,

  UNIQUE KEY `stem_observation_unique` (`individual_observation`,`stem`),

  KEY `fk_stem_observation_individual_observation1_idx` (`individual_observation`),

  KEY `fk_stem_observation_stem1_idx` (`stem`),

  CONSTRAINT `fk_stem_observation_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]';

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

  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 */;

  `taxon_occurrence` varbinary(767) NOT NULL,

  `sampling_event` varbinary(767) DEFAULT NULL,

  `observation_in_parent_event` varbinary(767) DEFAULT NULL COMMENT 'points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID',

  `collector_number` varbinary(767) DEFAULT NULL,

  `growth_form` varbinary(767) DEFAULT NULL,

  `cultivated` tinyint(1) DEFAULT NULL,

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

  PRIMARY KEY (`id`),

  KEY `fk_taxon_observation_taxon_occurrence1_idx` (`taxon_occurrence`),

  KEY `fk_taxon_observation_taxa_sampling_event1_idx` (`sampling_event`),

  KEY `fk_taxon_observation_taxon_observation1_idx` (`observation_in_parent_event`),

  CONSTRAINT `fk_taxon_observation_taxon_observation1` FOREIGN KEY (`observation_in_parent_event`) REFERENCES `taxon_observation` (`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,

  CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

  "occurrence_status" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_aggregate_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),

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

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

  /*KEY "fk_dataset_source2_idx" ("data_source")*/CHECK (true),

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

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

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

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

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

  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

  "aggregating_traits" hstore DEFAULT NULL,

  "count" integer DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),

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

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

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

  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),

  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),

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

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

  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'*/;

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

  "accession_number" text DEFAULT NULL,

  "defining_data" hstore DEFAULT NULL /*COMMENT 'of the observations made about the specimen in individual_observation.traits, this stores the subset that can be used to make a taxonomic redetermination. for a digital-only specimen, this would be the information that comprises the specimen (e.g. a photo, a sketch, or a description that is detailed enough to be able to make a redetermination). note that a taxon_presence without a physical voucher can still qualify as reobservable if a detailed description of it is provided here.'*/,

  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"),

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

  /*KEY "fk_specimen_collection1_idx" ("orig_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 "stem_observation_unique" */UNIQUE ("individual_observation","stem"),

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

  /*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/;

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

  /*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 */;

  "taxon_occurrence" text NOT NULL,

  "sampling_event" text DEFAULT NULL,

  "observation_in_parent_event" text DEFAULT NULL /*COMMENT 'points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID'*/,

  "collector_number" text DEFAULT NULL,

  "growth_form" text DEFAULT NULL,

  "cultivated" integer DEFAULT NULL,

  "traits" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_observation_taxon_occurrence1_idx" ("taxon_occurrence")*/CHECK (true),

  /*KEY "fk_taxon_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),

  /*KEY "fk_taxon_observation_taxon_observation1_idx" ("observation_in_parent_event")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_event") REFERENCES "taxon_observation" ("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),

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

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