Project

General

Profile

« Previous | Next » 

Revision 8676

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: changed taxon_name fkeys to taxon_concept where appropriate, and renamed the referencing columns to *_taxon_concept to clearly indicate the referenced table. taxon_concept fkeys are appropriate whenever a taxon is defined or associated with an observed entity, in which case the assertion is not just to a taxon name but to a defined taxon concept (albeit sometimes an unofficial taxon concept scoped by the collector or identifier).

View differences:

schemas/VegCore/document.mwb.xml
1711 1711 
                      <value type="int" key="scale">-1</value>
1712 1712 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1713 1713 
                      <value type="string" key="comment"></value>
1714 
                      <value type="string" key="name">matched_taxon</value>
1714 
                      <value type="string" key="name">matched_taxon_concept</value>
1715 1715 
                      <value type="string" key="oldName">matched_taxon</value>
1716 1716 
                      <link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1717 1717 
                    </value>
......
1781 1781 
                      <value type="string" key="oldName">fk_matched_taxon_qualified_taxon10</value>
1782 1782 
                    </value>
1783 1783 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="a3e070f8-a77c-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
1784 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f12b8-a780-11e2-afd5-080027bcf912</link>
1784 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
1785 1785 
                      <value _ptr_="0xa71cea8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1786 1786 
                        <link type="object">be8fb7a2-a6e0-11e2-95e9-080027bcf912</link>
1787 1787 
                      </value>
1788 1788 
                      <value type="int" key="deferability">0</value>
1789 1789 
                      <value type="string" key="deleteRule">CASCADE</value>
1790 
                      <link type="object" struct-name="db.Index" key="index">a3e07684-a77c-11e2-afd5-080027bcf912</link>
1790 
                      <link type="object" struct-name="db.Index" key="index">9b6b7d6a-ad0c-11e2-b309-080027bcf912</link>
1791 1791 
                      <value type="int" key="mandatory">1</value>
1792 1792 
                      <value type="int" key="many">1</value>
1793 1793 
                      <value type="int" key="modelOnly">0</value>
1794 1794 
                      <link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1795 1795 
                      <value _ptr_="0xa71d198" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1796 
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
1796 
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
1797 1797 
                      </value>
1798 1798 
                      <value type="int" key="referencedMandatory">1</value>
1799 1799 
                      <value type="string" key="updateRule">CASCADE</value>
......
1826 1826 
                      <value type="string" key="oldName">PRIMARY</value>
1827 1827 
                      <link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1828 1828 
                    </value>
1829 
                    <value type="object" struct-name="db.mysql.Index" id="a3e07684-a77c-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
1830 
                      <value _ptr_="0xa71d570" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1831 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="a3e078f0-a77c-11e2-afd5-080027bcf912" struct-checksum="0x62630b3c">
1829 
                    <value type="object" struct-name="db.mysql.Index" id="9b6b7d6a-ad0c-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
1830 
                      <value _ptr_="0xb958eb8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1831 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9b6c8c14-ad0c-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
1832 1832 
                          <value type="int" key="columnLength">0</value>
1833 1833 
                          <value type="string" key="comment"></value>
1834 1834 
                          <value type="int" key="descend">0</value>
1835 1835 
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8fb7a2-a6e0-11e2-95e9-080027bcf912</link>
1836 1836 
                          <value type="string" key="name"></value>
1837 
                          <link type="object" struct-name="GrtObject" key="owner">a3e07684-a77c-11e2-afd5-080027bcf912</link>
1837 
                          <link type="object" struct-name="GrtObject" key="owner">9b6b7d6a-ad0c-11e2-b309-080027bcf912</link>
1838 1838 
                        </value>
1839 1839 
                      </value>
1840 1840 
                      <value type="string" key="indexKind"></value>
......
1846 1846 
                      <value type="int" key="isPrimary">0</value>
1847 1847 
                      <value type="string" key="name">fk_parsed_taxon_assertion_taxon_name1_idx</value>
1848 1848 
                      <value type="int" key="unique">0</value>
1849 
                      <value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1_idx</value>
1849 
                      <value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value>
1850 1850 
                      <link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1851 1851 
                    </value>
1852 1852 
                  </value>
......
1880 1880 
                  <value type="int" key="commentedOut">0</value>
1881 1881 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1882 1882 
                  <value _ptr_="0xa7030c0" type="dict" key="customData"/>
1883 
                  <value type="string" key="lastChangeDate">2013-04-17 12:00</value>
1883 
                  <value type="string" key="lastChangeDate">2013-04-24 11:27</value>
1884 1884 
                  <value type="int" key="modelOnly">0</value>
1885 1885 
                  <value type="string" key="name">parsed_taxon_assertion</value>
1886 1886 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
1926 1926 
                      <value type="int" key="scale">-1</value>
1927 1927 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1928 1928 
                      <value type="string" key="comment"></value>
1929 
                      <value type="string" key="name">taxon</value>
1929 
                      <value type="string" key="name">taxon_concept</value>
1930 1930 
                      <value type="string" key="oldName">taxon</value>
1931 1931 
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
1932 1932 
                    </value>
......
1958 1958 
                      <value type="string" key="oldName">fk_aggregate_observation_taxon_occurrence1</value>
1959 1959 
                    </value>
