Project

General

Profile

« Previous | Next » 

Revision 10497

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/VegCore.ERD.mwb: subplot: renamed to rel_place and inherit from place directly, in order to store other plot elements that are relative to their containing plot

View differences:

schemas/VegCore/document.mwb.xml
5624 5624 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
5625 5625 
                  <value type="int" key="delayKeyWrite">0</value>
5626 5626 
                  <value _ptr_="0xabc73d8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
5627 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="b37dc2a8-a6fb-11e2-9461-080027bcf912" struct-checksum="0x70a8fc40">
5628 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
5629 
                      <value _ptr_="0xabc89a0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5627 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="a45bf56a-f980-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">
5628 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5629 
                      <value _ptr_="0xb9ecd28" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5630 5630 
                        <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>
5631 5631 
                      </value>
5632 5632 
                      <value type="int" key="deferability">0</value>
......
5635 5635 
                      <value type="int" key="many">0</value>
5636 5636 
                      <value type="int" key="modelOnly">0</value>
5637 5637 
                      <link type="object" struct-name="db.Table" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
5638 
                      <value _ptr_="0xabc8d08" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5639 
                        <link type="object">9f4bdd10-a6fb-11e2-9461-080027bcf912</link>
5638 
                      <value _ptr_="0xbbc33c8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
5639 
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
5640 5640 
                      </value>
5641 5641 
                      <value type="int" key="referencedMandatory">1</value>
5642 5642 
                      <value type="string" key="updateRule">CASCADE</value>
5643 5643 
                      <value type="string" key="comment"></value>
5644 
                      <value type="string" key="name">fk_subplot_plot1</value>
5645 
                      <value type="string" key="oldName">fk_subplot_plot1</value>
5644 
                      <value type="string" key="name">fk_subplot_place2</value>
5645 
                      <value type="string" key="oldName">fk_subplot_place2</value>
5646 5646 
                    </value>
5647 5647 
                  </value>
5648 5648 
                  <value _ptr_="0xabc7428" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
5700 5700 
                  <value type="int" key="commentedOut">0</value>
5701 5701 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
5702 5702 
                  <value _ptr_="0xabc71b0" type="dict" key="customData"/>
5703 
                  <value type="string" key="lastChangeDate">2013-07-27 09:04</value>
5703 
                  <value type="string" key="lastChangeDate">2013-07-30 18:34</value>
5704 5704 
                  <value type="int" key="modelOnly">0</value>
5705 
                  <value type="string" key="name">subplot</value>
5705 
                  <value type="string" key="name">rel_place</value>
5706 5706 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
5707 5707 
                  <value type="string" key="temp_sql"></value>
5708 
                  <value type="string" key="comment">"subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)</value>
5709 
                  <value type="string" key="oldName">subplot</value>
5708 
                  <value type="string" key="comment">stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))</value>
5709 
                  <value type="string" key="oldName">rel_place</value>
5710 5710 
                </value>
5711 5711 
                <value type="object" struct-name="db.mysql.Table" id="be8f78aa-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
5712 5712 
                  <value type="string" key="avgRowLength"></value>
......
11435 11435 
                <value type="int" key="visible">1</value>
11436 11436 
                <value type="string" key="name"></value>
11437 11437 
              </value>
11438 
              <value type="object" struct-name="workbench.physical.Connection" id="d174e69c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11439 
                <value type="string" key="caption">fk_subplot_plot1</value>
11440 
                <value type="real" key="captionXOffs">0.e+00</value>
11441 
                <value type="real" key="captionYOffs">0.e+00</value>
11442 
                <value type="string" key="comment"></value>
11443 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11444 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11445 
                <value type="string" key="extraCaption"></value>
11446 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11447 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11448 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">b37dc2a8-a6fb-11e2-9461-080027bcf912</link>
11449 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11450 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11451 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11452 
                <value type="int" key="drawSplit">0</value>
11453 
                <link type="object" struct-name="model.Figure" key="endFigure">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
11454 
                <link type="object" struct-name="model.Figure" key="startFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
11455 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11456 
                <value type="int" key="visible">1</value>
11457 
                <value type="string" key="name"></value>
11458 
              </value>
11459 11438 
              <value type="object" struct-name="workbench.physical.Connection" id="0d91611e-a7a1-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11460 11439 
                <value type="string" key="caption">fk_individual_observation_individual1</value>
11461 11440 
                <value type="real" key="captionXOffs">0.e+00</value>
