Project

General

Profile

« Previous | Next » 

Revision 11061

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset: replaced metadata_source with data_source, since the source field inherited from traceable is actually for where the information in the dataset record itself came from

View differences:

schemas/VegCore/ERD/document.mwb.xml
344 344
                      <value type="int" key="precision">-1</value>
345 345
                      <value type="int" key="scale">-1</value>
346 346
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
347
                      <value type="string" key="comment">where the information *about* the dataset came from (as opposed to where the dataset came from)</value>
348
                      <value type="string" key="name">metadata_source</value>
347
                      <value type="string" key="comment">where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)</value>
348
                      <value type="string" key="name">data_source</value>
349 349
                      <value type="string" key="oldName">metadata_source</value>
350 350
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
351 351
                    </value>
......
747 747
                  <value type="int" key="commentedOut">0</value>
748 748
                  <value type="string" key="createDate">2013-04-16 14:58</value>
749 749
                  <value _ptr_="0xb034dc0" type="dict" key="customData"/>
750
                  <value type="string" key="lastChangeDate">2013-09-22 07:56</value>
750
                  <value type="string" key="lastChangeDate">2013-09-22 08:23</value>
751 751
                  <value type="int" key="modelOnly">0</value>
752 752
                  <value type="string" key="name">dataset</value>
753 753
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15887 15887
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15888 15888
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15889 15889
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6a2c268a-1dfc-11e3-bbb6-080027bcf912</link>
15890
                <value type="real" key="middleSegmentOffset">-7.076507974642709086765535175800323486328125e+00</value>
15890
                <value type="real" key="middleSegmentOffset">2.077417266458184030852862633764743804931640625e+00</value>
15891 15891
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15892 15892
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15893 15893
                <value type="int" key="drawSplit">0</value>
......
16013 16013
                <value type="real" key="left">4.e+01</value>
16014 16014
                <value type="int" key="locked">0</value>
16015 16015
                <value type="int" key="manualSizing">0</value>
16016
                <value type="real" key="top">6.96e+02</value>
16017
                <value type="real" key="width">1.06e+02</value>
16016
                <value type="real" key="top">6.9e+02</value>
16017
                <value type="real" key="width">9.2e+01</value>
16018 16018
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16019 16019
                <value type="int" key="visible">1</value>
16020 16020
                <value type="string" key="name">dataset</value>
......
17551 17551
                <value type="int" key="expanded">1</value>
17552 17552
                <value type="real" key="height">1.e+02</value>
17553 17553
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17554
                <value type="real" key="left">1.85e+02</value>
17554
                <value type="real" key="left">1.73e+02</value>
17555 17555
                <value type="int" key="locked">0</value>
17556 17556
                <value type="int" key="manualSizing">0</value>
17557
                <value type="real" key="top">6.57e+02</value>
17557
                <value type="real" key="top">6.71e+02</value>
17558 17558
                <value type="real" key="width">1.06e+02</value>
17559 17559
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17560 17560
                <value type="int" key="visible">1</value>
......
17723 17723
              <value type="int" key="visible">1</value>
17724 17724
              <value type="string" key="name"></value>
17725 17725
            </value>
17726
            <value _ptr_="0xbaec758" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17727
              <link type="object">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
17728
            </value>
17726
            <value _ptr_="0xbaec758" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17729 17727
            <value type="int" key="updateBlocked">0</value>
17730 17728
            <value type="real" key="width">1.6215e+03</value>
17731 17729
            <value type="real" key="x">0.e+00</value>
......
17737 17735
        <value _ptr_="0xba3c620" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>
17738 17736
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17739 17737
        <value _ptr_="0xba3c650" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17740
        <value _ptr_="0xb030e28" type="dict" key="syncProfiles"/>
17738
        <value _ptr_="0xb030e28" type="dict" key="syncProfiles">
17739
          <value type="object" struct-name="db.mgmt.SyncProfile" id="418cd4ae-2397-11e3-ab7c-080027bcf912" struct-checksum="0xc64972c2" key="">
17740
            <value _ptr_="0xc5edb08" type="dict" key="lastKnownDBNames">
17741
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17742
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17743
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
17744
              <value type="string" key="04149c40-fa90-11e2-83d9-080027bcf912">official_name</value>