1960 1960 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="3c9e685c-a90f-11e2-8576-080027bcf912" struct-checksum="0x70a8fc40">
1961 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f12b8-a780-11e2-afd5-080027bcf912</link>
1961 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
1962 1962 
                      <value _ptr_="0x9fb7d40" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1963 1963 
                        <link type="object">3c9e6a14-a90f-11e2-8576-080027bcf912</link>
1964 1964 
                      </value>
1965 1965 
                      <value type="int" key="deferability">0</value>
1966 1966 
                      <value type="string" key="deleteRule">CASCADE</value>
1967 
                      <link type="object" struct-name="db.Index" key="index">3c9e8fda-a90f-11e2-8576-080027bcf912</link>
1967 
                      <link type="object" struct-name="db.Index" key="index">a622b3dc-ad0b-11e2-b309-080027bcf912</link>
1968 1968 
                      <value type="int" key="mandatory">1</value>
1969 1969 
                      <value type="int" key="many">1</value>
1970 1970 
                      <value type="int" key="modelOnly">0</value>
1971 1971 
                      <link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
1972 1972 
                      <value _ptr_="0x9fb7be0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1973 
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
1973 
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
1974 1974 
                      </value>
1975 1975 
                      <value type="int" key="referencedMandatory">1</value>
1976 1976 
                      <value type="string" key="updateRule">CASCADE</value>
......
2003 2003 
                      <value type="string" key="oldName">PRIMARY</value>
2004 2004 
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2005 2005 
                    </value>
2006 
                    <value type="object" struct-name="db.mysql.Index" id="3c9e8fda-a90f-11e2-8576-080027bcf912" struct-checksum="0x309b847a">
2007 
                      <value _ptr_="0x936a220" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2008 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="3c9e914c-a90f-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
2006 
                    <value type="object" struct-name="db.mysql.Index" id="a622b3dc-ad0b-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
2007 
                      <value _ptr_="0xbff3518" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2008 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="a623e720-ad0b-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
2009 2009 
                          <value type="int" key="columnLength">0</value>
2010 2010 
                          <value type="string" key="comment"></value>
2011 2011 
                          <value type="int" key="descend">0</value>
2012 2012 
                          <link type="object" struct-name="db.Column" key="referencedColumn">3c9e6a14-a90f-11e2-8576-080027bcf912</link>
2013 2013 
                          <value type="string" key="name"></value>
2014 
                          <link type="object" struct-name="GrtObject" key="owner">3c9e8fda-a90f-11e2-8576-080027bcf912</link>
2014 
                          <link type="object" struct-name="GrtObject" key="owner">a622b3dc-ad0b-11e2-b309-080027bcf912</link>
2015 2015 
                        </value>
2016 2016 
                      </value>
2017 2017 
                      <value type="string" key="indexKind"></value>
......
2057 2057 
                  <value type="int" key="commentedOut">0</value>
2058 2058 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2059 2059 
                  <value _ptr_="0x9fb35c0" type="dict" key="customData"/>
2060 
                  <value type="string" key="lastChangeDate">2013-04-23 11:41</value>
2060 
                  <value type="string" key="lastChangeDate">2013-04-24 11:25</value>
2061 2061 
                  <value type="int" key="modelOnly">0</value>
2062 2062 
                  <value type="string" key="name">aggregate_observation</value>
2063 2063 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
2103 2103 
                      <value type="int" key="scale">-1</value>
2104 2104 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2105 2105 
                      <value type="string" key="comment"></value>
2106 
                      <value type="string" key="name">taxon</value>
2106 
                      <value type="string" key="name">taxon_concept</value>
2107 2107 
                      <value type="string" key="oldName">taxon</value>
2108 2108 
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2109 2109 
                    </value>
......
2134 2134 
                      <value type="string" key="oldName">fk_taxon_observation_taxon_occurrence1</value>
2135 2135 
                    </value>
2136 2136 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0621717a-a90f-11e2-8576-080027bcf912" struct-checksum="0x70a8fc40">
2137 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f12b8-a780-11e2-afd5-080027bcf912</link>
2137 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
2138 2138 
                      <value _ptr_="0xa4b1ab8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2139 2139 
                        <link type="object">06217332-a90f-11e2-8576-080027bcf912</link>
2140 2140 
                      </value>
2141 2141 
                      <value type="int" key="deferability">0</value>
2142 2142 
                      <value type="string" key="deleteRule">CASCADE</value>
2143 
                      <link type="object" struct-name="db.Index" key="index">062193bc-a90f-11e2-8576-080027bcf912</link>
2143 
                      <link type="object" struct-name="db.Index" key="index">980eb49e-ad0b-11e2-b309-080027bcf912</link>
2144 2144 
                      <value type="int" key="mandatory">1</value>
2145 2145 
                      <value type="int" key="many">1</value>
2146 2146 
                      <value type="int" key="modelOnly">0</value>
2147 2147 
                      <link type="object" struct-name="db.Table" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2148 2148 
                      <value _ptr_="0x9fb3390" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2149 
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
2149 
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
2150 2150 
                      </value>
2151 2151 
                      <value type="int" key="referencedMandatory">1</value>
2152 2152 
                      <value type="string" key="updateRule">CASCADE</value>
......
2179 2179 
                      <value type="string" key="oldName">PRIMARY</value>
2180 2180 
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2181 2181 
                    </value>
2182 
                    <value type="object" struct-name="db.mysql.Index" id="062193bc-a90f-11e2-8576-080027bcf912" struct-checksum="0x309b847a">