......
12674 12653 
                <value type="int" key="visible">1</value>
12675 12654 
                <value type="string" key="name"></value>
12676 12655 
              </value>
12656 
              <value type="object" struct-name="workbench.physical.Connection" id="a45c0e9c-f980-11e2-8a2e-080027bcf912" struct-checksum="0x9baebc92">
12657 
                <value type="string" key="caption">fk_subplot_place2</value>
12658 
                <value type="real" key="captionXOffs">0.e+00</value>
12659 
                <value type="real" key="captionYOffs">0.e+00</value>
12660 
                <value type="string" key="comment"></value>
12661 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12662 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12663 
                <value type="string" key="extraCaption"></value>
12664 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12665 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12666 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">a45bf56a-f980-11e2-8a2e-080027bcf912</link>
12667 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12668 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12669 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12670 
                <value type="int" key="drawSplit">0</value>
12671 
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
12672 
                <link type="object" struct-name="model.Figure" key="startFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
12673 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12674 
                <value type="int" key="visible">1</value>
12675 
                <value type="string" key="name"></value>
12676 
              </value>
12677 12677 
            </value>
12678 12678 
            <value type="string" key="description"></value>
12679 12679 
            <value _ptr_="0xac124f0" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12746 12746 
                <value type="real" key="left">3.05e+02</value>
12747 12747 
                <value type="int" key="locked">0</value>
12748 12748 
                <value type="int" key="manualSizing">0</value>
12749 
                <value type="real" key="top">1.71e+02</value>
12749 
                <value type="real" key="top">1.75e+02</value>
12750 12750 
                <value type="real" key="width">1.25e+02</value>
12751 12751 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12752 12752 
                <value type="int" key="visible">1</value>
......
12766 12766 
                <value type="real" key="left">5.6e+02</value>
12767 12767 
                <value type="int" key="locked">0</value>
12768 12768 
                <value type="int" key="manualSizing">0</value>
12769 
                <value type="real" key="top">4.32e+02</value>
12769 
                <value type="real" key="top">4.66e+02</value>
12770 12770 
                <value type="real" key="width">8.1e+01</value>
12771 12771 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12772 12772 
                <value type="int" key="visible">1</value>
......
12786 12786 
                <value type="real" key="left">5.09e+02</value>
12787 12787 
                <value type="int" key="locked">0</value>
12788 12788 
                <value type="int" key="manualSizing">0</value>
12789 
                <value type="real" key="top">2.9e+01</value>
12789 
                <value type="real" key="top">3.3e+01</value>
12790 12790 
                <value type="real" key="width">8.e+01</value>
12791 12791 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12792 12792 
                <value type="int" key="visible">1</value>
......
12806 12806 
                <value type="real" key="left">6.78e+02</value>
12807 12807 
                <value type="int" key="locked">0</value>
12808 12808 
                <value type="int" key="manualSizing">0</value>
12809 
                <value type="real" key="top">5.09e+02</value>
12809 
                <value type="real" key="top">5.43e+02</value>
12810 12810 
                <value type="real" key="width">9.e+01</value>
12811 12811 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12812 12812 
                <value type="int" key="visible">1</value>
......
12826 12826 
                <value type="real" key="left">4.47e+02</value>
12827 12827 
                <value type="int" key="locked">0</value>
12828 12828 
                <value type="int" key="manualSizing">0</value>
12829 
                <value type="real" key="top">2.6e+02</value>
12829 
                <value type="real" key="top">2.64e+02</value>
12830 12830 
                <value type="real" key="width">9.6e+01</value>
12831 12831 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12832 12832 
                <value type="int" key="visible">1</value>
......
12846 12846 
                <value type="real" key="left">6.78e+02</value>
12847 12847 
                <value type="int" key="locked">0</value>
12848 12848 
                <value type="int" key="manualSizing">0</value>
12849 
                <value type="real" key="top">8.e+02</value>
12849 
                <value type="real" key="top">8.34e+02</value>
12850 12850 
                <value type="real" key="width">9.3e+01</value>
12851 12851 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12852 12852 
                <value type="int" key="visible">1</value>
......
12866 12866 
                <value type="real" key="left">3.27e+02</value>
12867 12867 
                <value type="int" key="locked">0</value>
12868 12868 
                <value type="int" key="manualSizing">0</value>
12869 
                <value type="real" key="top">4.62e+02</value>
12869 
                <value type="real" key="top">4.66e+02</value>
