Revision 10469
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/document.mwb.xml | ||
|---|---|---|
| 1869 | 1869 |
<value type="string" key="oldName">id</value> |
| 1870 | 1870 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
| 1871 | 1871 |
</value> |
| 1872 |
<value type="object" struct-name="db.mysql.Column" id="8039828a-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x783b5183"> |
|
| 1873 |
<value type="int" key="autoIncrement">0</value> |
|
| 1874 |
<value type="string" key="characterSetName"></value> |
|
| 1875 |
<value _ptr_="0xac7f760" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> |
|
| 1876 |
<value type="string" key="collationName"></value> |
|
| 1877 |
<value type="string" key="datatypeExplicitParams"></value> |
|
| 1878 |
<value type="string" key="defaultValue"></value> |
|
| 1879 |
<value type="int" key="defaultValueIsNull">0</value> |
|
| 1880 |
<value _ptr_="0xafd3b48" type="list" content-type="string" key="flags"/> |
|
| 1881 |
<value type="int" key="isNotNull">1</value> |
|
| 1882 |
<value type="int" key="length">767</value> |
|
| 1883 |
<value type="int" key="precision">-1</value> |
|
| 1884 |
<value type="int" key="scale">-1</value> |
|
| 1885 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
|
| 1886 |
<value type="string" key="comment"></value> |
|
| 1887 |
<value type="string" key="name">input_string</value> |
|
| 1888 |
<value type="string" key="oldName">taxon_string_string</value> |
|
| 1889 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 1890 |
</value> |
|
| 1891 |
<value type="object" struct-name="db.mysql.Column" id="400c0fac-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x783b5183"> |
|
| 1892 |
<value type="int" key="autoIncrement">0</value> |
|
| 1893 |
<value type="string" key="characterSetName"></value> |
|
| 1894 |
<value _ptr_="0xa4d29d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> |
|
| 1895 |
<value type="string" key="collationName"></value> |
|
| 1896 |
<value type="string" key="datatypeExplicitParams"></value> |
|
| 1897 |
<value type="string" key="defaultValue"></value> |
|
| 1898 |
<value type="int" key="defaultValueIsNull">0</value> |
|
| 1899 |
<value _ptr_="0xb4812a0" type="list" content-type="string" key="flags"/> |
|
| 1900 |
<value type="int" key="isNotNull">1</value> |
|
| 1901 |
<value type="int" key="length">767</value> |
|
| 1902 |
<value type="int" key="precision">-1</value> |
|
| 1903 |
<value type="int" key="scale">-1</value> |
|
| 1904 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
|
| 1905 |
<value type="string" key="comment"></value> |
|
| 1906 |
<value type="string" key="name">parsed_taxon_assertion</value> |
|
| 1907 |
<value type="string" key="oldName">taxon_assertion_id</value> |
|
| 1908 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 1909 |
</value> |
|
| 1872 | 1910 |
<value type="object" struct-name="db.mysql.Column" id="be8fb7a2-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x783b5183"> |
| 1873 | 1911 |
<value type="int" key="autoIncrement">0</value> |
| 1874 | 1912 |
<value type="string" key="characterSetName"></value> |
| ... | ... | |
| 1932 | 1970 |
<value type="string" key="defaultCollationName">utf8_bin</value> |
| 1933 | 1971 |
<value type="int" key="delayKeyWrite">0</value> |
| 1934 | 1972 |
<value _ptr_="0xa383e78" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"> |
| 1935 |
<value type="object" struct-name="db.mysql.ForeignKey" id="be8fc08a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40"> |
|
| 1973 |
<value type="object" struct-name="db.mysql.ForeignKey" id="a3e070f8-a77c-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40"> |
|
| 1974 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link> |
|
| 1975 |
<value _ptr_="0xa385818" type="list" content-type="object" content-struct-name="db.Column" key="columns"> |
|
| 1976 |
<link type="object">be8fb7a2-a6e0-11e2-95e9-080027bcf912</link> |
|
| 1977 |
</value> |
|
| 1978 |
<value type="int" key="deferability">0</value> |
|
| 1979 |
<value type="string" key="deleteRule">CASCADE</value> |
|
| 1980 |
<link type="object" struct-name="db.Index" key="index">9b6b7d6a-ad0c-11e2-b309-080027bcf912</link> |
|
| 1981 |
<value type="int" key="mandatory">1</value> |
|
| 1982 |
<value type="int" key="many">1</value> |
|
| 1983 |
<value type="int" key="modelOnly">0</value> |
|
| 1984 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 1985 |
<value _ptr_="0xa385ba0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns"> |
|
| 1986 |
<link type="object">18327370-a77d-11e2-afd5-080027bcf912</link> |
|
| 1987 |
</value> |
|
| 1988 |
<value type="int" key="referencedMandatory">1</value> |
|
| 1989 |
<value type="string" key="updateRule">CASCADE</value> |
|
| 1990 |
<value type="string" key="comment"></value> |
|
| 1991 |
<value type="string" key="name">fk_parsed_taxon_assertion_taxon_name1</value> |
|
| 1992 |
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value> |
|
| 1993 |
</value> |
|
| 1994 |
<value type="object" struct-name="db.mysql.ForeignKey" id="400c0dc2-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x70a8fc40"> |
|
| 1936 | 1995 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d17d6-a6e0-11e2-95e9-080027bcf912</link> |
| 1937 |
<value _ptr_="0xa385440" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 1938 |
<link type="object">be8fb5ae-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 1996 |
<value _ptr_="0xb8e0a78" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 1997 |
<link type="object">400c0fac-f6d1-11e2-a35e-080027bcf912</link>
|
|
| 1939 | 1998 |
</value> |
| 1940 | 1999 |
<value type="int" key="deferability">0</value> |
| 1941 | 2000 |
<value type="string" key="deleteRule">CASCADE</value> |
| 1942 |
<link type="object" struct-name="db.Index" key="index">be8fb98c-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 1943 |
<value type="int" key="mandatory">0</value>
|
|
| 1944 |
<value type="int" key="many">0</value>
|
|
| 2001 |
<link type="object" struct-name="db.Index" key="index">400c2370-f6d1-11e2-a35e-080027bcf912</link>
|
|
| 2002 |
<value type="int" key="mandatory">1</value>
|
|
| 2003 |
<value type="int" key="many">1</value>
|
|
| 1945 | 2004 |
<value type="int" key="modelOnly">0</value> |
| 1946 | 2005 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
| 1947 |
<value _ptr_="0xa3857a8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 2006 |
<value _ptr_="0xb70e390" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 1948 | 2007 |
<link type="object">be8d1ac4-a6e0-11e2-95e9-080027bcf912</link> |
| 1949 | 2008 |
</value> |
| 1950 | 2009 |
<value type="int" key="referencedMandatory">1</value> |
| 1951 | 2010 |
<value type="string" key="updateRule">CASCADE</value> |
| 1952 | 2011 |
<value type="string" key="comment"></value> |
| 1953 |
<value type="string" key="name">fk_matched_taxon_qualified_taxon10</value>
|
|
| 1954 |
<value type="string" key="oldName">fk_matched_taxon_qualified_taxon10</value>
|
|
| 2012 |
<value type="string" key="name">fk_taxon_scrub_taxon_assertion1</value>
|
|
| 2013 |
<value type="string" key="oldName">fk_taxon_scrub_taxon_assertion1</value>
|
|
| 1955 | 2014 |
</value> |
| 1956 |
<value type="object" struct-name="db.mysql.ForeignKey" id="a3e070f8-a77c-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 1957 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
|
|
| 1958 |
<value _ptr_="0xa385818" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 1959 |
<link type="object">be8fb7a2-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 2015 |
<value type="object" struct-name="db.mysql.ForeignKey" id="803980c8-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 2016 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4c3ffc96-a741-11e2-9fbf-080027bcf912</link>
|
|
| 2017 |
<value _ptr_="0xaaa2228" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 2018 |
<link type="object">8039828a-f6d1-11e2-a35e-080027bcf912</link>
|
|
| 1960 | 2019 |
</value> |
| 1961 | 2020 |
<value type="int" key="deferability">0</value> |
| 1962 | 2021 |
<value type="string" key="deleteRule">CASCADE</value> |
| 1963 |
<link type="object" struct-name="db.Index" key="index">9b6b7d6a-ad0c-11e2-b309-080027bcf912</link>
|
|
| 2022 |
<link type="object" struct-name="db.Index" key="index">80399806-f6d1-11e2-a35e-080027bcf912</link>
|
|
| 1964 | 2023 |
<value type="int" key="mandatory">1</value> |
| 1965 | 2024 |
<value type="int" key="many">1</value> |
| 1966 | 2025 |
<value type="int" key="modelOnly">0</value> |
| 1967 | 2026 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
| 1968 |
<value _ptr_="0xa385ba0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 1969 |
<link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
|
|
| 2027 |
<value _ptr_="0xaad7c98" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 2028 |
<link type="object">4c40001a-a741-11e2-9fbf-080027bcf912</link>
|
|
| 1970 | 2029 |
</value> |
| 1971 | 2030 |
<value type="int" key="referencedMandatory">1</value> |
| 1972 | 2031 |
<value type="string" key="updateRule">CASCADE</value> |
| 1973 | 2032 |
<value type="string" key="comment"></value> |
| 1974 |
<value type="string" key="name">fk_parsed_taxon_assertion_taxon_name1</value>
|
|
| 1975 |
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value>
|
|
| 2033 |
<value type="string" key="name">fk_taxon_scrub_taxon_string1</value>
|
|
| 2034 |
<value type="string" key="oldName">fk_taxon_scrub_taxon_string1</value>
|
|
| 1976 | 2035 |
</value> |
| 2036 |
<value type="object" struct-name="db.mysql.ForeignKey" id="9b006114-f6d2-11e2-a35e-080027bcf912" struct-checksum="0x70a8fc40"> |
|
| 2037 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2038 |
<value _ptr_="0xae85e08" type="list" content-type="object" content-struct-name="db.Column" key="columns"> |
|
| 2039 |
<link type="object">be8fb5ae-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2040 |
</value> |
|
| 2041 |
<value type="int" key="deferability">0</value> |
|
| 2042 |
<value type="string" key="deleteRule">CASCADE</value> |
|
| 2043 |
<value type="int" key="mandatory">0</value> |
|
| 2044 |
<value type="int" key="many">0</value> |
|
| 2045 |
<value type="int" key="modelOnly">0</value> |
|
| 2046 |
<link type="object" struct-name="db.Table" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2047 |
<value _ptr_="0xb190a20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns"> |
|
| 2048 |
<link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2049 |
</value> |
|
| 2050 |
<value type="int" key="referencedMandatory">1</value> |
|
| 2051 |
<value type="string" key="updateRule">CASCADE</value> |
|
| 2052 |
<value type="string" key="comment"></value> |
|
| 2053 |
<value type="string" key="name">fk_taxon_scrub_record1</value> |
|
| 2054 |
<value type="string" key="oldName">fk_taxon_scrub_record1</value> |
|
| 2055 |
</value> |
|
| 1977 | 2056 |
</value> |
| 1978 | 2057 |
<value _ptr_="0xa383ec8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> |
| 1979 | 2058 |
<value type="object" struct-name="db.mysql.Index" id="be8fb98c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a"> |
| ... | ... | |
| 2022 | 2101 |
<value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1_idx</value> |
| 2023 | 2102 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
| 2024 | 2103 |
</value> |
| 2104 |
<value type="object" struct-name="db.mysql.Index" id="400c2370-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x309b847a"> |
|
| 2105 |
<value _ptr_="0xb9b71e0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns"> |
|
| 2106 |
<value type="object" struct-name="db.mysql.IndexColumn" id="400c24ec-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x62630b3c"> |
|
| 2107 |
<value type="int" key="columnLength">0</value> |
|
| 2108 |
<value type="string" key="comment"></value> |
|
| 2109 |
<value type="int" key="descend">0</value> |
|
| 2110 |
<link type="object" struct-name="db.Column" key="referencedColumn">400c0fac-f6d1-11e2-a35e-080027bcf912</link> |
|
| 2111 |
<value type="string" key="name"></value> |
|
| 2112 |
<link type="object" struct-name="GrtObject" key="owner">400c2370-f6d1-11e2-a35e-080027bcf912</link> |
|
| 2113 |
</value> |
|
| 2114 |
</value> |
|
| 2115 |
<value type="string" key="indexKind"></value> |
|
| 2116 |
<value type="int" key="keyBlockSize">0</value> |
|
| 2117 |
<value type="string" key="withParser"></value> |
|
| 2118 |
<value type="string" key="comment"></value> |
|
| 2119 |
<value type="int" key="deferability">0</value> |
|
| 2120 |
<value type="string" key="indexType">INDEX</value> |
|
| 2121 |
<value type="int" key="isPrimary">0</value> |
|
| 2122 |
<value type="string" key="name">fk_taxon_scrub_taxon_assertion1_idx</value> |
|
| 2123 |
<value type="int" key="unique">0</value> |
|
| 2124 |
<value type="string" key="oldName">fk_taxon_scrub_taxon_assertion1</value> |
|
| 2125 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2126 |
</value> |
|
| 2127 |
<value type="object" struct-name="db.mysql.Index" id="80399806-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x309b847a"> |
|
| 2128 |
<value _ptr_="0xb907658" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns"> |
|
| 2129 |
<value type="object" struct-name="db.mysql.IndexColumn" id="8039998c-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x62630b3c"> |
|
| 2130 |
<value type="int" key="columnLength">0</value> |
|
| 2131 |
<value type="string" key="comment"></value> |
|
| 2132 |
<value type="int" key="descend">0</value> |
|
| 2133 |
<link type="object" struct-name="db.Column" key="referencedColumn">8039828a-f6d1-11e2-a35e-080027bcf912</link> |
|
| 2134 |
<value type="string" key="name"></value> |
|
| 2135 |
<link type="object" struct-name="GrtObject" key="owner">80399806-f6d1-11e2-a35e-080027bcf912</link> |
|
| 2136 |
</value> |
|
| 2137 |
</value> |
|
| 2138 |
<value type="string" key="indexKind"></value> |
|
| 2139 |
<value type="int" key="keyBlockSize">0</value> |
|
| 2140 |
<value type="string" key="withParser"></value> |
|
| 2141 |
<value type="string" key="comment"></value> |
|
| 2142 |
<value type="int" key="deferability">0</value> |
|
| 2143 |
<value type="string" key="indexType">INDEX</value> |
|
| 2144 |
<value type="int" key="isPrimary">0</value> |
|
| 2145 |
<value type="string" key="name">fk_taxon_scrub_taxon_string1_idx</value> |
|
| 2146 |
<value type="int" key="unique">0</value> |
|
| 2147 |
<value type="string" key="oldName">fk_taxon_scrub_taxon_string1</value> |
|
| 2148 |
<link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link> |
|
| 2149 |
</value> |
|
| 2025 | 2150 |
</value> |
| 2026 | 2151 |
<value type="string" key="maxRows"></value> |
| 2027 | 2152 |
<value type="string" key="mergeInsert"></value> |
| ... | ... | |
| 2053 | 2178 |
<value type="int" key="commentedOut">0</value> |
| 2054 | 2179 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
| 2055 | 2180 |
<value _ptr_="0xa383c50" type="dict" key="customData"/> |
| 2056 |
<value type="string" key="lastChangeDate">2013-04-24 11:27</value>
|
|
| 2181 |
<value type="string" key="lastChangeDate">2013-07-27 08:34</value>
|
|
| 2057 | 2182 |
<value type="int" key="modelOnly">0</value> |
| 2058 |
<value type="string" key="name">parsed_taxon_assertion</value>
|
|
| 2183 |
<value type="string" key="name">taxon_scrub</value>
|
|
| 2059 | 2184 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 2060 | 2185 |
<value type="string" key="temp_sql"></value> |
| 2061 | 2186 |
<value type="string" key="comment"></value> |
| ... | ... | |
| 10760 | 10885 |
<value type="int" key="visible">1</value> |
| 10761 | 10886 |
<value type="string" key="name"></value> |
| 10762 | 10887 |
</value> |
| 10763 |
<value type="object" struct-name="workbench.physical.Connection" id="71ddcae8-a780-11e2-afd5-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 10764 |
<value type="string" key="caption">fk_matched_taxon_qualified_taxon10</value> |
|
| 10765 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 10766 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 10767 |
<value type="string" key="comment"></value> |
|
| 10768 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 10769 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 10770 |
<value type="string" key="extraCaption"></value> |
|
| 10771 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 10772 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 10773 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">be8fc08a-a6e0-11e2-95e9-080027bcf912</link> |
|
| 10774 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 10775 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 10776 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 10777 |
<value type="int" key="drawSplit">0</value> |
|
| 10778 |
<link type="object" struct-name="model.Figure" key="endFigure">C6EB6F10-416D-4B78-8B89-732B76286379</link> |
|
| 10779 |
<link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link> |
|
| 10780 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 10781 |
<value type="int" key="visible">1</value> |
|
| 10782 |
<value type="string" key="name"></value> |
|
| 10783 |
</value> |
|
| 10784 | 10888 |
<value type="object" struct-name="workbench.physical.Connection" id="81793906-a780-11e2-9f99-080027bcf912" struct-checksum="0x9baebc92"> |
| 10785 | 10889 |
<value type="string" key="caption">fk_taxon_path_taxon_name1</value> |
| 10786 | 10890 |
<value type="real" key="captionXOffs">0.e+00</value> |
| ... | ... | |
| 12167 | 12271 |
<value type="int" key="visible">1</value> |
| 12168 | 12272 |
<value type="string" key="name"></value> |
| 12169 | 12273 |
</value> |
| 12274 |
<value type="object" struct-name="workbench.physical.Connection" id="400c2c12-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 12275 |
<value type="string" key="caption">fk_taxon_scrub_taxon_assertion1</value> |
|
| 12276 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 12277 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 12278 |
<value type="string" key="comment"></value> |
|
| 12279 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 12280 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 12281 |
<value type="string" key="extraCaption"></value> |
|
| 12282 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 12283 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 12284 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">400c0dc2-f6d1-11e2-a35e-080027bcf912</link> |
|
| 12285 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 12286 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 12287 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 12288 |
<value type="int" key="drawSplit">0</value> |
|
| 12289 |
<link type="object" struct-name="model.Figure" key="endFigure">C6EB6F10-416D-4B78-8B89-732B76286379</link> |
|
| 12290 |
<link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link> |
|
| 12291 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 12292 |
<value type="int" key="visible">1</value> |
|
| 12293 |
<value type="string" key="name"></value> |
|
| 12294 |
</value> |
|
| 12295 |
<value type="object" struct-name="workbench.physical.Connection" id="80399f68-f6d1-11e2-a35e-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 12296 |
<value type="string" key="caption">fk_taxon_scrub_taxon_string1</value> |
|
| 12297 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 12298 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 12299 |
<value type="string" key="comment"></value> |
|
| 12300 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 12301 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 12302 |
<value type="string" key="extraCaption"></value> |
|
| 12303 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 12304 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 12305 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">803980c8-f6d1-11e2-a35e-080027bcf912</link> |
|
| 12306 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 12307 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 12308 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 12309 |
<value type="int" key="drawSplit">0</value> |
|
| 12310 |
<link type="object" struct-name="model.Figure" key="endFigure">4c400ef2-a741-11e2-9fbf-080027bcf912</link> |
|
| 12311 |
<link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link> |
|
| 12312 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 12313 |
<value type="int" key="visible">1</value> |
|
| 12314 |
<value type="string" key="name"></value> |
|
| 12315 |
</value> |
|
| 12316 |
<value type="object" struct-name="workbench.physical.Connection" id="9b00807c-f6d2-11e2-a35e-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 12317 |
<value type="string" key="caption">fk_taxon_scrub_record1</value> |
|
| 12318 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 12319 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 12320 |
<value type="string" key="comment"></value> |
|
| 12321 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 12322 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 12323 |
<value type="string" key="extraCaption"></value> |
|
| 12324 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 12325 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 12326 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">9b006114-f6d2-11e2-a35e-080027bcf912</link> |
|
| 12327 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 12328 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 12329 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 12330 |
<value type="int" key="drawSplit">1</value> |
|
| 12331 |
<link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link> |
|
| 12332 |
<link type="object" struct-name="model.Figure" key="startFigure">4E121C15-84E9-4A1F-9B5D-26B6EAB09212</link> |
|
| 12333 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 12334 |
<value type="int" key="visible">1</value> |
|
| 12335 |
<value type="string" key="name"></value> |
|
| 12336 |
</value> |
|
| 12170 | 12337 |
</value> |
| 12171 | 12338 |
<value type="string" key="description"></value> |
| 12172 | 12339 |
<value _ptr_="0xa3fd7c0" type="list" content-type="object" content-struct-name="model.Figure" key="figures"> |
| ... | ... | |
| 12476 | 12643 |
<value type="int" key="expanded">1</value> |
| 12477 | 12644 |
<value type="real" key="height">1.23e+02</value> |
| 12478 | 12645 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12479 |
<value type="real" key="left">1.272e+03</value>
|
|
| 12646 |
<value type="real" key="left">1.279e+03</value>
|
|
| 12480 | 12647 |
<value type="int" key="locked">0</value> |
| 12481 | 12648 |
<value type="int" key="manualSizing">0</value> |
| 12482 |
<value type="real" key="top">1.126e+03</value>
|
|
| 12649 |
<value type="real" key="top">1.106e+03</value>
|
|
| 12483 | 12650 |
<value type="real" key="width">1.44e+02</value> |
| 12484 | 12651 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12485 | 12652 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 12496 | 12663 |
<value type="int" key="expanded">1</value> |
| 12497 | 12664 |
<value type="real" key="height">1.46e+02</value> |
| 12498 | 12665 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12499 |
<value type="real" key="left">9.01e+02</value>
|
|
| 12666 |
<value type="real" key="left">8.82e+02</value>
|
|
| 12500 | 12667 |
<value type="int" key="locked">0</value> |
| 12501 | 12668 |
<value type="int" key="manualSizing">0</value> |
| 12502 |
<value type="real" key="top">9.45e+02</value>
|
|
| 12669 |
<value type="real" key="top">9.19e+02</value>
|
|
| 12503 | 12670 |
<value type="real" key="width">1.42e+02</value> |
| 12504 | 12671 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12505 | 12672 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 12514 | 12681 |
<value type="int" key="triggersExpanded">0</value> |
| 12515 | 12682 |
<value type="string" key="color">#00ee00</value> |
| 12516 | 12683 |
<value type="int" key="expanded">1</value> |
| 12517 |
<value type="real" key="height">1.23e+02</value>
|
|
| 12684 |
<value type="real" key="height">1.69e+02</value>
|
|
| 12518 | 12685 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12519 |
<value type="real" key="left">8.78e+02</value>
|
|
| 12686 |
<value type="real" key="left">1.048e+03</value>
|
|
| 12520 | 12687 |
<value type="int" key="locked">0</value> |
| 12521 | 12688 |
<value type="int" key="manualSizing">0</value> |
| 12522 |
<value type="real" key="top">1.146e+03</value>
|
|
| 12523 |
<value type="real" key="width">1.88e+02</value>
|
|
| 12689 |
<value type="real" key="top">1.103e+03</value>
|
|
| 12690 |
<value type="real" key="width">1.41e+02</value>
|
|
| 12524 | 12691 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12525 | 12692 |
<value type="int" key="visible">1</value> |
| 12526 |
<value type="string" key="name">parsed_taxon_assertion</value>
|
|
| 12693 |
<value type="string" key="name">taxon_scrub</value>
|
|
| 12527 | 12694 |
</value> |
| 12528 | 12695 |
<value type="object" struct-name="workbench.physical.TableFigure" id="1CE42D82-5AE5-4C01-A503-85E84F7B01D3" struct-checksum="0x3b14eccb"> |
| 12529 | 12696 |
<value type="int" key="columnsExpanded">1</value> |
| ... | ... | |
| 13102 | 13269 |
<value type="int" key="expanded">1</value> |
| 13103 | 13270 |
<value type="real" key="height">5.4e+01</value> |
| 13104 | 13271 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13105 |
<value type="real" key="left">1.077e+03</value>
|
|
| 13272 |
<value type="real" key="left">1.058e+03</value>
|
|
| 13106 | 13273 |
<value type="int" key="locked">0</value> |
| 13107 | 13274 |
<value type="int" key="manualSizing">0</value> |
| 13108 |
<value type="real" key="top">1.016e+03</value>
|
|
| 13275 |
<value type="real" key="top">9.9e+02</value>
|
|
| 13109 | 13276 |
<value type="real" key="width">1.22e+02</value> |
| 13110 | 13277 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13111 | 13278 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13142 | 13309 |
<value type="int" key="expanded">1</value> |
| 13143 | 13310 |
<value type="real" key="height">1.92e+02</value> |
| 13144 | 13311 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13145 |
<value type="real" key="left">1.32e+03</value> |
|
| 13312 |
<value type="real" key="left">1.327e+03</value>
|
|
| 13146 | 13313 |
<value type="int" key="locked">0</value> |
| 13147 | 13314 |
<value type="int" key="manualSizing">0</value> |
| 13148 |
<value type="real" key="top">8.99e+02</value>
|
|
| 13315 |
<value type="real" key="top">8.73e+02</value>
|
|
| 13149 | 13316 |
<value type="real" key="width">1.2e+02</value> |
| 13150 | 13317 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13151 | 13318 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13162 | 13329 |
<value type="int" key="expanded">1</value> |
| 13163 | 13330 |
<value type="real" key="height">1.46e+02</value> |
| 13164 | 13331 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13165 |
<value type="real" key="left">1.481e+03</value>
|
|
| 13332 |
<value type="real" key="left">1.488e+03</value>
|
|
| 13166 | 13333 |
<value type="int" key="locked">0</value> |
| 13167 | 13334 |
<value type="int" key="manualSizing">0</value> |
| 13168 |
<value type="real" key="top">9.69e+02</value>
|
|
| 13335 |
<value type="real" key="top">9.43e+02</value>
|
|
| 13169 | 13336 |
<value type="real" key="width">1.14e+02</value> |
| 13170 | 13337 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13171 | 13338 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13252 | 13419 |
<value type="int" key="expanded">1</value> |
| 13253 | 13420 |
<value type="real" key="height">2.5e+01</value> |
| 13254 | 13421 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13255 |
<value type="real" key="left">1.046e+03</value>
|
|
| 13422 |
<value type="real" key="left">1.027e+03</value>
|
|
| 13256 | 13423 |
<value type="int" key="locked">0</value> |
| 13257 | 13424 |
<value type="int" key="manualSizing">0</value> |
| 13258 |
<value type="real" key="top">9.64e+02</value>
|
|
| 13425 |
<value type="real" key="top">9.39e+02</value>
|
|
| 13259 | 13426 |
<value type="real" key="width">9.1e+01</value> |
| 13260 | 13427 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13261 | 13428 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13267 | 13434 |
<value type="int" key="expanded">1</value> |
| 13268 | 13435 |
<value type="real" key="height">2.5e+01</value> |
| 13269 | 13436 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13270 |
<value type="real" key="left">1.206e+03</value>
|
|
| 13437 |
<value type="real" key="left">1.213e+03</value>
|
|
| 13271 | 13438 |
<value type="int" key="locked">0</value> |
| 13272 | 13439 |
<value type="int" key="manualSizing">0</value> |
| 13273 |
<value type="real" key="top">1.049e+03</value>
|
|
| 13440 |
<value type="real" key="top">1.023e+03</value>
|
|
| 13274 | 13441 |
<value type="real" key="width">1.09e+02</value> |
| 13275 | 13442 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13276 | 13443 |
<value type="int" key="visible">1</value> |
| 13277 | 13444 |
<value type="string" key="name">2. concatenated</value> |
| 13278 | 13445 |
</value> |
| 13279 | 13446 |
<value type="object" struct-name="workbench.model.NoteFigure" id="9bf693ce-aca2-11e2-a207-080027bcf912" struct-checksum="0x56ccd040"> |
| 13280 |
<value type="string" key="text">v 3. parsed</value>
|
|
| 13447 |
<value type="string" key="text">3. parsed v</value>
|
|
| 13281 | 13448 |
<value type="string" key="color">#ffffff</value> |
| 13282 | 13449 |
<value type="int" key="expanded">1</value> |
| 13283 | 13450 |
<value type="real" key="height">2.7e+01</value> |
| 13284 | 13451 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13285 |
<value type="real" key="left">1.046e+03</value>
|
|
| 13452 |
<value type="real" key="left">1.036e+03</value>
|
|
| 13286 | 13453 |
<value type="int" key="locked">0</value> |
| 13287 | 13454 |
<value type="int" key="manualSizing">0</value> |
| 13288 |
<value type="real" key="top">1.095e+03</value>
|
|
| 13455 |
<value type="real" key="top">1.049e+03</value>
|
|
| 13289 | 13456 |
<value type="real" key="width">7.7e+01</value> |
| 13290 | 13457 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13291 | 13458 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13297 | 13464 |
<value type="int" key="expanded">1</value> |
| 13298 | 13465 |
<value type="real" key="height">2.5e+01</value> |
| 13299 | 13466 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13300 |
<value type="real" key="left">1.072e+03</value>
|
|
| 13467 |
<value type="real" key="left">1.192e+03</value>
|
|
| 13301 | 13468 |
<value type="int" key="locked">0</value> |
| 13302 | 13469 |
<value type="int" key="manualSizing">0</value> |
| 13303 |
<value type="real" key="top">1.178e+03</value>
|
|
| 13470 |
<value type="real" key="top">1.194e+03</value>
|
|
| 13304 | 13471 |
<value type="real" key="width">8.3e+01</value> |
| 13305 | 13472 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13306 | 13473 |
<value type="int" key="visible">1</value> |
| ... | ... | |
| 13312 | 13479 |
<value type="int" key="expanded">1</value> |
| 13313 | 13480 |
<value type="real" key="height">2.7e+01</value> |
| 13314 | 13481 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13315 |
<value type="real" key="left">1.449e+03</value>
|
|
| 13482 |
<value type="real" key="left">1.456e+03</value>
|
|
| 13316 | 13483 |
<value type="int" key="locked">0</value> |
| 13317 | 13484 |
<value type="int" key="manualSizing">0</value> |
| 13318 |
<value type="real" key="top">1.2e+03</value>
|
|
| 13485 |
<value type="real" key="top">1.179e+03</value>
|
|
| 13319 | 13486 |
<value type="real" key="width">8.6e+01</value> |
| 13320 | 13487 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13321 | 13488 |
<value type="int" key="visible">1</value> |
| 13322 | 13489 |
<value type="string" key="name">5. accepted</value> |
| 13323 | 13490 |
</value> |
| 13324 | 13491 |
<value type="object" struct-name="workbench.model.NoteFigure" id="5d420074-aca6-11e2-a207-080027bcf912" struct-checksum="0x56ccd040"> |
| 13325 |
<value type="string" key="text">1a. verbatim v</value>
|
|
| 13492 |
<value type="string" key="text">v 1a. verbatim</value>
|
|
| 13326 | 13493 |
<value type="string" key="color">#ffffff</value> |
| 13327 | 13494 |
<value type="int" key="expanded">1</value> |
| 13328 | 13495 |
<value type="real" key="height">2.5e+01</value> |
| ... | ... | |
| 13331 | 13498 |
<value type="int" key="locked">0</value> |
| 13332 | 13499 |
<value type="int" key="manualSizing">0</value> |
| 13333 | 13500 |
<value type="real" key="top">8.84e+02</value> |
| 13334 |
<value type="real" key="width">9.e+01</value> |
|
| 13501 |
<value type="real" key="width">9.3e+01</value>
|
|
| 13335 | 13502 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 13336 | 13503 |
<value type="int" key="visible">1</value> |
| 13337 | 13504 |
<value type="string" key="name">1a. verbatim</value> |
| ... | ... | |
| 14072 | 14239 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 14073 | 14240 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 14074 | 14241 |
<value type="string" key="caption">New Model</value> |
| 14075 |
<value type="string" key="dateChanged">2013-07-27 08:05</value>
|
|
| 14242 |
<value type="string" key="dateChanged">2013-07-27 08:38</value>
|
|
| 14076 | 14243 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 14077 | 14244 |
<value type="string" key="description"></value> |
| 14078 | 14245 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 72 | 72 |
UNIQUE KEY `collection_unique` (`institution`,`name`), |
| 73 | 73 |
KEY `fk_collection_organization1_idx` (`institution`), |
| 74 | 74 |
KEY `fk_collection_source1_idx` (`id`), |
| 75 |
CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 76 |
CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 75 |
CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 76 |
CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 77 | 77 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)';
|
| 78 | 78 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 79 | 79 |
|
| ... | ... | |
| 143 | 143 |
KEY `fk_event_place1_idx` (`place`), |
| 144 | 144 |
KEY `fk_event1_idx` (`parent`), |
| 145 | 145 |
KEY `fk_event_party_list1_idx` (`participants`), |
| 146 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 146 | 147 |
CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 147 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 148 | 148 |
CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 149 | 149 |
CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 150 | 150 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of time" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)';
|
| ... | ... | |
| 226 | 226 |
/*!40000 ALTER TABLE `geopath` ENABLE KEYS */; |
| 227 | 227 |
|
| 228 | 228 |
-- |
| 229 |
-- Table structure for table `geovalidatable_place`
|
|
| 229 |
-- Table structure for table `geoplace` |
|
| 230 | 230 |
-- |
| 231 | 231 |
|
| 232 | 232 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 233 | 233 |
/*!40101 SET character_set_client = utf8 */; |
| 234 |
CREATE TABLE `geovalidatable_place` (
|
|
| 234 |
CREATE TABLE `geoplace` ( |
|
| 235 | 235 |
`id` varbinary(767) NOT NULL, |
| 236 | 236 |
`geocoordinates` varbinary(767) NOT NULL, |
| 237 | 237 |
`geopath` varbinary(767) NOT NULL, |
| ... | ... | |
| 239 | 239 |
UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoordinates`), |
| 240 | 240 |
KEY `fk_geovalidation_place_path1_idx` (`geopath`), |
| 241 | 241 |
KEY `fk_geovalidation_coordinates1_idx` (`geocoordinates`), |
| 242 |
CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 243 |
CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 242 |
CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 243 |
CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 244 | 244 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 245 | 245 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 246 | 246 |
|
| 247 | 247 |
-- |
| 248 |
-- Dumping data for table `geovalidatable_place`
|
|
| 248 |
-- Dumping data for table `geoplace` |
|
| 249 | 249 |
-- |
| 250 | 250 |
|
| 251 |
/*!40000 ALTER TABLE `geovalidatable_place` DISABLE KEYS */;
|
|
| 252 |
/*!40000 ALTER TABLE `geovalidatable_place` ENABLE KEYS */;
|
|
| 251 |
/*!40000 ALTER TABLE `geoplace` DISABLE KEYS */; |
|
| 252 |
/*!40000 ALTER TABLE `geoplace` ENABLE KEYS */; |
|
| 253 | 253 |
|
| 254 | 254 |
-- |
| 255 | 255 |
-- Table structure for table `geovalidation` |
| ... | ... | |
| 263 | 263 |
`lat_long_domain_valid` tinyint(1) NOT NULL, |
| 264 | 264 |
`lat_long_in_place_ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 265 | 265 |
PRIMARY KEY (`id`), |
| 266 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geovalidatable_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 266 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 267 | 267 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'; |
| 268 | 268 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 269 | 269 |
|
| ... | ... | |
| 333 | 333 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 334 | 334 |
PRIMARY KEY (`id`), |
| 335 | 335 |
KEY `fk_method_method1_idx` (`parent`), |
| 336 |
CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 337 |
CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 336 |
CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 337 |
CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 338 | 338 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A specific method definition followed in the creation of the dataset. Each method links to a protocol and literature citation reference. A protocol may have many method or steps." ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/methods/method)';
|
| 339 | 339 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 340 | 340 |
|
| ... | ... | |
| 367 | 367 |
/*!40000 ALTER TABLE `organization` ENABLE KEYS */; |
| 368 | 368 |
|
| 369 | 369 |
-- |
| 370 |
-- Table structure for table `parsed_taxon_assertion` |
|
| 371 |
-- |
|
| 372 |
|
|
| 373 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 374 |
/*!40101 SET character_set_client = utf8 */; |
|
| 375 |
CREATE TABLE `parsed_taxon_assertion` ( |
|
| 376 |
`id` varbinary(767) NOT NULL, |
|
| 377 |
`matched_taxon_concept` varbinary(767) DEFAULT NULL, |
|
| 378 |
`match_score` float DEFAULT NULL, |
|
| 379 |
`match_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 380 |
PRIMARY KEY (`id`), |
|
| 381 |
KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`), |
|
| 382 |
CONSTRAINT `fk_matched_taxon_qualified_taxon10` FOREIGN KEY (`id`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 383 |
CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 384 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 385 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 386 |
|
|
| 387 |
-- |
|
| 388 |
-- Dumping data for table `parsed_taxon_assertion` |
|
| 389 |
-- |
|
| 390 |
|
|
| 391 |
/*!40000 ALTER TABLE `parsed_taxon_assertion` DISABLE KEYS */; |
|
| 392 |
/*!40000 ALTER TABLE `parsed_taxon_assertion` ENABLE KEYS */; |
|
| 393 |
|
|
| 394 |
-- |
|
| 395 | 370 |
-- Table structure for table `party` |
| 396 | 371 |
-- |
| 397 | 372 |
|
| ... | ... | |
| 403 | 378 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 404 | 379 |
PRIMARY KEY (`id`), |
| 405 | 380 |
KEY `fk_party_organization1_idx` (`organization`), |
| 406 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 407 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 381 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 382 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 408 | 383 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 409 | 384 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 410 | 385 |
|
| ... | ... | |
| 449 | 424 |
PRIMARY KEY (`id`,`entry`), |
| 450 | 425 |
KEY `fk_party_list_has_party_party1_idx` (`entry`), |
| 451 | 426 |
KEY `fk_party_list_has_party_party_list1_idx` (`id`), |
| 452 |
CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 453 |
CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 427 |
CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 428 |
CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 454 | 429 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 455 | 430 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 456 | 431 |
|
| ... | ... | |
| 477 | 452 |
KEY `fk_place_coordinates1_idx` (`geocoordinates`), |
| 478 | 453 |
KEY `fk_place1_idx` (`parent`), |
| 479 | 454 |
KEY `fk_place_place_path1_idx` (`geopath`), |
| 455 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 456 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 480 | 457 |
CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 481 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 482 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 483 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 458 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 484 | 459 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';
|
| 485 | 460 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 486 | 461 |
|
| ... | ... | |
| 510 | 485 |
KEY `fk_place_observation_place1_idx` (`place`), |
| 511 | 486 |
KEY `fk_place_observation_geological_context1_idx` (`geological_context`), |
| 512 | 487 |
KEY `fk_place_observation_community1_idx` (`community`), |
| 488 |
CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 489 |
CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 513 | 490 |
CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 514 |
CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 515 |
CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 516 | 491 |
CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 517 | 492 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'; |
| 518 | 493 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 656 | 631 |
`method` varbinary(767) DEFAULT NULL, |
| 657 | 632 |
PRIMARY KEY (`id`), |
| 658 | 633 |
KEY `fk_sampling_event_method1_idx` (`method`), |
| 659 |
CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 660 |
CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 634 |
CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 635 |
CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 661 | 636 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 662 | 637 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 663 | 638 |
|
| ... | ... | |
| 748 | 723 |
KEY `fk_specimen_collection2_idx` (`current_collection`), |
| 749 | 724 |
KEY `fk_specimen_organization3_idx` (`owner_collection`), |
| 750 | 725 |
KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`), |
| 751 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 726 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 727 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 728 |
CONSTRAINT `fk_specimen_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 752 | 729 |
CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 753 |
CONSTRAINT `fk_specimen_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 754 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 755 | 730 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 756 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 731 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 757 | 732 |
CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 758 | 733 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it';
|
| 759 | 734 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 777 | 752 |
`traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 778 | 753 |
PRIMARY KEY (`id`), |
| 779 | 754 |
KEY `fk_specimen_observation_specimen1_idx` (`specimen`), |
| 780 |
CONSTRAINT `fk_specimen_observation_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 781 |
CONSTRAINT `fk_specimen_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 755 |
CONSTRAINT `fk_specimen_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 756 |
CONSTRAINT `fk_specimen_observation_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 782 | 757 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 783 | 758 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 784 | 759 |
|
| ... | ... | |
| 827 | 802 |
UNIQUE KEY `stem_observation_unique` (`individual_observation`,`stem`), |
| 828 | 803 |
KEY `fk_stem_observation_individual_observation1_idx` (`individual_observation`), |
| 829 | 804 |
KEY `fk_stem_observation_stem1_idx` (`stem`), |
| 805 |
CONSTRAINT `fk_stem_observation_stem1` FOREIGN KEY (`stem`) REFERENCES `stem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 830 | 806 |
CONSTRAINT `fk_stem_observation_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 831 |
CONSTRAINT `fk_stem_observation_individual_observation2` FOREIGN KEY (`id`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 832 |
CONSTRAINT `fk_stem_observation_stem1` FOREIGN KEY (`stem`) REFERENCES `stem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 807 |
CONSTRAINT `fk_stem_observation_individual_observation2` FOREIGN KEY (`id`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 833 | 808 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'; |
| 834 | 809 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 835 | 810 |
|
| ... | ... | |
| 924 | 899 |
KEY `fk_taxon_assertion_taxon_string1_idx` (`string`), |
| 925 | 900 |
KEY `fk_taxon_assertion_taxon_name1_idx` (`taxon`), |
| 926 | 901 |
CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 927 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 928 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 902 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 903 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 929 | 904 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 930 | 905 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 931 | 906 |
|
| ... | ... | |
| 952 | 927 |
KEY `fk_taxon_taxon1_idx` (`parent`), |
| 953 | 928 |
KEY `fk_taxon_concept_source1_idx` (`according_to`), |
| 954 | 929 |
KEY `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon_concept`), |
| 930 |
CONSTRAINT `fk_taxon_taxon1` FOREIGN KEY (`parent`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 955 | 931 |
CONSTRAINT `fk_taxon_concept_source1` FOREIGN KEY (`according_to`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 956 | 932 |
CONSTRAINT `fk_taxon_concept_taxon_concept1` FOREIGN KEY (`accepted_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 957 |
CONSTRAINT `fk_taxon_concept_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 958 |
CONSTRAINT `fk_taxon_taxon1` FOREIGN KEY (`parent`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 933 |
CONSTRAINT `fk_taxon_concept_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 959 | 934 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'; |
| 960 | 935 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 961 | 936 |
|
| ... | ... | |
| 981 | 956 |
UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`), |
| 982 | 957 |
KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`), |
| 983 | 958 |
KEY `fk_taxon_determination_party_list1_idx` (`identified_by`), |
| 984 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 959 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 985 | 960 |
CONSTRAINT `fk_taxon_determination_record1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 986 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 961 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 987 | 962 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'; |
| 988 | 963 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 989 | 964 |
|
| ... | ... | |
| 1010 | 985 |
`rank` varbinary(767) DEFAULT NULL, |
| 1011 | 986 |
PRIMARY KEY (`id`), |
| 1012 | 987 |
KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`), |
| 1013 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 1014 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 988 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 989 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 1015 | 990 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 1016 | 991 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1017 | 992 |
|
| ... | ... | |
| 1068 | 1043 |
PRIMARY KEY (`id`), |
| 1069 | 1044 |
KEY `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination`), |
| 1070 | 1045 |
KEY `fk_taxon_occurrence_taxon_determination2_idx` (`current_determination`), |
| 1071 |
CONSTRAINT `fk_taxon_occurrence_event1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1072 | 1046 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` FOREIGN KEY (`original_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1073 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` FOREIGN KEY (`current_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1047 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` FOREIGN KEY (`current_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1048 |
CONSTRAINT `fk_taxon_occurrence_event1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1074 | 1049 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'; |
| 1075 | 1050 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1076 | 1051 |
|
| ... | ... | |
| 1130 | 1105 |
/*!40000 ALTER TABLE `taxon_presence` ENABLE KEYS */; |
| 1131 | 1106 |
|
| 1132 | 1107 |
-- |
| 1108 |
-- Table structure for table `taxon_scrub` |
|
| 1109 |
-- |
|
| 1110 |
|
|
| 1111 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 1112 |
/*!40101 SET character_set_client = utf8 */; |
|
| 1113 |
CREATE TABLE `taxon_scrub` ( |
|
| 1114 |
`id` varbinary(767) NOT NULL, |
|
| 1115 |
`input_string` varbinary(767) NOT NULL, |
|
| 1116 |
`parsed_taxon_assertion` varbinary(767) NOT NULL, |
|
| 1117 |
`matched_taxon_concept` varbinary(767) DEFAULT NULL, |
|
| 1118 |
`match_score` float DEFAULT NULL, |
|
| 1119 |
`match_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 1120 |
PRIMARY KEY (`id`), |
|
| 1121 |
KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`), |
|
| 1122 |
KEY `fk_taxon_scrub_taxon_assertion1_idx` (`parsed_taxon_assertion`), |
|
| 1123 |
KEY `fk_taxon_scrub_taxon_string1_idx` (`input_string`), |
|
| 1124 |
CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1125 |
CONSTRAINT `fk_taxon_scrub_taxon_assertion1` FOREIGN KEY (`parsed_taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1126 |
CONSTRAINT `fk_taxon_scrub_taxon_string1` FOREIGN KEY (`input_string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1127 |
CONSTRAINT `fk_taxon_scrub_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1128 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 1129 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 1130 |
|
|
| 1131 |
-- |
|
| 1132 |
-- Dumping data for table `taxon_scrub` |
|
| 1133 |
-- |
|
| 1134 |
|
|
| 1135 |
/*!40000 ALTER TABLE `taxon_scrub` DISABLE KEYS */; |
|
| 1136 |
/*!40000 ALTER TABLE `taxon_scrub` ENABLE KEYS */; |
|
| 1137 |
|
|
| 1138 |
-- |
|
| 1133 | 1139 |
-- Table structure for table `taxon_string` |
| 1134 | 1140 |
-- |
| 1135 | 1141 |
|
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 74 | 74 |
/*CONSTRAINT "collection_unique" */UNIQUE ("institution","name"),
|
| 75 | 75 |
/*KEY "fk_collection_organization1_idx" ("institution")*/CHECK (true),
|
| 76 | 76 |
/*KEY "fk_collection_source1_idx" ("id")*/CHECK (true),
|
| 77 |
/*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 78 |
/*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 77 |
/*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 78 |
/*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 79 | 79 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)'*/;
|
| 80 | 80 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 81 | 81 |
|
| ... | ... | |
| 145 | 145 |
/*KEY "fk_event_place1_idx" ("place")*/CHECK (true),
|
| 146 | 146 |
/*KEY "fk_event1_idx" ("parent")*/CHECK (true),
|
| 147 | 147 |
/*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),
|
| 148 |
/*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 148 | 149 |
/*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 149 |
/*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 150 | 150 |
/*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 151 | 151 |
/*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 152 | 152 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/;
|
| ... | ... | |
| 228 | 228 |
/*!40000 ALTER TABLE "geopath" ENABLE KEYS */; |
| 229 | 229 |
|
| 230 | 230 |
-- |
| 231 |
-- Table structure for table "geovalidatable_place"
|
|
| 231 |
-- Table structure for table "geoplace" |
|
| 232 | 232 |
-- |
| 233 | 233 |
|
| 234 | 234 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 235 | 235 |
/*!40101 SET character_set_client = utf8 */; |
| 236 |
CREATE TABLE "geovalidatable_place" (
|
|
| 236 |
CREATE TABLE "geoplace" ( |
|
| 237 | 237 |
"id" text NOT NULL, |
| 238 | 238 |
"geocoordinates" text NOT NULL, |
| 239 | 239 |
"geopath" text NOT NULL, |
| ... | ... | |
| 241 | 241 |
/*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoordinates"),
|
| 242 | 242 |
/*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true),
|
| 243 | 243 |
/*KEY "fk_geovalidation_coordinates1_idx" ("geocoordinates")*/CHECK (true),
|
| 244 |
/*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 245 |
/*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 244 |
/*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 245 |
/*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 246 | 246 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 247 | 247 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 248 | 248 |
|
| 249 | 249 |
-- |
| 250 |
-- Dumping data for table "geovalidatable_place"
|
|
| 250 |
-- Dumping data for table "geoplace" |
|
| 251 | 251 |
-- |
| 252 | 252 |
|
| 253 |
/*!40000 ALTER TABLE "geovalidatable_place" DISABLE KEYS */;
|
|
| 254 |
/*!40000 ALTER TABLE "geovalidatable_place" ENABLE KEYS */;
|
|
| 253 |
/*!40000 ALTER TABLE "geoplace" DISABLE KEYS */; |
|
| 254 |
/*!40000 ALTER TABLE "geoplace" ENABLE KEYS */; |
|
| 255 | 255 |
|
| 256 | 256 |
-- |
| 257 | 257 |
-- Table structure for table "geovalidation" |
| ... | ... | |
| 265 | 265 |
"lat_long_domain_valid" integer NOT NULL, |
| 266 | 266 |
"lat_long_in_place_ranks" hstore DEFAULT NULL, |
| 267 | 267 |
PRIMARY KEY ("id"),
|
| 268 |
/*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "geovalidatable_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 268 |
/*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 269 | 269 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/; |
| 270 | 270 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 271 | 271 |
|
| ... | ... | |
| 335 | 335 |
"info" hstore DEFAULT NULL, |
| 336 | 336 |
PRIMARY KEY ("id"),
|
| 337 | 337 |
/*KEY "fk_method_method1_idx" ("parent")*/CHECK (true),
|
| 338 |
/*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 339 |
/*CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 338 |
/*CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 339 |
/*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 340 | 340 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A specific method definition followed in the creation of the dataset. Each method links to a protocol and literature citation reference. A protocol may have many method or steps." ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/methods/method)'*/;
|
| 341 | 341 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 342 | 342 |
|
| ... | ... | |
| 369 | 369 |
/*!40000 ALTER TABLE "organization" ENABLE KEYS */; |
| 370 | 370 |
|
| 371 | 371 |
-- |
| 372 |
-- Table structure for table "parsed_taxon_assertion" |
|
| 373 |
-- |
|
| 374 |
|
|
| 375 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 376 |
/*!40101 SET character_set_client = utf8 */; |
|
| 377 |
CREATE TABLE "parsed_taxon_assertion" ( |
|
| 378 |
"id" text NOT NULL, |
|
| 379 |
"matched_taxon_concept" text DEFAULT NULL, |
|
| 380 |
"match_score" float DEFAULT NULL, |
|
| 381 |
"match_info" hstore DEFAULT NULL, |
|
| 382 |
PRIMARY KEY ("id"),
|
|
| 383 |
/*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),
|
|
| 384 |
/*CONSTRAINT "fk_matched_taxon_qualified_taxon10" FOREIGN KEY ("id") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 385 |
/*CONSTRAINT "fk_parsed_taxon_assertion_taxon_name1" FOREIGN KEY ("matched_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 386 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 387 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 388 |
|
|
| 389 |
-- |
|
| 390 |
-- Dumping data for table "parsed_taxon_assertion" |
|
| 391 |
-- |
|
| 392 |
|
|
| 393 |
/*!40000 ALTER TABLE "parsed_taxon_assertion" DISABLE KEYS */; |
|
| 394 |
/*!40000 ALTER TABLE "parsed_taxon_assertion" ENABLE KEYS */; |
|
| 395 |
|
|
| 396 |
-- |
|
| 397 | 372 |
-- Table structure for table "party" |
| 398 | 373 |
-- |
| 399 | 374 |
|
| ... | ... | |
| 405 | 380 |
"info" hstore DEFAULT NULL, |
| 406 | 381 |
PRIMARY KEY ("id"),
|
| 407 | 382 |
/*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),
|
| 408 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 409 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 383 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 384 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 410 | 385 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 411 | 386 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 412 | 387 |
|
| ... | ... | |
| 451 | 426 |
PRIMARY KEY ("id","entry"),
|
| 452 | 427 |
/*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),
|
| 453 | 428 |
/*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),
|
| 454 |
/*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 455 |
/*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 429 |
/*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 430 |
/*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 456 | 431 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 457 | 432 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 458 | 433 |
|
| ... | ... | |
| 479 | 454 |
/*KEY "fk_place_coordinates1_idx" ("geocoordinates")*/CHECK (true),
|
| 480 | 455 |
/*KEY "fk_place1_idx" ("parent")*/CHECK (true),
|
| 481 | 456 |
/*KEY "fk_place_place_path1_idx" ("geopath")*/CHECK (true),
|
| 457 |
/*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 458 |
/*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 482 | 459 |
/*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 483 |
/*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 484 |
/*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 485 |
/*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 460 |
/*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 486 | 461 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/;
|
| 487 | 462 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 488 | 463 |
|
| ... | ... | |
| 512 | 487 |
/*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),
|
| 513 | 488 |
/*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),
|
| 514 | 489 |
/*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),
|
| 490 |
/*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 491 |
/*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 515 | 492 |
/*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 516 |
/*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 517 |
/*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 518 | 493 |
/*CONSTRAINT "fk_place_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 519 | 494 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/; |
| 520 | 495 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 658 | 633 |
"method" text DEFAULT NULL, |
| 659 | 634 |
PRIMARY KEY ("id"),
|
| 660 | 635 |
/*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),
|
| 661 |
/*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 662 |
/*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 636 |
/*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 637 |
/*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 663 | 638 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 664 | 639 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 665 | 640 |
|
| ... | ... | |
| 750 | 725 |
/*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),
|
| 751 | 726 |
/*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),
|
| 752 | 727 |
/*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),
|
| 753 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 728 |
/*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 729 |
/*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 730 |
/*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 754 | 731 |
/*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 755 |
/*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 756 |
/*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 757 | 732 |
/*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 758 |
/*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 733 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 759 | 734 |
/*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 760 | 735 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it'*/;
|
| 761 | 736 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 779 | 754 |
"traits" hstore DEFAULT NULL, |
| 780 | 755 |
PRIMARY KEY ("id"),
|
| 781 | 756 |
/*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),
|
| 782 |
/*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 783 |
/*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 757 |
/*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 758 |
/*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 784 | 759 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 785 | 760 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 786 | 761 |
|
| ... | ... | |
| 829 | 804 |
/*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"),
|
| 830 | 805 |
/*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true),
|
| 831 | 806 |
/*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true),
|
| 807 |
/*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 832 | 808 |
/*CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 833 |
/*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 834 |
/*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 809 |
/*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 835 | 810 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/; |
| 836 | 811 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 837 | 812 |
|
| ... | ... | |
| 926 | 901 |
/*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true),
|
| 927 | 902 |
/*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true),
|
| 928 | 903 |
/*CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 929 |
/*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 930 |
/*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 904 |
/*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 905 |
/*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 931 | 906 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 932 | 907 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 933 | 908 |
|
| ... | ... | |
| 954 | 929 |
/*KEY "fk_taxon_taxon1_idx" ("parent")*/CHECK (true),
|
| 955 | 930 |
/*KEY "fk_taxon_concept_source1_idx" ("according_to")*/CHECK (true),
|
| 956 | 931 |
/*KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept")*/CHECK (true),
|
| 932 |
/*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 957 | 933 |
/*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 958 | 934 |
/*CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 959 |
/*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 960 |
/*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 935 |
/*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 961 | 936 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'*/; |
| 962 | 937 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 963 | 938 |
|
| ... | ... | |
| 983 | 958 |
/*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),
|
| 984 | 959 |
/*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),
|
| 985 | 960 |
/*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),
|
| 986 |
/*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 961 |
/*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 987 | 962 |
/*CONSTRAINT "fk_taxon_determination_record1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 988 |
/*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 963 |
/*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 989 | 964 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/; |
| 990 | 965 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 991 | 966 |
|
| ... | ... | |
| 1012 | 987 |
"rank" text DEFAULT NULL, |
| 1013 | 988 |
PRIMARY KEY ("id"),
|
| 1014 | 989 |
/*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),
|
| 1015 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1016 |
/*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 990 |
/*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 991 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1017 | 992 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 1018 | 993 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1019 | 994 |
|
| ... | ... | |
| 1070 | 1045 |
PRIMARY KEY ("id"),
|
| 1071 | 1046 |
/*KEY "fk_taxon_occurrence_taxon_determination1_idx" ("original_determination")*/CHECK (true),
|
| 1072 | 1047 |
/*KEY "fk_taxon_occurrence_taxon_determination2_idx" ("current_determination")*/CHECK (true),
|
| 1073 |
/*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1074 | 1048 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination1" FOREIGN KEY ("original_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1075 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1049 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1050 |
/*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1076 | 1051 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'*/; |
| 1077 | 1052 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1078 | 1053 |
|
| ... | ... | |
| 1132 | 1107 |
/*!40000 ALTER TABLE "taxon_presence" ENABLE KEYS */; |
| 1133 | 1108 |
|
| 1134 | 1109 |
-- |
| 1110 |
-- Table structure for table "taxon_scrub" |
|
| 1111 |
-- |
|
| 1112 |
|
|
| 1113 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 1114 |
/*!40101 SET character_set_client = utf8 */; |
|
| 1115 |
CREATE TABLE "taxon_scrub" ( |
|
| 1116 |
"id" text NOT NULL, |
|
| 1117 |
"input_string" text NOT NULL, |
|
| 1118 |
"parsed_taxon_assertion" text NOT NULL, |
|
| 1119 |
"matched_taxon_concept" text DEFAULT NULL, |
|
| 1120 |
"match_score" float DEFAULT NULL, |
|
| 1121 |
"match_info" hstore DEFAULT NULL, |
|
| 1122 |
PRIMARY KEY ("id"),
|
|
| 1123 |
/*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),
|
|
| 1124 |
/*KEY "fk_taxon_scrub_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true),
|
|
| 1125 |
/*KEY "fk_taxon_scrub_taxon_string1_idx" ("input_string")*/CHECK (true),
|
|
| 1126 |
/*CONSTRAINT "fk_parsed_taxon_assertion_taxon_name1" FOREIGN KEY ("matched_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1127 |
/*CONSTRAINT "fk_taxon_scrub_taxon_assertion1" FOREIGN KEY ("parsed_taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1128 |
/*CONSTRAINT "fk_taxon_scrub_taxon_string1" FOREIGN KEY ("input_string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1129 |
/*CONSTRAINT "fk_taxon_scrub_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1130 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 1131 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 1132 |
|
|
| 1133 |
-- |
|
| 1134 |
-- Dumping data for table "taxon_scrub" |
|
| 1135 |
-- |
|
| 1136 |
|
|
| 1137 |
/*!40000 ALTER TABLE "taxon_scrub" DISABLE KEYS */; |
|
| 1138 |
/*!40000 ALTER TABLE "taxon_scrub" ENABLE KEYS */; |
|
| 1139 |
|
|
| 1140 |
-- |
|
| 1135 | 1141 |
-- Table structure for table "taxon_string" |
| 1136 | 1142 |
-- |
| 1137 | 1143 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: replaced parsed_taxon_assertion with taxon_scrub, which HAS-A parsed taxon_assertion rather than BEING-A parsed_taxon_assertion. (multiple TNRS results may parse to the same thing.)