Project

General

Profile

« Previous | Next » 

Revision 11220

schemas/VegCore/ERD/VegCore.ERD.mwb: taxa_sampling_event.parent (inherited): require this to be a taxa_sampling_event. documented that this is the taxa_sampling_event for the parent stratum.

View differences:

schemas/VegCore/ERD/document.mwb.xml
10739 10739
                      <value type="string" key="oldName">id</value>
10740 10740
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10741 10741
                    </value>
10742
                    <value type="object" struct-name="db.mysql.Column" id="7b3be4b0-3143-11e3-aa43-080027bcf912" struct-checksum="0x783b5183">
10743
                      <value type="int" key="autoIncrement">0</value>
10744
                      <value type="string" key="characterSetName"></value>
10745
                      <value _ptr_="0xc8fbe00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10746
                      <value type="string" key="collationName"></value>
10747
                      <value type="string" key="datatypeExplicitParams"></value>
10748
                      <value type="string" key="defaultValue"></value>
10749
                      <value type="int" key="defaultValueIsNull">1</value>
10750
                      <value _ptr_="0xc6d1610" type="list" content-type="string" key="flags"/>
10751
                      <value type="int" key="isNotNull">0</value>
10752
                      <value type="int" key="length">767</value>
10753
                      <value type="int" key="precision">-1</value>
10754
                      <value type="int" key="scale">-1</value>
10755
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10756
                      <value type="string" key="comment">the taxa_sampling_event for the parent stratum</value>
10757
                      <value type="string" key="name">parent</value>
10758
                      <value type="string" key="oldName">parent</value>
10759
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10760
                    </value>
10742 10761
                    <value type="object" struct-name="db.mysql.Column" id="b7749e74-2985-11e3-a80d-080027bcf912" struct-checksum="0x783b5183">
10743 10762
                      <value type="int" key="autoIncrement">0</value>
10744 10763
                      <value type="string" key="characterSetName"></value>
......
10804 10823
                      <value type="string" key="name">fk_project_event10</value>
10805 10824
                      <value type="string" key="oldName">fk_project_event10</value>
10806 10825
                    </value>
10807
                    <value type="object" struct-name="db.mysql.ForeignKey" id="b7749c3a-2985-11e3-a80d-080027bcf912" struct-checksum="0x70a8fc40">
10808
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f387c-a6e0-11e2-95e9-080027bcf912</link>
10809
                      <value _ptr_="0xba12940" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10810
                        <link type="object">b7749e74-2985-11e3-a80d-080027bcf912</link>
10826
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7b3be21c-3143-11e3-aa43-080027bcf912" struct-checksum="0x70a8fc40">
10827
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
10828
                      <value _ptr_="0xc65fc18" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10829
                        <link type="object">7b3be4b0-3143-11e3-aa43-080027bcf912</link>
10811 10830
                      </value>
10812 10831
                      <value type="int" key="deferability">0</value>
10813 10832
                      <value type="string" key="deleteRule">CASCADE</value>
10814
                      <link type="object" struct-name="db.Index" key="index">b774c534-2985-11e3-a80d-080027bcf912</link>
10833
                      <link type="object" struct-name="db.Index" key="index">7b3c062a-3143-11e3-aa43-080027bcf912</link>
10815 10834
                      <value type="int" key="mandatory">1</value>
10816 10835
                      <value type="int" key="many">1</value>
10817 10836
                      <value type="int" key="modelOnly">0</value>
10818 10837
                      <link type="object" struct-name="db.Table" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10819
                      <value _ptr_="0xba12cc8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10820
                        <link type="object">be8f3ade-a6e0-11e2-95e9-080027bcf912</link>
10838
                      <value _ptr_="0xd2e2fe0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10839
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
10821 10840
                      </value>
10822
                      <value type="int" key="referencedMandatory">1</value>
10841
                      <value type="int" key="referencedMandatory">0</value>
10823 10842
                      <value type="string" key="updateRule">CASCADE</value>
10824 10843
                      <value type="string" key="comment"></value>
10825
                      <value type="string" key="name">taxa_sampling_event_id_fkey1</value>
10826
                      <value type="string" key="oldName">taxa_sampling_event_id_fkey1</value>
10844
                      <value type="string" key="name">taxa_sampling_event_id_fkey2</value>
10845
                      <value type="string" key="oldName">taxa_sampling_event_id_fkey2</value>
10827 10846
                    </value>
10828 10847
                    <value type="object" struct-name="db.mysql.ForeignKey" id="a841b894-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">
10829 10848
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d8c2a-a6e0-11e2-95e9-080027bcf912</link>
......
10846 10865
                      <value type="string" key="name">fk_sampling_event_method1</value>
