Project

General

Profile

« Previous | Next » 

Revision 10473

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon_determination: changed IS-A relationship with taxon_observation to HAS-A so that a separate taxon_observation doesn't need to be created for each taxon_determination (even though each taxon_determination event is theoretically a reobservation of the specimen, etc.). instead, inherit from sampling_event to include the necessary event-related fields.

View differences:

schemas/VegCore/document.mwb.xml
2958 2958 
                      <value type="int" key="isPrimary">0</value>
2959 2959 
                      <value type="string" key="name">geocoords_unique</value>
2960 2960 
                      <value type="int" key="unique">0</value>
2961 
                      <value type="string" key="oldName"></value>
2961 
                      <value type="string" key="oldName">geocoords_unique</value>
2962 2962 
                      <link type="object" struct-name="GrtObject" key="owner">be8d4a58-a6e0-11e2-95e9-080027bcf912</link>
2963 2963 
                    </value>
2964 2964 
                  </value>
......
4311 4311 
                      <value type="string" key="oldName">id</value>
4312 4312 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4313 4313 
                    </value>
4314 
                    <value type="object" struct-name="db.mysql.Column" id="3d9b17ba-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4314 
                    <value type="object" struct-name="db.mysql.Column" id="4a62f964-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
4315 4315 
                      <value type="int" key="autoIncrement">0</value>
4316 4316 
                      <value type="string" key="characterSetName"></value>
4317 
                      <value _ptr_="0xb2699e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4317 
                      <value _ptr_="0xc96c438" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4318 4318 
                      <value type="string" key="collationName"></value>
4319 4319 
                      <value type="string" key="datatypeExplicitParams"></value>
4320 4320 
                      <value type="string" key="defaultValue"></value>
4321 4321 
                      <value type="int" key="defaultValueIsNull">0</value>
4322 
                      <value _ptr_="0xb269d48" type="list" content-type="string" key="flags"/>
4322 
                      <value _ptr_="0xbe967a8" type="list" content-type="string" key="flags"/>
4323 4323 
                      <value type="int" key="isNotNull">1</value>
4324 4324 
                      <value type="int" key="length">767</value>
4325 4325 
                      <value type="int" key="precision">-1</value>
4326 4326 
                      <value type="int" key="scale">-1</value>
4327 4327 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4328 4328 
                      <value type="string" key="comment"></value>
4329 
                      <value type="string" key="name">taxon_assertion</value>
4330 
                      <value type="string" key="oldName">taxon_assertion</value>
4329 
                      <value type="string" key="name">taxon_observation</value>
4330 
                      <value type="string" key="oldName">taxon_observation_id</value>
4331 4331 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4332 4332 
                    </value>
4333 4333 
                    <value type="object" struct-name="db.mysql.Column" id="3d9b197c-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
......
4349 4349 
                      <value type="string" key="oldName">identified_by</value>
4350 4350 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4351 4351 
                    </value>
4352 
                    <value type="object" struct-name="db.mysql.Column" id="3d9b17ba-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4353 
                      <value type="int" key="autoIncrement">0</value>
4354 
                      <value type="string" key="characterSetName"></value>
4355 
                      <value _ptr_="0xb2699e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4356 
                      <value type="string" key="collationName"></value>
4357 
                      <value type="string" key="datatypeExplicitParams"></value>
4358 
                      <value type="string" key="defaultValue"></value>
4359 
                      <value type="int" key="defaultValueIsNull">0</value>
4360 
                      <value _ptr_="0xb269d48" type="list" content-type="string" key="flags"/>
4361 
                      <value type="int" key="isNotNull">1</value>
4362 
                      <value type="int" key="length">767</value>
4363 
                      <value type="int" key="precision">-1</value>
4364 
                      <value type="int" key="scale">-1</value>
4365 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4366 
                      <value type="string" key="comment"></value>
4367 
                      <value type="string" key="name">taxon_assertion</value>
4368 
                      <value type="string" key="oldName">taxon_assertion</value>
4369 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4370 
                    </value>
4352 4371 
                    <value type="object" struct-name="db.mysql.Column" id="3d9b1d28-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4353 4372 
                      <value type="int" key="autoIncrement">0</value>