2183 
                      <value _ptr_="0x9fb2148" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2184 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="06219592-a90f-11e2-8576-080027bcf912" struct-checksum="0x62630b3c">
2182 
                    <value type="object" struct-name="db.mysql.Index" id="980eb49e-ad0b-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
2183 
                      <value _ptr_="0xbd272b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2184 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="980fd0e0-ad0b-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
2185 2185 
                          <value type="int" key="columnLength">0</value>
2186 2186 
                          <value type="string" key="comment"></value>
2187 2187 
                          <value type="int" key="descend">0</value>
2188 2188 
                          <link type="object" struct-name="db.Column" key="referencedColumn">06217332-a90f-11e2-8576-080027bcf912</link>
2189 2189 
                          <value type="string" key="name"></value>
2190 
                          <link type="object" struct-name="GrtObject" key="owner">062193bc-a90f-11e2-8576-080027bcf912</link>
2190 
                          <link type="object" struct-name="GrtObject" key="owner">980eb49e-ad0b-11e2-b309-080027bcf912</link>
2191 2191 
                        </value>
2192 2192 
                      </value>
2193 2193 
                      <value type="string" key="indexKind"></value>
......
2233 2233 
                  <value type="int" key="commentedOut">0</value>
2234 2234 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2235 2235 
                  <value _ptr_="0x9fbd320" type="dict" key="customData"/>
2236 
                  <value type="string" key="lastChangeDate">2013-04-23 11:41</value>
2236 
                  <value type="string" key="lastChangeDate">2013-04-24 11:25</value>
2237 2237 
                  <value type="int" key="modelOnly">0</value>
2238 2238 
                  <value type="string" key="name">taxon_presence</value>
2239 2239 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
2317 2317 
                      <value type="int" key="scale">-1</value>
2318 2318 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2319 2319 
                      <value type="string" key="comment"></value>
2320 
                      <value type="string" key="name">accepted_taxon</value>
2320 
                      <value type="string" key="name">accepted_taxon_concept</value>
2321 2321 
                      <value type="string" key="oldName">accepted_taxon</value>
2322 2322 
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2323 2323 
                    </value>
......
2559 2559 
                  <value type="int" key="commentedOut">0</value>
2560 2560 
                  <value type="string" key="createDate">2013-04-17 09:37</value>
2561 2561 
                  <value _ptr_="0x9fce550" type="dict" key="customData"/>
2562 
                  <value type="string" key="lastChangeDate">2013-04-17 09:37</value>
2562 
                  <value type="string" key="lastChangeDate">2013-04-24 11:33</value>
2563 2563 
                  <value type="int" key="modelOnly">0</value>
2564 2564 
                  <value type="string" key="name">taxon_concept</value>
2565 2565 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
5736 5736 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5737 5737 
                      <value type="string" key="comment"></value>
5738 5738 
                      <value type="string" key="name">code_in_individual</value>
5739 
                      <value type="string" key="oldName">code</value>
5739 
                      <value type="string" key="oldName">code_in_individual</value>
5740 5740 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5741 5741 
                    </value>
5742 5742 
                    <value type="object" struct-name="db.mysql.Column" id="eb778aac-ad01-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
......
10251 10251 
                <value type="int" key="visible">1</value>
10252 10252 
                <value type="string" key="name"></value>
10253 10253 
              </value>
10254 
              <value type="object" struct-name="workbench.physical.Connection" id="71dde69a-a780-11e2-afd5-080027bcf912" struct-checksum="0x9baebc92">
10255 
                <value type="string" key="caption">fk_parsed_taxon_assertion_taxon_name1</value>
10256 
                <value type="real" key="captionXOffs">0.e+00</value>
10257 
                <value type="real" key="captionYOffs">0.e+00</value>
10258 
                <value type="string" key="comment"></value>
10259 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
10260 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
10261 
                <value type="string" key="extraCaption"></value>
10262 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
10263 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
10264 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">a3e070f8-a77c-11e2-afd5-080027bcf912</link>
10265 
                <value type="real" key="middleSegmentOffset">-6.e+00</value>
10266 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
10267 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
10268 
                <value type="int" key="drawSplit">0</value>
10269 
                <link type="object" struct-name="model.Figure" key="endFigure">00ee9e8a-a775-11e2-92a3-080027bcf912</link>
10270 
                <link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link>
10271 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
10272 
                <value type="int" key="visible">1</value>
10273 
                <value type="string" key="name"></value>
10274 
              </value>
10275 10254 
              <value type="object" struct-name="workbench.physical.Connection" id="71de040e-a780-11e2-afd5-080027bcf912" struct-checksum="0x9baebc92">
10276 10255 
                <value type="string" key="caption">fk_taxon_string_parsed_taxon_assertion1</value>
10277 10256 
                <value type="real" key="captionXOffs">0.e+00</value>
......
11049 11028 
                <value type="int" key="visible">1</value>
11050 11029 
                <value type="string" key="name"></value>
11051 11030 
              </value>
11052 
              <value type="object" struct-name="workbench.physical.Connection" id="0621aeb0-a90f-11e2-8576-080027bcf912" struct-checksum="0x9baebc92">
11053 
                <value type="string" key="caption">fk_taxon_presence_taxon_name1</value>
11054 
                <value type="real" key="captionXOffs">0.e+00</value>
11055 
                <value type="real" key="captionYOffs">0.e+00</value>
11056 
                <value type="string" key="comment"></value>