10847 10866
                      <value type="string" key="oldName">fk_sampling_event_method1</value>
10848 10867
                    </value>
10868
                    <value type="object" struct-name="db.mysql.ForeignKey" id="b7749c3a-2985-11e3-a80d-080027bcf912" struct-checksum="0x70a8fc40">
10869
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f387c-a6e0-11e2-95e9-080027bcf912</link>
10870
                      <value _ptr_="0xba12940" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10871
                        <link type="object">b7749e74-2985-11e3-a80d-080027bcf912</link>
10872
                      </value>
10873
                      <value type="int" key="deferability">0</value>
10874
                      <value type="string" key="deleteRule">CASCADE</value>
10875
                      <link type="object" struct-name="db.Index" key="index">b774c534-2985-11e3-a80d-080027bcf912</link>
10876
                      <value type="int" key="mandatory">1</value>
10877
                      <value type="int" key="many">1</value>
10878
                      <value type="int" key="modelOnly">0</value>
10879
                      <link type="object" struct-name="db.Table" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10880
                      <value _ptr_="0xba12cc8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10881
                        <link type="object">be8f3ade-a6e0-11e2-95e9-080027bcf912</link>
10882
                      </value>
10883
                      <value type="int" key="referencedMandatory">1</value>
10884
                      <value type="string" key="updateRule">CASCADE</value>
10885
                      <value type="string" key="comment"></value>
10886
                      <value type="string" key="name">taxa_sampling_event_id_fkey1</value>
10887
                      <value type="string" key="oldName">taxa_sampling_event_id_fkey1</value>
10888
                    </value>
10849 10889
                  </value>
10850 10890
                  <value _ptr_="0xba114c0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
10851 10891
                    <value type="object" struct-name="db.mysql.Index" id="7f177760-f6c0-11e2-af44-080027bcf912" struct-checksum="0x309b847a">
......
10871 10911
                      <value type="string" key="oldName">PRIMARY</value>
10872 10912
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10873 10913
                    </value>
10914
                    <value type="object" struct-name="db.mysql.Index" id="21d06e5c-3137-11e3-aa43-080027bcf912" struct-checksum="0x309b847a">
10915
                      <value _ptr_="0xc530718" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10916
                        <value type="object" struct-name="db.mysql.IndexColumn" id="27d7e0aa-3137-11e3-aa43-080027bcf912" struct-checksum="0x62630b3c">
10917
                          <value type="int" key="columnLength">0</value>
10918
                          <value type="string" key="comment"></value>
10919
                          <value type="int" key="descend">0</value>
10920
                          <link type="object" struct-name="db.Column" key="referencedColumn">b7749e74-2985-11e3-a80d-080027bcf912</link>
10921
                          <value type="string" key="name"></value>
10922
                          <link type="object" struct-name="GrtObject" key="owner">21d06e5c-3137-11e3-aa43-080027bcf912</link>
10923
                        </value>
10924
                        <value type="object" struct-name="db.mysql.IndexColumn" id="283ac0ee-3137-11e3-aa43-080027bcf912" struct-checksum="0x62630b3c">
10925
                          <value type="int" key="columnLength">0</value>
10926
                          <value type="string" key="comment"></value>
10927
                          <value type="int" key="descend">0</value>
10928
                          <link type="object" struct-name="db.Column" key="referencedColumn">a841ba7e-f6c0-11e2-af44-080027bcf912</link>
10929
                          <value type="string" key="name"></value>
10930
                          <link type="object" struct-name="GrtObject" key="owner">21d06e5c-3137-11e3-aa43-080027bcf912</link>
10931
                        </value>
10932
                      </value>
10933
                      <value type="string" key="indexKind"></value>
10934
                      <value type="int" key="keyBlockSize">0</value>
10935
                      <value type="string" key="withParser"></value>
10936
                      <value type="string" key="comment"></value>
10937
                      <value type="int" key="deferability">0</value>
10938
                      <value type="string" key="indexType">UNIQUE</value>
10939
                      <value type="int" key="isPrimary">0</value>
10940
                      <value type="string" key="name">taxa_sampling_event__unique</value>
10941
                      <value type="int" key="unique">1</value>
10942
                      <value type="string" key="oldName">taxa_sampling_event__unique</value>
10943
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10944
                    </value>
10874 10945
                    <value type="object" struct-name="db.mysql.Index" id="a842920a-f6c0-11e2-af44-080027bcf912" struct-checksum="0x309b847a">
