Project

General

Profile

« Previous | Next » 

Revision 8671

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: moved collection_event from taxon_occurrence to specimen because only specimens are actually collected, while other taxon_occurrences (e.g. individuals) must be uniquely identified by some means that are shared between re-observations (e.g. the stem tag)

View differences:

schemas/VegCore/document.mwb.xml
2774 2774 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2775 2775 
                      <value type="string" key="comment"></value>
2776 2776 
                      <value type="string" key="name">collector</value>
2777 
                      <value type="string" key="oldName">party_id</value>
2777 
                      <value type="string" key="oldName">collector</value>
2778 2778 
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
2779 2779 
                    </value>
2780 2780 
                    <value type="object" struct-name="db.mysql.Column" id="58b0d99a-ad00-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
......
2793 2793 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2794 2794 
                      <value type="string" key="comment"></value>
2795 2795 
                      <value type="string" key="name">collector_number</value>
2796 
                      <value type="string" key="oldName"></value>
2796 
                      <value type="string" key="oldName">collector_number</value>
2797 2797 
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
2798 2798 
                    </value>
2799 2799 
                    <value type="object" struct-name="db.mysql.Column" id="3730d234-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
......
3052 3052 
                      <value type="int" key="isPrimary">0</value>
3053 3053 
                      <value type="string" key="name">fk_taxon_observation_party1_idx</value>
3054 3054 
                      <value type="int" key="unique">0</value>
3055 
                      <value type="string" key="oldName">fk_taxon_observation_party1</value>
3055 
                      <value type="string" key="oldName">fk_taxon_observation_party1_idx</value>
3056 3056 
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
3057 3057 
                    </value>
3058 3058 
                  </value>
......
5720 5720 
                      <value type="string" key="oldName">id</value>
5721 5721 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5722 5722 
                    </value>
5723 
                    <value type="object" struct-name="db.mysql.Column" id="eb778aac-ad01-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5724 
                      <value type="int" key="autoIncrement">0</value>
5725 
                      <value type="string" key="characterSetName"></value>
5726 
                      <value _ptr_="0xae5b0d8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5727 
                      <value type="string" key="collationName"></value>
5728 
                      <value type="string" key="datatypeExplicitParams"></value>
5729 
                      <value type="string" key="defaultValue"></value>
5730 
                      <value type="int" key="defaultValueIsNull">0</value>
5731 
                      <value _ptr_="0xaf2ba58" type="list" content-type="string" key="flags"/>
5732 
                      <value type="int" key="isNotNull">0</value>
5733 
                      <value type="int" key="length">767</value>
5734 
                      <value type="int" key="precision">-1</value>
5735 
                      <value type="int" key="scale">-1</value>
5736 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5737 
                      <value type="string" key="comment"></value>
5738 
                      <value type="string" key="name">collection_event</value>
5739 
                      <value type="string" key="oldName">taxon_observation_id</value>
5740 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5741 
                    </value>
5723 5742 
                    <value type="object" struct-name="db.mysql.Column" id="c6730896-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5724 5743 
                      <value type="int" key="autoIncrement">0</value>
5725 5744 
                      <value type="string" key="characterSetName"></value>
......
5945 5964 
                      <value type="string" key="name">fk_specimen_organization3</value>
5946 5965 
                      <value type="string" key="oldName">fk_specimen_organization3</value>
5947 5966 
                    </value>
5967 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="eb778868-ad01-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
5968 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
5969 
                      <value _ptr_="0xb59e428" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5970 
                        <link type="object">eb778aac-ad01-11e2-b309-080027bcf912</link>
5971 
                      </value>
5972 
                      <value type="int" key="deferability">0</value>
5973 
                      <value type="string" key="deleteRule">CASCADE</value>
5974 
                      <link type="object" struct-name="db.Index" key="index">eb77b1da-ad01-11e2-b309-080027bcf912</link>
5975 
                      <value type="int" key="mandatory">1</value>
5976 
                      <value type="int" key="many">1</value>
5977 
                      <value type="int" key="modelOnly">0</value>
5978 
                      <link type="object" struct-name="db.Table" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5979 
                      <value _ptr_="0xa7d9d50" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5980 
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
5981 
                      </value>
5982 
                      <value type="int" key="referencedMandatory">0</value>