11057 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11058 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11059 
                <value type="string" key="extraCaption"></value>
11060 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11061 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11062 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">0621717a-a90f-11e2-8576-080027bcf912</link>
11063 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11064 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11065 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11066 
                <value type="int" key="drawSplit">1</value>
11067 
                <link type="object" struct-name="model.Figure" key="endFigure">00ee9e8a-a775-11e2-92a3-080027bcf912</link>
11068 
                <link type="object" struct-name="model.Figure" key="startFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
11069 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11070 
                <value type="int" key="visible">1</value>
11071 
                <value type="string" key="name"></value>
11072 
              </value>
11073 
              <value type="object" struct-name="workbench.physical.Connection" id="3c9ead58-a90f-11e2-8576-080027bcf912" struct-checksum="0x9baebc92">
11074 
                <value type="string" key="caption">fk_aggregate_observation_taxon_name1</value>
11075 
                <value type="real" key="captionXOffs">0.e+00</value>
11076 
                <value type="real" key="captionYOffs">0.e+00</value>
11077 
                <value type="string" key="comment"></value>
11078 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11079 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11080 
                <value type="string" key="extraCaption"></value>
11081 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11082 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11083 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3c9e685c-a90f-11e2-8576-080027bcf912</link>
11084 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11085 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11086 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11087 
                <value type="int" key="drawSplit">1</value>
11088 
                <link type="object" struct-name="model.Figure" key="endFigure">00ee9e8a-a775-11e2-92a3-080027bcf912</link>
11089 
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
11090 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11091 
                <value type="int" key="visible">1</value>
11092 
                <value type="string" key="name"></value>
11093 
              </value>
11094 11031 
              <value type="object" struct-name="workbench.physical.Connection" id="18e780f4-a91b-11e2-bdec-080027bcf912" struct-checksum="0x9baebc92">
11095 11032 
                <value type="string" key="caption">fk_organization_party1</value>
11096 11033 
                <value type="real" key="captionXOffs">0.e+00</value>
......
11553 11490 
                <value type="int" key="visible">1</value>
11554 11491 
                <value type="string" key="name"></value>
11555 11492 
              </value>
11493 
              <value type="object" struct-name="workbench.physical.Connection" id="980eab5c-ad0b-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11494 
                <value type="string" key="caption">fk_taxon_presence_taxon_name1</value>
11495 
                <value type="real" key="captionXOffs">0.e+00</value>
11496 
                <value type="real" key="captionYOffs">0.e+00</value>
11497 
                <value type="string" key="comment"></value>
11498 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11499 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11500 
                <value type="string" key="extraCaption"></value>
11501 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11502 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11503 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">0621717a-a90f-11e2-8576-080027bcf912</link>
11504 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11505 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11506 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11507 
                <value type="int" key="drawSplit">1</value>
11508 
                <link type="object" struct-name="model.Figure" key="endFigure">8932D751-419A-4213-960A-F4E3E44763CD</link>
11509 
                <link type="object" struct-name="model.Figure" key="startFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
11510 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11511 
                <value type="int" key="visible">1</value>
11512 
                <value type="string" key="name"></value>
11513 
              </value>
11514 
              <value type="object" struct-name="workbench.physical.Connection" id="a622a5b8-ad0b-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11515 
                <value type="string" key="caption">fk_aggregate_observation_taxon_name1</value>
11516 
                <value type="real" key="captionXOffs">0.e+00</value>
11517 
                <value type="real" key="captionYOffs">0.e+00</value>
11518 
                <value type="string" key="comment"></value>
11519 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11520 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11521 
                <value type="string" key="extraCaption"></value>
11522 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11523 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11524 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3c9e685c-a90f-11e2-8576-080027bcf912</link>
11525 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11526 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11527 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11528 
                <value type="int" key="drawSplit">1</value>
11529 
                <link type="object" struct-name="model.Figure" key="endFigure">8932D751-419A-4213-960A-F4E3E44763CD</link>
11530 
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
11531 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11532 
                <value type="int" key="visible">1</value>
11533 
                <value type="string" key="name"></value>
11534 
              </value>
11535 
              <value type="object" struct-name="workbench.physical.Connection" id="9b6b743c-ad0c-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11536 
                <value type="string" key="caption">fk_parsed_taxon_assertion_taxon_name1</value>
11537 
                <value type="real" key="captionXOffs">0.e+00</value>
11538 
                <value type="real" key="captionYOffs">0.e+00</value>
11539 
                <value type="string" key="comment"></value>
11540 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11541 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11542 
                <value type="string" key="extraCaption"></value>
11543 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11544 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11545 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">a3e070f8-a77c-11e2-afd5-080027bcf912</link>
11546 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11547 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11548 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11549 
                <value type="int" key="drawSplit">0</value>
11550 
                <link type="object" struct-name="model.Figure" key="endFigure">8932D751-419A-4213-960A-F4E3E44763CD</link>
11551 
                <link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link>
11552 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11553 
                <value type="int" key="visible">1</value>
11554 
                <value type="string" key="name"></value>
11555 
              </value>
11556 11556 
            </value>
11557 11557 
            <value type="string" key="description"></value>
11558 11558 
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
11862 11862 
                <value type="int" key="expanded">1</value>
11863 11863 
                <value type="real" key="height">1.23e+02</value>
11864 11864 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11865 
                <value type="real" key="left">1.311e+03</value>
11865 
                <value type="real" key="left">1.272e+03</value>