12870 12870 
                <value type="real" key="width">1.62e+02</value>
12871 12871 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12872 12872 
                <value type="int" key="visible">1</value>
......
12886 12886 
                <value type="real" key="left">4.97e+02</value>
12887 12887 
                <value type="int" key="locked">0</value>
12888 12888 
                <value type="int" key="manualSizing">0</value>
12889 
                <value type="real" key="top">8.e+02</value>
12889 
                <value type="real" key="top">8.34e+02</value>
12890 12890 
                <value type="real" key="width">1.55e+02</value>
12891 12891 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12892 12892 
                <value type="int" key="visible">1</value>
......
12903 12903 
                <value type="int" key="expanded">1</value>
12904 12904 
                <value type="real" key="height">1.23e+02</value>
12905 12905 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12906 
                <value type="real" key="left">6.75e+02</value>
12906 
                <value type="real" key="left">6.52e+02</value>
12907 12907 
                <value type="int" key="locked">0</value>
12908 12908 
                <value type="int" key="manualSizing">0</value>
12909 
                <value type="real" key="top">3.34e+02</value>
12910 
                <value type="real" key="width">9.3e+01</value>
12909 
                <value type="real" key="top">1.e+01</value>
12910 
                <value type="real" key="width">1.02e+02</value>
12911 12911 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12912 12912 
                <value type="int" key="visible">1</value>
12913 
                <value type="string" key="name">subplot</value>
12913 
                <value type="string" key="name">rel_place</value>
12914 12914 
              </value>
12915 12915 
              <value type="object" struct-name="workbench.physical.TableFigure" id="8EACA0D2-66A0-4E36-B59C-E8F7594BE004" struct-checksum="0x3b14eccb">
12916 12916 
                <value type="int" key="columnsExpanded">1</value>
......
12926 12926 
                <value type="real" key="left">5.02e+02</value>
12927 12927 
                <value type="int" key="locked">0</value>
12928 12928 
                <value type="int" key="manualSizing">0</value>
12929 
                <value type="real" key="top">1.053e+03</value>
12929 
                <value type="real" key="top">1.087e+03</value>
12930 12930 
                <value type="real" key="width">1.45e+02</value>
12931 12931 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12932 12932 
                <value type="int" key="visible">1</value>
......
12946 12946 
                <value type="real" key="left">3.06e+02</value>
12947 12947 
                <value type="int" key="locked">0</value>
12948 12948 
                <value type="int" key="manualSizing">0</value>
12949 
                <value type="real" key="top">8.22e+02</value>
12949 
                <value type="real" key="top">8.56e+02</value>
12950 12950 
                <value type="real" key="width">1.58e+02</value>
12951 12951 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12952 12952 
                <value type="int" key="visible">1</value>
......
12966 12966 
                <value type="real" key="left">3.32e+02</value>
12967 12967 
                <value type="int" key="locked">0</value>
12968 12968 
                <value type="int" key="manualSizing">0</value>
12969 
                <value type="real" key="top">9.52e+02</value>
12969 
                <value type="real" key="top">9.86e+02</value>
12970 12970 
                <value type="real" key="width">1.14e+02</value>
12971 12971 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12972 12972 
                <value type="int" key="visible">1</value>
......
13569 13569 
                <value type="int" key="expanded">1</value>
13570 13570 
                <value type="real" key="height">1.92e+02</value>
13571 13571 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13572 
                <value type="real" key="left">6.59e+02</value>
13572 
                <value type="real" key="left">6.41e+02</value>
13573 13573 
                <value type="int" key="locked">0</value>
13574 13574 
                <value type="int" key="manualSizing">0</value>
13575 
                <value type="real" key="top">1.09e+02</value>
13575 
                <value type="real" key="top">1.54e+02</value>
13576 13576 
                <value type="real" key="width">1.25e+02</value>
13577 13577 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13578 13578 
                <value type="int" key="visible">1</value>
......
13592 13592 
                <value type="real" key="left">6.78e+02</value>
13593 13593 
                <value type="int" key="locked">0</value>
13594 13594 
                <value type="int" key="manualSizing">0</value>
13595 
                <value type="real" key="top">9.34e+02</value>
13595 
                <value type="real" key="top">9.68e+02</value>
13596 13596 
                <value type="real" key="width">9.4e+01</value>
13597 13597 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13598 13598 
                <value type="int" key="visible">1</value>
......
13632 13632 
                <value type="real" key="left">3.41e+02</value>