5983 
                      <value type="string" key="updateRule">CASCADE</value>
5984 
                      <value type="string" key="comment"></value>
5985 
                      <value type="string" key="name">fk_specimen_taxon_observation1</value>
5986 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1</value>
5987 
                    </value>
5948 5988 
                  </value>
5949 5989 
                  <value _ptr_="0xa7478a0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
5950 5990 
                    <value type="object" struct-name="db.mysql.Index" id="c6731048-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
6062 6102 
                      <value type="string" key="oldName">fk_specimen_organization3_idx</value>
6063 6103 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6064 6104 
                    </value>
6105 
                    <value type="object" struct-name="db.mysql.Index" id="eb77b1da-ad01-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
6106 
                      <value _ptr_="0xaeea798" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6107 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="eb77b446-ad01-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
6108 
                          <value type="int" key="columnLength">0</value>
6109 
                          <value type="string" key="comment"></value>
6110 
                          <value type="int" key="descend">0</value>
6111 
                          <link type="object" struct-name="db.Column" key="referencedColumn">eb778aac-ad01-11e2-b309-080027bcf912</link>
6112 
                          <value type="string" key="name"></value>
6113 
                          <link type="object" struct-name="GrtObject" key="owner">eb77b1da-ad01-11e2-b309-080027bcf912</link>
6114 
                        </value>
6115 
                      </value>
6116 
                      <value type="string" key="indexKind"></value>
6117 
                      <value type="int" key="keyBlockSize">0</value>
6118 
                      <value type="string" key="withParser"></value>
6119 
                      <value type="string" key="comment"></value>
6120 
                      <value type="int" key="deferability">0</value>
6121 
                      <value type="string" key="indexType">INDEX</value>
6122 
                      <value type="int" key="isPrimary">0</value>
6123 
                      <value type="string" key="name">fk_specimen_taxon_observation1_idx</value>
6124 
                      <value type="int" key="unique">0</value>
6125 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1</value>
6126 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6127 
                    </value>
6065 6128 
                  </value>
6066 6129 
                  <value type="string" key="maxRows"></value>
6067 6130 
                  <value type="string" key="mergeInsert"></value>
......
6093 6156 
                  <value type="int" key="commentedOut">0</value>
6094 6157 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6095 6158 
                  <value _ptr_="0xa747628" type="dict" key="customData"/>
6096 
                  <value type="string" key="lastChangeDate">2013-04-19 12:17</value>
6159 
                  <value type="string" key="lastChangeDate">2013-04-24 10:11</value>
6097 6160 
                  <value type="int" key="modelOnly">0</value>
6098 6161 
                  <value type="string" key="name">specimen</value>
6099 6162 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
6124 6187 
                      <value type="string" key="oldName">id</value>
6125 6188 
                      <link type="object" struct-name="GrtObject" key="owner">c672a8d8-a7a0-11e2-b667-080027bcf912</link>
6126 6189 
                    </value>
6127 
                    <value type="object" struct-name="db.mysql.Column" id="5a9269f2-a7a8-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
6128 
                      <value type="int" key="autoIncrement">0</value>
6129 
                      <value type="string" key="characterSetName"></value>
6130 
                      <value _ptr_="0xa74e470" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6131 
                      <value type="string" key="collationName"></value>
6132 
                      <value type="string" key="datatypeExplicitParams"></value>
6133 
                      <value type="string" key="defaultValue"></value>
6134 
                      <value type="int" key="defaultValueIsNull">1</value>
6135 
                      <value _ptr_="0xa74e7f0" type="list" content-type="string" key="flags"/>
6136 
                      <value type="int" key="isNotNull">0</value>
6137 
                      <value type="int" key="length">767</value>
6138 
                      <value type="int" key="precision">-1</value>
6139 
                      <value type="int" key="scale">-1</value>
6140 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6141 
                      <value type="string" key="comment"></value>
6142 
                      <value type="string" key="name">collection_event</value>
6143 
                      <value type="string" key="oldName">collection_event</value>
6144 
                      <link type="object" struct-name="GrtObject" key="owner">c672a8d8-a7a0-11e2-b667-080027bcf912</link>
6145 
                    </value>
6146 6190 
                    <value type="object" struct-name="db.mysql.Column" id="c672b24c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6147 6191 
                      <value type="int" key="autoIncrement">0</value>