11866 11866 
                <value type="int" key="locked">0</value>
11867 11867 
                <value type="int" key="manualSizing">0</value>
11868 
                <value type="real" key="top">1.149e+03</value>
11869 
                <value type="real" key="width">1.34e+02</value>
11868 
                <value type="real" key="top">1.126e+03</value>
11869 
                <value type="real" key="width">1.44e+02</value>
11870 11870 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11871 11871 
                <value type="int" key="visible">1</value>
11872 11872 
                <value type="string" key="name">taxon_concept</value>
......
11882 11882 
                <value type="int" key="expanded">1</value>
11883 11883 
                <value type="real" key="height">1.46e+02</value>
11884 11884 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11885 
                <value type="real" key="left">9.16e+02</value>
11885 
                <value type="real" key="left">9.18e+02</value>
11886 11886 
                <value type="int" key="locked">0</value>
11887 11887 
                <value type="int" key="manualSizing">0</value>
11888 
                <value type="real" key="top">9.37e+02</value>
11888 
                <value type="real" key="top">9.36e+02</value>
11889 11889 
                <value type="real" key="width">1.42e+02</value>
11890 11890 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11891 11891 
                <value type="int" key="visible">1</value>
......
11902 11902 
                <value type="int" key="expanded">1</value>
11903 11903 
                <value type="real" key="height">1.23e+02</value>
11904 11904 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11905 
                <value type="real" key="left">9.24e+02</value>
11905 
                <value type="real" key="left">9.26e+02</value>
11906 11906 
                <value type="int" key="locked">0</value>
11907 11907 
                <value type="int" key="manualSizing">0</value>
11908 
                <value type="real" key="top">1.152e+03</value>
11908 
                <value type="real" key="top">1.146e+03</value>
11909 11909 
                <value type="real" key="width">1.88e+02</value>
11910 11910 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11911 11911 
                <value type="int" key="visible">1</value>
......
11962 11962 
                <value type="int" key="expanded">1</value>
11963 11963 
                <value type="real" key="height">1.23e+02</value>
11964 11964 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11965 
                <value type="real" key="left">8.46e+02</value>
11965 
                <value type="real" key="left">8.48e+02</value>
11966 11966 
                <value type="int" key="locked">0</value>
11967 11967 
                <value type="int" key="manualSizing">0</value>
11968 
                <value type="real" key="top">7.47e+02</value>
11968 
                <value type="real" key="top">7.46e+02</value>
11969 11969 
                <value type="real" key="width">1.68e+02</value>
11970 11970 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11971 11971 
                <value type="int" key="visible">1</value>
......
12488 12488 
                <value type="int" key="expanded">1</value>
12489 12489 
                <value type="real" key="height">7.7e+01</value>
12490 12490 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12491 
                <value type="real" key="left">1.089e+03</value>
12491 
                <value type="real" key="left">1.091e+03</value>
12492 12492 
                <value type="int" key="locked">0</value>
12493 12493 
                <value type="int" key="manualSizing">0</value>
12494 
                <value type="real" key="top">8.68e+02</value>
12494 
                <value type="real" key="top">8.49e+02</value>
12495 12495 
                <value type="real" key="width">1.39e+02</value>
12496 12496 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12497 12497 
                <value type="int" key="visible">1</value>
......
12528 12528 
                <value type="int" key="expanded">1</value>
12529 12529 
                <value type="real" key="height">1.92e+02</value>
12530 12530 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12531 
                <value type="real" key="left">1.318e+03</value>
12531 
                <value type="real" key="left">1.32e+03</value>
12532 12532 
                <value type="int" key="locked">0</value>
12533 12533 
                <value type="int" key="manualSizing">0</value>
12534 
                <value type="real" key="top">9.19e+02</value>
12534 
                <value type="real" key="top">8.9e+02</value>
12535 12535 
                <value type="real" key="width">1.2e+02</value>
12536 12536 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12537 12537 
                <value type="int" key="visible">1</value>
......
12548 12548 
                <value type="int" key="expanded">1</value>
12549 12549 
                <value type="real" key="height">1.46e+02</value>
12550 12550 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12551 
                <value type="real" key="left">1.479e+03</value>
12551 
                <value type="real" key="left">1.481e+03</value>
12552 12552 
                <value type="int" key="locked">0</value>
12553 12553 
                <value type="int" key="manualSizing">0</value>
12554 
                <value type="real" key="top">9.89e+02</value>
12554 
                <value type="real" key="top">9.6e+02</value>
12555 12555 
                <value type="real" key="width">1.14e+02</value>
12556 12556 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12557 12557 
                <value type="int" key="visible">1</value>
......
12663 12663 
                <value type="int" key="expanded">1</value>
12664 12664 
                <value type="real" key="height">2.7e+01</value>
12665 12665 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12666 
                <value type="real" key="left">7.18e+02</value>
12666 
                <value type="real" key="left">7.19e+02</value>
12667 12667 
                <value type="int" key="locked">0</value>
12668 12668 
                <value type="int" key="manualSizing">0</value>
12669 
                <value type="real" key="top">8.76e+02</value>
12669 
                <value type="real" key="top">8.75e+02</value>
12670 12670 
                <value type="real" key="width">2.02e+02</value>
12671 12671 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12672 12672 
                <value type="int" key="visible">1</value>
......
12678 12678 
                <value type="int" key="expanded">1</value>
12679 12679 
                <value type="real" key="height">2.5e+01</value>