4354 4373 
                      <value type="string" key="characterSetName"></value>
......
4395 4414 
                      <value type="string" key="name">fk_taxon_occurrence_has_qualified_taxon1</value>
4396 4415 
                      <value type="string" key="oldName">fk_taxon_occurrence_has_qualified_taxon1</value>
4397 4416 
                    </value>
4398 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="3d9b3790-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
4399 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
4400 
                      <value _ptr_="0xb26ac38" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4401 
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
4417 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="2ed4b280-f680-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
4418 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
4419 
                      <value _ptr_="0xb26b030" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4420 
                        <link type="object">3d9b197c-a7a1-11e2-b667-080027bcf912</link>
4402 4421 
                      </value>
4403 4422 
                      <value type="int" key="deferability">0</value>
4404 4423 
                      <value type="string" key="deleteRule">CASCADE</value>
4405 
                      <link type="object" struct-name="db.Index" key="index">3d9b26c4-a7a1-11e2-b667-080027bcf912</link>
4406 
                      <value type="int" key="mandatory">0</value>
4407 
                      <value type="int" key="many">0</value>
4424 
                      <link type="object" struct-name="db.Index" key="index">2ed4c4d2-f680-11e2-aebb-080027bcf912</link>
4425 
                      <value type="int" key="mandatory">1</value>
4426 
                      <value type="int" key="many">1</value>
4408 4427 
                      <value type="int" key="modelOnly">0</value>
4409 4428 
                      <link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4410 
                      <value _ptr_="0xb26afc0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4411 
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
4429 
                      <value _ptr_="0xb26b3b8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4430 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
4412 4431 
                      </value>
4413 4432 
                      <value type="int" key="referencedMandatory">1</value>
4414 4433 
                      <value type="string" key="updateRule">CASCADE</value>
4415 4434 
                      <value type="string" key="comment"></value>
4416 
                      <value type="string" key="name">fk_taxon_determination_record1</value>
4417 
                      <value type="string" key="oldName">fk_taxon_determination_record1</value>
4435 
                      <value type="string" key="name">fk_taxon_determination_party_list1</value>
4436 
                      <value type="string" key="oldName">fk_taxon_determination_party_list1</value>
4418 4437 
                    </value>
4419 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="2ed4b280-f680-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
4420 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
4421 
                      <value _ptr_="0xb26b030" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4422 
                        <link type="object">3d9b197c-a7a1-11e2-b667-080027bcf912</link>
4438 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="4a62f766-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
4439 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
4440 
                      <value _ptr_="0xc324108" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4441 
                        <link type="object">4a62f964-f6dd-11e2-b6d1-080027bcf912</link>
4423 4442 
                      </value>
4424 4443 
                      <value type="int" key="deferability">0</value>
4425 4444 
                      <value type="string" key="deleteRule">CASCADE</value>
4426 
                      <link type="object" struct-name="db.Index" key="index">2ed4c4d2-f680-11e2-aebb-080027bcf912</link>
4445 
                      <link type="object" struct-name="db.Index" key="index">4a630f80-f6dd-11e2-b6d1-080027bcf912</link>
4427 4446 
                      <value type="int" key="mandatory">1</value>
4428 4447 
                      <value type="int" key="many">1</value>
4429 4448 
                      <value type="int" key="modelOnly">0</value>
4430 4449 
                      <link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4431 
                      <value _ptr_="0xb26b3b8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4432 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
4450 
                      <value _ptr_="0xbe90ca0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4451 
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
4433 4452 
                      </value>
4434 4453 
                      <value type="int" key="referencedMandatory">1</value>
4435 4454 
                      <value type="string" key="updateRule">CASCADE</value>
4436 4455 
                      <value type="string" key="comment"></value>
4437 
                      <value type="string" key="name">fk_taxon_determination_party_list1</value>
4438 
                      <value type="string" key="oldName">fk_taxon_determination_party_list1</value>
4456 
                      <value type="string" key="name">fk_taxon_determination_taxon_observation1</value>
4457 
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1</value>
4439 4458 
                    </value>