6148 6192 
                      <value type="string" key="characterSetName"></value>
......
6250 6294 
                      <value type="string" key="name">fk_taxon_occurrence_event1</value>
6251 6295 
                      <value type="string" key="oldName">fk_taxon_occurrence_event1</value>
6252 6296 
                    </value>
6253 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="5a92683a-a7a8-11e2-8ba6-080027bcf912" struct-checksum="0x70a8fc40">
6254 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672743a-a7a0-11e2-b667-080027bcf912</link>
6255 
                      <value _ptr_="0xa750798" type="list" content-type="object" content-struct-name="db.Column" key="columns">
6256 
                        <link type="object">5a9269f2-a7a8-11e2-8ba6-080027bcf912</link>
6257 
                      </value>
6258 
                      <value type="int" key="deferability">0</value>
6259 
                      <value type="string" key="deleteRule">CASCADE</value>
6260 
                      <link type="object" struct-name="db.Index" key="index">5a9589a2-a7a8-11e2-8ba6-080027bcf912</link>
6261 
                      <value type="int" key="mandatory">1</value>
6262 
                      <value type="int" key="many">1</value>
6263 
                      <value type="int" key="modelOnly">0</value>
6264 
                      <link type="object" struct-name="db.Table" key="owner">c672a8d8-a7a0-11e2-b667-080027bcf912</link>
6265 
                      <value _ptr_="0xa750b20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6266 
                        <link type="object">c67276b0-a7a0-11e2-b667-080027bcf912</link>
6267 
                      </value>
6268 
                      <value type="int" key="referencedMandatory">0</value>
6269 
                      <value type="string" key="updateRule">CASCADE</value>
6270 
                      <value type="string" key="comment"></value>
6271 
                      <value type="string" key="name">fk_taxon_occurrence_event2</value>
6272 
                      <value type="string" key="oldName">fk_taxon_occurrence_event2</value>
6273 
                    </value>
6274 6297 
                  </value>
6275 6298 
                  <value _ptr_="0xa74d8c0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
6276 6299 
                    <value type="object" struct-name="db.mysql.Index" id="c672bda0-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
6342 6365 
                      <value type="string" key="oldName">fk_taxon_occurrence_taxon_determination2_idx</value>
6343 6366 
                      <link type="object" struct-name="GrtObject" key="owner">c672a8d8-a7a0-11e2-b667-080027bcf912</link>
6344 6367 
                    </value>
6345 
                    <value type="object" struct-name="db.mysql.Index" id="5a9589a2-a7a8-11e2-8ba6-080027bcf912" struct-checksum="0x309b847a">
6346 
                      <value _ptr_="0xa752430" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6347 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="5a9647de-a7a8-11e2-8ba6-080027bcf912" struct-checksum="0x62630b3c">
6348 
                          <value type="int" key="columnLength">0</value>
6349 
                          <value type="string" key="comment"></value>
6350 
                          <value type="int" key="descend">0</value>
6351 
                          <link type="object" struct-name="db.Column" key="referencedColumn">5a9269f2-a7a8-11e2-8ba6-080027bcf912</link>
6352 
                          <value type="string" key="name"></value>
6353 
                          <link type="object" struct-name="GrtObject" key="owner">5a9589a2-a7a8-11e2-8ba6-080027bcf912</link>
6354 
                        </value>
6355 
                      </value>
6356 
                      <value type="string" key="indexKind"></value>
6357 
                      <value type="int" key="keyBlockSize">0</value>
6358 
                      <value type="string" key="withParser"></value>
6359 
                      <value type="string" key="comment"></value>
6360 
                      <value type="int" key="deferability">0</value>
6361 
                      <value type="string" key="indexType">INDEX</value>
6362 
                      <value type="int" key="isPrimary">0</value>
6363 
                      <value type="string" key="name">fk_taxon_occurrence_event2_idx</value>
6364 
                      <value type="int" key="unique">0</value>
6365 
                      <value type="string" key="oldName">fk_taxon_occurrence_event2_idx</value>
6366 
                      <link type="object" struct-name="GrtObject" key="owner">c672a8d8-a7a0-11e2-b667-080027bcf912</link>
6367 
                    </value>