10875 10946
                      <value _ptr_="0xba13530" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10876 10947
                        <value type="object" struct-name="db.mysql.IndexColumn" id="a842b0fa-f6c0-11e2-af44-080027bcf912" struct-checksum="0x62630b3c">
......
10917 10988
                      <value type="string" key="oldName">taxa_sampling_event_id_fkey1_idx</value>
10918 10989
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10919 10990
                    </value>
10920
                    <value type="object" struct-name="db.mysql.Index" id="21d06e5c-3137-11e3-aa43-080027bcf912" struct-checksum="0x309b847a">
10921
                      <value _ptr_="0xc530718" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10922
                        <value type="object" struct-name="db.mysql.IndexColumn" id="27d7e0aa-3137-11e3-aa43-080027bcf912" struct-checksum="0x62630b3c">
10991
                    <value type="object" struct-name="db.mysql.Index" id="7b3c062a-3143-11e3-aa43-080027bcf912" struct-checksum="0x309b847a">
10992
                      <value _ptr_="0xc97a990" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10993
                        <value type="object" struct-name="db.mysql.IndexColumn" id="7b3c0850-3143-11e3-aa43-080027bcf912" struct-checksum="0x62630b3c">
10923 10994
                          <value type="int" key="columnLength">0</value>
10924 10995
                          <value type="string" key="comment"></value>
10925 10996
                          <value type="int" key="descend">0</value>
10926
                          <link type="object" struct-name="db.Column" key="referencedColumn">b7749e74-2985-11e3-a80d-080027bcf912</link>
10997
                          <link type="object" struct-name="db.Column" key="referencedColumn">7b3be4b0-3143-11e3-aa43-080027bcf912</link>
10927 10998
                          <value type="string" key="name"></value>
10928
                          <link type="object" struct-name="GrtObject" key="owner">21d06e5c-3137-11e3-aa43-080027bcf912</link>
10999
                          <link type="object" struct-name="GrtObject" key="owner">7b3c062a-3143-11e3-aa43-080027bcf912</link>
10929 11000
                        </value>
10930
                        <value type="object" struct-name="db.mysql.IndexColumn" id="283ac0ee-3137-11e3-aa43-080027bcf912" struct-checksum="0x62630b3c">
10931
                          <value type="int" key="columnLength">0</value>
10932
                          <value type="string" key="comment"></value>
10933
                          <value type="int" key="descend">0</value>
10934
                          <link type="object" struct-name="db.Column" key="referencedColumn">a841ba7e-f6c0-11e2-af44-080027bcf912</link>
10935
                          <value type="string" key="name"></value>
10936
                          <link type="object" struct-name="GrtObject" key="owner">21d06e5c-3137-11e3-aa43-080027bcf912</link>
10937
                        </value>
10938 11001
                      </value>
10939 11002
                      <value type="string" key="indexKind"></value>
10940 11003
                      <value type="int" key="keyBlockSize">0</value>
10941 11004
                      <value type="string" key="withParser"></value>
10942 11005
                      <value type="string" key="comment"></value>
10943 11006
                      <value type="int" key="deferability">0</value>
10944
                      <value type="string" key="indexType">UNIQUE</value>
11007
                      <value type="string" key="indexType">INDEX</value>
10945 11008
                      <value type="int" key="isPrimary">0</value>
10946
                      <value type="string" key="name">taxa_sampling_event__unique</value>
10947
                      <value type="int" key="unique">1</value>
10948
                      <value type="string" key="oldName">taxa_sampling_event__unique</value>
11009
                      <value type="string" key="name">taxa_sampling_event_id_fkey2_idx</value>
11010
                      <value type="int" key="unique">0</value>
11011
                      <value type="string" key="oldName">taxa_sampling_event_id_fkey2_idx</value>
10949 11012
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10950 11013
                    </value>
10951 11014
                  </value>
......
10979 11042
                  <value type="int" key="commentedOut">0</value>
10980 11043
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10981 11044
                  <value _ptr_="0xba11248" type="dict" key="customData"/>
10982
                  <value type="string" key="lastChangeDate">2013-10-09 16:18</value>
11045
                  <value type="string" key="lastChangeDate">2013-10-09 17:35</value>
10983 11046
                  <value type="int" key="modelOnly">0</value>
10984 11047
                  <value type="string" key="name">taxa_sampling_event</value>
10985 11048
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15968 16031
                <value type="int" key="visible">1</value>
15969 16032
                <value type="string" key="name"></value>
15970 16033
              </value>
16034
              <value type="object" struct-name="workbench.physical.Connection" id="7b3c11f6-3143-11e3-aa43-080027bcf912" struct-checksum="0x9baebc92">