13633 13633 
                <value type="int" key="locked">0</value>
13634 13634 
                <value type="int" key="manualSizing">0</value>
13635 
                <value type="real" key="top">5.81e+02</value>
13635 
                <value type="real" key="top">5.85e+02</value>
13636 13636 
                <value type="real" key="width">1.4e+02</value>
13637 13637 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13638 13638 
                <value type="int" key="visible">1</value>
......
13932 13932 
                <value type="real" key="left">5.54e+02</value>
13933 13933 
                <value type="int" key="locked">0</value>
13934 13934 
                <value type="int" key="manualSizing">0</value>
13935 
                <value type="real" key="top">6.69e+02</value>
13935 
                <value type="real" key="top">7.03e+02</value>
13936 13936 
                <value type="real" key="width">1.4e+02</value>
13937 13937 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13938 13938 
                <value type="int" key="visible">1</value>
......
13952 13952 
                <value type="real" key="left">2.66e+02</value>
13953 13953 
                <value type="int" key="locked">0</value>
13954 13954 
                <value type="int" key="manualSizing">0</value>
13955 
                <value type="real" key="top">1.5e+01</value>
13955 
                <value type="real" key="top">1.9e+01</value>
13956 13956 
                <value type="real" key="width">1.36e+02</value>
13957 13957 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13958 13958 
                <value type="int" key="visible">1</value>
......
14112 14112 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14113 14113 
        <value _ptr_="0xab85450" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14114 14114 
        <value _ptr_="0xa229c20" type="dict" key="syncProfiles">
14115 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="994875b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14116 
            <value _ptr_="0xbe90000" type="dict" key="lastKnownDBNames">
14115 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="707e8ab8-f981-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14116 
            <value _ptr_="0xc1f9880" type="dict" key="lastKnownDBNames">
14117 14117 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14118 14118 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14119 14119 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14334 14334 
              <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>
14335 14335 
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>
14336 14336 
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
14337 
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
14337 14338 
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
14338 14339 
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
14339 14340 
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
......
14342 14343 
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
14343 14344 
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
14344 14345 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
14345 
              <value type="string" key="b37dc2a8-a6fb-11e2-9461-080027bcf912">fk_subplot_plot1</value>
14346 14346 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
14347 14347 
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
14348 14348 
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
......
14433 14433 
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
14434 14434 
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
14435 14435 
              <value type="string" key="be8f60ea-a6e0-11e2-95e9-080027bcf912">fk_soil_observation_place_observation1</value>
14436 
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplot</value>
14436 
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">rel_place</value>
14437 14437 
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
14438 14438 
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
14439 14439 
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">scrubbed_geoplace</value>
......
14635 14635 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14636 14636 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14637 14637 
      <value type="string" key="caption">New Model</value>
14638 
      <value type="string" key="dateChanged">2013-07-30 18:22</value>
14638 
      <value type="string" key="dateChanged">2013-07-30 18:36</value>
14639 14639 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14640 14640 
      <value type="string" key="description"></value>
14641 14641 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
605 605 
/*!40000 ALTER TABLE `referenced_class` ENABLE KEYS */;
606 606 

  		




  607
  607
  
    
--


  		




  
  608
  
    
-- Table structure for table `rel_place`


  		




  
  609
  
    
--


  		




  
  610
  
    

  		




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


  		




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


  		




  
  613
  
    
CREATE TABLE `rel_place` (


  		




  
  614
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  615
  
    
  `x_m` double DEFAULT NULL,


  		




  
  616
  
    
  `y_m` double DEFAULT NULL,


  		




  
  617
  
    
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  
  618
  
    
  PRIMARY KEY (`id`),


  		




  
  619
  
    
  CONSTRAINT `fk_subplot_place2` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  620
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))';


  		




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


  		




  
  622
  
    

  		




  
  623
  
    
--


  		




  
  624
  
    
-- Dumping data for table `rel_place`


  		




  
  625
  
    
--


  		




  
  626
  
    

  		




  
  627
  
    
/*!40000 ALTER TABLE `rel_place` DISABLE KEYS */;


  		




  
  628
  
    
/*!40000 ALTER TABLE `rel_place` ENABLE KEYS */;


  		




  
  629
  
    

  		




  
  630
  
    
--


  		




  608
  631
  
    
-- Table structure for table `relationship`


  		




  609
  632
  
    
--


  		




  610
  633
  
    

  		




  ......




  899
  922
  
    