12680 12680 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12681 
                <value type="real" key="left">1.062e+03</value>
12681 
                <value type="real" key="left">1.165e+03</value>
12682 12682 
                <value type="int" key="locked">0</value>
12683 12683 
                <value type="int" key="manualSizing">0</value>
12684 12684 
                <value type="real" key="top">1.004e+03</value>
......
12693 12693 
                <value type="int" key="expanded">1</value>
12694 12694 
                <value type="real" key="height">2.5e+01</value>
12695 12695 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12696 
                <value type="real" key="left">1.2e+03</value>
12696 
                <value type="real" key="left">1.201e+03</value>
12697 12697 
                <value type="int" key="locked">0</value>
12698 12698 
                <value type="int" key="manualSizing">0</value>
12699 
                <value type="real" key="top">9.64e+02</value>
12699 
                <value type="real" key="top">9.56e+02</value>
12700 12700 
                <value type="real" key="width">1.09e+02</value>
12701 12701 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12702 12702 
                <value type="int" key="visible">1</value>
......
12708 12708 
                <value type="int" key="expanded">1</value>
12709 12709 
                <value type="real" key="height">2.7e+01</value>
12710 12710 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12711 
                <value type="real" key="left">1.07e+03</value>
12711 
                <value type="real" key="left">1.069e+03</value>
12712 12712 
                <value type="int" key="locked">0</value>
12713 12713 
                <value type="int" key="manualSizing">0</value>
12714 
                <value type="real" key="top">1.109e+03</value>
12714 
                <value type="real" key="top">1.095e+03</value>
12715 12715 
                <value type="real" key="width">7.4e+01</value>
12716 12716 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12717 12717 
                <value type="int" key="visible">1</value>
......
12723 12723 
                <value type="int" key="expanded">1</value>
12724 12724 
                <value type="real" key="height">2.5e+01</value>
12725 12725 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12726 
                <value type="real" key="left">1.12e+03</value>
12726 
                <value type="real" key="left">1.156e+03</value>
12727 12727 
                <value type="int" key="locked">0</value>
12728 12728 
                <value type="int" key="manualSizing">0</value>
12729 
                <value type="real" key="top">1.184e+03</value>
12729 
                <value type="real" key="top">1.179e+03</value>
12730 12730 
                <value type="real" key="width">8.3e+01</value>
12731 12731 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12732 12732 
                <value type="int" key="visible">1</value>
12733 12733 
                <value type="string" key="name">4. matched</value>
12734 12734 
              </value>
12735 12735 
              <value type="object" struct-name="workbench.model.NoteFigure" id="d1f23ed8-aca2-11e2-a207-080027bcf912" struct-checksum="0x56ccd040">
12736 
                <value type="string" key="text">5. accepted &gt;</value>
12736 
                <value type="string" key="text">&lt; 5. accepted</value>
12737 12737 
                <value type="string" key="color">#ffffff</value>
12738 12738 
                <value type="int" key="expanded">1</value>
12739 12739 
                <value type="real" key="height">2.7e+01</value>
12740 12740 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12741 
                <value type="real" key="left">1.221e+03</value>
12741 
                <value type="real" key="left">1.449e+03</value>
12742 12742 
                <value type="int" key="locked">0</value>
12743 12743 
                <value type="int" key="manualSizing">0</value>
12744 
                <value type="real" key="top">1.237e+03</value>
12744 
                <value type="real" key="top">1.2e+03</value>
12745 12745 
                <value type="real" key="width">8.6e+01</value>
12746 12746 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12747 12747 
                <value type="int" key="visible">1</value>
......
12753 12753 
                <value type="int" key="expanded">1</value>
12754 12754 
                <value type="real" key="height">2.5e+01</value>
12755 12755 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12756 
                <value type="real" key="left">9.36e+02</value>
12756 
                <value type="real" key="left">9.38e+02</value>
12757 12757 
                <value type="int" key="locked">0</value>
12758 12758 
                <value type="int" key="manualSizing">0</value>
12759 
                <value type="real" key="top">8.76e+02</value>
12759 
                <value type="real" key="top">8.75e+02</value>
12760 12760 
                <value type="real" key="width">9.e+01</value>
12761 12761 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12762 12762 
                <value type="int" key="visible">1</value>
......
12900 12900 
              <value type="string" key="name"></value>
12901 12901 
            </value>
12902 12902 
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12903 
              <link type="object">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
12903 
              <link type="object">71dceeac-a780-11e2-afd5-080027bcf912</link>
12904 
              <link type="object">71daccd0-a780-11e2-afd5-080027bcf912</link>
12904 12905 
            </value>
12905 12906 
            <value type="int" key="updateBlocked">0</value>
12906 12907 
            <value type="real" key="width">1.6215e+03</value>
......
12996 12997 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12997 12998 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12998 12999 
      <value type="string" key="caption">New Model</value>
12999 
      <value type="string" key="dateChanged">2013-04-24 11:08</value>
13000 
      <value type="string" key="dateChanged">2013-04-24 11:34</value>
13000 13001 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13001 13002 
      <value type="string" key="description"></value>
13002 13003 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
170 170 

  		




  171
  171
  
    

  		




  172
  172
  
    
-- -----------------------------------------------------


  		




  
  173
  
    
-- Table `taxon_concept`


  		




  
  174
  
    
-- -----------------------------------------------------


  		




  
  175
  
    