17745
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
17746
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
17747
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
17748
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
17749
              <value type="string" key="07e2f24c-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1</value>
17750
              <value type="string" key="07e2f45e-1dde-11e3-bd5f-080027bcf912">sampling_event</value>
17751
              <value type="string" key="07e3e7c4-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1_idx</value>
17752
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
17753
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
17754
              <value type="string" key="09a29b5c-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1</value>
17755
              <value type="string" key="09a29d14-1dd2-11e3-b98c-080027bcf912">within_place</value>
17756
              <value type="string" key="09a2b70e-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1_idx</value>
17757
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>
17758
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
17759
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
17760
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>
17761
              <value type="string" key="0ab98e12-a7a1-11e2-b667-080027bcf912">traits</value>
17762
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17763
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>
17764
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
17765
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
17766
              <value type="string" key="0de39e86-1dec-11e3-b571-080027bcf912">record</value>
17767
              <value type="string" key="0de3a2aa-1dec-11e3-b571-080027bcf912">id</value>
17768
              <value type="string" key="0de3a61a-1dec-11e3-b571-080027bcf912">dataset</value>
17769
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">id_within_dataset</value>
17770
              <value type="string" key="0de3afc0-1dec-11e3-b571-080027bcf912">fk_record_source10</value>
17771
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>
17772
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>
17773
              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>
17774
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>
17775
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
17776
              <value type="string" key="1156cf50-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1</value>
17777
              <value type="string" key="1156d180-2393-11e3-a6f3-080027bcf912">parent</value>
17778
              <value type="string" key="1156fa5c-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1_idx</value>
17779
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>
17780
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
17781
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
17782
              <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>
17783
              <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>
17784
              <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>
17785
              <value type="string" key="1427502e-1bf0-11e3-849d-080027bcf912">fk_reobservable_presence_reobservable2</value>
17786
              <value type="string" key="14276b0e-1bf0-11e3-849d-080027bcf912">fk_reobservable_presence_reobservable2_idx</value>
17787
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
17788
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
17789
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
17790
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
17791
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
17792
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17793
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
17794
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>
17795
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
17796
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>
17797
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>
17798
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>
17799
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>
17800
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>
17801
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>
17802
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>
17803
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>
17804
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>
17805
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>
17806
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>
17807
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>
17808
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
17809
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
17810
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
17811
              <value type="string" key="1b07bbcc-1dcb-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1_idx</value>
17812
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>
17813
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
17814
              <value type="string" key="1e711948-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_occurrence_record1</value>
17815
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
17816
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>
17817
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>
17818
              <value type="string" key="2213caf6-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1</value>
17819
              <value type="string" key="2213dee2-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1_idx</value>
17820
              <value type="string" key="238b4ae4-a700-11e2-9461-080027bcf912">stratum</value>
17821
              <value type="string" key="238b4f6c-a700-11e2-9461-080027bcf912">id</value>
17822
              <value type="string" key="238b53d6-a700-11e2-9461-080027bcf912">fk_place_path_record10</value>
17823
              <value type="string" key="23ec4078-0075-11e3-906b-080027bcf912">layer</value>
17824
              <value type="string" key="23ec4406-0075-11e3-906b-080027bcf912">id</value>
17825
              <value type="string" key="23ec4726-0075-11e3-906b-080027bcf912">name</value>
17826
              <value type="string" key="23ec49ec-0075-11e3-906b-080027bcf912">info</value>
17827
              <value type="string" key="23ec4e92-0075-11e3-906b-080027bcf912">PRIMARY</value>
17828
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>
17829
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>
17830
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>
17831
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
17832
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
17833
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
17834
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>
17835
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
17836
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
17837
              <value type="string" key="26b22c2a-011d-11e3-9f3a-080027bcf912">fk_taxon_absence_taxa_sampling_event1</value>
17838
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
17839
              <value type="string" key="293dc5b4-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_taxon_presence1</value>
17840
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
17841
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
17842
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
17843
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>
17844
              <value type="string" key="2ebd5a70-238c-11e3-a6f3-080027bcf912">metadata_source</value>
17845
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
17846
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
17847
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>
17848
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>
17849
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>
17850
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
17851
              <value type="string" key="3237beb6-238c-11e3-a6f3-080027bcf912">fk_dataset_source2</value>
