Project

General

Profile

« Previous | Next » 

Revision 11113

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: specimen.specimenholder_institutions: moved to individual_observation because the list of institutions which store a specimen from the plant actually relates to the plant, not a particular specimen (this list should be the same for all specimens taken from the plant)

View differences:

schemas/VegCore/ERD/document.mwb.xml
6482 6482 
                      <value type="string" key="oldName">defining_data</value>
6483 6483 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6484 6484 
                    </value>
6485 
                    <value type="object" struct-name="db.mysql.Column" id="54dd4d82-f67d-11e2-aebb-080027bcf912" struct-checksum="0x783b5183">
6486 
                      <value type="int" key="autoIncrement">0</value>
6487 
                      <value type="string" key="characterSetName"></value>
6488 
                      <value _ptr_="0xbb28808" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6489 
                      <value type="string" key="collationName"></value>
6490 
                      <value type="string" key="datatypeExplicitParams"></value>
6491 
                      <value type="string" key="defaultValue"></value>
6492 
                      <value type="int" key="defaultValueIsNull">1</value>
6493 
                      <value _ptr_="0xbb28b88" type="list" content-type="string" key="flags"/>
6494 
                      <value type="int" key="isNotNull">0</value>
6495 
                      <value type="int" key="length">767</value>
6496 
                      <value type="int" key="precision">-1</value>
6497 
                      <value type="int" key="scale">-1</value>
6498 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6499 
                      <value type="string" key="comment"></value>
6500 
                      <value type="string" key="name">specimenholder_institutions</value>
6501 
                      <value type="string" key="oldName">specimenholder_institutions</value>
6502 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6503 
                    </value>
6504 6485 
                    <value type="object" struct-name="db.mysql.Column" id="bb0eaf44-ad10-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
6505 6486 
                      <value type="int" key="autoIncrement">0</value>
6506 6487 
                      <value type="string" key="characterSetName"></value>
......
6608 6589 
                      <value type="string" key="name">fk_specimen_collection2</value>
6609 6590 
                      <value type="string" key="oldName">fk_specimen_collection2</value>
6610 6591 
                    </value>
6611 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="54dd4bd4-f67d-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
6612 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
6613 
                      <value _ptr_="0xbb2a268" type="list" content-type="object" content-struct-name="db.Column" key="columns">
6614 
                        <link type="object">54dd4d82-f67d-11e2-aebb-080027bcf912</link>
6615 
                      </value>
6616 
                      <value type="int" key="deferability">0</value>
6617 
                      <value type="string" key="deleteRule">CASCADE</value>
6618 
                      <link type="object" struct-name="db.Index" key="index">54dd6466-f67d-11e2-aebb-080027bcf912</link>
6619 
                      <value type="int" key="mandatory">1</value>
6620 
                      <value type="int" key="many">1</value>
6621 
                      <value type="int" key="modelOnly">0</value>
6622 
                      <link type="object" struct-name="db.Table" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6623 
                      <value _ptr_="0xbb2a5f0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6624 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
6625 
                      </value>
6626 
                      <value type="int" key="referencedMandatory">0</value>
6627 
                      <value type="string" key="updateRule">CASCADE</value>
6628 
                      <value type="string" key="comment"></value>
6629 
                      <value type="string" key="name">fk_specimen_party_list1</value>
6630 
                      <value type="string" key="oldName">fk_specimen_party_list1</value>
6631 
                    </value>
6632 6592 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ec6965f0-a925-11e2-acee-080027bcf912" struct-checksum="0x70a8fc40">
6633 6593 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8df962-a6e0-11e2-95e9-080027bcf912</link>
6634 6594 
                      <value _ptr_="0xbb2a660" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
6858 6818 
                      <value type="string" key="oldName">fk_specimen_organization3_idx</value>
6859 6819 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6860 6820 
                    </value>
6861 
                    <value type="object" struct-name="db.mysql.Index" id="54dd6466-f67d-11e2-aebb-080027bcf912" struct-checksum="0x309b847a">
6862 
                      <value _ptr_="0xbb301c8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6863 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="54dd65ec-f67d-11e2-aebb-080027bcf912" struct-checksum="0x62630b3c">
6864 
                          <value type="int" key="columnLength">0</value>
6865 
                          <value type="string" key="comment"></value>
6866 
                          <value type="int" key="descend">0</value>
6867 
                          <link type="object" struct-name="db.Column" key="referencedColumn">54dd4d82-f67d-11e2-aebb-080027bcf912</link>
6868 
                          <value type="string" key="name"></value>
6869 
                          <link type="object" struct-name="GrtObject" key="owner">54dd6466-f67d-11e2-aebb-080027bcf912</link>