/*!40000 ALTER TABLE `stratum` ENABLE KEYS */;


  		




  900
  923
  
    

  		




  901
  924
  
    
--


  		




  902
  
  
    
-- Table structure for table `subplot`


  		




  903
  
  
    
--


  		




  904
  
  
    

  		




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


  		




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


  		




  907
  
  
    
CREATE TABLE `subplot` (


  		




  908
  
  
    
  `id` varbinary(767) NOT NULL,


  		




  909
  
  
    
  `x_m` double DEFAULT NULL,


  		




  910
  
  
    
  `y_m` double DEFAULT NULL,


  		




  911
  
  
    
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  912
  
  
    
  PRIMARY KEY (`id`),


  		




  913
  
  
    
  CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  914
  
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)';


  		




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


  		




  916
  
  
    

  		




  917
  
  
    
--


  		




  918
  
  
    
-- Dumping data for table `subplot`


  		




  919
  
  
    
--


  		




  920
  
  
    

  		




  921
  
  
    
/*!40000 ALTER TABLE `subplot` DISABLE KEYS */;


  		




  922
  
  
    
/*!40000 ALTER TABLE `subplot` ENABLE KEYS */;


  		




  923
  
  
    

  		




  924
  
  
    
--


  		




  925
  925
  
    
-- Table structure for table `taxon_absence`


  		




  926
  926
  
    
--


  		




  927
  927
  
    

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  607
  607
  
    
/*!40000 ALTER TABLE "referenced_class" ENABLE KEYS */;


  		




  608
  608
  
    

  		




  609
  609
  
    
--


  		




  
  610
  
    
-- Table structure for table "rel_place"


  		




  
  611
  
    
--


  		




  
  612
  
    

  		




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


  		




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


  		




  
  615
  
    
CREATE TABLE "rel_place" (


  		




  
  616
  
    
  "id" text NOT NULL,


  		




  
  617
  
    
  "x_m" double precision DEFAULT NULL,


  		




  
  618
  
    
  "y_m" double precision DEFAULT NULL,


  		




  
  619
  
    
  "coords" hstore DEFAULT NULL,


  		




  
  620
  
    
  PRIMARY KEY ("id"),


  		




  
  621
  
    
  /*CONSTRAINT "fk_subplot_place2" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  622
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;


  		




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


  		




  
  624
  
    

  		




  
  625
  
    
--


  		




  
  626
  
    
-- Dumping data for table "rel_place"


  		




  
  627
  
    
--


  		




  
  628
  
    

  		




  
  629
  
    
/*!40000 ALTER TABLE "rel_place" DISABLE KEYS */;


  		




  
  630
  
    
/*!40000 ALTER TABLE "rel_place" ENABLE KEYS */;


  		




  
  631
  
    

  		




  
  632
  
    
--


  		




  610
  633
  
    
-- Table structure for table "relationship"


  		




  611
  634
  
    
--


  		




  612
  635
  
    

  		




  ......




  901
  924
  
    
/*!40000 ALTER TABLE "stratum" ENABLE KEYS */;


  		




  902
  925
  
    

  		




  903
  926
  
    
--


  		




  904
  
  
    
-- Table structure for table "subplot"


  		




  905
  
  
    
--


  		




  906
  
  
    

  		




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


  		




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


  		




  909
  
  
    
CREATE TABLE "subplot" (


  		




  910
  
  
    
  "id" text NOT NULL,


  		




  911
  
  
    
  "x_m" double precision DEFAULT NULL,


  		




  912
  
  
    
  "y_m" double precision DEFAULT NULL,


  		




  913
  
  
    
  "coords" hstore DEFAULT NULL,


  		




  914
  
  
    
  PRIMARY KEY ("id"),


  		




  915
  
  
    
  /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  916
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)'*/;


  		




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


  		




  918
  
  
    

  		




  919
  
  
    
--


  		




  920
  
  
    
-- Dumping data for table "subplot"


  		




  921
  
  
    
--


  		




  922
  
  
    

  		




  923
  
  
    
/*!40000 ALTER TABLE "subplot" DISABLE KEYS */;


  		




  924
  
  
    
/*!40000 ALTER TABLE "subplot" ENABLE KEYS */;


  		




  925
  
  
    

  		




  926
  
  
    
--


  		




  927
  927
  
    
-- Table structure for table "taxon_absence"


  		




  928
  928
  
    
--


  		




  929
  929
  
    

  		












Also available in:  Unified diff