17852
              <value type="string" key="3237d356-238c-11e3-a6f3-080027bcf912">fk_dataset_source2_idx</value>
17853
              <value type="string" key="323a36d4-011b-11e3-b872-080027bcf912">fk_individual_observation_place1</value>
17854
              <value type="string" key="323a39a4-011b-11e3-b872-080027bcf912">place_observed_at</value>
17855
              <value type="string" key="323a5f56-011b-11e3-b872-080027bcf912">fk_individual_observation_place1_idx</value>
17856
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
17857
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
17858
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
17859
              <value type="string" key="3587a3e0-1dc6-11e3-838b-410b6ef2c3ca">fk_reobservable_taxon_occurrence1</value>
17860
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
17861
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
17862
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
17863
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
17864
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
17865
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>
17866
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>
17867
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>
17868
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17869
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
17870
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
17871
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
17872
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
17873
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
17874
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>
17875
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>
17876
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>
17877
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>
17878
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>
17879
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>
17880
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>
17881
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>
17882
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
17883
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
17884
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
17885
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>
17886
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
17887
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
17888
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>
17889
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>
17890
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
17891
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
17892
              <value type="string" key="47b3b670-0076-11e3-906b-080027bcf912">diameter_max_m</value>
17893
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
17894
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17895
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
17896
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17897
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>
17898
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>
17899
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>
17900
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
17901
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17902
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>
17903
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>
17904
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>
17905
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>
17906
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
17907
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
17908
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
17909
              <value type="string" key="48c4e182-1dff-11e3-9d67-080027bcf912">event_unique_within_place</value>
17910
              <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>
17911
              <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent_plot</value>
17912
              <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>
17913
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
17914
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
17915
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
17916
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
17917
              <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>
17918
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
17919
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
17920
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
17921
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
17922
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>
17923
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
17924
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
17925
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
17926
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
17927
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
17928
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
17929
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
17930
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
17931
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
17932
              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</value>
17933
              <value type="string" key="5a8a530a-1dca-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1</value>
17934
              <value type="string" key="5a8a54cc-1dca-11e3-b98c-080027bcf912">orig_observation</value>
17935
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
17936
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>
17937
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
17938
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
17939
              <value type="string" key="61c193a8-1dee-11e3-b571-080027bcf912">fk_source_party_list1</value>
17940
              <value type="string" key="61c1b04a-1dee-11e3-b571-080027bcf912">fk_source_party_list1_idx</value>
17941
              <value type="string" key="648b8c10-0075-11e3-906b-080027bcf912">fk_layer_stratum1</value>
17942
              <value type="string" key="65752312-0119-11e3-b872-080027bcf912">cover_percent</value>
17943
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>
17944
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>
17945
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
17946
              <value type="string" key="6856853a-a796-11e2-84c3-080027bcf912">traits</value>
17947
              <value type="string" key="686ec05a-f9bc-11e2-a599-080027bcf912">fk_subplot_plot1</value>
17948
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
17949
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>
17950
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>
17951
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>
17952
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>
17953
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>
17954
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>
17955
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17956
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>
17957
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>
17958
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>
17959
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>
17960
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>
17961
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>
17962
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>
17963
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
17964
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
17965
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17966
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
17967
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">taxon_presence</value>
17968
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>
17969
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
17970
              <value type="string" key="6a2c268a-1dfc-11e3-bbb6-080027bcf912">fk_record_source2</value>
17971
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>
17972
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>
17973
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>
17974
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>
17975
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>
17976
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>
17977
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>
17978
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>
17979
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
17980
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
17981
              <value type="string" key="7255cc48-1beb-11e3-8de9-080027bcf912">specimen_unique_in_individual_observation</value>
17982
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
17983
              <value type="string" key="760751d2-2324-11e3-a5a2-080027bcf912">fk_dataset_traceable1</value>
17984
              <value type="string" key="77c740cc-1de8-11e3-b571-080027bcf912">role</value>
17985
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
17986
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>
17987
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>
17988
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>
17989
              <value type="string" key="7afec6ec-0075-11e3-906b-080027bcf912">info</value>
17990
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
17991
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
17992
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
17993
              <value type="string" key="7cd351c8-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1</value>
17994
              <value type="string" key="7cd35394-1168-11e3-8d7f-080027bcf912">individual_observation</value>