4459 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="55756896-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
4460 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
4461 
                      <value _ptr_="0xc190cf0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4462 
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
4463 
                      </value>
4464 
                      <value type="int" key="deferability">0</value>
4465 
                      <value type="string" key="deleteRule">CASCADE</value>
4466 
                      <value type="int" key="mandatory">0</value>
4467 
                      <value type="int" key="many">0</value>
4468 
                      <value type="int" key="modelOnly">0</value>
4469 
                      <link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4470 
                      <value _ptr_="0xc05ca00" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4471 
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
4472 
                      </value>
4473 
                      <value type="int" key="referencedMandatory">1</value>
4474 
                      <value type="string" key="updateRule">CASCADE</value>
4475 
                      <value type="string" key="comment"></value>
4476 
                      <value type="string" key="name">fk_taxon_determination_sampling_event1</value>
4477 
                      <value type="string" key="oldName">fk_taxon_determination_sampling_event1</value>
4478 
                    </value>
4440 4479 
                  </value>
4441 4480 
                  <value _ptr_="0xb2692e8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
4442 4481 
                    <value type="object" struct-name="db.mysql.Index" id="3d9b1f30-a7a1-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
4539 4578 
                      <value type="string" key="oldName">fk_taxon_determination_party_list1_idx</value>
4540 4579 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4541 4580 
                    </value>
4581 
                    <value type="object" struct-name="db.mysql.Index" id="4a630f80-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
4582 
                      <value _ptr_="0xb32b588" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4583 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="4a631124-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
4584 
                          <value type="int" key="columnLength">0</value>
4585 
                          <value type="string" key="comment"></value>
4586 
                          <value type="int" key="descend">0</value>
4587 
                          <link type="object" struct-name="db.Column" key="referencedColumn">4a62f964-f6dd-11e2-b6d1-080027bcf912</link>
4588 
                          <value type="string" key="name"></value>
4589 
                          <link type="object" struct-name="GrtObject" key="owner">4a630f80-f6dd-11e2-b6d1-080027bcf912</link>
4590 
                        </value>
4591 
                      </value>
4592 
                      <value type="string" key="indexKind"></value>
4593 
                      <value type="int" key="keyBlockSize">0</value>
4594 
                      <value type="string" key="withParser"></value>
4595 
                      <value type="string" key="comment"></value>
4596 
                      <value type="int" key="deferability">0</value>
4597 
                      <value type="string" key="indexType">INDEX</value>
4598 
                      <value type="int" key="isPrimary">0</value>
4599 
                      <value type="string" key="name">fk_taxon_determination_taxon_observation1_idx</value>
4600 
                      <value type="int" key="unique">0</value>
4601 
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1</value>
4602 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4603 
                    </value>
4542 4604 
                  </value>
4543 4605 
                  <value type="string" key="maxRows"></value>
4544 4606 
                  <value type="string" key="mergeInsert"></value>
......
4570 4632 
                  <value type="int" key="commentedOut">0</value>
4571 4633 
                  <value type="string" key="createDate">2013-04-17 13:56</value>
4572 4634 
                  <value _ptr_="0xb269070" type="dict" key="customData"/>
4573 
                  <value type="string" key="lastChangeDate">2013-07-26 22:48</value>
4635 
                  <value type="string" key="lastChangeDate">2013-07-27 09:58</value>
4574 4636 
                  <value type="int" key="modelOnly">0</value>
4575 4637 
                  <value type="string" key="name">taxon_determination</value>
4576 4638 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11691 11753 
                <value type="int" key="visible">1</value>
11692 11754 
                <value type="string" key="name"></value>
11693 11755 
              </value>
11694 
              <value type="object" struct-name="workbench.physical.Connection" id="0ad91298-ac45-11e2-820d-080027bcf912" struct-checksum="0x9baebc92">
11695 
                <value type="string" key="caption">fk_taxon_determination_record1</value>
11696 
                <value type="real" key="captionXOffs">0.e+00</value>
11697 
                <value type="real" key="captionYOffs">0.e+00</value>
11698 
                <value type="string" key="comment"></value>
11699 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11700 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11701 
                <value type="string" key="extraCaption"></value>