6870 
                        </value>
6871 
                      </value>
6872 
                      <value type="string" key="indexKind"></value>
6873 
                      <value type="int" key="keyBlockSize">0</value>
6874 
                      <value type="string" key="withParser"></value>
6875 
                      <value type="string" key="comment"></value>
6876 
                      <value type="int" key="deferability">0</value>
6877 
                      <value type="string" key="indexType">INDEX</value>
6878 
                      <value type="int" key="isPrimary">0</value>
6879 
                      <value type="string" key="name">fk_specimen_party_list1_idx</value>
6880 
                      <value type="int" key="unique">0</value>
6881 
                      <value type="string" key="oldName">fk_specimen_party_list1_idx</value>
6882 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6883 
                    </value>
6884 6821 
                    <value type="object" struct-name="db.mysql.Index" id="7cd372b6-1168-11e3-8d7f-080027bcf912" struct-checksum="0x309b847a">
6885 6822 
                      <value _ptr_="0xbb308a8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6886 6823 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="7cd3745a-1168-11e3-8d7f-080027bcf912" struct-checksum="0x62630b3c">
......
7230 7167 
                      <value type="string" key="oldName">code</value>
7231 7168 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7232 7169 
                    </value>
7170 
                    <value type="object" struct-name="db.mysql.Column" id="bb863556-2992-11e3-a80d-080027bcf912" struct-checksum="0x783b5183">
7171 
                      <value type="int" key="autoIncrement">0</value>
7172 
                      <value type="string" key="characterSetName"></value>
7173 
                      <value _ptr_="0xd1f4a50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
7174 
                      <value type="string" key="collationName"></value>
7175 
                      <value type="string" key="datatypeExplicitParams"></value>
7176 
                      <value type="string" key="defaultValue"></value>
7177 
                      <value type="int" key="defaultValueIsNull">1</value>
7178 
                      <value _ptr_="0xca9edd8" type="list" content-type="string" key="flags"/>
7179 
                      <value type="int" key="isNotNull">0</value>
7180 
                      <value type="int" key="length">767</value>
7181 
                      <value type="int" key="precision">-1</value>
7182 
                      <value type="int" key="scale">-1</value>
7183 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
7184 
                      <value type="string" key="comment">institutions which store specimens from this plant</value>
7185 
                      <value type="string" key="name">specimenholder_institutions</value>
7186 
                      <value type="string" key="oldName">specimenholder_institutions</value>
7187 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7188 
                    </value>
7233 7189 
                  </value>
7234 7190 
                  <value type="string" key="connectionString"></value>
7235 7191 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
7236 7192 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
7237 7193 
                  <value type="int" key="delayKeyWrite">0</value>
7238 7194 
                  <value _ptr_="0xbb349d8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
7195 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="bb86336c-2992-11e3-a80d-080027bcf912" struct-checksum="0x70a8fc40">
7196 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
7197 
                      <value _ptr_="0xd16a380" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7198 
                        <link type="object">bb863556-2992-11e3-a80d-080027bcf912</link>
7199 
                      </value>
7200 
                      <value type="int" key="deferability">0</value>
7201 
                      <value type="string" key="deleteRule">CASCADE</value>
7202 
                      <link type="object" struct-name="db.Index" key="index">bb865680-2992-11e3-a80d-080027bcf912</link>
7203 
                      <value type="int" key="mandatory">1</value>
7204 
                      <value type="int" key="many">1</value>
7205 
                      <value type="int" key="modelOnly">0</value>
7206 
                      <link type="object" struct-name="db.Table" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7207 
                      <value _ptr_="0xd228620" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7208 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
7209 
                      </value>
7210 
                      <value type="int" key="referencedMandatory">0</value>
7211 
                      <value type="string" key="updateRule">CASCADE</value>
7212 
                      <value type="string" key="comment"></value>
7213 
                      <value type="string" key="name">individual_observation_id_fkey1</value>
7214 
                      <value type="string" key="oldName">individual_observation_id_fkey1</value>
7215 
                    </value>
7239 7216 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0ab99812-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
7240 7217 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
7241 7218 
                      <value _ptr_="0xbb35fa0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
7370 7347 
                      <value type="string" key="oldName">fk_individual_observation_place1_idx</value>
7371 7348 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7372 7349 
                    </value>
7350 
                    <value type="object" struct-name="db.mysql.Index" id="bb865680-2992-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">
7351 
                      <value _ptr_="0xd0848b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
7352 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="bb86582e-2992-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
7353 
                          <value type="int" key="columnLength">0</value>
7354 
                          <value type="string" key="comment"></value>