17995
              <value type="string" key="7cd372b6-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1_idx</value>
17996
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
17997
              <value type="string" key="7e2aa84c-1dfb-11e3-bbb6-080027bcf912">fk_dataset_source1</value>
17998
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>
17999
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
18000
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
18001
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>
18002
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>
18003
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>
18004
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>
18005
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>
18006
              <value type="string" key="813d59c4-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1</value>
18007
              <value type="string" key="813d5bfe-1de9-11e3-b571-080027bcf912">list</value>
18008
              <value type="string" key="813e36c8-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1_idx</value>
18009
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
18010
              <value type="string" key="8222d06e-1e00-11e3-9d67-080027bcf912">name</value>
18011
              <value type="string" key="83cc6526-236c-11e3-a6f3-080027bcf912">name</value>
18012
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
18013
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
18014
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>
18015
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>
18016
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>
18017
              <value type="string" key="8535dbc2-006c-11e3-895c-080027bcf912">stratum_event</value>
18018
              <value type="string" key="8535dfbe-006c-11e3-895c-080027bcf912">id</value>
18019
              <value type="string" key="8535e306-006c-11e3-895c-080027bcf912">stratum</value>
18020
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>
18021
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
18022
              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>
18023
              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>
18024
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
18025
              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>
18026
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
18027
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
18028
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
18029
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
18030
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
18031
              <value type="string" key="96b8693a-1e00-11e3-9d67-080027bcf912">party_unique</value>
18032
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
18033
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
18034
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
18035
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
18036
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
18037
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
18038
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>
18039
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>
18040
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>
18041
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">party</value>
18042
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>
18043
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>
18044
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>
18045
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>
18046
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>
18047
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>
18048
              <value type="string" key="9ff2d244-1dfe-11e3-9d67-080027bcf912">event_unique_within_parent</value>
18049
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>
18050
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>
18051
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
18052
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
18053
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>
18054
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
18055
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
18056
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
18057
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
18058
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
18059
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>
18060
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
18061
              <value type="string" key="a882f398-0117-11e3-b872-080027bcf912">count</value>
18062
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
18063
              <value type="string" key="ab3ef4b0-1dc8-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3</value>
18064
              <value type="string" key="ab3ef6ae-1dc8-11e3-b98c-080027bcf912">current_observation</value>
18065
              <value type="string" key="ab56b99c-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1</value>
18066
              <value type="string" key="ab56bc12-1ddc-11e3-bd5f-080027bcf912">sampling_event</value>
18067
              <value type="string" key="ab56d2f6-1ddc-11e3-bd5f-080027bcf912">fk_aggregate_observation_taxa_sampling_event1_idx</value>
18068
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>
18069
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>
18070
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>
18071
              <value type="string" key="aecb187e-1de2-11e3-b950-080027bcf912">fk_taxon_observation_taxon_observation1</value>
18072
              <value type="string" key="aecb1a5e-1de2-11e3-b950-080027bcf912">observation_in_parent_place</value>
18073
              <value type="string" key="aecb3a34-1de2-11e3-b950-080027bcf912">fk_taxon_observation_taxon_observation1_idx</value>
18074
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
18075
              <value type="string" key="afc401d4-1df9-11e3-bbb6-080027bcf912">source</value>
18076
              <value type="string" key="afc4053a-1df9-11e3-bbb6-080027bcf912">id</value>
18077
              <value type="string" key="afc40c10-1df9-11e3-bbb6-080027bcf912">name</value>
18078
              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>
18079
              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>
18080
              <value type="string" key="afc422b8-1df9-11e3-bbb6-080027bcf912">source_unique</value>
18081
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
18082
              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>
18083
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
18084
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
18085
              <value type="string" key="b922e5ba-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1</value>
18086
              <value type="string" key="b922fa5a-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1_idx</value>