DROP TABLE IF EXISTS `taxon_concept` ;


  		




  
  176
  
    

  		




  
  177
  
    
CREATE  TABLE IF NOT EXISTS `taxon_concept` (


  		




  
  178
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  
  179
  
    
  `according_to` VARBINARY(767) NOT NULL ,


  		




  
  180
  
    
  `parent` VARBINARY(767) NOT NULL ,


  		




  
  181
  
    
  `accepted_taxon_concept` VARBINARY(767) NULL DEFAULT NULL ,


  		




  
  182
  
    
  PRIMARY KEY (`id`) ,


  		




  
  183
  
    
  INDEX `fk_taxon_taxon1_idx` (`parent` ASC) ,


  		




  
  184
  
    
  INDEX `fk_taxon_concept_source1_idx` (`according_to` ASC) ,


  		




  
  185
  
    
  INDEX `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon_concept` ASC) ,


  		




  
  186
  
    
  UNIQUE INDEX `taxon_concept_unique_name` (`according_to` ASC) ,


  		




  
  187
  
    
  CONSTRAINT `fk_taxon_taxon1`


  		




  
  188
  
    
    FOREIGN KEY (`parent` )


  		




  
  189
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  
  190
  
    
    ON DELETE CASCADE


  		




  
  191
  
    
    ON UPDATE CASCADE,


  		




  
  192
  
    
  CONSTRAINT `fk_taxon_concept_source1`


  		




  
  193
  
    
    FOREIGN KEY (`according_to` )


  		




  
  194
  
    
    REFERENCES `source` (`id` )


  		




  
  195
  
    
    ON DELETE CASCADE


  		




  
  196
  
    
    ON UPDATE CASCADE,


  		




  
  197
  
    
  CONSTRAINT `fk_taxon_concept_taxon_concept1`


  		




  
  198
  
    
    FOREIGN KEY (`accepted_taxon_concept` )


  		




  
  199
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  
  200
  
    
    ON DELETE CASCADE


  		




  
  201
  
    
    ON UPDATE CASCADE,


  		




  
  202
  
    
  CONSTRAINT `fk_taxon_concept_taxon_name1`


  		




  
  203
  
    
    FOREIGN KEY (`id` )


  		




  
  204
  
    
    REFERENCES `taxon_name` (`id` )


  		




  
  205
  
    
    ON DELETE CASCADE


  		




  
  206
  
    
    ON UPDATE CASCADE)


  		




  
  207
  
    
ENGINE = InnoDB


  		




  
  208
  
    
DEFAULT CHARACTER SET = utf8


  		




  
  209
  
    
COLLATE = utf8_bin;


  		




  
  210
  
    

  		




  
  211
  
    

  		




  
  212
  
    
-- -----------------------------------------------------


  		




  173
  213
  
    
-- Table `parsed_taxon_assertion`


  		




  174
  214
  
    
-- -----------------------------------------------------


  		




  175
  215
  
    
DROP TABLE IF EXISTS `parsed_taxon_assertion` ;


  		




  176
  216
  
    

  		




  177
  217
  
    
CREATE  TABLE IF NOT EXISTS `parsed_taxon_assertion` (


  		




  178
  218
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  179
  
  
    
  `matched_taxon` VARBINARY(767) NULL DEFAULT NULL ,


  		




  
  219
  
    
  `matched_taxon_concept` VARBINARY(767) NULL DEFAULT NULL ,


  		




  180
  220
  
    
  `match_score` FLOAT NULL ,


  		




  181
  221
  
    
  `match_info` SET('hstore') NULL ,


  		




  182
  222
  
    
  PRIMARY KEY (`id`) ,


  		




  183
  
  
    
  INDEX `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon` ASC) ,


  		




  
  223
  
    
  INDEX `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept` ASC) ,


  		




  184
  224
  
    
  CONSTRAINT `fk_matched_taxon_qualified_taxon10`


  		




  185
  225
  
    
    FOREIGN KEY (`id` )


  		




  186
  226
  
    
    REFERENCES `taxon_assertion` (`id` )


  		




  187
  227
  
    
    ON DELETE CASCADE


  		




  188
  228
  
    
    ON UPDATE CASCADE,


  		




  189
  229
  
    
  CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1`


  		




  190
  
  
    
    FOREIGN KEY (`matched_taxon` )


  		




  191
  
  
    
    REFERENCES `taxon_name` (`id` )


  		




  
  230
  
    
    FOREIGN KEY (`matched_taxon_concept` )


  		




  
  231
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  192
  232
  
    
    ON DELETE CASCADE


  		




  193
  233
  
    
    ON UPDATE CASCADE)


  		




  194
  234
  
    
ENGINE = InnoDB


  		




  ......




  604
  644
  
    

  		




  605
  645
  
    
CREATE  TABLE IF NOT EXISTS `aggregate_observation` (


  		




  606
  646
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  607
  
  
    
  `taxon` VARBINARY(767) NOT NULL ,


  		




  
  647
  
    
  `taxon_concept` VARBINARY(767) NOT NULL ,


  		




  608
  648
  
    
  PRIMARY KEY (`id`) ,


  		




  609
  
  
    
  INDEX `fk_aggregate_observation_taxon_name1_idx` (`taxon` ASC) ,


  		




  
  649
  
    
  INDEX `fk_aggregate_observation_taxon_name1_idx` (`taxon_concept` ASC) ,


  		




  610
  650
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_occurrence1`


  		




  611
  651
  
    
    FOREIGN KEY (`id` )


  		




  612
  652
  
    
    REFERENCES `taxon_observation` (`id` )


  		




  613
  653
  
    
    ON DELETE CASCADE


  		




  614
  654
  
    
    ON UPDATE CASCADE,


  		




  615
  655
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_name1`


  		




  616
  
  
    
    FOREIGN KEY (`taxon` )


  		




  617
  
  
    
    REFERENCES `taxon_name` (`id` )


  		




  
  656
  
    
    FOREIGN KEY (`taxon_concept` )


  		




  
  657
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  618
  658
  
    
    ON DELETE CASCADE


  		




  619
  659
  
    
    ON UPDATE CASCADE)


  		




  620
  660
  
    
ENGINE = InnoDB


  		




  ......




  629
  669
  
    

  		




  630
  670
  
    
CREATE  TABLE IF NOT EXISTS `taxon_presence` (


  		




  631
  671
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  632
  
  
    
  `taxon` VARBINARY(767) NOT NULL ,


  		




  
  672
  
    
  `taxon_concept` VARBINARY(767) NOT NULL ,


  		




  633
  673
  
    
  PRIMARY KEY (`id`) ,


  		




  634
  
  
    
  INDEX `fk_taxon_presence_taxon_name1_idx` (`taxon` ASC) ,


  		




  
  674
  
    
  INDEX `fk_taxon_presence_taxon_name1_idx` (`taxon_concept` ASC) ,


  		




  635
  675
  
    
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1`


  		




  636
  676
  
    
    FOREIGN KEY (`id` )


  		




  637
  677
  
    
    REFERENCES `taxon_observation` (`id` )


  		




  638
  678
  
    
    ON DELETE CASCADE


  		




  639
  679
  
    
    ON UPDATE CASCADE,


  		




  640
  680
  
    
  CONSTRAINT `fk_taxon_presence_taxon_name1`


  		




  641
  
  
    
    FOREIGN KEY (`taxon` )


  		




  642
  
  
    
    REFERENCES `taxon_name` (`id` )


  		




  643
  
  
    
    ON DELETE CASCADE


  		




  644
  
  
    
    ON UPDATE CASCADE)


  		




  645
  
  
    