16035
                <value type="string" key="caption">taxa_sampling_event_id_fkey2</value>
16036
                <value type="real" key="captionXOffs">0.e+00</value>
16037
                <value type="real" key="captionYOffs">0.e+00</value>
16038
                <value type="string" key="comment"></value>
16039
                <value type="real" key="endCaptionXOffs">0.e+00</value>
16040
                <value type="real" key="endCaptionYOffs">0.e+00</value>
16041
                <value type="string" key="extraCaption"></value>
16042
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
16043
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
16044
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7b3be21c-3143-11e3-aa43-080027bcf912</link>
16045
                <value type="real" key="middleSegmentOffset">0.e+00</value>
16046
                <value type="real" key="startCaptionXOffs">0.e+00</value>
16047
                <value type="real" key="startCaptionYOffs">0.e+00</value>
16048
                <value type="int" key="drawSplit">0</value>
16049
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
16050
                <link type="object" struct-name="model.Figure" key="startFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
16051
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16052
                <value type="int" key="visible">1</value>
16053
                <value type="string" key="name"></value>
16054
              </value>
15971 16055
            </value>
15972 16056
            <value type="string" key="description"></value>
15973 16057
            <value _ptr_="0xba36450" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
16140 16224
                <value type="real" key="left">6.96e+02</value>
16141 16225
                <value type="int" key="locked">0</value>
16142 16226
                <value type="int" key="manualSizing">0</value>
16143
                <value type="real" key="top">7.67e+02</value>
16227
                <value type="real" key="top">7.9e+02</value>
16144 16228
                <value type="real" key="width">9.3e+01</value>
16145 16229
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16146 16230
                <value type="int" key="visible">1</value>
......
16177 16261
                <value type="int" key="expanded">1</value>
16178 16262
                <value type="real" key="height">2.61e+02</value>
16179 16263
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16180
                <value type="real" key="left">3.74e+02</value>
16264
                <value type="real" key="left">3.67e+02</value>
16181 16265
                <value type="int" key="locked">0</value>
16182 16266
                <value type="int" key="manualSizing">0</value>
16183 16267
                <value type="real" key="top">8.72e+02</value>
......
16217 16301
                <value type="int" key="expanded">1</value>
16218 16302
                <value type="real" key="height">1.23e+02</value>
16219 16303
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16220
                <value type="real" key="left">5.43e+02</value>
16304
                <value type="real" key="left">5.36e+02</value>
16221 16305
                <value type="int" key="locked">0</value>
16222 16306
                <value type="int" key="manualSizing">0</value>
16223 16307
                <value type="real" key="top">1.019e+03</value>
......
16237 16321
                <value type="int" key="expanded">1</value>
16238 16322
                <value type="real" key="height">1.e+02</value>
16239 16323
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16240
                <value type="real" key="left">4.22e+02</value>
16324
                <value type="real" key="left">4.15e+02</value>
16241 16325
                <value type="int" key="locked">0</value>
16242 16326
                <value type="int" key="manualSizing">0</value>
16243 16327
                <value type="real" key="top">1.174e+03</value>
......
16257 16341
                <value type="int" key="expanded">1</value>
16258 16342
                <value type="real" key="height">1.e+02</value>
16259 16343
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16260
                <value type="real" key="left">2.97e+02</value>
16344
                <value type="real" key="left">2.9e+02</value>
16261 16345
                <value type="int" key="locked">0</value>
16262 16346
                <value type="int" key="manualSizing">0</value>
16263 16347
                <value type="real" key="top">1.174e+03</value>
......
17181 17265
                <value type="int" key="triggersExpanded">0</value>
17182 17266
                <value type="string" key="color">#66ffff</value>
17183 17267
                <value type="int" key="expanded">1</value>
17184
                <value type="real" key="height">1.e+02</value>
17268
                <value type="real" key="height">1.23e+02</value>
17185 17269
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17186 17270
                <value type="real" key="left">6.29e+02</value>
17187 17271
                <value type="int" key="locked">0</value>
......
17405 17489
                <value type="real" key="left">6.88e+02</value>
17406 17490
                <value type="int" key="locked">0</value>
17407 17491
                <value type="int" key="manualSizing">0</value>
17408
                <value type="real" key="top">9.19e+02</value>
17492
                <value type="real" key="top">9.42e+02</value>
17409 17493
                <value type="real" key="width">1.09e+02</value>
17410 17494
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17411 17495
                <value type="int" key="visible">1</value>
......
17690 17774
              <value type="string" key="name"></value>
17691 17775
            </value>
17692 17776
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17693
              <link type="object">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
17777
              <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