18087
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
18088
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
18089
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>
18090
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>
18091
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">code_in_individual</value>
18092
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
18093
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">dataset</value>
18094
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>
18095
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18096
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">traceable</value>
18097
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>
18098
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>
18099
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18100
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>
18101
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>
18102
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
18103
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18104
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
18105
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geoplace</value>
18106
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
18107
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18108
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
18109
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>
18110
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18111
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>
18112
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>
18113
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>
18114
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>
18115
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>
18116
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>
18117
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18118
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>
18119
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>
18120
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>
18121
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>
18122
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18123
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>
18124
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>
18125
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>
18126
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>
18127
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>
18128
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">stem</value>
18129
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18130
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>
18131
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>
18132
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>
18133
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>
18134
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">individual_count</value>
18135
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>
18136
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18137
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
18138
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
18139
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
18140
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
18141
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18142
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>
18143
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18144
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
18145
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18146
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
18147
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
18148
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
18149
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">place</value>
18150
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18151
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>
18152
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>
18153
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>
18154
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>
18155
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>
18156
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>
18157
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>
18158
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>
18159
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
18160
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18161
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplace</value>
18162
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
18163
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18164
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>
18165
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
18166
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18167
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
18168
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>
18169
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18170
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>
18171
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>
18172
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>
18173
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>
18174
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18175
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>
18176
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>
18177
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18178
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>
18179
              <value type="string" key="c20b4bce-ad13-11e2-b309-080027bcf912">fk_specimen_organization3_idx</value>
18180
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>
18181
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>
18182
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>
18183
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>
18184
              <value type="string" key="c4391d16-006c-11e3-895c-080027bcf912">fk_stratum_event_sampling_event1</value>
18185
              <value type="string" key="c540c5c0-ad19-11e2-9d85-080027bcf912">traits</value>
18186
              <value type="string" key="c66112f6-ad10-11e2-b309-080027bcf912">fk_specimen_collection2</value>
18187
              <value type="string" key="c6612660-ad10-11e2-b309-080027bcf912">fk_specimen_collection2_idx</value>
18188
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
18189
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>
18190
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>
18191
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>
18192
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>
18193
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>
18194
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>
18195
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>
18196
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18197
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
18198
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
18199
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
18200
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
18201
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18202
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
18203
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
18204
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
18205
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
18206
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
18207
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
18208
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>
18209
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>
18210
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">place</value>
18211
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18212
              <value type="string" key="c67283da-a7a0-11e2-b667-080027bcf912">fk_event_place1_idx</value>
18213
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>
18214
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>
18215
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>
18216
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>
18217
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>
18218
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>
18219
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18220
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>
18221
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>
18222
              <value type="string" key="c673038c-a7a0-11e2-b667-080027bcf912">owner_collection</value>
18223
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>
18224
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>
18225
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>
18226
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18227
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>
18228
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>
18229
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>
18230
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>
18231
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>
18232
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>
18233
              <value type="string" key="c7c2089c-a91b-11e2-bdec-080027bcf912">fk_source_party2_idx</value>
18234
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">data_owners</value>
18235
              <value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value>
18236
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
18237
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
18238
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
18239
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>
18240
              <value type="string" key="d2855d46-1df2-11e3-bbb6-080027bcf912">fk_source_party1_idx</value>
18241
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
18242
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
18243
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>
18244
              <value type="string" key="db4e8988-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1</value>
18245
              <value type="string" key="db4e8bea-1dc6-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18246
              <value type="string" key="db4ea800-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1_idx</value>
18247
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>
18248
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
18249
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">aggregating_traits</value>
18250
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>
18251
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>
18252
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18253
              <value type="string" key="e5155806-a793-11e2-84c3-080027bcf912">info</value>
18254
              <value type="string" key="e550209e-f676-11e2-9716-080027bcf912">fk_party_organization1</value>
18255
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>
18256
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>
18257
              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>
18258
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18259
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
18260
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
18261
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>
18262
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
18263
              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>
18264
              <value type="string" key="eca92a0e-1de3-11e3-b950-080027bcf912">fk_taxa_sampling_event_project1</value>
18265
              <value type="string" key="eca92bf8-1de3-11e3-b950-080027bcf912">project</value>
18266
              <value type="string" key="eca94142-1de3-11e3-b950-080027bcf912">fk_taxa_sampling_event_project1_idx</value>
18267
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
18268
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
18269
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
18270
              <value type="string" key="ed551182-011b-11e3-b872-080027bcf912">fk_taxa_sampling_event_place1</value>
18271
              <value type="string" key="ed551376-011b-11e3-b872-080027bcf912">within_place</value>
18272
              <value type="string" key="ed55f9e4-011b-11e3-b872-080027bcf912">fk_taxa_sampling_event_place1_idx</value>