6368 6368 
                  </value>
6369 6369 
                  <value type="string" key="maxRows"></value>
6370 6370 
                  <value type="string" key="mergeInsert"></value>
......
10883 10883 
                <value type="int" key="visible">1</value>
10884 10884 
                <value type="string" key="name"></value>
10885 10885 
              </value>
10886 
              <value type="object" struct-name="workbench.physical.Connection" id="5a971984-a7a8-11e2-8ba6-080027bcf912" struct-checksum="0x9baebc92">
10887 
                <value type="string" key="caption">fk_taxon_occurrence_event2</value>
10888 
                <value type="real" key="captionXOffs">0.e+00</value>
10889 
                <value type="real" key="captionYOffs">0.e+00</value>
10890 
                <value type="string" key="comment"></value>
10891 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
10892 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
10893 
                <value type="string" key="extraCaption"></value>
10894 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
10895 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
10896 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">5a92683a-a7a8-11e2-8ba6-080027bcf912</link>
10897 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
10898 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
10899 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
10900 
                <value type="int" key="drawSplit">1</value>
10901 
                <link type="object" struct-name="model.Figure" key="endFigure">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
10902 
                <link type="object" struct-name="model.Figure" key="startFigure">1CE42D82-5AE5-4C01-A503-85E84F7B01D3</link>
10903 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
10904 
                <value type="int" key="visible">1</value>
10905 
                <value type="string" key="name"></value>
10906 
              </value>
10907 10886 
              <value type="object" struct-name="workbench.physical.Connection" id="1c0e74a4-a7a9-11e2-8ba6-080027bcf912" struct-checksum="0x9baebc92">
10908 10887 
                <value type="string" key="caption">fk_taxon_observation_taxon_occurrence2</value>
10909 10888 
                <value type="real" key="captionXOffs">0.e+00</value>
......
11356 11335 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11357 11336 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11358 11337 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>
11359 
                <value type="real" key="middleSegmentOffset">1.775e+02</value>
11338 
                <value type="real" key="middleSegmentOffset">1.56e+02</value>
11360 11339 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11361 11340 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11362 11341 
                <value type="int" key="drawSplit">0</value>
......
11450 11429 
                <value type="int" key="visible">1</value>
11451 11430 
                <value type="string" key="name"></value>
11452 11431 
              </value>
11432 
              <value type="object" struct-name="workbench.physical.Connection" id="eb77bcd4-ad01-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11433 
                <value type="string" key="caption">fk_specimen_taxon_observation1</value>
11434 
                <value type="real" key="captionXOffs">0.e+00</value>
11435 
                <value type="real" key="captionYOffs">0.e+00</value>
11436 
                <value type="string" key="comment"></value>
11437 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11438 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11439 
                <value type="string" key="extraCaption"></value>
11440 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11441 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11442 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">eb778868-ad01-11e2-b309-080027bcf912</link>
11443 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11444 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11445 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11446 
                <value type="int" key="drawSplit">1</value>
11447 
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
11448 
                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
11449 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11450 
                <value type="int" key="visible">1</value>
11451 
                <value type="string" key="name"></value>
11452 
              </value>
11453 11453 
            </value>
11454 11454 
            <value type="string" key="description"></value>
11455 11455 
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
11817 11817 
                <value type="int" key="triggersExpanded">0</value>
11818 11818 
                <value type="string" key="color">#FFFF00</value>
11819 11819 
                <value type="int" key="expanded">1</value>
11820 
                <value type="real" key="height">1.23e+02</value>
11820 
                <value type="real" key="height">1.e+02</value>
11821 11821 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11822 11822 
                <value type="real" key="left">1.404e+03</value>
11823 11823 
                <value type="int" key="locked">0</value>
11824 11824 
                <value type="int" key="manualSizing">0</value>
11825 
                <value type="real" key="top">5.8e+01</value>
11825 
                <value type="real" key="top">7.5e+01</value>
11826 11826 
                <value type="real" key="width">1.53e+02</value>
11827 11827 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11828 11828 
                <value type="int" key="visible">1</value>
......
11977 11977 
                <value type="int" key="triggersExpanded">0</value>
11978 11978 
                <value type="string" key="color">#CCCC33</value>
11979 11979 
                <value type="int" key="expanded">1</value>