17694 17778
            </value>
17695 17779
            <value type="int" key="updateBlocked">0</value>
17696 17780
            <value type="real" key="width">1.6215e+03</value>
......
17704 17788
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17705 17789
        <value _ptr_="0xb986d58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17706 17790
        <value _ptr_="0xb1a9c10" type="dict" key="syncProfiles">
17707
          <value type="object" struct-name="db.mgmt.SyncProfile" id="f84f18f6-313d-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17708
            <value _ptr_="0xd048ec0" type="dict" key="lastKnownDBNames">
17791
          <value type="object" struct-name="db.mgmt.SyncProfile" id="0cffa544-3144-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17792
            <value _ptr_="0xd610598" type="dict" key="lastKnownDBNames">
17709 17793
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17710 17794
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17711 17795
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17957 18041
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>
17958 18042
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
17959 18043
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
18044
              <value type="string" key="7b3be21c-3143-11e3-aa43-080027bcf912">taxa_sampling_event_id_fkey2</value>
18045
              <value type="string" key="7b3be4b0-3143-11e3-aa43-080027bcf912">parent</value>
18046
              <value type="string" key="7b3c062a-3143-11e3-aa43-080027bcf912">taxa_sampling_event_id_fkey2_idx</value>
17960 18047
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
17961 18048
              <value type="string" key="7cd351c8-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1</value>
17962 18049
              <value type="string" key="7cd35394-1168-11e3-8d7f-080027bcf912">individual_observation</value>
......
18339 18426
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18340 18427
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18341 18428
      <value type="string" key="caption">New Model</value>
18342
      <value type="string" key="dateChanged">2013-10-09 17:15</value>
18429
      <value type="string" key="dateChanged">2013-10-09 17:36</value>
18343 18430
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18344 18431
      <value type="string" key="description"></value>
18345 18432
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1065 1065
/*!40101 SET character_set_client = utf8 */;
1066 1066
CREATE TABLE `taxa_sampling_event` (
1067 1067
  `id` varbinary(767) NOT NULL,
1068
  `parent` varbinary(767) DEFAULT NULL COMMENT 'the taxa_sampling_event for the parent stratum',
1068 1069
  `place_visit` varbinary(767) NOT NULL,
1069 1070
  `subsetting_method` varbinary(767) DEFAULT NULL,
1070 1071
  PRIMARY KEY (`id`),
1071 1072
  UNIQUE KEY `taxa_sampling_event__unique` (`place_visit`,`subsetting_method`),
1072 1073
  KEY `fk_sampling_event_method1_idx` (`subsetting_method`),
1073 1074
  KEY `taxa_sampling_event_id_fkey1_idx` (`place_visit`),
1074
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_visit`) REFERENCES `place_visit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1075
  KEY `taxa_sampling_event_id_fkey2_idx` (`parent`),
1075 1076
  CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1076
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`subsetting_method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1077
  CONSTRAINT `taxa_sampling_event_id_fkey2` FOREIGN KEY (`parent`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1078
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`subsetting_method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1079
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_visit`) REFERENCES `place_visit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1077 1080
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)';
1078 1081
/*!40101 SET character_set_client = @saved_cs_client */;
1079 1082

  
schemas/VegCore/VegCore.pg.sql
1067 1067
/*!40101 SET character_set_client = utf8 */;
1068 1068
CREATE TABLE "taxa_sampling_event" (
1069 1069
  "id" text NOT NULL,
1070
  "parent" text DEFAULT NULL /*COMMENT 'the taxa_sampling_event for the parent stratum'*/,
1070 1071
  "place_visit" text NOT NULL,
1071 1072
  "subsetting_method" text DEFAULT NULL,
1072 1073
  PRIMARY KEY ("id"),
1073 1074
  /*CONSTRAINT "taxa_sampling_event__unique" */UNIQUE ("place_visit","subsetting_method"),
1074 1075
  /*KEY "fk_sampling_event_method1_idx" ("subsetting_method")*/CHECK (true),
1075 1076
  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_visit")*/CHECK (true),
1076
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_visit") REFERENCES "place_visit" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1077
  /*KEY "taxa_sampling_event_id_fkey2_idx" ("parent")*/CHECK (true),
1077 1078
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1078
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("subsetting_method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1079
  /*CONSTRAINT "taxa_sampling_event_id_fkey2" FOREIGN KEY ("parent") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1080
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("subsetting_method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1081
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_visit") REFERENCES "place_visit" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1079 1082
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)'*/;
1080 1083
/*!40101 SET character_set_client = @saved_cs_client */;
1081 1084

  

Also available in: Unified diff