7355 
                          <value type="int" key="descend">0</value>
7356 
                          <link type="object" struct-name="db.Column" key="referencedColumn">bb863556-2992-11e3-a80d-080027bcf912</link>
7357 
                          <value type="string" key="name"></value>
7358 
                          <link type="object" struct-name="GrtObject" key="owner">bb865680-2992-11e3-a80d-080027bcf912</link>
7359 
                        </value>
7360 
                      </value>
7361 
                      <value type="string" key="indexKind"></value>
7362 
                      <value type="int" key="keyBlockSize">0</value>
7363 
                      <value type="string" key="withParser"></value>
7364 
                      <value type="string" key="comment"></value>
7365 
                      <value type="int" key="deferability">0</value>
7366 
                      <value type="string" key="indexType">INDEX</value>
7367 
                      <value type="int" key="isPrimary">0</value>
7368 
                      <value type="string" key="name">individual_observation_id_fkey1_idx</value>
7369 
                      <value type="int" key="unique">0</value>
7370 
                      <value type="string" key="oldName">individual_observation_id_fkey1_idx</value>
7371 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7372 
                    </value>
7373 7373 
                  </value>
7374 7374 
                  <value type="string" key="maxRows"></value>
7375 7375 
                  <value type="string" key="mergeInsert"></value>
......
7401 7401 
                  <value type="int" key="commentedOut">0</value>
7402 7402 
                  <value type="string" key="createDate">2013-04-17 13:54</value>
7403 7403 
                  <value _ptr_="0xbb347b0" type="dict" key="customData"/>
7404 
                  <value type="string" key="lastChangeDate">2013-08-30 05:09</value>
7404 
                  <value type="string" key="lastChangeDate">2013-09-29 22:43</value>
7405 7405 
                  <value type="int" key="modelOnly">0</value>
7406 7406 
                  <value type="string" key="name">individual_observation</value>
7407 7407 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
14322 14322 
                <value type="int" key="visible">1</value>
14323 14323 
                <value type="string" key="name"></value>
14324 14324 
              </value>
14325 
              <value type="object" struct-name="workbench.physical.Connection" id="54dd6dee-f67d-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92">
14326 
                <value type="string" key="caption">fk_specimen_party_list1</value>
14327 
                <value type="real" key="captionXOffs">0.e+00</value>
14328 
                <value type="real" key="captionYOffs">0.e+00</value>
14329 
                <value type="string" key="comment"></value>
14330 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
14331 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
14332 
                <value type="string" key="extraCaption"></value>
14333 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14334 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14335 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">54dd4bd4-f67d-11e2-aebb-080027bcf912</link>
14336 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
14337 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14338 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14339 
                <value type="int" key="drawSplit">1</value>
14340 
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
14341 
                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
14342 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14343 
                <value type="int" key="visible">1</value>
14344 
                <value type="string" key="name"></value>
14345 
              </value>
14346 14325 
              <value type="object" struct-name="workbench.physical.Connection" id="21b637c2-f680-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92">
14347 14326 
                <value type="string" key="caption">fk_taxon_observation_party_list1</value>
14348 14327 
                <value type="real" key="captionXOffs">0.e+00</value>
......
15299 15278 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15300 15279 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15301 15280 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1427502e-1bf0-11e3-849d-080027bcf912</link>
15302 
                <value type="real" key="middleSegmentOffset">2.8592712552464132613749825395643711090087890625e+02</value>
15281 
                <value type="real" key="middleSegmentOffset">2.7108168899396304141191649250686168670654296875e+02</value>
15303 15282 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15304 15283 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15305 15284 
                <value type="int" key="drawSplit">0</value>
......
15876 15855 
                <value type="int" key="visible">1</value>
15877 15856 
                <value type="string" key="name"></value>
15878 15857 
              </value>
15858 
              <value type="object" struct-name="workbench.physical.Connection" id="bb865ec8-2992-11e3-a80d-080027bcf912" struct-checksum="0x9baebc92">
15859 
                <value type="string" key="caption">individual_observation_id_fkey1</value>
15860 
                <value type="real" key="captionXOffs">0.e+00</value>
15861 
                <value type="real" key="captionYOffs">0.e+00</value>
15862 
                <value type="string" key="comment"></value>
15863 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15864 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15865 
                <value type="string" key="extraCaption"></value>
15866 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15867 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15868 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">bb86336c-2992-11e3-a80d-080027bcf912</link>
15869 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15870 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15871 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15872 
                <value type="int" key="drawSplit">1</value>
15873 
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
15874 
                <link type="object" struct-name="model.Figure" key="startFigure">D1965EDA-481F-496B-9C24-79553E7891E8</link>