11980 
                <value type="real" key="height">1.92e+02</value>
11980 
                <value type="real" key="height">2.15e+02</value>
11981 11981 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11982 11982 
                <value type="real" key="left">1.467e+03</value>
11983 11983 
                <value type="int" key="locked">0</value>
......
12002 12002 
                <value type="real" key="left">1.474e+03</value>
12003 12003 
                <value type="int" key="locked">0</value>
12004 12004 
                <value type="int" key="manualSizing">0</value>
12005 
                <value type="real" key="top">8.54e+02</value>
12005 
                <value type="real" key="top">8.78e+02</value>
12006 12006 
                <value type="real" key="width">1.06e+02</value>
12007 12007 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12008 12008 
                <value type="int" key="visible">1</value>
......
12465 12465 
                <value type="int" key="expanded">1</value>
12466 12466 
                <value type="real" key="height">2.15e+02</value>
12467 12467 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12468 
                <value type="real" key="left">9.07e+02</value>
12468 
                <value type="real" key="left">9.25e+02</value>
12469 12469 
                <value type="int" key="locked">0</value>
12470 12470 
                <value type="int" key="manualSizing">0</value>
12471 
                <value type="real" key="top">4.6e+01</value>
12471 
                <value type="real" key="top">7.3e+01</value>
12472 12472 
                <value type="real" key="width">1.56e+02</value>
12473 12473 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12474 12474 
                <value type="int" key="visible">1</value>
......
12485 12485 
                <value type="int" key="expanded">1</value>
12486 12486 
                <value type="real" key="height">7.7e+01</value>
12487 12487 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12488 
                <value type="real" key="left">1.031e+03</value>
12488 
                <value type="real" key="left">1.026e+03</value>
12489 12489 
                <value type="int" key="locked">0</value>
12490 12490 
                <value type="int" key="manualSizing">0</value>
12491 
                <value type="real" key="top">7.29e+02</value>
12491 
                <value type="real" key="top">6.36e+02</value>
12492 12492 
                <value type="real" key="width">1.8e+02</value>
12493 12493 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12494 12494 
                <value type="int" key="visible">1</value>
......
12545 12545 
                <value type="int" key="expanded">1</value>
12546 12546 
                <value type="real" key="height">1.e+02</value>
12547 12547 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12548 
                <value type="real" key="left">1.219e+03</value>
12548 
                <value type="real" key="left">1.221e+03</value>
12549 12549 
                <value type="int" key="locked">0</value>
12550 12550 
                <value type="int" key="manualSizing">0</value>
12551 
                <value type="real" key="top">6.29e+02</value>
12551 
                <value type="real" key="top">6.82e+02</value>
12552 12552 
                <value type="real" key="width">2.13e+02</value>
12553 12553 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12554 12554 
                <value type="int" key="visible">1</value>
......
12876 12876 
      <value type="int" key="MySQLDbModule:SkipFKIndexes">0</value>
12877 12877 
      <value type="int" key="MySQLDbModule:SkipForeignKeys">0</value>
12878 12878 
      <value type="int" key="MySQLDbModule:generate_create_index">0</value>
12879 
      <value type="int" key="MySQLDbModule:generate_drop">0</value>
12879 
      <value type="int" key="MySQLDbModule:generate_drop">1</value>
12880 12880 
      <value type="int" key="MySQLDbModule:generate_insert">0</value>
12881 12881 
      <value type="int" key="MySQLDbModule:generate_schema_drop">0</value>
12882 12882 
      <value type="int" key="MySQLDbModule:generate_show_warnings">0</value>
12883 
      <value type="int" key="MySQLDbModule:generate_use">0</value>
12883 
      <value type="int" key="MySQLDbModule:generate_use">1</value>
12884 12884 
      <value type="string" key="MySQLDbModule:input_filename">/media/sf_aaronmk/Dropbox/svn/schemas/VegCore/VegCore.my.sql</value>
12885 12885 
      <value type="int" key="MySQLDbModule:omit_schema_qualifier">1</value>
12886 12886 
      <value type="string" key="MySQLDbModule:output_filename">/media/sf_aaronmk/Dropbox/svn/schemas/VegCore/VegCore.my.sql</value>
......
12891 12891 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12892 12892 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12893 12893 
      <value type="string" key="caption">New Model</value>