11702 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11703 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11704 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3d9b3790-a7a1-11e2-b667-080027bcf912</link>
11705 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11706 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11707 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11708 
                <value type="int" key="drawSplit">0</value>
11709 
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
11710 
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
11711 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11712 
                <value type="int" key="visible">1</value>
11713 
                <value type="string" key="name"></value>
11714 
              </value>
11715 11756 
              <value type="object" struct-name="workbench.physical.Connection" id="2a9fe494-ac45-11e2-820d-080027bcf912" struct-checksum="0x9baebc92">
11716 11757 
                <value type="string" key="caption">fk_individual_observation_taxon_occurrence1</value>
11717 11758 
                <value type="real" key="captionXOffs">0.e+00</value>
......
12384 12425 
                <value type="int" key="visible">1</value>
12385 12426 
                <value type="string" key="name"></value>
12386 12427 
              </value>
12428 
              <value type="object" struct-name="workbench.physical.Connection" id="4a631b9c-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12429 
                <value type="string" key="caption">fk_taxon_determination_taxon_observation1</value>
12430 
                <value type="real" key="captionXOffs">0.e+00</value>
12431 
                <value type="real" key="captionYOffs">0.e+00</value>
12432 
                <value type="string" key="comment"></value>
12433 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12434 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12435 
                <value type="string" key="extraCaption"></value>
12436 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12437 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12438 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">4a62f766-f6dd-11e2-b6d1-080027bcf912</link>
12439 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12440 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12441 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12442 
                <value type="int" key="drawSplit">0</value>
12443 
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
12444 
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
12445 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12446 
                <value type="int" key="visible">1</value>
12447 
                <value type="string" key="name"></value>
12448 
              </value>
12449 
              <value type="object" struct-name="workbench.physical.Connection" id="557583a8-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12450 
                <value type="string" key="caption">fk_taxon_determination_sampling_event1</value>
12451 
                <value type="real" key="captionXOffs">0.e+00</value>
12452 
                <value type="real" key="captionYOffs">0.e+00</value>
12453 
                <value type="string" key="comment"></value>
12454 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12455 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12456 
                <value type="string" key="extraCaption"></value>
12457 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12458 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12459 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">55756896-f6dd-11e2-b6d1-080027bcf912</link>
12460 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12461 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12462 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12463 
                <value type="int" key="drawSplit">0</value>
12464 
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
12465 
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
12466 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12467 
                <value type="int" key="visible">1</value>
12468 
                <value type="string" key="name"></value>
12469 
              </value>
12387 12470 
            </value>
12388 12471 
            <value type="string" key="description"></value>
12389 12472 
            <value _ptr_="0xb2c2dd8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12553 12636 
                <value type="int" key="expanded">1</value>
12554 12637 
                <value type="real" key="height">1.e+02</value>
12555 12638 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12556 
                <value type="real" key="left">6.76e+02</value>
12639 
                <value type="real" key="left">6.74e+02</value>
12557 12640 
                <value type="int" key="locked">0</value>
12558 12641 
                <value type="int" key="manualSizing">0</value>
12559 
                <value type="real" key="top">6.95e+02</value>
12642 
                <value type="real" key="top">7.65e+02</value>
12560 12643 
                <value type="real" key="width">9.3e+01</value>
12561 12644 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12562 12645 
                <value type="int" key="visible">1</value>
......
12791 12874 
                <value type="int" key="triggersExpanded">0</value>
12792 12875 
                <value type="string" key="color">#00ee00</value>
12793 12876 
                <value type="int" key="expanded">1</value>
12794 
                <value type="real" key="height">1.23e+02</value>
12877 
                <value type="real" key="height">1.46e+02</value>
12795 12878 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12796 12879 
                <value type="real" key="left">8.69e+02</value>
12797 12880 
                <value type="int" key="locked">0</value>
12798 12881 
                <value type="int" key="manualSizing">0</value>
12799 
                <value type="real" key="top">7.55e+02</value>
12882 
                <value type="real" key="top">7.32e+02</value>
12800 12883 
                <value type="real" key="width">1.68e+02</value>