15875 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15876 
                <value type="int" key="visible">1</value>
15877 
                <value type="string" key="name"></value>
15878 
              </value>
15879 15879 
            </value>
15880 15880 
            <value type="string" key="description"></value>
15881 15881 
            <value _ptr_="0xbb8bc40" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
16245 16245 
                <value type="int" key="expanded">1</value>
16246 16246 
                <value type="real" key="height">7.7e+01</value>
16247 16247 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16248 
                <value type="real" key="left">1.488e+03</value>
16248 
                <value type="real" key="left">1.491e+03</value>
16249 16249 
                <value type="int" key="locked">0</value>
16250 16250 
                <value type="int" key="manualSizing">0</value>
16251 16251 
                <value type="real" key="top">1.7e+01</value>
......
16325 16325 
                <value type="int" key="expanded">1</value>
16326 16326 
                <value type="real" key="height">1.23e+02</value>
16327 16327 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16328 
                <value type="real" key="left">1.301e+03</value>
16328 
                <value type="real" key="left">1.292e+03</value>
16329 16329 
                <value type="int" key="locked">0</value>
16330 16330 
                <value type="int" key="manualSizing">0</value>
16331 
                <value type="real" key="top">6.5e+01</value>
16331 
                <value type="real" key="top">7.6e+01</value>
16332 16332 
                <value type="real" key="width">1.06e+02</value>
16333 16333 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16334 16334 
                <value type="int" key="visible">1</value>
......
16343 16343 
                <value type="int" key="triggersExpanded">0</value>
16344 16344 
                <value type="string" key="color">#CCFFCC</value>
16345 16345 
                <value type="int" key="expanded">1</value>
16346 
                <value type="real" key="height">1.23e+02</value>
16346 
                <value type="real" key="height">1.46e+02</value>
16347 16347 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16348 16348 
                <value type="real" key="left">1.068e+03</value>
16349 16349 
                <value type="int" key="locked">0</value>
......
16403 16403 
                <value type="int" key="triggersExpanded">0</value>
16404 16404 
                <value type="string" key="color">#CCCC33</value>
16405 16405 
                <value type="int" key="expanded">1</value>
16406 
                <value type="real" key="height">2.61e+02</value>
16406 
                <value type="real" key="height">2.38e+02</value>
16407 16407 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16408 
                <value type="real" key="left">1.42e+03</value>
16408 
                <value type="real" key="left">1.418e+03</value>
16409 16409 
                <value type="int" key="locked">0</value>
16410 16410 
                <value type="int" key="manualSizing">0</value>
16411 
                <value type="real" key="top">4.23e+02</value>
16412 
                <value type="real" key="width">1.57e+02</value>
16411 
                <value type="real" key="top">3.95e+02</value>
16412 
                <value type="real" key="width">1.3e+02</value>
16413 16413 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16414 16414 
                <value type="int" key="visible">1</value>
16415 16415 
                <value type="string" key="name">specimen</value>
......
16425 16425 
                <value type="int" key="expanded">1</value>
16426 16426 
                <value type="real" key="height">1.e+02</value>
16427 16427 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16428 
                <value type="real" key="left">1.43e+03</value>
16428 
                <value type="real" key="left">1.412e+03</value>
16429 16429 
                <value type="int" key="locked">0</value>
16430 16430 
                <value type="int" key="manualSizing">0</value>
16431 
                <value type="real" key="top">2.83e+02</value>
16431 
                <value type="real" key="top">2.55e+02</value>
16432 16432 
                <value type="real" key="width">1.06e+02</value>
16433 16433 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16434 16434 
                <value type="int" key="visible">1</value>
......
16891 16891 
                <value type="int" key="expanded">1</value>
16892 16892 
                <value type="real" key="height">1.e+02</value>
16893 16893 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16894 
                <value type="real" key="left">1.218e+03</value>
16894 
                <value type="real" key="left">1.216e+03</value>
16895 16895 
                <value type="int" key="locked">0</value>
16896 16896 
                <value type="int" key="manualSizing">0</value>
16897 16897 
                <value type="real" key="top">5.04e+02</value>
......
17652 17652 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17653 17653 
        <value _ptr_="0xbadb488" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17654 17654 
        <value _ptr_="0xb078db0" type="dict" key="syncProfiles">
17655 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="c1db31b8-298d-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17656 
            <value _ptr_="0xd0d12a8" type="dict" key="lastKnownDBNames">
17655 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ade7aad2-2993-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17656 
            <value _ptr_="0xdbe0e20" type="dict" key="lastKnownDBNames">
