Revision 10466
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/document.mwb.xml | ||
|---|---|---|
| 2836 | 2836 |
<value type="int" key="commentedOut">0</value> |
| 2837 | 2837 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
| 2838 | 2838 |
<value _ptr_="0xa390438" type="dict" key="customData"/> |
| 2839 |
<value type="string" key="lastChangeDate">2013-04-24 14:29</value>
|
|
| 2839 |
<value type="string" key="lastChangeDate">2013-07-27 07:26</value>
|
|
| 2840 | 2840 |
<value type="int" key="modelOnly">0</value> |
| 2841 |
<value type="string" key="name">coordinates</value> |
|
| 2841 |
<value type="string" key="name">geocoordinates</value>
|
|
| 2842 | 2842 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 2843 | 2843 |
<value type="string" key="temp_sql"></value> |
| 2844 | 2844 |
<value type="string" key="comment">A numerically-defined point</value> |
| 2845 |
<value type="string" key="oldName">coordinates</value> |
|
| 2845 |
<value type="string" key="oldName">geocoordinates</value>
|
|
| 2846 | 2846 |
</value> |
| 2847 | 2847 |
<value type="object" struct-name="db.mysql.Table" id="16537a20-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x1a403946"> |
| 2848 | 2848 |
<value type="string" key="avgRowLength"></value> |
| ... | ... | |
| 4961 | 4961 |
<value type="int" key="commentedOut">0</value> |
| 4962 | 4962 |
<value type="string" key="createDate">2013-04-17 13:52</value> |
| 4963 | 4963 |
<value _ptr_="0xa3adf40" type="dict" key="customData"/> |
| 4964 |
<value type="string" key="lastChangeDate">2013-04-24 14:29</value>
|
|
| 4964 |
<value type="string" key="lastChangeDate">2013-07-27 07:36</value>
|
|
| 4965 | 4965 |
<value type="int" key="modelOnly">0</value> |
| 4966 |
<value type="string" key="name">place_path</value>
|
|
| 4966 |
<value type="string" key="name">geopath</value>
|
|
| 4967 | 4967 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 4968 | 4968 |
<value type="string" key="temp_sql"></value> |
| 4969 | 4969 |
<value type="string" key="comment">A named region</value> |
| 4970 |
<value type="string" key="oldName">place_path</value>
|
|
| 4970 |
<value type="string" key="oldName">geopath</value>
|
|
| 4971 | 4971 |
</value> |
| 4972 | 4972 |
<value type="object" struct-name="db.mysql.Table" id="be8f58b6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
| 4973 | 4973 |
<value type="string" key="avgRowLength"></value> |
| ... | ... | |
| 5159 | 5159 |
<value type="int" key="scale">-1</value> |
| 5160 | 5160 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 5161 | 5161 |
<value type="string" key="comment"></value> |
| 5162 |
<value type="string" key="name">coordinates</value> |
|
| 5163 |
<value type="string" key="oldName">coordinates</value> |
|
| 5162 |
<value type="string" key="name">geocoordinates</value>
|
|
| 5163 |
<value type="string" key="oldName">geocoordinates</value>
|
|
| 5164 | 5164 |
<link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link> |
| 5165 | 5165 |
</value> |
| 5166 | 5166 |
<value type="object" struct-name="db.mysql.Column" id="c67244c4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 5178 | 5178 |
<value type="int" key="scale">-1</value> |
| 5179 | 5179 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 5180 | 5180 |
<value type="string" key="comment"></value> |
| 5181 |
<value type="string" key="name">path</value> |
|
| 5182 |
<value type="string" key="oldName">path</value> |
|
| 5181 |
<value type="string" key="name">geopath</value>
|
|
| 5182 |
<value type="string" key="oldName">geopath</value>
|
|
| 5183 | 5183 |
<link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link> |
| 5184 | 5184 |
</value> |
| 5185 | 5185 |
<value type="object" struct-name="db.mysql.Column" id="c672467c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 5416 | 5416 |
<value type="int" key="commentedOut">0</value> |
| 5417 | 5417 |
<value type="string" key="createDate">2013-04-17 13:52</value> |
| 5418 | 5418 |
<value _ptr_="0xa3b2cb8" type="dict" key="customData"/> |
| 5419 |
<value type="string" key="lastChangeDate">2013-04-24 14:30</value>
|
|
| 5419 |
<value type="string" key="lastChangeDate">2013-07-27 07:37</value>
|
|
| 5420 | 5420 |
<value type="int" key="modelOnly">0</value> |
| 5421 | 5421 |
<value type="string" key="name">place</value> |
| 5422 | 5422 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 5501 | 5501 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link> |
| 5502 | 5502 |
<value type="string" key="comment"></value> |
| 5503 | 5503 |
<value type="string" key="name">coordinates</value> |
| 5504 |
<value type="string" key="oldName"></value> |
|
| 5504 |
<value type="string" key="oldName">coordinates</value>
|
|
| 5505 | 5505 |
<link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link> |
| 5506 | 5506 |
</value> |
| 5507 | 5507 |
</value> |
| ... | ... | |
| 5632 | 5632 |
<value type="int" key="scale">-1</value> |
| 5633 | 5633 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 5634 | 5634 |
<value type="string" key="comment"></value> |
| 5635 |
<value type="string" key="name">coordinates</value> |
|
| 5636 |
<value type="string" key="oldName">coordinates</value> |
|
| 5635 |
<value type="string" key="name">geocoordinates</value>
|
|
| 5636 |
<value type="string" key="oldName">geocoordinates</value>
|
|
| 5637 | 5637 |
<link type="object" struct-name="GrtObject" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link> |
| 5638 | 5638 |
</value> |
| 5639 | 5639 |
<value type="object" struct-name="db.mysql.Column" id="2ba6fbb8-a761-11e2-aa10-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 5651 | 5651 |
<value type="int" key="scale">-1</value> |
| 5652 | 5652 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 5653 | 5653 |
<value type="string" key="comment"></value> |
| 5654 |
<value type="string" key="name">path</value> |
|
| 5655 |
<value type="string" key="oldName">path</value> |
|
| 5654 |
<value type="string" key="name">geopath</value>
|
|
| 5655 |
<value type="string" key="oldName">geopath</value>
|
|
| 5656 | 5656 |
<link type="object" struct-name="GrtObject" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link> |
| 5657 | 5657 |
</value> |
| 5658 | 5658 |
</value> |
| ... | ... | |
| 5836 | 5836 |
<value type="int" key="commentedOut">0</value> |
| 5837 | 5837 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
| 5838 | 5838 |
<value _ptr_="0xa3b99e0" type="dict" key="customData"/> |
| 5839 |
<value type="string" key="lastChangeDate">2013-04-18 16:21</value>
|
|
| 5839 |
<value type="string" key="lastChangeDate">2013-07-27 07:38</value>
|
|
| 5840 | 5840 |
<value type="int" key="modelOnly">0</value> |
| 5841 |
<value type="string" key="name">validatable_place</value> |
|
| 5841 |
<value type="string" key="name">geovalidatable_place</value>
|
|
| 5842 | 5842 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 5843 | 5843 |
<value type="string" key="temp_sql"></value> |
| 5844 | 5844 |
<value type="string" key="comment"></value> |
| 5845 |
<value type="string" key="oldName">validatable_place</value> |
|
| 5845 |
<value type="string" key="oldName">geovalidatable_place</value>
|
|
| 5846 | 5846 |
</value> |
| 5847 | 5847 |
<value type="object" struct-name="db.mysql.Table" id="c672f914-a7a0-11e2-b667-080027bcf912" struct-checksum="0x1a403946"> |
| 5848 | 5848 |
<value type="string" key="avgRowLength"></value> |
| ... | ... | |
| 8183 | 8183 |
<value type="string" key="collationName"></value> |
| 8184 | 8184 |
<value type="string" key="datatypeExplicitParams"></value> |
| 8185 | 8185 |
<value type="string" key="defaultValue"></value> |
| 8186 |
<value type="int" key="defaultValueIsNull">0</value>
|
|
| 8186 |
<value type="int" key="defaultValueIsNull">1</value>
|
|
| 8187 | 8187 |
<value _ptr_="0xad56548" type="list" content-type="string" key="flags"/> |
| 8188 | 8188 |
<value type="int" key="isNotNull">0</value> |
| 8189 | 8189 |
<value type="int" key="length">767</value> |
| ... | ... | |
| 8192 | 8192 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 8193 | 8193 |
<value type="string" key="comment"></value> |
| 8194 | 8194 |
<value type="string" key="name">shape</value> |
| 8195 |
<value type="string" key="oldName"></value> |
|
| 8195 |
<value type="string" key="oldName">shape</value>
|
|
| 8196 | 8196 |
<link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link> |
| 8197 | 8197 |
</value> |
| 8198 | 8198 |
<value type="object" struct-name="db.mysql.Column" id="66c25c1c-a791-11e2-84c3-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 8211 | 8211 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 8212 | 8212 |
<value type="string" key="comment"></value> |
| 8213 | 8213 |
<value type="string" key="name">bounding_box_rect</value> |
| 8214 |
<value type="string" key="oldName">bounding_box_WKT</value>
|
|
| 8214 |
<value type="string" key="oldName">bounding_box_rect</value>
|
|
| 8215 | 8215 |
<link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link> |
| 8216 | 8216 |
</value> |
| 8217 | 8217 |
<value type="object" struct-name="db.mysql.Column" id="0a33807e-f6c5-11e2-af44-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 8221 | 8221 |
<value type="string" key="collationName"></value> |
| 8222 | 8222 |
<value type="string" key="datatypeExplicitParams"></value> |
| 8223 | 8223 |
<value type="string" key="defaultValue"></value> |
| 8224 |
<value type="int" key="defaultValueIsNull">0</value>
|
|
| 8224 |
<value type="int" key="defaultValueIsNull">1</value>
|
|
| 8225 | 8225 |
<value _ptr_="0xa3e1120" type="list" content-type="string" key="flags"/> |
| 8226 | 8226 |
<value type="int" key="isNotNull">0</value> |
| 8227 | 8227 |
<value type="int" key="length">767</value> |
| ... | ... | |
| 8249 | 8249 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link> |
| 8250 | 8250 |
<value type="string" key="comment"></value> |
| 8251 | 8251 |
<value type="string" key="name">dimensions</value> |
| 8252 |
<value type="string" key="oldName"></value> |
|
| 8252 |
<value type="string" key="oldName">dimensions</value>
|
|
| 8253 | 8253 |
<link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link> |
| 8254 | 8254 |
</value> |
| 8255 | 8255 |
</value> |
| ... | ... | |
| 12236 | 12236 |
<value type="int" key="expanded">1</value> |
| 12237 | 12237 |
<value type="real" key="height">1.e+02</value> |
| 12238 | 12238 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12239 |
<value type="real" key="left">5.99e+02</value>
|
|
| 12239 |
<value type="real" key="left">6.01e+02</value>
|
|
| 12240 | 12240 |
<value type="int" key="locked">0</value> |
| 12241 | 12241 |
<value type="int" key="manualSizing">0</value> |
| 12242 | 12242 |
<value type="real" key="top">5.7e+01</value> |
| 12243 |
<value type="real" key="width">1.18e+02</value>
|
|
| 12243 |
<value type="real" key="width">1.39e+02</value>
|
|
| 12244 | 12244 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12245 | 12245 |
<value type="int" key="visible">1</value> |
| 12246 |
<value type="string" key="name">coordinates</value> |
|
| 12246 |
<value type="string" key="name">geocoordinates</value>
|
|
| 12247 | 12247 |
</value> |
| 12248 | 12248 |
<value type="object" struct-name="workbench.physical.TableFigure" id="C43D5355-2E9C-4315-BA47-B9741D1BB3B9" struct-checksum="0x3b14eccb"> |
| 12249 | 12249 |
<value type="int" key="columnsExpanded">1</value> |
| ... | ... | |
| 12276 | 12276 |
<value type="int" key="expanded">1</value> |
| 12277 | 12277 |
<value type="real" key="height">1.46e+02</value> |
| 12278 | 12278 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12279 |
<value type="real" key="left">4.3e+02</value>
|
|
| 12279 |
<value type="real" key="left">4.25e+02</value>
|
|
| 12280 | 12280 |
<value type="int" key="locked">0</value> |
| 12281 | 12281 |
<value type="int" key="manualSizing">0</value> |
| 12282 | 12282 |
<value type="real" key="top">2.95e+02</value> |
| 12283 |
<value type="real" key="width">8.e+01</value>
|
|
| 12283 |
<value type="real" key="width">9.7e+01</value>
|
|
| 12284 | 12284 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12285 | 12285 |
<value type="int" key="visible">1</value> |
| 12286 | 12286 |
<value type="string" key="name">place</value> |
| ... | ... | |
| 12316 | 12316 |
<value type="int" key="expanded">1</value> |
| 12317 | 12317 |
<value type="real" key="height">1.92e+02</value> |
| 12318 | 12318 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12319 |
<value type="real" key="left">2.58e+02</value>
|
|
| 12319 |
<value type="real" key="left">2.57e+02</value>
|
|
| 12320 | 12320 |
<value type="int" key="locked">0</value> |
| 12321 | 12321 |
<value type="int" key="manualSizing">0</value> |
| 12322 | 12322 |
<value type="real" key="top">6.e+01</value> |
| 12323 |
<value type="real" key="width">1.12e+02</value>
|
|
| 12323 |
<value type="real" key="width">9.6e+01</value>
|
|
| 12324 | 12324 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12325 | 12325 |
<value type="int" key="visible">1</value> |
| 12326 |
<value type="string" key="name">place_path</value>
|
|
| 12326 |
<value type="string" key="name">geopath</value>
|
|
| 12327 | 12327 |
</value> |
| 12328 | 12328 |
<value type="object" struct-name="workbench.physical.TableFigure" id="D9C4F621-07DC-4B10-A898-30DA84E9030D" struct-checksum="0x3b14eccb"> |
| 12329 | 12329 |
<value type="int" key="columnsExpanded">1</value> |
| ... | ... | |
| 12356 | 12356 |
<value type="int" key="expanded">1</value> |
| 12357 | 12357 |
<value type="real" key="height">1.e+02</value> |
| 12358 | 12358 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 12359 |
<value type="real" key="left">4.12e+02</value>
|
|
| 12359 |
<value type="real" key="left">3.97e+02</value>
|
|
| 12360 | 12360 |
<value type="int" key="locked">0</value> |
| 12361 | 12361 |
<value type="int" key="manualSizing">0</value> |
| 12362 |
<value type="real" key="top">1.4e+01</value>
|
|
| 12363 |
<value type="real" key="width">1.49e+02</value>
|
|
| 12362 |
<value type="real" key="top">1.1e+01</value>
|
|
| 12363 |
<value type="real" key="width">1.7e+02</value>
|
|
| 12364 | 12364 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
| 12365 | 12365 |
<value type="int" key="visible">1</value> |
| 12366 |
<value type="string" key="name">validatable_place</value> |
|
| 12366 |
<value type="string" key="name">geovalidatable_place</value>
|
|
| 12367 | 12367 |
</value> |
| 12368 | 12368 |
<value type="object" struct-name="workbench.physical.TableFigure" id="FF3A48D7-490E-4E77-B97B-1F51BF51FA8A" struct-checksum="0x3b14eccb"> |
| 12369 | 12369 |
<value type="int" key="columnsExpanded">1</value> |
| ... | ... | |
| 13042 | 13042 |
<value type="int" key="expanded">1</value> |
| 13043 | 13043 |
<value type="real" key="height">2.3e+01</value> |
| 13044 | 13044 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13045 |
<value type="real" key="left">8.21e+02</value>
|
|
| 13045 |
<value type="real" key="left">8.1e+02</value> |
|
| 13046 | 13046 |
<value type="int" key="locked">0</value> |
| 13047 | 13047 |
<value type="int" key="manualSizing">0</value> |
| 13048 | 13048 |
<value type="real" key="top">0.e+00</value> |
| ... | ... | |
| 13122 | 13122 |
<value type="int" key="expanded">1</value> |
| 13123 | 13123 |
<value type="real" key="height">1.23e+02</value> |
| 13124 | 13124 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13125 |
<value type="real" key="left">4.17e+02</value>
|
|
| 13125 |
<value type="real" key="left">4.12e+02</value>
|
|
| 13126 | 13126 |
<value type="int" key="locked">0</value> |
| 13127 | 13127 |
<value type="int" key="manualSizing">0</value> |
| 13128 | 13128 |
<value type="real" key="top">1.47e+02</value> |
| ... | ... | |
| 13342 | 13342 |
<value type="int" key="expanded">1</value> |
| 13343 | 13343 |
<value type="real" key="height">2.7e+01</value> |
| 13344 | 13344 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
| 13345 |
<value type="real" key="left">7.67e+02</value>
|
|
| 13345 |
<value type="real" key="left">7.56e+02</value>
|
|
| 13346 | 13346 |
<value type="int" key="locked">0</value> |
| 13347 | 13347 |
<value type="int" key="manualSizing">0</value> |
| 13348 | 13348 |
<value type="real" key="top">0.e+00</value> |
| ... | ... | |
| 13568 | 13568 |
<link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link> |
| 13569 | 13569 |
<value _ptr_="0xa376868" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/> |
| 13570 | 13570 |
<value _ptr_="0x9b953e8" type="dict" key="syncProfiles"> |
| 13571 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="2a7cd92e-f6c6-11e2-a35e-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
| 13572 |
<value _ptr_="0xacbca68" type="dict" key="lastKnownDBNames">
|
|
| 13571 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="6e266272-f6ca-11e2-a35e-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
| 13572 |
<value _ptr_="0xae9af80" type="dict" key="lastKnownDBNames">
|
|
| 13573 | 13573 |
<value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value> |
| 13574 | 13574 |
<value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value> |
| 13575 | 13575 |
<value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value> |
| ... | ... | |
| 13629 | 13629 |
<value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value> |
| 13630 | 13630 |
<value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value> |
| 13631 | 13631 |
<value type="string" key="2ba6f9f6-a761-11e2-aa10-080027bcf912">fk_geovalidation_place_path1</value> |
| 13632 |
<value type="string" key="2ba6fbb8-a761-11e2-aa10-080027bcf912">path</value> |
|
| 13632 |
<value type="string" key="2ba6fbb8-a761-11e2-aa10-080027bcf912">geopath</value>
|
|
| 13633 | 13633 |
<value type="string" key="2ba715bc-a761-11e2-aa10-080027bcf912">fk_geovalidation_place_path1_idx</value> |
| 13634 | 13634 |
<value type="string" key="2e2885fa-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1</value> |
| 13635 |
<value type="string" key="2e2887c6-a761-11e2-aa10-080027bcf912">coordinates</value> |
|
| 13635 |
<value type="string" key="2e2887c6-a761-11e2-aa10-080027bcf912">geocoordinates</value>
|
|
| 13636 | 13636 |
<value type="string" key="2e28a288-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1_idx</value> |
| 13637 | 13637 |
<value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value> |
| 13638 | 13638 |
<value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value> |
| ... | ... | |
| 13745 | 13745 |
<value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value> |
| 13746 | 13746 |
<value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value> |
| 13747 | 13747 |
<value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value> |
| 13748 |
<value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value> |
|
| 13748 | 13749 |
<value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value> |
| 13749 | 13750 |
<value type="string" key="980eb49e-ad0b-11e2-b309-080027bcf912">fk_taxon_presence_taxon_name1_idx</value> |
| 13750 | 13751 |
<value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value> |
| ... | ... | |
| 13810 | 13811 |
<value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value> |
| 13811 | 13812 |
<value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value> |
| 13812 | 13813 |
<value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value> |
| 13813 |
<value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">coordinates</value> |
|
| 13814 |
<value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geocoordinates</value>
|
|
| 13814 | 13815 |
<value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value> |
| 13815 | 13816 |
<value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value> |
| 13816 | 13817 |
<value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value> |
| ... | ... | |
| 13871 | 13872 |
<value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplot</value> |
| 13872 | 13873 |
<value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value> |
| 13873 | 13874 |
<value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value> |
| 13874 |
<value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">validatable_place</value> |
|
| 13875 |
<value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>
|
|
| 13875 | 13876 |
<value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value> |
| 13876 | 13877 |
<value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value> |
| 13877 | 13878 |
<value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value> |
| ... | ... | |
| 13895 | 13896 |
<value type="string" key="c540c5c0-ad19-11e2-9d85-080027bcf912">traits</value> |
| 13896 | 13897 |
<value type="string" key="c66112f6-ad10-11e2-b309-080027bcf912">fk_specimen_collection2</value> |
| 13897 | 13898 |
<value type="string" key="c6612660-ad10-11e2-b309-080027bcf912">fk_specimen_collection2_idx</value> |
| 13898 |
<value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">place_path</value>
|
|
| 13899 |
<value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
|
|
| 13899 | 13900 |
<value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value> |
| 13900 | 13901 |
<value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value> |
| 13901 | 13902 |
<value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value> |
| ... | ... | |
| 13907 | 13908 |
<value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value> |
| 13908 | 13909 |
<value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value> |
| 13909 | 13910 |
<value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value> |
| 13910 |
<value type="string" key="c6724334-a7a0-11e2-b667-080027bcf912">coordinates</value> |
|
| 13911 |
<value type="string" key="c67244c4-a7a0-11e2-b667-080027bcf912">path</value> |
|
| 13911 |
<value type="string" key="c6724334-a7a0-11e2-b667-080027bcf912">geocoordinates</value>
|
|
| 13912 |
<value type="string" key="c67244c4-a7a0-11e2-b667-080027bcf912">geopath</value>
|
|
| 13912 | 13913 |
<value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value> |
| 13913 | 13914 |
<value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value> |
| 13914 | 13915 |
<value type="string" key="c6724b72-a7a0-11e2-b667-080027bcf912">fk_place_coordinates1_idx</value> |
| ... | ... | |
| 13960 | 13961 |
<value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value> |
| 13961 | 13962 |
<value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value> |
| 13962 | 13963 |
<value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value> |
| 13964 |
<value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coordinates</value> |
|
| 13963 | 13965 |
<value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value> |
| 13964 | 13966 |
<value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value> |
| 13965 | 13967 |
<value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value> |
| ... | ... | |
| 14070 | 14072 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 14071 | 14073 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 14072 | 14074 |
<value type="string" key="caption">New Model</value> |
| 14073 |
<value type="string" key="dateChanged">2013-07-27 07:22</value>
|
|
| 14075 |
<value type="string" key="dateChanged">2013-07-27 07:40</value>
|
|
| 14074 | 14076 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 14075 | 14077 |
<value type="string" key="description"></value> |
| 14076 | 14078 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 107 | 107 |
/*!40000 ALTER TABLE `community` ENABLE KEYS */; |
| 108 | 108 |
|
| 109 | 109 |
-- |
| 110 |
-- Table structure for table `coordinates` |
|
| 111 |
-- |
|
| 112 |
|
|
| 113 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 114 |
/*!40101 SET character_set_client = utf8 */; |
|
| 115 |
CREATE TABLE `coordinates` ( |
|
| 116 |
`id` varbinary(767) NOT NULL, |
|
| 117 |
`latitude_deg` varbinary(767) DEFAULT NULL, |
|
| 118 |
`longitude_deg` varbinary(767) DEFAULT NULL, |
|
| 119 |
PRIMARY KEY (`id`) |
|
| 120 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'; |
|
| 121 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 122 |
|
|
| 123 |
-- |
|
| 124 |
-- Dumping data for table `coordinates` |
|
| 125 |
-- |
|
| 126 |
|
|
| 127 |
/*!40000 ALTER TABLE `coordinates` DISABLE KEYS */; |
|
| 128 |
/*!40000 ALTER TABLE `coordinates` ENABLE KEYS */; |
|
| 129 |
|
|
| 130 |
-- |
|
| 131 | 110 |
-- Table structure for table `derived_class` |
| 132 | 111 |
-- |
| 133 | 112 |
|
| ... | ... | |
| 179 | 158 |
/*!40000 ALTER TABLE `event` ENABLE KEYS */; |
| 180 | 159 |
|
| 181 | 160 |
-- |
| 161 |
-- Table structure for table `geocoordinates` |
|
| 162 |
-- |
|
| 163 |
|
|
| 164 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 165 |
/*!40101 SET character_set_client = utf8 */; |
|
| 166 |
CREATE TABLE `geocoordinates` ( |
|
| 167 |
`id` varbinary(767) NOT NULL, |
|
| 168 |
`latitude_deg` varbinary(767) DEFAULT NULL, |
|
| 169 |
`longitude_deg` varbinary(767) DEFAULT NULL, |
|
| 170 |
PRIMARY KEY (`id`) |
|
| 171 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'; |
|
| 172 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 173 |
|
|
| 174 |
-- |
|
| 175 |
-- Dumping data for table `geocoordinates` |
|
| 176 |
-- |
|
| 177 |
|
|
| 178 |
/*!40000 ALTER TABLE `geocoordinates` DISABLE KEYS */; |
|
| 179 |
/*!40000 ALTER TABLE `geocoordinates` ENABLE KEYS */; |
|
| 180 |
|
|
| 181 |
-- |
|
| 182 | 182 |
-- Table structure for table `geological_context` |
| 183 | 183 |
-- |
| 184 | 184 |
|
| ... | ... | |
| 201 | 201 |
/*!40000 ALTER TABLE `geological_context` ENABLE KEYS */; |
| 202 | 202 |
|
| 203 | 203 |
-- |
| 204 |
-- Table structure for table `geopath` |
|
| 205 |
-- |
|
| 206 |
|
|
| 207 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 208 |
/*!40101 SET character_set_client = utf8 */; |
|
| 209 |
CREATE TABLE `geopath` ( |
|
| 210 |
`id` varbinary(767) NOT NULL, |
|
| 211 |
`continent` varbinary(767) DEFAULT NULL, |
|
| 212 |
`country` varbinary(767) DEFAULT NULL, |
|
| 213 |
`state_province` varbinary(767) DEFAULT NULL, |
|
| 214 |
`county` varbinary(767) DEFAULT NULL, |
|
| 215 |
`municipality` varbinary(767) DEFAULT NULL, |
|
| 216 |
`ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 217 |
PRIMARY KEY (`id`) |
|
| 218 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'; |
|
| 219 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 220 |
|
|
| 221 |
-- |
|
| 222 |
-- Dumping data for table `geopath` |
|
| 223 |
-- |
|
| 224 |
|
|
| 225 |
/*!40000 ALTER TABLE `geopath` DISABLE KEYS */; |
|
| 226 |
/*!40000 ALTER TABLE `geopath` ENABLE KEYS */; |
|
| 227 |
|
|
| 228 |
-- |
|
| 229 |
-- Table structure for table `geovalidatable_place` |
|
| 230 |
-- |
|
| 231 |
|
|
| 232 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 233 |
/*!40101 SET character_set_client = utf8 */; |
|
| 234 |
CREATE TABLE `geovalidatable_place` ( |
|
| 235 |
`id` varbinary(767) NOT NULL, |
|
| 236 |
`geocoordinates` varbinary(767) NOT NULL, |
|
| 237 |
`geopath` varbinary(767) NOT NULL, |
|
| 238 |
PRIMARY KEY (`id`), |
|
| 239 |
UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoordinates`), |
|
| 240 |
KEY `fk_geovalidation_place_path1_idx` (`geopath`), |
|
| 241 |
KEY `fk_geovalidation_coordinates1_idx` (`geocoordinates`), |
|
| 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 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 245 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 246 |
|
|
| 247 |
-- |
|
| 248 |
-- Dumping data for table `geovalidatable_place` |
|
| 249 |
-- |
|
| 250 |
|
|
| 251 |
/*!40000 ALTER TABLE `geovalidatable_place` DISABLE KEYS */; |
|
| 252 |
/*!40000 ALTER TABLE `geovalidatable_place` ENABLE KEYS */; |
|
| 253 |
|
|
| 254 |
-- |
|
| 204 | 255 |
-- Table structure for table `geovalidation` |
| 205 | 256 |
-- |
| 206 | 257 |
|
| ... | ... | |
| 212 | 263 |
`lat_long_domain_valid` tinyint(1) NOT NULL, |
| 213 | 264 |
`lat_long_in_place_ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 214 | 265 |
PRIMARY KEY (`id`), |
| 215 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `validatable_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 266 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geovalidatable_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 216 | 267 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'; |
| 217 | 268 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 218 | 269 |
|
| ... | ... | |
| 419 | 470 |
CREATE TABLE `place` ( |
| 420 | 471 |
`id` varbinary(767) NOT NULL, |
| 421 | 472 |
`parent` varbinary(767) NOT NULL, |
| 422 |
`coordinates` varbinary(767) DEFAULT NULL, |
|
| 423 |
`path` varbinary(767) DEFAULT NULL, |
|
| 473 |
`geocoordinates` varbinary(767) DEFAULT NULL,
|
|
| 474 |
`geopath` varbinary(767) DEFAULT NULL,
|
|
| 424 | 475 |
`locality` varbinary(767) DEFAULT NULL, |
| 425 | 476 |
PRIMARY KEY (`id`), |
| 426 |
KEY `fk_place_coordinates1_idx` (`coordinates`), |
|
| 477 |
KEY `fk_place_coordinates1_idx` (`geocoordinates`),
|
|
| 427 | 478 |
KEY `fk_place1_idx` (`parent`), |
| 428 |
KEY `fk_place_place_path1_idx` (`path`), |
|
| 429 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 430 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`coordinates`) REFERENCES `coordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 479 |
KEY `fk_place_place_path1_idx` (`geopath`),
|
|
| 480 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 481 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 431 | 482 |
CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 432 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`path`) REFERENCES `place_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 483 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 433 | 484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';
|
| 434 | 485 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 435 | 486 |
|
| ... | ... | |
| 474 | 525 |
/*!40000 ALTER TABLE `place_observation` ENABLE KEYS */; |
| 475 | 526 |
|
| 476 | 527 |
-- |
| 477 |
-- Table structure for table `place_path` |
|
| 478 |
-- |
|
| 479 |
|
|
| 480 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 481 |
/*!40101 SET character_set_client = utf8 */; |
|
| 482 |
CREATE TABLE `place_path` ( |
|
| 483 |
`id` varbinary(767) NOT NULL, |
|
| 484 |
`continent` varbinary(767) DEFAULT NULL, |
|
| 485 |
`country` varbinary(767) DEFAULT NULL, |
|
| 486 |
`state_province` varbinary(767) DEFAULT NULL, |
|
| 487 |
`county` varbinary(767) DEFAULT NULL, |
|
| 488 |
`municipality` varbinary(767) DEFAULT NULL, |
|
| 489 |
`ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 490 |
PRIMARY KEY (`id`) |
|
| 491 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'; |
|
| 492 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 493 |
|
|
| 494 |
-- |
|
| 495 |
-- Dumping data for table `place_path` |
|
| 496 |
-- |
|
| 497 |
|
|
| 498 |
/*!40000 ALTER TABLE `place_path` DISABLE KEYS */; |
|
| 499 |
/*!40000 ALTER TABLE `place_path` ENABLE KEYS */; |
|
| 500 |
|
|
| 501 |
-- |
|
| 502 | 528 |
-- Table structure for table `plot` |
| 503 | 529 |
-- |
| 504 | 530 |
|
| ... | ... | |
| 1121 | 1147 |
|
| 1122 | 1148 |
/*!40000 ALTER TABLE `taxon_string` DISABLE KEYS */; |
| 1123 | 1149 |
/*!40000 ALTER TABLE `taxon_string` ENABLE KEYS */; |
| 1124 |
|
|
| 1125 |
-- |
|
| 1126 |
-- Table structure for table `validatable_place` |
|
| 1127 |
-- |
|
| 1128 |
|
|
| 1129 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 1130 |
/*!40101 SET character_set_client = utf8 */; |
|
| 1131 |
CREATE TABLE `validatable_place` ( |
|
| 1132 |
`id` varbinary(767) NOT NULL, |
|
| 1133 |
`coordinates` varbinary(767) NOT NULL, |
|
| 1134 |
`path` varbinary(767) NOT NULL, |
|
| 1135 |
PRIMARY KEY (`id`), |
|
| 1136 |
UNIQUE KEY `validatable_place_unique` (`path`,`coordinates`), |
|
| 1137 |
KEY `fk_geovalidation_place_path1_idx` (`path`), |
|
| 1138 |
KEY `fk_geovalidation_coordinates1_idx` (`coordinates`), |
|
| 1139 |
CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`path`) REFERENCES `place_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1140 |
CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`coordinates`) REFERENCES `coordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1141 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 1142 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 1143 |
|
|
| 1144 |
-- |
|
| 1145 |
-- Dumping data for table `validatable_place` |
|
| 1146 |
-- |
|
| 1147 |
|
|
| 1148 |
/*!40000 ALTER TABLE `validatable_place` DISABLE KEYS */; |
|
| 1149 |
/*!40000 ALTER TABLE `validatable_place` ENABLE KEYS */; |
|
| 1150 | 1150 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 1151 | 1151 |
|
| 1152 | 1152 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 109 | 109 |
/*!40000 ALTER TABLE "community" ENABLE KEYS */; |
| 110 | 110 |
|
| 111 | 111 |
-- |
| 112 |
-- Table structure for table "coordinates" |
|
| 113 |
-- |
|
| 114 |
|
|
| 115 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 116 |
/*!40101 SET character_set_client = utf8 */; |
|
| 117 |
CREATE TABLE "coordinates" ( |
|
| 118 |
"id" text NOT NULL, |
|
| 119 |
"latitude_deg" text DEFAULT NULL, |
|
| 120 |
"longitude_deg" text DEFAULT NULL, |
|
| 121 |
PRIMARY KEY ("id")
|
|
| 122 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'*/; |
|
| 123 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 124 |
|
|
| 125 |
-- |
|
| 126 |
-- Dumping data for table "coordinates" |
|
| 127 |
-- |
|
| 128 |
|
|
| 129 |
/*!40000 ALTER TABLE "coordinates" DISABLE KEYS */; |
|
| 130 |
/*!40000 ALTER TABLE "coordinates" ENABLE KEYS */; |
|
| 131 |
|
|
| 132 |
-- |
|
| 133 | 112 |
-- Table structure for table "derived_class" |
| 134 | 113 |
-- |
| 135 | 114 |
|
| ... | ... | |
| 181 | 160 |
/*!40000 ALTER TABLE "event" ENABLE KEYS */; |
| 182 | 161 |
|
| 183 | 162 |
-- |
| 163 |
-- Table structure for table "geocoordinates" |
|
| 164 |
-- |
|
| 165 |
|
|
| 166 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 167 |
/*!40101 SET character_set_client = utf8 */; |
|
| 168 |
CREATE TABLE "geocoordinates" ( |
|
| 169 |
"id" text NOT NULL, |
|
| 170 |
"latitude_deg" text DEFAULT NULL, |
|
| 171 |
"longitude_deg" text DEFAULT NULL, |
|
| 172 |
PRIMARY KEY ("id")
|
|
| 173 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'*/; |
|
| 174 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 175 |
|
|
| 176 |
-- |
|
| 177 |
-- Dumping data for table "geocoordinates" |
|
| 178 |
-- |
|
| 179 |
|
|
| 180 |
/*!40000 ALTER TABLE "geocoordinates" DISABLE KEYS */; |
|
| 181 |
/*!40000 ALTER TABLE "geocoordinates" ENABLE KEYS */; |
|
| 182 |
|
|
| 183 |
-- |
|
| 184 | 184 |
-- Table structure for table "geological_context" |
| 185 | 185 |
-- |
| 186 | 186 |
|
| ... | ... | |
| 203 | 203 |
/*!40000 ALTER TABLE "geological_context" ENABLE KEYS */; |
| 204 | 204 |
|
| 205 | 205 |
-- |
| 206 |
-- Table structure for table "geopath" |
|
| 207 |
-- |
|
| 208 |
|
|
| 209 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 210 |
/*!40101 SET character_set_client = utf8 */; |
|
| 211 |
CREATE TABLE "geopath" ( |
|
| 212 |
"id" text NOT NULL, |
|
| 213 |
"continent" text DEFAULT NULL, |
|
| 214 |
"country" text DEFAULT NULL, |
|
| 215 |
"state_province" text DEFAULT NULL, |
|
| 216 |
"county" text DEFAULT NULL, |
|
| 217 |
"municipality" text DEFAULT NULL, |
|
| 218 |
"ranks" hstore DEFAULT NULL, |
|
| 219 |
PRIMARY KEY ("id")
|
|
| 220 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'*/; |
|
| 221 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 222 |
|
|
| 223 |
-- |
|
| 224 |
-- Dumping data for table "geopath" |
|
| 225 |
-- |
|
| 226 |
|
|
| 227 |
/*!40000 ALTER TABLE "geopath" DISABLE KEYS */; |
|
| 228 |
/*!40000 ALTER TABLE "geopath" ENABLE KEYS */; |
|
| 229 |
|
|
| 230 |
-- |
|
| 231 |
-- Table structure for table "geovalidatable_place" |
|
| 232 |
-- |
|
| 233 |
|
|
| 234 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 235 |
/*!40101 SET character_set_client = utf8 */; |
|
| 236 |
CREATE TABLE "geovalidatable_place" ( |
|
| 237 |
"id" text NOT NULL, |
|
| 238 |
"geocoordinates" text NOT NULL, |
|
| 239 |
"geopath" text NOT NULL, |
|
| 240 |
PRIMARY KEY ("id"),
|
|
| 241 |
/*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoordinates"),
|
|
| 242 |
/*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true),
|
|
| 243 |
/*KEY "fk_geovalidation_coordinates1_idx" ("geocoordinates")*/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 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 247 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 248 |
|
|
| 249 |
-- |
|
| 250 |
-- Dumping data for table "geovalidatable_place" |
|
| 251 |
-- |
|
| 252 |
|
|
| 253 |
/*!40000 ALTER TABLE "geovalidatable_place" DISABLE KEYS */; |
|
| 254 |
/*!40000 ALTER TABLE "geovalidatable_place" ENABLE KEYS */; |
|
| 255 |
|
|
| 256 |
-- |
|
| 206 | 257 |
-- Table structure for table "geovalidation" |
| 207 | 258 |
-- |
| 208 | 259 |
|
| ... | ... | |
| 214 | 265 |
"lat_long_domain_valid" integer NOT NULL, |
| 215 | 266 |
"lat_long_in_place_ranks" hstore DEFAULT NULL, |
| 216 | 267 |
PRIMARY KEY ("id"),
|
| 217 |
/*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "validatable_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 268 |
/*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "geovalidatable_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 218 | 269 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/; |
| 219 | 270 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 220 | 271 |
|
| ... | ... | |
| 421 | 472 |
CREATE TABLE "place" ( |
| 422 | 473 |
"id" text NOT NULL, |
| 423 | 474 |
"parent" text NOT NULL, |
| 424 |
"coordinates" text DEFAULT NULL, |
|
| 425 |
"path" text DEFAULT NULL, |
|
| 475 |
"geocoordinates" text DEFAULT NULL,
|
|
| 476 |
"geopath" text DEFAULT NULL,
|
|
| 426 | 477 |
"locality" text DEFAULT NULL, |
| 427 | 478 |
PRIMARY KEY ("id"),
|
| 428 |
/*KEY "fk_place_coordinates1_idx" ("coordinates")*/CHECK (true),
|
|
| 479 |
/*KEY "fk_place_coordinates1_idx" ("geocoordinates")*/CHECK (true),
|
|
| 429 | 480 |
/*KEY "fk_place1_idx" ("parent")*/CHECK (true),
|
| 430 |
/*KEY "fk_place_place_path1_idx" ("path")*/CHECK (true),
|
|
| 431 |
/*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 432 |
/*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 481 |
/*KEY "fk_place_place_path1_idx" ("geopath")*/CHECK (true),
|
|
| 482 |
/*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 483 |
/*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 433 | 484 |
/*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 434 |
/*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("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)
|
|
| 435 | 486 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/;
|
| 436 | 487 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 437 | 488 |
|
| ... | ... | |
| 476 | 527 |
/*!40000 ALTER TABLE "place_observation" ENABLE KEYS */; |
| 477 | 528 |
|
| 478 | 529 |
-- |
| 479 |
-- Table structure for table "place_path" |
|
| 480 |
-- |
|
| 481 |
|
|
| 482 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 483 |
/*!40101 SET character_set_client = utf8 */; |
|
| 484 |
CREATE TABLE "place_path" ( |
|
| 485 |
"id" text NOT NULL, |
|
| 486 |
"continent" text DEFAULT NULL, |
|
| 487 |
"country" text DEFAULT NULL, |
|
| 488 |
"state_province" text DEFAULT NULL, |
|
| 489 |
"county" text DEFAULT NULL, |
|
| 490 |
"municipality" text DEFAULT NULL, |
|
| 491 |
"ranks" hstore DEFAULT NULL, |
|
| 492 |
PRIMARY KEY ("id")
|
|
| 493 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'*/; |
|
| 494 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 495 |
|
|
| 496 |
-- |
|
| 497 |
-- Dumping data for table "place_path" |
|
| 498 |
-- |
|
| 499 |
|
|
| 500 |
/*!40000 ALTER TABLE "place_path" DISABLE KEYS */; |
|
| 501 |
/*!40000 ALTER TABLE "place_path" ENABLE KEYS */; |
|
| 502 |
|
|
| 503 |
-- |
|
| 504 | 530 |
-- Table structure for table "plot" |
| 505 | 531 |
-- |
| 506 | 532 |
|
| ... | ... | |
| 1123 | 1149 |
|
| 1124 | 1150 |
/*!40000 ALTER TABLE "taxon_string" DISABLE KEYS */; |
| 1125 | 1151 |
/*!40000 ALTER TABLE "taxon_string" ENABLE KEYS */; |
| 1126 |
|
|
| 1127 |
-- |
|
| 1128 |
-- Table structure for table "validatable_place" |
|
| 1129 |
-- |
|
| 1130 |
|
|
| 1131 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 1132 |
/*!40101 SET character_set_client = utf8 */; |
|
| 1133 |
CREATE TABLE "validatable_place" ( |
|
| 1134 |
"id" text NOT NULL, |
|
| 1135 |
"coordinates" text NOT NULL, |
|
| 1136 |
"path" text NOT NULL, |
|
| 1137 |
PRIMARY KEY ("id"),
|
|
| 1138 |
/*CONSTRAINT "validatable_place_unique" */UNIQUE ("path","coordinates"),
|
|
| 1139 |
/*KEY "fk_geovalidation_place_path1_idx" ("path")*/CHECK (true),
|
|
| 1140 |
/*KEY "fk_geovalidation_coordinates1_idx" ("coordinates")*/CHECK (true),
|
|
| 1141 |
/*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1142 |
/*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1143 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 1144 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 1145 |
|
|
| 1146 |
-- |
|
| 1147 |
-- Dumping data for table "validatable_place" |
|
| 1148 |
-- |
|
| 1149 |
|
|
| 1150 |
/*!40000 ALTER TABLE "validatable_place" DISABLE KEYS */; |
|
| 1151 |
/*!40000 ALTER TABLE "validatable_place" ENABLE KEYS */; |
|
| 1152 | 1152 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 1153 | 1153 |
|
| 1154 | 1154 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: place tables that are absolute within Earth rather than relative to a parent place: prefixed geo- to table name for clarity