ENGINE = InnoDB


  		




  646
  
  
    
DEFAULT CHARACTER SET = utf8


  		




  647
  
  
    
COLLATE = utf8_bin;


  		




  648
  
  
    

  		




  649
  
  
    

  		




  650
  
  
    
-- -----------------------------------------------------


  		




  651
  
  
    
-- Table `taxon_concept`


  		




  652
  
  
    
-- -----------------------------------------------------


  		




  653
  
  
    
DROP TABLE IF EXISTS `taxon_concept` ;


  		




  654
  
  
    

  		




  655
  
  
    
CREATE  TABLE IF NOT EXISTS `taxon_concept` (


  		




  656
  
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  657
  
  
    
  `according_to` VARBINARY(767) NOT NULL ,


  		




  658
  
  
    
  `parent` VARBINARY(767) NOT NULL ,


  		




  659
  
  
    
  `accepted_taxon` VARBINARY(767) NULL DEFAULT NULL ,


  		




  660
  
  
    
  PRIMARY KEY (`id`) ,


  		




  661
  
  
    
  INDEX `fk_taxon_taxon1_idx` (`parent` ASC) ,


  		




  662
  
  
    
  INDEX `fk_taxon_concept_source1_idx` (`according_to` ASC) ,


  		




  663
  
  
    
  INDEX `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon` ASC) ,


  		




  664
  
  
    
  UNIQUE INDEX `taxon_concept_unique_name` (`according_to` ASC) ,


  		




  665
  
  
    
  CONSTRAINT `fk_taxon_taxon1`


  		




  666
  
  
    
    FOREIGN KEY (`parent` )


  		




  
  681
  
    
    FOREIGN KEY (`taxon_concept` )


  		




  667
  682
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  668
  683
  
    
    ON DELETE CASCADE


  		




  669
  
  
    
    ON UPDATE CASCADE,


  		




  670
  
  
    
  CONSTRAINT `fk_taxon_concept_source1`


  		




  671
  
  
    
    FOREIGN KEY (`according_to` )


  		




  672
  
  
    
    REFERENCES `source` (`id` )


  		




  673
  
  
    
    ON DELETE CASCADE


  		




  674
  
  
    
    ON UPDATE CASCADE,


  		




  675
  
  
    
  CONSTRAINT `fk_taxon_concept_taxon_concept1`


  		




  676
  
  
    
    FOREIGN KEY (`accepted_taxon` )


  		




  677
  
  
    
    REFERENCES `taxon_concept` (`id` )


  		




  678
  
  
    
    ON DELETE CASCADE


  		




  679
  
  
    
    ON UPDATE CASCADE,


  		




  680
  
  
    
  CONSTRAINT `fk_taxon_concept_taxon_name1`


  		




  681
  
  
    
    FOREIGN KEY (`id` )


  		




  682
  
  
    
    REFERENCES `taxon_name` (`id` )


  		




  683
  
  
    
    ON DELETE CASCADE


  		




  684
  684
  
    
    ON UPDATE CASCADE)


  		




  685
  685
  
    
ENGINE = InnoDB


  		




  686
  686
  
    
DEFAULT CHARACTER SET = utf8


  		












Also available in:  Unified diff