12801 12884 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12802 12885 
                <value type="int" key="visible">1</value>
......
13299 13382 
                <value type="int" key="expanded">1</value>
13300 13383 
                <value type="real" key="height">1.e+02</value>
13301 13384 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13302 
                <value type="real" key="left">6.76e+02</value>
13385 
                <value type="real" key="left">6.74e+02</value>
13303 13386 
                <value type="int" key="locked">0</value>
13304 13387 
                <value type="int" key="manualSizing">0</value>
13305 
                <value type="real" key="top">8.29e+02</value>
13388 
                <value type="real" key="top">8.99e+02</value>
13306 13389 
                <value type="real" key="width">9.4e+01</value>
13307 13390 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13308 13391 
                <value type="int" key="visible">1</value>
......
13642 13725 
                <value type="real" key="left">5.54e+02</value>
13643 13726 
                <value type="int" key="locked">0</value>
13644 13727 
                <value type="int" key="manualSizing">0</value>
13645 
                <value type="real" key="top">5.85e+02</value>
13728 
                <value type="real" key="top">6.09e+02</value>
13646 13729 
                <value type="real" key="width">1.4e+02</value>
13647 13730 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13648 13731 
                <value type="int" key="visible">1</value>
......
13772 13855 
              <value type="int" key="visible">1</value>
13773 13856 
              <value type="string" key="name"></value>
13774 13857 
            </value>
13775 
            <value _ptr_="0xb2c2eb0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
13776 
              <link type="object">2E4C661D-4F5E-45E6-9290-A20ABF3BCBCD</link>
13777 
            </value>
13858 
            <value _ptr_="0xb2c2eb0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
13778 13859 
            <value type="int" key="updateBlocked">0</value>
13779 13860 
            <value type="real" key="width">1.6215e+03</value>
13780 13861 
            <value type="real" key="x">0.e+00</value>
......
13787 13868 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
13788 13869 
        <value _ptr_="0xb2394c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
13789 13870 
        <value _ptr_="0xaa26720" type="dict" key="syncProfiles">
13790 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="78dea35a-f6d9-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13791 
            <value _ptr_="0xc410858" type="dict" key="lastKnownDBNames">
13871 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9e0096fa-f6db-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13872 
            <value _ptr_="0xc98c998" type="dict" key="lastKnownDBNames">
13792 13873 
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
13793 13874 
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
13794 13875 
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
......
13829 13910 
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
13830 13911 
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
13831 13912 
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
13913 
              <value type="string" key="1a652744-f6da-11e2-b6d1-080027bcf912">geocoords_unique</value>
13832 13914 
              <value type="string" key="1c07f840-a7a9-11e2-8ba6-080027bcf912">fk_taxon_observation_taxon_occurrence2</value>
13833 13915 
              <value type="string" key="1c07f9f8-a7a9-11e2-8ba6-080027bcf912">taxon_occurrence</value>
13834 13916 
              <value type="string" key="1c0c53ea-a7a9-11e2-8ba6-080027bcf912">fk_taxon_observation_taxon_occurrence2_idx</value>
......
14298 14380 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14299 14381 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14300 14382 
      <value type="string" key="caption">New Model</value>
14301 
      <value type="string" key="dateChanged">2013-07-27 09:42</value>
14383 
      <value type="string" key="dateChanged">2013-07-27 09:58</value>
14302 14384 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14303 14385 
      <value type="string" key="description"></value>