17657 17657 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17658 17658 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17659 17659 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17838 17838 
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
17839 17839 
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
17840 17840 
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
17841 
              <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>
17842 17841 
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
17843 17842 
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
17844 17843 
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
17845 17844 
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
17846 17845 
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>
17847 17846 
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
17848 
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
17849 
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
17850 
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
17851 17847 
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
17852 17848 
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
17853 17849 
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
......
18011 18007 
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
18012 18008 
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>
18013 18009 
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>
18010 
              <value type="string" key="bb86336c-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1</value>
18011 
              <value type="string" key="bb863556-2992-11e3-a80d-080027bcf912">specimenholder_institutions</value>
18012 
              <value type="string" key="bb865680-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1_idx</value>
18014 18013 
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">code_in_individual</value>
18015 18014 
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
18016 18015 
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">dataset</value>
......
18175 18174 
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18176 18175 
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18177 18176 
              <value type="string" key="e96e2084-23eb-11e3-ab7c-080027bcf912">name</value>
18178 
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
18179 
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
18180 
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>
18181 18177 
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
18182 18178 
              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>
18183 18179 
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
......
18286 18282 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18287 18283 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18288 18284 
      <value type="string" key="caption">New Model</value>
18289 
      <value type="string" key="dateChanged">2013-09-29 22:16</value>
18285 
      <value type="string" key="dateChanged">2013-09-29 22:46</value>
18290 18286 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18291 18287 
      <value type="string" key="description"></value>
18292 18288 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
425 425 
  `place_observed_at` varbinary(767) DEFAULT NULL,
426 426 
  `individual` varbinary(767) DEFAULT NULL COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant',
427 427 
  `code` varbinary(767) DEFAULT NULL,
428 
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant',
428 429 
  PRIMARY KEY (`id`),
429 430 
  KEY `fk_individual_observation_individual1_idx` (`individual`),
430 431 
  KEY `fk_individual_observation_place1_idx` (`place_observed_at`),
432 
  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),
433 
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
431 434 
  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
432 435 
  CONSTRAINT `fk_individual_observation_place1` FOREIGN KEY (`place_observed_at`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
433 436 
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
......
901 904 
  `barcode` varbinary(767) DEFAULT NULL,
902 905 
  `accession_number` varbinary(767) DEFAULT NULL,
903 906 
  `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.',
904 
  `specimenholder_institutions` varbinary(767) DEFAULT NULL,
905 907 
  `current_collection` varbinary(767) DEFAULT NULL,
906 908 
  `owner_collection` varbinary(767) DEFAULT NULL,
907 909 
  PRIMARY KEY (`id`),
......
912 914 
  KEY `fk_specimen_collection1_idx` (`orig_collection`),
913 915 
  KEY `fk_specimen_collection2_idx` (`current_collection`),
914 916 
  KEY `fk_specimen_organization3_idx` (`owner_collection`),
915 
  KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`),
916 917 
  KEY `fk_specimen_individual_observation1_idx` (`individual_observation`),
917 918 
  CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
919 
  CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
918 920 
  CONSTRAINT `fk_specimen_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
919 
  CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
920 
  CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
921 921 
  CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
922 922 
  CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
923 923 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.';
schemas/VegCore/VegCore.pg.sql
427 427 
  "place_observed_at" text DEFAULT NULL,
428 428 
  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
429 429 
  "code" text DEFAULT NULL,
430 
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant'*/,
430 431 
  PRIMARY KEY ("id"),
431 432 
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
432 433 
  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),
434 
  /*KEY "individual_observation_id_fkey1_idx" ("specimenholder_institutions")*/CHECK (true),
435 
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
433 436 
  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
434 437 
  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
435 438 
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
......
903 906 
  "barcode" text DEFAULT NULL,
904 907 
  "accession_number" text DEFAULT NULL,
905 908 
  "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.'*/,
906 
  "specimenholder_institutions" text DEFAULT NULL,
907 909 
  "current_collection" text DEFAULT NULL,
908 910 
  "owner_collection" text DEFAULT NULL,
909 911 
  PRIMARY KEY ("id"),
......
914 916 
  /*KEY "fk_specimen_collection1_idx" ("orig_collection")*/CHECK (true),
915 917 
  /*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),
916 918 
  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),
917 
  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),
918 919 
  /*KEY "fk_specimen_individual_observation1_idx" ("individual_observation")*/CHECK (true),
919 920 
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
921 
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
920 922 
  /*CONSTRAINT "fk_specimen_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
921 
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
922 
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
923 923 
  /*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
924 924 
  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
925 925 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.'*/;

Also available in: Unified diff