12894 
      <value type="string" key="dateChanged">2013-04-24 10:00</value>
12894 
      <value type="string" key="dateChanged">2013-04-24 10:14</value>
12895 12895 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
12896 12896 
      <value type="string" key="description"></value>
12897 12897 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
413 413 

  		




  414
  414
  
    
CREATE  TABLE IF NOT EXISTS `specimen` (


  		




  415
  415
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  
  416
  
    
  `collection_event` VARBINARY(767) NULL ,


  		




  416
  417
  
    
  `collection` VARBINARY(767) NULL DEFAULT NULL ,


  		




  417
  418
  
    
  `stamping_institution` VARBINARY(767) NULL DEFAULT NULL ,


  		




  418
  419
  
    
  `donor_institution` VARBINARY(767) NULL DEFAULT NULL ,


  		




  ......




  424
  425
  
    
  INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) ,


  		




  425
  426
  
    
  INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) ,


  		




  426
  427
  
    
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,


  		




  
  428
  
    
  INDEX `fk_specimen_taxon_observation1_idx` (`collection_event` ASC) ,


  		




  427
  429
  
    
  CONSTRAINT `fk_specimen_taxon_occurrence1`


  		




  428
  430
  
    
    FOREIGN KEY (`id` )


  		




  429
  431
  
    
    REFERENCES `taxon_occurrence` (`id` )


  		




  ......




  448
  450
  
    
    FOREIGN KEY (`owner` )


  		




  449
  451
  
    
    REFERENCES `organization` (`id` )


  		




  450
  452
  
    
    ON DELETE CASCADE


  		




  
  453
  
    
    ON UPDATE CASCADE,


  		




  
  454
  
    
  CONSTRAINT `fk_specimen_taxon_observation1`


  		




  
  455
  
    
    FOREIGN KEY (`collection_event` )


  		




  
  456
  
    
    REFERENCES `taxon_observation` (`id` )


  		




  
  457
  
    
    ON DELETE CASCADE


  		




  451
  458
  
    
    ON UPDATE CASCADE)


  		




  452
  459
  
    
ENGINE = InnoDB


  		




  453
  460
  
    
DEFAULT CHARACTER SET = utf8


  		




  ......




  538
  545
  
    

  		




  539
  546
  
    
CREATE  TABLE IF NOT EXISTS `taxon_occurrence` (


  		




  540
  547
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  541
  
  
    
  `collection_event` VARBINARY(767) NULL DEFAULT NULL ,


  		




  542
  548
  
    
  `current_determination` VARBINARY(767) NULL DEFAULT NULL ,


  		




  543
  549
  
    
  `original_determination` VARBINARY(767) NULL DEFAULT NULL ,


  		




  544
  550
  
    
  PRIMARY KEY (`id`) ,


  		




  545
  551
  
    
  INDEX `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination` ASC) ,


  		




  546
  552
  
    
  INDEX `fk_taxon_occurrence_taxon_determination2_idx` (`current_determination` ASC) ,


  		




  547
  
  
    
  INDEX `fk_taxon_occurrence_event2_idx` (`collection_event` ASC) ,


  		




  548
  553
  
    
  CONSTRAINT `fk_taxon_occurrence_taxon_determination1`


  		




  549
  554
  
    
    FOREIGN KEY (`original_determination` )


  		




  550
  555
  
    
    REFERENCES `taxon_determination` (`id` )


  		




  ......




  559
  564
  
    
    FOREIGN KEY (`id` )


  		




  560
  565
  
    
    REFERENCES `record` (`id` )


  		




  561
  566
  
    
    ON DELETE CASCADE


  		




  562
  
  
    
    ON UPDATE CASCADE,


  		




  563
  
  
    
  CONSTRAINT `fk_taxon_occurrence_event2`


  		




  564
  
  
    
    FOREIGN KEY (`collection_event` )


  		




  565
  
  
    
    REFERENCES `event` (`id` )


  		




  566
  
  
    
    ON DELETE CASCADE


  		




  567
  567
  
    
    ON UPDATE CASCADE)


  		




  568
  568
  
    
ENGINE = InnoDB


  		




  569
  569
  
    
DEFAULT CHARACTER SET = utf8


  		












Also available in:  Unified diff