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

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

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="1156d180-2393-11e3-a6f3-080027bcf912" struct-checksum="0x783b5183">

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

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

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

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

                    </value>

                  </value>

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

                  <value type="string" key="defaultCharacterSetName">utf8</value>

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

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

                  <value _ptr_="0xba56bc0" 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">be8cc04c-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>

                      <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">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                      </value>

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="1156cf50-2393-11e3-a6f3-080027bcf912" struct-checksum="0x70a8fc40">

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

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

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

                    </value>

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>

                      </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">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>

                      </value>

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

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

                    </value>

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

                      </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">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>

                      </value>

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

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

                    </value>

                  </value>

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

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

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

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

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

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

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

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

        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>

        <value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xb0204c8" 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="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>

              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>

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

              <value type="string" key="174e1b4c-23e9-11e3-ab7c-080027bcf912">person</value>

              <value type="string" key="174e1e76-23e9-11e3-ab7c-080027bcf912">id</value>

              <value type="string" key="174e216e-23e9-11e3-ab7c-080027bcf912">fk_organization_party10</value>

              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>

              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>

              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>

              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">data_owners</value>

              <value type="string" key="cb38187e-29d4-11e3-a673-080027bcf912">source__unique</value>

              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</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 `dataset` (

  `id` varbinary(767) NOT NULL,

  `name` varbinary(767) NOT NULL,

  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).',

  `dataset_source` varbinary(767) DEFAULT NULL COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable); = Brad.vegpath.org?attribution.proximate_data_provider',

  `first_publisher` varbinary(767) DEFAULT NULL COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider',

  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',

  PRIMARY KEY (`id`),

  UNIQUE KEY `dataset_unique` (`parent`,`name`),

  KEY `fk_source_party_list1_idx` (`data_owners`),

  KEY `fk_dataset_source2_idx` (`dataset_source`),

  KEY `fk_dataset_dataset1_idx` (`parent`),

  KEY `fk_source_party2_idx` (`first_publisher`),

  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`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_source2` FOREIGN KEY (`dataset_source`) 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,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';

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

CREATE TABLE "dataset" (

  "id" text NOT NULL,

  "name" text NOT NULL,

  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).'*/,

  "dataset_source" text DEFAULT NULL /*COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable); = Brad.vegpath.org?attribution.proximate_data_provider'*/,

  "first_publisher" text DEFAULT NULL /*COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider'*/,

  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "dataset_unique" */UNIQUE ("parent","name"),

  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),

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

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

  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),

  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("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_source2" FOREIGN KEY ("dataset_source") 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),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;

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