18273
              <value type="string" key="f15726c2-011f-11e3-9f3a-080027bcf912">aggregate_observation</value>
18274
              <value type="string" key="f1572a5a-011f-11e3-9f3a-080027bcf912">id</value>
18275
              <value type="string" key="f1572d5c-011f-11e3-9f3a-080027bcf912">occurrence_status</value>
18276
              <value type="string" key="f1573162-011f-11e3-9f3a-080027bcf912">traits</value>
18277
              <value type="string" key="f157336a-011f-11e3-9f3a-080027bcf912">fk_taxon_presence_taxon_determination10</value>
18278
              <value type="string" key="f1573748-011f-11e3-9f3a-080027bcf912">PRIMARY</value>
18279
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
18280
              <value type="string" key="f903388e-0084-11e3-ac06-080027bcf912">reobservable_presence</value>
18281
              <value type="string" key="f9033c9e-0084-11e3-ac06-080027bcf912">id</value>
18282
              <value type="string" key="f903400e-0084-11e3-ac06-080027bcf912">voucher</value>
18283
              <value type="string" key="f903472a-0084-11e3-ac06-080027bcf912">PRIMARY</value>
18284
              <value type="string" key="f9d23e32-1dc5-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18285
              <value type="string" key="f9d241ca-1dc5-11e3-838b-410b6ef2c3ca">id</value>
18286
              <value type="string" key="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca">PRIMARY</value>
18287
              <value type="string" key="f9d963a4-2326-11e3-a5a2-080027bcf912">id_within_source</value>
18288
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">traceable_unique</value>
18289
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
18290
            </value>
18291
            <value type="string" key="lastSyncDate"></value>
18292
            <value type="string" key="name"></value>
18293
          </value>
18294
        </value>
17741 18295
        <value _ptr_="0xba3c680" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>
17742 18296
        <value _ptr_="0xba3c6b0" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>
17743 18297
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
17820 18374
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17821 18375
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17822 18376
      <value type="string" key="caption">New Model</value>
17823
      <value type="string" key="dateChanged">2013-09-22 07:56</value>
18377
      <value type="string" key="dateChanged">2013-09-22 08:23</value>
17824 18378
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17825 18379
      <value type="string" key="description"></value>
17826 18380
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
127 127
CREATE TABLE `dataset` (
128 128
  `id` varbinary(767) NOT NULL,
129 129
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by source (inherited from traceable). e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the source).',
130
  `metadata_source` varbinary(767) DEFAULT NULL COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)',
130
  `data_source` varbinary(767) DEFAULT NULL COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)',
131 131
  `first_publisher` varbinary(767) DEFAULT NULL,
132 132
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
133 133
  `contacts` varbinary(767) DEFAULT NULL,
......
136 136
  KEY `fk_source_party2_idx` (`first_publisher`),
137 137
  KEY `fk_source_party_list1_idx` (`data_owners`),
138 138
  KEY `fk_source_party1_idx` (`contacts`),
139
  KEY `fk_dataset_source2_idx` (`metadata_source`),
139
  KEY `fk_dataset_source2_idx` (`data_source`),
140 140
  KEY `fk_dataset_dataset1_idx` (`parent`),
141
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`metadata_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`data_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143 142
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 143
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
145 144
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
145
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
146 146
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
147 147
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
148 148
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
schemas/VegCore/VegCore.pg.sql
129 129
CREATE TABLE "dataset" (
130 130
  "id" text NOT NULL,
131 131
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by source (inherited from traceable). e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the source).'*/,
132
  "metadata_source" text DEFAULT NULL /*COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)'*/,
132
  "data_source" text DEFAULT NULL /*COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)'*/,
133 133
  "first_publisher" text DEFAULT NULL,
134 134
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
135 135
  "contacts" text DEFAULT NULL,
......
138 138
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
139 139
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),
140 140
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
141
  /*KEY "fk_dataset_source2_idx" ("metadata_source")*/CHECK (true),
141
  /*KEY "fk_dataset_source2_idx" ("data_source")*/CHECK (true),
142 142
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),
143
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("metadata_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("data_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145 144
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146 145
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
147 146
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
147
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
148 148
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
149 149
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
150 150
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;

Also available in: Unified diff