/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 10522

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: require rel_place to have a parent place. merge plot_element into subplot because subplot is the only place the parent_plot constraint is imposed (individuals can now be located in any place, not just a plot).

     /*!40000 ALTER TABLE "plot" ENABLE KEYS */;
     --
     -- Table structure for table "plot_element"
     --
     /*!40101 SET @saved_cs_client     = @@character_set_client */;
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE "plot_element" (
       "id" text NOT NULL,
       "parent_plot" text NOT NULL,
       PRIMARY KEY ("id"),
       /*KEY "fk_subplot_plot2_idx" ("parent_plot")*/CHECK (true),
       /*CONSTRAINT "fk_subplot_rel_place10" FOREIGN KEY ("id") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
       /*CONSTRAINT "fk_subplot_plot20" FOREIGN KEY ("parent_plot") REFERENCES "plot" ("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 */;
     --
     -- Dumping data for table "plot_element"
     --
     /*!40000 ALTER TABLE "plot_element" DISABLE KEYS */;
     /*!40000 ALTER TABLE "plot_element" ENABLE KEYS */;
     --
     -- Table structure for table "project"
     --
-...
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE "rel_place" (
       "id" text NOT NULL,
       "parent" text NOT NULL,
       "x_m" double precision DEFAULT NULL,
       "y_m" double precision DEFAULT NULL,
       "coords" hstore DEFAULT NULL,
       PRIMARY KEY ("id"),
       /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),
       /*CONSTRAINT "fk_rel_place_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
       /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
     ) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;
     /*!40101 SET character_set_client = @saved_cs_client */;
-...
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE "subplot" (
       "id" text NOT NULL,
       "parent_plot" text NOT NULL,
       PRIMARY KEY ("id"),
       /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
       /*CONSTRAINT "fk_subplot_plot_element1" FOREIGN KEY ("id") REFERENCES "plot_element" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
       /*KEY "fk_subplot_plot2_idx" ("parent_plot")*/CHECK (true),
       /*CONSTRAINT "fk_subplot_plot2" FOREIGN KEY ("parent_plot") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
       /*CONSTRAINT "fk_subplot_rel_place1" FOREIGN KEY ("id") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
       /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("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 */;

                           <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
                           <value type="string" key="comment"></value>
                           <value type="string" key="name">place</value>
                           <value type="string" key="oldName">rel_place_id</value>
                           <value type="string" key="oldName">place</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
-...
                           <value type="int" key="isPrimary">0</value>
                           <value type="string" key="name">fk_individual_rel_place1_idx</value>
                           <value type="int" key="unique">0</value>
                           <value type="string" key="oldName">fk_individual_rel_place1</value>
                           <value type="string" key="oldName">fk_individual_rel_place1_idx</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
                         </value>
                       </value>
-...
                           <value type="string" key="oldName">id</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Column" id="13884530-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x783b5183">
                           <value type="int" key="autoIncrement">0</value>
                           <value type="string" key="characterSetName"></value>
                           <value _ptr_="0xb927060" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
                           <value type="string" key="collationName"></value>
                           <value type="string" key="datatypeExplicitParams"></value>
                           <value type="string" key="defaultValue"></value>
                           <value type="int" key="defaultValueIsNull">0</value>
                           <value _ptr_="0xc4a8658" type="list" content-type="string" key="flags"/>
                           <value type="int" key="isNotNull">1</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>
                           <value type="string" key="name">parent</value>
                           <value type="string" key="oldName">parent</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Column" id="cfea1514-a790-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
                           <value type="int" key="autoIncrement">0</value>
                           <value type="string" key="characterSetName"></value>
-...
                           <value type="string" key="name">fk_subplot_place2</value>
                           <value type="string" key="oldName">fk_subplot_place2</value>
                         </value>
                         <value type="object" struct-name="db.mysql.ForeignKey" id="1388436e-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x70a8fc40">
                           <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
                           <value _ptr_="0xbcf6678" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">13884530-f9c5-11e2-9af4-080027bcf912</link>
                           </value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="deleteRule">CASCADE</value>
                           <link type="object" struct-name="db.Index" key="index">13885958-f9c5-11e2-9af4-080027bcf912</link>
                           <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">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
                           <value _ptr_="0xb7d7f28" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                             <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
                           </value>
                           <value type="int" key="referencedMandatory">1</value>
                           <value type="string" key="updateRule">CASCADE</value>
                           <value type="string" key="comment"></value>
                           <value type="string" key="name">fk_rel_place_place1</value>
                           <value type="string" key="oldName">fk_rel_place_place1</value>
                         </value>
                       </value>
                       <value _ptr_="0xb06cc70" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
                         <value type="object" struct-name="db.mysql.Index" id="be8f6c7a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
-...
                           <value type="string" key="oldName">PRIMARY</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Index" id="13885958-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xbb76db0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="13885ade-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x62630b3c">
                               <value type="int" key="columnLength">0</value>
                               <value type="string" key="comment"></value>
                               <value type="int" key="descend">0</value>
                               <link type="object" struct-name="db.Column" key="referencedColumn">13884530-f9c5-11e2-9af4-080027bcf912</link>
                               <value type="string" key="name"></value>
                               <link type="object" struct-name="GrtObject" key="owner">13885958-f9c5-11e2-9af4-080027bcf912</link>
                             </value>
                           </value>
                           <value type="string" key="indexKind"></value>
                           <value type="int" key="keyBlockSize">0</value>
                           <value type="string" key="withParser"></value>
                           <value type="string" key="comment"></value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="indexType">INDEX</value>
                           <value type="int" key="isPrimary">0</value>
                           <value type="string" key="name">fk_rel_place_place1_idx</value>
                           <value type="int" key="unique">0</value>
                           <value type="string" key="oldName">fk_rel_place_place1_idx</value>
                           <link type="object" struct-name="GrtObject" key="owner">be8f67e8-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_="0xb06c9f8" type="dict" key="customData"/>
                       <value type="string" key="lastChangeDate">2013-07-30 18:34</value>
                       <value type="string" key="lastChangeDate">2013-07-31 02:39</value>
                       <value type="int" key="modelOnly">0</value>
                       <value type="string" key="name">rel_place</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">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Column" id="49a235d6-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x783b5183">
                           <value type="int" key="autoIncrement">0</value>
                           <value type="string" key="characterSetName"></value>
                           <value _ptr_="0xbe18d40" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
                           <value type="string" key="collationName"></value>
                           <value type="string" key="datatypeExplicitParams"></value>
                           <value type="string" key="defaultValue"></value>
                           <value type="int" key="defaultValueIsNull">0</value>
                           <value _ptr_="0xb934528" type="list" content-type="string" key="flags"/>
                           <value type="int" key="isNotNull">1</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>
                           <value type="string" key="name">parent_plot</value>
                           <value type="string" key="oldName">parent_plot</value>
                           <link type="object" struct-name="GrtObject" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                         </value>
                       </value>
                       <value type="string" key="connectionString"></value>
                       <value type="string" key="defaultCharacterSetName">utf8</value>
-...
                           <value type="string" key="name">fk_subplot_plot1</value>
                           <value type="string" key="oldName">fk_subplot_plot1</value>
                         </value>
                         <value type="object" struct-name="db.mysql.ForeignKey" id="a13a5e16-f9bd-11e2-af16-080027bcf912" struct-checksum="0x70a8fc40">
                           <link type="object" struct-name="db.mysql.Table" key="referencedTable">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                           <value _ptr_="0xb0b4f70" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">2673bdc2-f9bc-11e2-a599-080027bcf912</link>
                         <value type="object" struct-name="db.mysql.ForeignKey" id="49a23428-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x70a8fc40">
                           <link type="object" struct-name="db.mysql.Table" key="referencedTable">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
                           <value _ptr_="0xc452a58" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">49a235d6-f9c5-11e2-9af4-080027bcf912</link>
                           </value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="deleteRule">CASCADE</value>
                           <value type="int" key="mandatory">0</value>
                           <value type="int" key="many">0</value>
                           <link type="object" struct-name="db.Index" key="index">49a26722-f9c5-11e2-9af4-080027bcf912</link>
                           <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">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                           <value _ptr_="0xb0b52f8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                             <link type="object">36135336-f9bd-11e2-af16-080027bcf912</link>
                           <value _ptr_="0xb9b3d18" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                             <link type="object">9f4bdd10-a6fb-11e2-9461-080027bcf912</link>
                           </value>
                           <value type="int" key="referencedMandatory">1</value>
                           <value type="string" key="updateRule">CASCADE</value>
                           <value type="string" key="comment"></value>
                           <value type="string" key="name">fk_subplot_plot_element1</value>
                           <value type="string" key="oldName">fk_subplot_plot_element1</value>
                           <value type="string" key="name">fk_subplot_plot2</value>
                           <value type="string" key="oldName">fk_subplot_plot2</value>
                         </value>
                       </value>
                       <value _ptr_="0xb0b4490" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
                         <value type="object" struct-name="db.mysql.Index" id="2673d532-f9bc-11e2-a599-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xb0b5388" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="2673d65e-f9bc-11e2-a599-080027bcf912" struct-checksum="0x62630b3c">
                               <value type="int" key="columnLength">0</value>
                               <value type="string" key="comment"></value>
                               <value type="int" key="descend">0</value>
                               <link type="object" struct-name="db.Column" key="referencedColumn">2673bdc2-f9bc-11e2-a599-080027bcf912</link>
                               <value type="string" key="name"></value>
                               <link type="object" struct-name="GrtObject" key="owner">2673d532-f9bc-11e2-a599-080027bcf912</link>
                             </value>
                           </value>
                           <value type="string" key="indexKind"></value>
                           <value type="int" key="keyBlockSize">0</value>
                           <value type="string" key="withParser"></value>
                           <value type="string" key="comment"></value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="indexType">PRIMARY</value>
                           <value type="int" key="isPrimary">1</value>
                           <value type="string" key="name">PRIMARY</value>
                           <value type="int" key="unique">0</value>
                           <value type="string" key="oldName">PRIMARY</value>
                           <link type="object" struct-name="GrtObject" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                         </value>
                       </value>
                       <value type="string" key="maxRows"></value>
                       <value type="string" key="mergeInsert"></value>
                       <value type="string" key="mergeUnion"></value>
                       <value type="string" key="minRows"></value>
                       <value type="string" key="nextAutoInc"></value>
                       <value type="string" key="packKeys"></value>
                       <value type="int" key="partitionCount">0</value>
                       <value _ptr_="0xb0b4540" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
                       <value type="string" key="partitionExpression"></value>
                       <value type="string" key="partitionType"></value>
                       <value type="string" key="password"></value>
                       <link type="object" struct-name="db.mysql.Index" key="primaryKey">2673d532-f9bc-11e2-a599-080027bcf912</link>
                       <value type="string" key="raidChunkSize"></value>
                       <value type="string" key="raidChunks"></value>
                       <value type="string" key="raidType"></value>
                       <value type="string" key="rowFormat"></value>
                       <value type="int" key="subpartitionCount">0</value>
                       <value type="string" key="subpartitionExpression"></value>
                       <value type="string" key="subpartitionType"></value>
                       <value type="string" key="tableDataDir"></value>
                       <value type="string" key="tableEngine">InnoDB</value>
                       <value type="string" key="tableIndexDir"></value>
                       <value _ptr_="0xb0b44e0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
                       <value type="int" key="isStub">0</value>
                       <value type="int" key="isSystem">0</value>
                       <value type="int" key="isTemporary">0</value>
                       <value type="string" key="temporaryScope"></value>
                       <value type="int" key="commentedOut">0</value>
                       <value type="string" key="createDate">2013-04-16 14:58</value>
                       <value _ptr_="0xb0b4218" type="dict" key="customData"/>
                       <value type="string" key="lastChangeDate">2013-07-31 01:39</value>
                       <value type="int" key="modelOnly">0</value>
                       <value type="string" key="name">subplot</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"></value>
                       <value type="string" key="oldName">subplot</value>
                     </value>
                     <value type="object" struct-name="db.mysql.Table" id="36134f4e-f9bd-11e2-af16-080027bcf912" struct-checksum="0x1a403946">
                       <value type="string" key="avgRowLength"></value>
                       <value type="int" key="checksum">0</value>
                       <value _ptr_="0xb0b5768" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">
                         <value type="object" struct-name="db.mysql.Column" id="36135336-f9bd-11e2-af16-080027bcf912" struct-checksum="0x783b5183">
                           <value type="int" key="autoIncrement">0</value>
                           <value type="string" key="characterSetName"></value>
                           <value _ptr_="0xb0b62b8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
                           <value type="string" key="collationName"></value>
                           <value type="string" key="datatypeExplicitParams"></value>
                           <value type="string" key="defaultValue"></value>
                           <value type="int" key="defaultValueIsNull">0</value>
                           <value _ptr_="0xb0b6618" type="list" content-type="string" key="flags"/>
                           <value type="int" key="isNotNull">1</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>
                           <value type="string" key="name">id</value>
                           <value type="string" key="oldName">id</value>
                           <link type="object" struct-name="GrtObject" key="owner">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Column" id="36135688-f9bd-11e2-af16-080027bcf912" struct-checksum="0x783b5183">
                           <value type="int" key="autoIncrement">0</value>
                           <value type="string" key="characterSetName"></value>
                           <value _ptr_="0xb0b6768" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
                           <value type="string" key="collationName"></value>
                           <value type="string" key="datatypeExplicitParams"></value>
                           <value type="string" key="defaultValue"></value>
                           <value type="int" key="defaultValueIsNull">0</value>
                           <value _ptr_="0xb0b6ac8" type="list" content-type="string" key="flags"/>
                           <value type="int" key="isNotNull">1</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>
                           <value type="string" key="name">parent_plot</value>
                           <value type="string" key="oldName">parent_plot</value>
                           <link type="object" struct-name="GrtObject" key="owner">36134f4e-f9bd-11e2-af16-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_="0xb0b6018" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
                         <value type="object" struct-name="db.mysql.ForeignKey" id="36135b4c-f9bd-11e2-af16-080027bcf912" struct-checksum="0x70a8fc40">
                         <value type="object" struct-name="db.mysql.ForeignKey" id="4e34b204-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x70a8fc40">
                           <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
                           <value _ptr_="0xb0b6c40" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">36135336-f9bd-11e2-af16-080027bcf912</link>
                           <value _ptr_="0xbddbd28" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">2673bdc2-f9bc-11e2-a599-080027bcf912</link>
                           </value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="deleteRule">CASCADE</value>
                           <value type="int" key="mandatory">0</value>
                           <value type="int" key="many">0</value>
                           <value type="int" key="modelOnly">0</value>
                           <link type="object" struct-name="db.Table" key="owner">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                           <value _ptr_="0xb0b6fa8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                           <link type="object" struct-name="db.Table" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                           <value _ptr_="0xc2156c0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                             <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>
                           </value>
                           <value type="int" key="referencedMandatory">1</value>
                           <value type="string" key="updateRule">CASCADE</value>
                           <value type="string" key="comment"></value>
                           <value type="string" key="name">fk_subplot_rel_place10</value>
                           <value type="string" key="oldName">fk_subplot_rel_place10</value>
                           <value type="string" key="name">fk_subplot_rel_place1</value>
                           <value type="string" key="oldName">fk_subplot_rel_place1</value>
                         </value>
                         <value type="object" struct-name="db.mysql.ForeignKey" id="36135d36-f9bd-11e2-af16-080027bcf912" struct-checksum="0x70a8fc40">
                           <link type="object" struct-name="db.mysql.Table" key="referencedTable">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
                           <value _ptr_="0xb0b7018" type="list" content-type="object" content-struct-name="db.Column" key="columns">
                             <link type="object">36135688-f9bd-11e2-af16-080027bcf912</link>
                           </value>
                           <value type="int" key="deferability">0</value>
                           <value type="string" key="deleteRule">CASCADE</value>
                           <link type="object" struct-name="db.Index" key="index">36136222-f9bd-11e2-af16-080027bcf912</link>
                           <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">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                           <value _ptr_="0xb0b73a0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
                             <link type="object">9f4bdd10-a6fb-11e2-9461-080027bcf912</link>
                           </value>
                           <value type="int" key="referencedMandatory">1</value>
                           <value type="string" key="updateRule">CASCADE</value>
                           <value type="string" key="comment"></value>
                           <value type="string" key="name">fk_subplot_plot20</value>
                           <value type="string" key="oldName">fk_subplot_plot20</value>
                         </value>
                       </value>
                       <value _ptr_="0xb0b6068" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
                         <value type="object" struct-name="db.mysql.Index" id="36135f20-f9bd-11e2-af16-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xb0b7430" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="36136056-f9bd-11e2-af16-080027bcf912" struct-checksum="0x62630b3c">
                       <value _ptr_="0xb0b4490" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
                         <value type="object" struct-name="db.mysql.Index" id="2673d532-f9bc-11e2-a599-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xb0b5388" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="2673d65e-f9bc-11e2-a599-080027bcf912" struct-checksum="0x62630b3c">
                               <value type="int" key="columnLength">0</value>
                               <value type="string" key="comment"></value>
                               <value type="int" key="descend">0</value>
                               <link type="object" struct-name="db.Column" key="referencedColumn">36135336-f9bd-11e2-af16-080027bcf912</link>
                               <link type="object" struct-name="db.Column" key="referencedColumn">2673bdc2-f9bc-11e2-a599-080027bcf912</link>
                               <value type="string" key="name"></value>
                               <link type="object" struct-name="GrtObject" key="owner">36135f20-f9bd-11e2-af16-080027bcf912</link>
                               <link type="object" struct-name="GrtObject" key="owner">2673d532-f9bc-11e2-a599-080027bcf912</link>
                             </value>
                           </value>
                           <value type="string" key="indexKind"></value>
-...
                           <value type="string" key="name">PRIMARY</value>
                           <value type="int" key="unique">0</value>
                           <value type="string" key="oldName">PRIMARY</value>
                           <link type="object" struct-name="GrtObject" key="owner">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                           <link type="object" struct-name="GrtObject" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                         </value>
                         <value type="object" struct-name="db.mysql.Index" id="36136222-f9bd-11e2-af16-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xb0b7810" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="36136330-f9bd-11e2-af16-080027bcf912" struct-checksum="0x62630b3c">
                         <value type="object" struct-name="db.mysql.Index" id="49a26722-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x309b847a">
                           <value _ptr_="0xbe108f0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
                             <value type="object" struct-name="db.mysql.IndexColumn" id="49a268bc-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x62630b3c">
                               <value type="int" key="columnLength">0</value>
                               <value type="string" key="comment"></value>
                               <value type="int" key="descend">0</value>
                               <link type="object" struct-name="db.Column" key="referencedColumn">36135688-f9bd-11e2-af16-080027bcf912</link>
                               <link type="object" struct-name="db.Column" key="referencedColumn">49a235d6-f9c5-11e2-9af4-080027bcf912</link>
                               <value type="string" key="name"></value>
                               <link type="object" struct-name="GrtObject" key="owner">36136222-f9bd-11e2-af16-080027bcf912</link>
                               <link type="object" struct-name="GrtObject" key="owner">49a26722-f9c5-11e2-9af4-080027bcf912</link>
                             </value>
                           </value>
                           <value type="string" key="indexKind"></value>
-...
                           <value type="string" key="name">fk_subplot_plot2_idx</value>
                           <value type="int" key="unique">0</value>
                           <value type="string" key="oldName">fk_subplot_plot2_idx</value>
                           <link type="object" struct-name="GrtObject" key="owner">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                           <link type="object" struct-name="GrtObject" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
                         </value>
                       </value>
                       <value type="string" key="maxRows"></value>
-...
                       <value type="string" key="nextAutoInc"></value>
                       <value type="string" key="packKeys"></value>
                       <value type="int" key="partitionCount">0</value>
                       <value _ptr_="0xb0b6118" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
                       <value _ptr_="0xb0b4540" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>
                       <value type="string" key="partitionExpression"></value>
                       <value type="string" key="partitionType"></value>
                       <value type="string" key="password"></value>
                       <link type="object" struct-name="db.mysql.Index" key="primaryKey">36135f20-f9bd-11e2-af16-080027bcf912</link>
                       <link type="object" struct-name="db.mysql.Index" key="primaryKey">2673d532-f9bc-11e2-a599-080027bcf912</link>
                       <value type="string" key="raidChunkSize"></value>
                       <value type="string" key="raidChunks"></value>
                       <value type="string" key="raidType"></value>
-...
                       <value type="string" key="tableDataDir"></value>
                       <value type="string" key="tableEngine">InnoDB</value>
                       <value type="string" key="tableIndexDir"></value>
                       <value _ptr_="0xb0b60b8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
                       <value _ptr_="0xb0b44e0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>
                       <value type="int" key="isStub">0</value>
                       <value type="int" key="isSystem">0</value>
                       <value type="int" key="isTemporary">0</value>
                       <value type="string" key="temporaryScope"></value>
                       <value type="int" key="commentedOut">0</value>
                       <value type="string" key="createDate">2013-04-16 14:58</value>
                       <value _ptr_="0xb0b5df0" type="dict" key="customData"/>
                       <value type="string" key="lastChangeDate">2013-07-31 01:43</value>
                       <value _ptr_="0xb0b4218" type="dict" key="customData"/>
                       <value type="string" key="lastChangeDate">2013-07-31 02:41</value>
                       <value type="int" key="modelOnly">0</value>
                       <value type="string" key="name">plot_element</value>
                       <value type="string" key="name">subplot</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"></value>
                       <value type="string" key="oldName">plot_element</value>
                       <value type="string" key="oldName">subplot</value>
                     </value>
                   </value>
                   <value _ptr_="0xb02b6d0" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>
-...
                     <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">686ec05a-f9bc-11e2-a599-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">4.61543287187117812209180556237697601318359375e+01</value>
                     <value type="real" key="middleSegmentOffset">7.69338819406340235218522138893604278564453125e+00</value>
                     <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="36142860-f9bd-11e2-af16-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_subplot_rel_place10</value>
                   <value type="object" struct-name="workbench.physical.Connection" id="978fde0c-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_individual_rel_place1</value>
                     <value type="real" key="captionXOffs">0.e+00</value>
                     <value type="real" key="captionYOffs">0.e+00</value>
                     <value type="string" key="comment"></value>
-...
                     <value type="string" key="extraCaption"></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">36135b4c-f9bd-11e2-af16-080027bcf912</link>
                     <link type="object" struct-name="db.ForeignKey" key="foreignKey">978ed0d4-f9c4-11e2-9af4-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">0.e+00</value>
                     <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>
                     <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">361378e8-f9bd-11e2-af16-080027bcf912</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
                     <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
                     <value type="int" key="visible">1</value>
                     <value type="string" key="name"></value>
                   </value>
                   <value type="object" struct-name="workbench.physical.Connection" id="36142ff4-f9bd-11e2-af16-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_subplot_plot20</value>
                   <value type="object" struct-name="workbench.physical.Connection" id="13886128-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_rel_place_place1</value>
                     <value type="real" key="captionXOffs">0.e+00</value>
                     <value type="real" key="captionYOffs">0.e+00</value>
                     <value type="string" key="comment"></value>
-...
                     <value type="string" key="extraCaption"></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">36135d36-f9bd-11e2-af16-080027bcf912</link>
                     <link type="object" struct-name="db.ForeignKey" key="foreignKey">1388436e-f9c5-11e2-9af4-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">0.e+00</value>
                     <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>
                     <link type="object" struct-name="model.Figure" key="endFigure">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">361378e8-f9bd-11e2-af16-080027bcf912</link>
                     <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
                     <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
                     <value type="int" key="visible">1</value>
                     <value type="string" key="name"></value>
                   </value>
                   <value type="object" struct-name="workbench.physical.Connection" id="a13a746e-f9bd-11e2-af16-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_subplot_plot_element1</value>
                   <value type="object" struct-name="workbench.physical.Connection" id="49a273de-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_subplot_plot2</value>
                     <value type="real" key="captionXOffs">0.e+00</value>
                     <value type="real" key="captionYOffs">0.e+00</value>
                     <value type="string" key="comment"></value>
-...
                     <value type="string" key="extraCaption"></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">a13a5e16-f9bd-11e2-af16-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">-2.845971321911520135472528636455535888671875e+00</value>
                     <link type="object" struct-name="db.ForeignKey" key="foreignKey">49a23428-f9c5-11e2-9af4-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">0.e+00</value>
                     <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>
                     <link type="object" struct-name="model.Figure" key="endFigure">361378e8-f9bd-11e2-af16-080027bcf912</link>
                     <link type="object" struct-name="model.Figure" key="endFigure">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
                     <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
                     <value type="int" key="visible">1</value>
                     <value type="string" key="name"></value>
                   </value>
                   <value type="object" struct-name="workbench.physical.Connection" id="978fde0c-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_individual_rel_place1</value>
                   <value type="object" struct-name="workbench.physical.Connection" id="4e34d068-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
                     <value type="string" key="caption">fk_subplot_rel_place1</value>
                     <value type="real" key="captionXOffs">0.e+00</value>
                     <value type="real" key="captionYOffs">0.e+00</value>
                     <value type="string" key="comment"></value>
-...
                     <value type="string" key="extraCaption"></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">978ed0d4-f9c4-11e2-9af4-080027bcf912</link>
                     <link type="object" struct-name="db.ForeignKey" key="foreignKey">4e34b204-f9c5-11e2-9af4-080027bcf912</link>
                     <value type="real" key="middleSegmentOffset">0.e+00</value>
                     <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>
                     <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
                     <link type="object" struct-name="model.Figure" key="startFigure">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
                     <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
                     <value type="int" key="visible">1</value>
                     <value type="string" key="name"></value>
-...
                     <value type="int" key="triggersExpanded">0</value>
                     <value type="string" key="color">#ffcc33</value>
                     <value type="int" key="expanded">1</value>
                     <value type="real" key="height">1.23e+02</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="real" key="left">6.94e+02</value>
                     <value type="int" key="locked">0</value>
-...
                     <value type="real" key="left">6.01e+02</value>
                     <value type="int" key="locked">0</value>
                     <value type="int" key="manualSizing">0</value>
                     <value type="real" key="top">1.87e+02</value>
                     <value type="real" key="top">2.02e+02</value>
                     <value type="real" key="width">1.25e+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="triggersExpanded">0</value>
                     <value type="string" key="color">#ffcc33</value>
                     <value type="int" key="expanded">1</value>
                     <value type="real" key="height">5.4e+01</value>
                     <value type="real" key="height">7.7e+01</value>
                     <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
                     <value type="real" key="left">6.62e+02</value>
                     <value type="real" key="left">6.75e+02</value>
                     <value type="int" key="locked">0</value>
                     <value type="int" key="manualSizing">0</value>
                     <value type="real" key="top">5.64e+02</value>
                     <value type="real" key="top">4.88e+02</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="string" key="name">subplot</value>
                   </value>
                   <value type="object" struct-name="workbench.physical.TableFigure" id="361378e8-f9bd-11e2-af16-080027bcf912" struct-checksum="0x3b14eccb">
                     <value type="int" key="columnsExpanded">1</value>
                     <value type="int" key="foreignKeysExpanded">0</value>
                     <value type="int" key="indicesExpanded">0</value>
                     <value type="int" key="summarizeDisplay">-1</value>
                     <link type="object" struct-name="db.Table" key="table">36134f4e-f9bd-11e2-af16-080027bcf912</link>
                     <value type="int" key="triggersExpanded">0</value>
                     <value type="string" key="color">#ffcc33</value>
                     <value type="int" key="expanded">1</value>
                     <value type="real" key="height">7.7e+01</value>
                     <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
                     <value type="real" key="left">6.62e+02</value>
                     <value type="int" key="locked">0</value>
                     <value type="int" key="manualSizing">0</value>
                     <value type="real" key="top">4.49e+02</value>
                     <value type="real" key="width">1.24e+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="string" key="name">plot_element</value>
                   </value>
                 </value>
                 <value type="real" key="height">1.2865e+03</value>
                 <value _ptr_="0xb0bcb58" type="list" content-type="object" content-struct-name="model.Layer" key="layers">
-...
                     <link type="object">c269d028-f998-11e2-a599-080027bcf912</link>
                     <link type="object">62239986-f99a-11e2-a599-080027bcf912</link>
                     <link type="object">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
                     <link type="object">361378e8-f9bd-11e2-af16-080027bcf912</link>
                   </value>
                   <value _ptr_="0xb0ff950" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>
                   <value type="real" key="height">1.2865e+03</value>
-...
             <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
             <value _ptr_="0xb02a548" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
             <value _ptr_="0xa7bf3d8" type="dict" key="syncProfiles">
               <value type="object" struct-name="db.mgmt.SyncProfile" id="049bb4aa-f9c3-11e2-9af4-080027bcf912" struct-checksum="0xc64972c2" key="">
                 <value _ptr_="0xbf09c98" type="dict" key="lastKnownDBNames">
               <value type="object" struct-name="db.mgmt.SyncProfile" id="83b653c4-f9c5-11e2-9af4-080027bcf912" struct-checksum="0xc64972c2" key="">
                 <value _ptr_="0xc002748" type="dict" key="lastKnownDBNames">
                   <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="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
                   <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
                   <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>
                   <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>
                   <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>
                   <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>
                   <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
                   <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
                   <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
-...
                   <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
                   <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
                   <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
                   <value type="string" key="36134f4e-f9bd-11e2-af16-080027bcf912">plot_element</value>
                   <value type="string" key="36135336-f9bd-11e2-af16-080027bcf912">id</value>
                   <value type="string" key="36135688-f9bd-11e2-af16-080027bcf912">parent_plot</value>
                   <value type="string" key="36135b4c-f9bd-11e2-af16-080027bcf912">fk_subplot_rel_place10</value>
                   <value type="string" key="36135d36-f9bd-11e2-af16-080027bcf912">fk_subplot_plot20</value>
                   <value type="string" key="36135f20-f9bd-11e2-af16-080027bcf912">PRIMARY</value>
                   <value type="string" key="36136222-f9bd-11e2-af16-080027bcf912">fk_subplot_plot2_idx</value>
                   <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
                   <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
                   <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
-...
                   <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
                   <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
                   <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
                   <value type="string" key="424a66d6-f985-11e2-8a2e-080027bcf912">plot_position</value>
                   <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
                   <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>
                   <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
-...
                   <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
                   <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
                   <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
                   <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>
                   <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent_plot</value>
                   <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>
                   <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
                   <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
                   <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
                   <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
                   <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>
                   <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
                   <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
                   <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
                   <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
-...
                   <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>
                   <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
                   <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
                   <value type="string" key="71774360-f9bd-11e2-af16-080027bcf912">fk_individual_plot_element1</value>
                   <value type="string" key="717754c2-f9bd-11e2-af16-080027bcf912">fk_individual_plot_element1_idx</value>
                   <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
                   <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
                   <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">footprint_geom_WKT</value>
-...
                   <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
                   <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
                   <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>
                   <value type="string" key="978ed0d4-f9c4-11e2-9af4-080027bcf912">fk_individual_rel_place1</value>
                   <value type="string" key="978ed2dc-f9c4-11e2-9af4-080027bcf912">place</value>
                   <value type="string" key="978f9618-f9c4-11e2-9af4-080027bcf912">fk_individual_rel_place1_idx</value>
                   <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
                   <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
                   <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
-...
                   <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
                   <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
                   <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>
                   <value type="string" key="a13a5e16-f9bd-11e2-af16-080027bcf912">fk_subplot_plot_element1</value>
                   <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>
                   <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
                   <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</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="dateChanged">2013-07-31 02:36</value>
           <value type="string" key="dateChanged">2013-07-31 02:42</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>

     /*!40000 ALTER TABLE `plot` ENABLE KEYS */;
     --
     -- Table structure for table `plot_element`
     --
     /*!40101 SET @saved_cs_client     = @@character_set_client */;
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE `plot_element` (
       `id` varbinary(767) NOT NULL,
       `parent_plot` varbinary(767) NOT NULL,
       PRIMARY KEY (`id`),
       KEY `fk_subplot_plot2_idx` (`parent_plot`),
       CONSTRAINT `fk_subplot_rel_place10` FOREIGN KEY (`id`) REFERENCES `rel_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
       CONSTRAINT `fk_subplot_plot20` FOREIGN KEY (`parent_plot`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     /*!40101 SET character_set_client = @saved_cs_client */;
     --
     -- Dumping data for table `plot_element`
     --
     /*!40000 ALTER TABLE `plot_element` DISABLE KEYS */;
     /*!40000 ALTER TABLE `plot_element` ENABLE KEYS */;
     --
     -- Table structure for table `project`
     --
-...
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE `rel_place` (
       `id` varbinary(767) NOT NULL,
       `parent` varbinary(767) NOT NULL,
       `x_m` double DEFAULT NULL,
       `y_m` double DEFAULT NULL,
       `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,
       PRIMARY KEY (`id`),
       KEY `fk_rel_place_place1_idx` (`parent`),
       CONSTRAINT `fk_rel_place_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
       CONSTRAINT `fk_subplot_place2` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))';
     /*!40101 SET character_set_client = @saved_cs_client */;
-...
     /*!40101 SET character_set_client = utf8 */;
     CREATE TABLE `subplot` (
       `id` varbinary(767) NOT NULL,
       `parent_plot` varbinary(767) NOT NULL,
       PRIMARY KEY (`id`),
       CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
       CONSTRAINT `fk_subplot_plot_element1` FOREIGN KEY (`id`) REFERENCES `plot_element` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
       KEY `fk_subplot_plot2_idx` (`parent_plot`),
       CONSTRAINT `fk_subplot_plot2` FOREIGN KEY (`parent_plot`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
       CONSTRAINT `fk_subplot_rel_place1` FOREIGN KEY (`id`) REFERENCES `rel_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
       CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
     /*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff

Project

General

Profile

Revision 10522

Added by Aaron Marcuse-Kubitza over 11 years ago