14304 14386 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
240 240 
  UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoords`),
241 241 
  KEY `fk_geovalidation_place_path1_idx` (`geopath`),
242 242 
  KEY `fk_geovalidation_coordinates1_idx` (`geocoords`),
243 
  CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
244 
  CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
243 
  CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
244 
  CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
245 245 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
246 246 
/*!40101 SET character_set_client = @saved_cs_client */;
247 247 

  		




  ......




  454
  454
  
    
  KEY `fk_place_coordinates1_idx` (`geocoords`),


  		




  455
  455
  
    
  KEY `fk_place1_idx` (`parent`),


  		




  456
  456
  
    
  KEY `fk_place_place_path1_idx` (`geopath`),


  		




  
  457
  
    
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  457
  458
  
    
  CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoords`) REFERENCES `geocoords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  458
  459
  
    
  CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  459
  
  
    
  CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  460
  
  
    
  CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  460
  
    
  CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  461
  461
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';


  		




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


  		




  463
  463
  
    

  		




  ......




  951
  951
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  952
  952
  
    
CREATE TABLE `taxon_determination` (


  		




  953
  953
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  954
  
    
  `taxon_observation` varbinary(767) NOT NULL,


  		




  
  955
  
    
  `identified_by` varbinary(767) DEFAULT NULL,


  		




  954
  956
  
    
  `taxon_assertion` varbinary(767) NOT NULL,


  		




  955
  
  
    
  `identified_by` varbinary(767) DEFAULT NULL,


  		




  956
  957
  
    
  `fit_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  957
  958
  
    
  PRIMARY KEY (`id`),


  		




  958
  959
  
    
  UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`),


  		




  959
  960
  
    
  KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`),


  		




  960
  961
  
    
  KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),


  		




  
  962
  
    
  KEY `fk_taxon_determination_taxon_observation1_idx` (`taxon_observation`),


  		




  961
  963
  
    
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  962
  
  
    
  CONSTRAINT `fk_taxon_determination_record1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  963
  
  
    
  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  964
  
    
  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  965
  
    
  CONSTRAINT `fk_taxon_determination_taxon_observation1` FOREIGN KEY (`taxon_observation`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  966
  
    
  CONSTRAINT `fk_taxon_determination_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  964
  967
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]';


  		




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


  		




  966
  969
  
    

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  242
  242
  
    
  /*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoords"),


  		




  243
  243
  
    
  /*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true),


  		




  244
  244
  
    
  /*KEY "fk_geovalidation_coordinates1_idx" ("geocoords")*/CHECK (true),


  		




  245
  
  
    
  /*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  246
  
  
    
  /*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  245
  
    
  /*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  246
  
    
  /*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




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


  		




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


  		




  249
  249
  
    

  		




  ......




  456
  456
  
    
  /*KEY "fk_place_coordinates1_idx" ("geocoords")*/CHECK (true),


  		




  457
  457
  
    
  /*KEY "fk_place1_idx" ("parent")*/CHECK (true),


  		




  458
  458
  
    
  /*KEY "fk_place_place_path1_idx" ("geopath")*/CHECK (true),


  		




  
  459
  
    
  /*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  459
  460
  
    
  /*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoords") REFERENCES "geocoords" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  460
  461
  
    
  /*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  461
  
  
    
  /*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  462
  
  
    
  /*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  462
  
    
  /*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  463
  463
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/;


  		




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


  		




  465
  465
  
    

  		




  ......




  953
  953
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  954
  954
  
    
CREATE TABLE "taxon_determination" (


  		




  955
  955
  
    
  "id" text NOT NULL,


  		




  
  956
  
    
  "taxon_observation" text NOT NULL,


  		




  
  957
  
    
  "identified_by" text DEFAULT NULL,


  		




  956
  958
  
    
  "taxon_assertion" text NOT NULL,


  		




  957
  
  
    
  "identified_by" text DEFAULT NULL,


  		




  958
  959
  
    
  "fit_info" hstore DEFAULT NULL,


  		




  959
  960
  
    
  PRIMARY KEY ("id"),


  		




  960
  961
  
    
  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),


  		




  961
  962
  
    
  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),


  		




  962
  963
  
    
  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),


  		




  
  964
  
    
  /*KEY "fk_taxon_determination_taxon_observation1_idx" ("taxon_observation")*/CHECK (true),


  		




  963
  965
  
    
  /*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  964
  
  
    
  /*CONSTRAINT "fk_taxon_determination_record1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  965
  
  
    
  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  966
  
    
  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  967
  
    
  /*CONSTRAINT "fk_taxon_determination_taxon_observation1" FOREIGN KEY ("taxon_observation") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  968
  
    
  /*CONSTRAINT "fk_taxon_determination_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  966
  969
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;


  		




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


  		




  968
  971
  
    

  		












Also available in:  Unified diff