Revision 10455
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/document.mwb.xml | ||
|---|---|---|
| 2965 | 2965 |
<value type="int" key="scale">-1</value> |
| 2966 | 2966 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 2967 | 2967 |
<value type="string" key="comment"></value> |
| 2968 |
<value type="string" key="name">collector</value> |
|
| 2968 |
<value type="string" key="name">collectors</value>
|
|
| 2969 | 2969 |
<value type="string" key="oldName">collector</value> |
| 2970 | 2970 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| 2971 | 2971 |
</value> |
| ... | ... | |
| 3132 | 3132 |
<value type="string" key="name">fk_taxon_observation_specimen1</value> |
| 3133 | 3133 |
<value type="string" key="oldName">fk_taxon_observation_specimen1</value> |
| 3134 | 3134 |
</value> |
| 3135 |
<value type="object" struct-name="db.mysql.ForeignKey" id="b9be8a58-acff-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 3136 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 3137 |
<value _ptr_="0xa8df5a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 3135 |
<value type="object" struct-name="db.mysql.ForeignKey" id="21b40060-f680-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 3136 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
|
|
| 3137 |
<value _ptr_="0xb34f7e0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 3138 | 3138 |
<link type="object">b9be8c42-acff-11e2-b309-080027bcf912</link> |
| 3139 | 3139 |
</value> |
| 3140 | 3140 |
<value type="int" key="deferability">0</value> |
| 3141 | 3141 |
<value type="string" key="deleteRule">CASCADE</value> |
| 3142 |
<link type="object" struct-name="db.Index" key="index">b9bea376-acff-11e2-b309-080027bcf912</link>
|
|
| 3142 |
<link type="object" struct-name="db.Index" key="index">21b41366-f680-11e2-aebb-080027bcf912</link>
|
|
| 3143 | 3143 |
<value type="int" key="mandatory">1</value> |
| 3144 | 3144 |
<value type="int" key="many">1</value> |
| 3145 | 3145 |
<value type="int" key="modelOnly">0</value> |
| 3146 | 3146 |
<link type="object" struct-name="db.Table" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| 3147 |
<value _ptr_="0xa8df930" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 3148 |
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 3147 |
<value _ptr_="0xb311f18" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 3148 |
<link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
|
|
| 3149 | 3149 |
</value> |
| 3150 |
<value type="int" key="referencedMandatory">0</value>
|
|
| 3150 |
<value type="int" key="referencedMandatory">1</value>
|
|
| 3151 | 3151 |
<value type="string" key="updateRule">CASCADE</value> |
| 3152 | 3152 |
<value type="string" key="comment"></value> |
| 3153 |
<value type="string" key="name">fk_taxon_observation_party1</value> |
|
| 3154 |
<value type="string" key="oldName">fk_taxon_observation_party1</value> |
|
| 3153 |
<value type="string" key="name">fk_taxon_observation_party_list1</value>
|
|
| 3154 |
<value type="string" key="oldName">fk_taxon_observation_party_list1</value>
|
|
| 3155 | 3155 |
</value> |
| 3156 | 3156 |
</value> |
| 3157 | 3157 |
<value _ptr_="0xa155ea8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> |
| ... | ... | |
| 3224 | 3224 |
<value type="string" key="oldName">fk_taxon_observation_specimen1_idx</value> |
| 3225 | 3225 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| 3226 | 3226 |
</value> |
| 3227 |
<value type="object" struct-name="db.mysql.Index" id="b9bea376-acff-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
|
|
| 3228 |
<value _ptr_="0xa8e0b60" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
| 3229 |
<value type="object" struct-name="db.mysql.IndexColumn" id="b9bea538-acff-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
|
|
| 3227 |
<value type="object" struct-name="db.mysql.Index" id="21b41366-f680-11e2-aebb-080027bcf912" struct-checksum="0x309b847a">
|
|
| 3228 |
<value _ptr_="0xb3c50f8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
|
| 3229 |
<value type="object" struct-name="db.mysql.IndexColumn" id="21b447e6-f680-11e2-aebb-080027bcf912" struct-checksum="0x62630b3c">
|
|
| 3230 | 3230 |
<value type="int" key="columnLength">0</value> |
| 3231 | 3231 |
<value type="string" key="comment"></value> |
| 3232 | 3232 |
<value type="int" key="descend">0</value> |
| 3233 | 3233 |
<link type="object" struct-name="db.Column" key="referencedColumn">b9be8c42-acff-11e2-b309-080027bcf912</link> |
| 3234 | 3234 |
<value type="string" key="name"></value> |
| 3235 |
<link type="object" struct-name="GrtObject" key="owner">b9bea376-acff-11e2-b309-080027bcf912</link>
|
|
| 3235 |
<link type="object" struct-name="GrtObject" key="owner">21b41366-f680-11e2-aebb-080027bcf912</link>
|
|
| 3236 | 3236 |
</value> |
| 3237 | 3237 |
</value> |
| 3238 | 3238 |
<value type="string" key="indexKind"></value> |
| ... | ... | |
| 3242 | 3242 |
<value type="int" key="deferability">0</value> |
| 3243 | 3243 |
<value type="string" key="indexType">INDEX</value> |
| 3244 | 3244 |
<value type="int" key="isPrimary">0</value> |
| 3245 |
<value type="string" key="name">fk_taxon_observation_party1_idx</value> |
|
| 3245 |
<value type="string" key="name">fk_taxon_observation_party_list1_idx</value>
|
|
| 3246 | 3246 |
<value type="int" key="unique">0</value> |
| 3247 |
<value type="string" key="oldName">fk_taxon_observation_party1_idx</value>
|
|
| 3247 |
<value type="string" key="oldName">fk_taxon_observation_party_list1</value>
|
|
| 3248 | 3248 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| 3249 | 3249 |
</value> |
| 3250 | 3250 |
</value> |
| ... | ... | |
| 3278 | 3278 |
<value type="int" key="commentedOut">0</value> |
| 3279 | 3279 |
<value type="string" key="createDate">2013-04-17 13:52</value> |
| 3280 | 3280 |
<value _ptr_="0xa8baf20" type="dict" key="customData"/> |
| 3281 |
<value type="string" key="lastChangeDate">2013-04-24 09:59</value>
|
|
| 3281 |
<value type="string" key="lastChangeDate">2013-07-26 22:48</value>
|
|
| 3282 | 3282 |
<value type="int" key="modelOnly">0</value> |
| 3283 | 3283 |
<value type="string" key="name">taxon_observation</value> |
| 3284 | 3284 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 4324 | 4324 |
<value type="string" key="name">fk_taxon_determination_record1</value> |
| 4325 | 4325 |
<value type="string" key="oldName">fk_taxon_determination_record1</value> |
| 4326 | 4326 |
</value> |
| 4327 |
<value type="object" struct-name="db.mysql.ForeignKey" id="3d9b390c-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 4328 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 4329 |
<value _ptr_="0xa8f0560" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 4327 |
<value type="object" struct-name="db.mysql.ForeignKey" id="2ed4b280-f680-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
|
|
| 4328 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
|
|
| 4329 |
<value _ptr_="0xb4827a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
|
| 4330 | 4330 |
<link type="object">3d9b197c-a7a1-11e2-b667-080027bcf912</link> |
| 4331 | 4331 |
</value> |
| 4332 | 4332 |
<value type="int" key="deferability">0</value> |
| 4333 | 4333 |
<value type="string" key="deleteRule">CASCADE</value> |
| 4334 |
<link type="object" struct-name="db.Index" key="index">3d9b2a2a-a7a1-11e2-b667-080027bcf912</link>
|
|
| 4334 |
<link type="object" struct-name="db.Index" key="index">2ed4c4d2-f680-11e2-aebb-080027bcf912</link>
|
|
| 4335 | 4335 |
<value type="int" key="mandatory">1</value> |
| 4336 | 4336 |
<value type="int" key="many">1</value> |
| 4337 | 4337 |
<value type="int" key="modelOnly">0</value> |
| 4338 | 4338 |
<link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link> |
| 4339 |
<value _ptr_="0xa8f08e8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 4340 |
<link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
|
|
| 4339 |
<value _ptr_="0xb3af6b0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
|
| 4340 |
<link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
|
|
| 4341 | 4341 |
</value> |
| 4342 |
<value type="int" key="referencedMandatory">0</value>
|
|
| 4342 |
<value type="int" key="referencedMandatory">1</value>
|
|
| 4343 | 4343 |
<value type="string" key="updateRule">CASCADE</value> |
| 4344 | 4344 |
<value type="string" key="comment"></value> |
| 4345 |
<value type="string" key="name">fk_taxon_determination_party1</value> |
|
| 4346 |
<value type="string" key="oldName">fk_taxon_determination_party1</value> |
|
| 4345 |
<value type="string" key="name">fk_taxon_determination_party_list1</value>
|
|
| 4346 |
<value type="string" key="oldName">fk_taxon_determination_party_list1</value>
|
|
| 4347 | 4347 |
</value> |
| 4348 | 4348 |
</value> |
| 4349 | 4349 |
<value _ptr_="0xa8ee818" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> |
| ... | ... | |
| 4393 | 4393 |
<value type="string" key="oldName">PRIMARY</value> |
| 4394 | 4394 |
<link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link> |
| 4395 | 4395 |
</value> |
| 4396 |
<value type="object" struct-name="db.mysql.Index" id="3d9b2a2a-a7a1-11e2-b667-080027bcf912" struct-checksum="0x309b847a"> |
|
| 4397 |
<value _ptr_="0xa8f1438" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns"> |
|
| 4398 |
<value type="object" struct-name="db.mysql.IndexColumn" id="3d9b2c1e-a7a1-11e2-b667-080027bcf912" struct-checksum="0x62630b3c"> |
|
| 4399 |
<value type="int" key="columnLength">0</value> |
|
| 4400 |
<value type="string" key="comment"></value> |
|
| 4401 |
<value type="int" key="descend">0</value> |
|
| 4402 |
<link type="object" struct-name="db.Column" key="referencedColumn">3d9b197c-a7a1-11e2-b667-080027bcf912</link> |
|
| 4403 |
<value type="string" key="name"></value> |
|
| 4404 |
<link type="object" struct-name="GrtObject" key="owner">3d9b2a2a-a7a1-11e2-b667-080027bcf912</link> |
|
| 4405 |
</value> |
|
| 4406 |
</value> |
|
| 4407 |
<value type="string" key="indexKind"></value> |
|
| 4408 |
<value type="int" key="keyBlockSize">0</value> |
|
| 4409 |
<value type="string" key="withParser"></value> |
|
| 4410 |
<value type="string" key="comment"></value> |
|
| 4411 |
<value type="int" key="deferability">0</value> |
|
| 4412 |
<value type="string" key="indexType">INDEX</value> |
|
| 4413 |
<value type="int" key="isPrimary">0</value> |
|
| 4414 |
<value type="string" key="name">fk_taxon_determination_party1_idx</value> |
|
| 4415 |
<value type="int" key="unique">0</value> |
|
| 4416 |
<value type="string" key="oldName">fk_taxon_determination_party1_idx</value> |
|
| 4417 |
<link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link> |
|
| 4418 |
</value> |
|
| 4419 | 4396 |
<value type="object" struct-name="db.mysql.Index" id="3d9b2d86-a7a1-11e2-b667-080027bcf912" struct-checksum="0x309b847a"> |
| 4420 | 4397 |
<value _ptr_="0xa8f1b18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns"> |
| 4421 | 4398 |
<value type="object" struct-name="db.mysql.IndexColumn" id="3d9b30c4-a7a1-11e2-b667-080027bcf912" struct-checksum="0x62630b3c"> |
| ... | ... | |
| 4447 | 4424 |
<value type="string" key="oldName">taxon_determination_unique</value> |
| 4448 | 4425 |
<link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link> |
| 4449 | 4426 |
</value> |
| 4427 |
<value type="object" struct-name="db.mysql.Index" id="2ed4c4d2-f680-11e2-aebb-080027bcf912" struct-checksum="0x309b847a"> |
|
| 4428 |
<value _ptr_="0xb947a88" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns"> |
|
| 4429 |
<value type="object" struct-name="db.mysql.IndexColumn" id="2ed4fc5e-f680-11e2-aebb-080027bcf912" struct-checksum="0x62630b3c"> |
|
| 4430 |
<value type="int" key="columnLength">0</value> |
|
| 4431 |
<value type="string" key="comment"></value> |
|
| 4432 |
<value type="int" key="descend">0</value> |
|
| 4433 |
<link type="object" struct-name="db.Column" key="referencedColumn">3d9b197c-a7a1-11e2-b667-080027bcf912</link> |
|
| 4434 |
<value type="string" key="name"></value> |
|
| 4435 |
<link type="object" struct-name="GrtObject" key="owner">2ed4c4d2-f680-11e2-aebb-080027bcf912</link> |
|
| 4436 |
</value> |
|
| 4437 |
</value> |
|
| 4438 |
<value type="string" key="indexKind"></value> |
|
| 4439 |
<value type="int" key="keyBlockSize">0</value> |
|
| 4440 |
<value type="string" key="withParser"></value> |
|
| 4441 |
<value type="string" key="comment"></value> |
|
| 4442 |
<value type="int" key="deferability">0</value> |
|
| 4443 |
<value type="string" key="indexType">INDEX</value> |
|
| 4444 |
<value type="int" key="isPrimary">0</value> |
|
| 4445 |
<value type="string" key="name">fk_taxon_determination_party_list1_idx</value> |
|
| 4446 |
<value type="int" key="unique">0</value> |
|
| 4447 |
<value type="string" key="oldName">fk_taxon_determination_party_list1</value> |
|
| 4448 |
<link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link> |
|
| 4449 |
</value> |
|
| 4450 | 4450 |
</value> |
| 4451 | 4451 |
<value type="string" key="maxRows"></value> |
| 4452 | 4452 |
<value type="string" key="mergeInsert"></value> |
| ... | ... | |
| 4478 | 4478 |
<value type="int" key="commentedOut">0</value> |
| 4479 | 4479 |
<value type="string" key="createDate">2013-04-17 13:56</value> |
| 4480 | 4480 |
<value _ptr_="0xa8ee5a0" type="dict" key="customData"/> |
| 4481 |
<value type="string" key="lastChangeDate">2013-04-24 14:33</value>
|
|
| 4481 |
<value type="string" key="lastChangeDate">2013-07-26 22:48</value>
|
|
| 4482 | 4482 |
<value type="int" key="modelOnly">0</value> |
| 4483 | 4483 |
<value type="string" key="name">taxon_determination</value> |
| 4484 | 4484 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 4601 | 4601 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 4602 | 4602 |
<value type="string" key="comment"></value> |
| 4603 | 4603 |
<value type="string" key="name">participants</value> |
| 4604 |
<value type="string" key="oldName">party_list_id</value>
|
|
| 4604 |
<value type="string" key="oldName">participants</value>
|
|
| 4605 | 4605 |
<link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link> |
| 4606 | 4606 |
</value> |
| 4607 | 4607 |
<value type="object" struct-name="db.mysql.Column" id="c6727f0c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 4848 | 4848 |
<value type="int" key="isPrimary">0</value> |
| 4849 | 4849 |
<value type="string" key="name">fk_event_party_list1_idx</value> |
| 4850 | 4850 |
<value type="int" key="unique">0</value> |
| 4851 |
<value type="string" key="oldName">fk_event_party_list1</value> |
|
| 4851 |
<value type="string" key="oldName">fk_event_party_list1_idx</value>
|
|
| 4852 | 4852 |
<link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link> |
| 4853 | 4853 |
</value> |
| 4854 | 4854 |
</value> |
| ... | ... | |
| 6105 | 6105 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 6106 | 6106 |
<value type="string" key="comment"></value> |
| 6107 | 6107 |
<value type="string" key="name">specimenholder_institutions</value> |
| 6108 |
<value type="string" key="oldName">party_list_id</value>
|
|
| 6108 |
<value type="string" key="oldName">specimenholder_institutions</value>
|
|
| 6109 | 6109 |
<link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link> |
| 6110 | 6110 |
</value> |
| 6111 | 6111 |
<value type="object" struct-name="db.mysql.Column" id="bb0eaf44-ad10-11e2-b309-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 6575 | 6575 |
<value type="int" key="isPrimary">0</value> |
| 6576 | 6576 |
<value type="string" key="name">fk_specimen_party_list1_idx</value> |
| 6577 | 6577 |
<value type="int" key="unique">0</value> |
| 6578 |
<value type="string" key="oldName">fk_specimen_party_list1</value> |
|
| 6578 |
<value type="string" key="oldName">fk_specimen_party_list1_idx</value>
|
|
| 6579 | 6579 |
<link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link> |
| 6580 | 6580 |
</value> |
| 6581 | 6581 |
</value> |
| ... | ... | |
| 9392 | 9392 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link> |
| 9393 | 9393 |
<value type="string" key="comment"></value> |
| 9394 | 9394 |
<value type="string" key="name">count</value> |
| 9395 |
<value type="string" key="oldName">organization</value>
|
|
| 9395 |
<value type="string" key="oldName">count</value>
|
|
| 9396 | 9396 |
<link type="object" struct-name="GrtObject" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link> |
| 9397 | 9397 |
</value> |
| 9398 | 9398 |
</value> |
| ... | ... | |
| 9420 | 9420 |
<value type="string" key="updateRule">CASCADE</value> |
| 9421 | 9421 |
<value type="string" key="comment"></value> |
| 9422 | 9422 |
<value type="string" key="name">fk_collection_source100</value> |
| 9423 |
<value type="string" key="oldName">fk_collection_source10</value> |
|
| 9423 |
<value type="string" key="oldName">fk_collection_source100</value>
|
|
| 9424 | 9424 |
</value> |
| 9425 | 9425 |
</value> |
| 9426 | 9426 |
<value _ptr_="0xa93ee90" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> |
| ... | ... | |
| 9484 | 9484 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 9485 | 9485 |
<value type="string" key="temp_sql"></value> |
| 9486 | 9486 |
<value type="string" key="comment"></value> |
| 9487 |
<value type="string" key="oldName"></value> |
|
| 9487 |
<value type="string" key="oldName">party_list</value>
|
|
| 9488 | 9488 |
</value> |
| 9489 | 9489 |
<value type="object" struct-name="db.mysql.Table" id="9d6c9e9a-f678-11e2-9716-080027bcf912" struct-checksum="0x1a403946"> |
| 9490 | 9490 |
<value type="string" key="avgRowLength"></value> |
| ... | ... | |
| 9506 | 9506 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 9507 | 9507 |
<value type="string" key="comment"></value> |
| 9508 | 9508 |
<value type="string" key="name">id</value> |
| 9509 |
<value type="string" key="oldName">party_list_id</value>
|
|
| 9509 |
<value type="string" key="oldName">id</value> |
|
| 9510 | 9510 |
<link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link> |
| 9511 | 9511 |
</value> |
| 9512 | 9512 |
<value type="object" struct-name="db.mysql.Column" id="9d6cb150-f678-11e2-9716-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 9525 | 9525 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 9526 | 9526 |
<value type="string" key="comment"></value> |
| 9527 | 9527 |
<value type="string" key="name">entry</value> |
| 9528 |
<value type="string" key="oldName">party_id</value>
|
|
| 9528 |
<value type="string" key="oldName">entry</value>
|
|
| 9529 | 9529 |
<link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link> |
| 9530 | 9530 |
</value> |
| 9531 | 9531 |
<value type="object" struct-name="db.mysql.Column" id="43f70d90-f679-11e2-9716-080027bcf912" struct-checksum="0x783b5183"> |
| ... | ... | |
| 9544 | 9544 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link> |
| 9545 | 9545 |
<value type="string" key="comment"></value> |
| 9546 | 9546 |
<value type="string" key="name">sort_order</value> |
| 9547 |
<value type="string" key="oldName"></value> |
|
| 9547 |
<value type="string" key="oldName">sort_order</value>
|
|
| 9548 | 9548 |
<link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link> |
| 9549 | 9549 |
</value> |
| 9550 | 9550 |
</value> |
| ... | ... | |
| 9648 | 9648 |
<value type="int" key="isPrimary">0</value> |
| 9649 | 9649 |
<value type="string" key="name">fk_party_list_has_party_party1_idx</value> |
| 9650 | 9650 |
<value type="int" key="unique">0</value> |
| 9651 |
<value type="string" key="oldName">fk_party_list_has_party_party1</value> |
|
| 9651 |
<value type="string" key="oldName">fk_party_list_has_party_party1_idx</value>
|
|
| 9652 | 9652 |
<link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link> |
| 9653 | 9653 |
</value> |
| 9654 | 9654 |
<value type="object" struct-name="db.mysql.Index" id="9d6cbbd2-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a"> |
| ... | ... | |
| 9671 | 9671 |
<value type="int" key="isPrimary">0</value> |
| 9672 | 9672 |
<value type="string" key="name">fk_party_list_has_party_party_list1_idx</value> |
| 9673 | 9673 |
<value type="int" key="unique">0</value> |
| 9674 |
<value type="string" key="oldName">fk_party_list_has_party_party_list1</value> |
|
| 9674 |
<value type="string" key="oldName">fk_party_list_has_party_party_list1_idx</value>
|
|
| 9675 | 9675 |
<link type="object" struct-name="GrtObject" key="owner">9d6c9e9a-f678-11e2-9716-080027bcf912</link> |
| 9676 | 9676 |
</value> |
| 9677 | 9677 |
</value> |
| ... | ... | |
| 9711 | 9711 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 9712 | 9712 |
<value type="string" key="temp_sql"></value> |
| 9713 | 9713 |
<value type="string" key="comment"></value> |
| 9714 |
<value type="string" key="oldName">party_list_has_party</value>
|
|
| 9714 |
<value type="string" key="oldName">party_list_entry</value>
|
|
| 9715 | 9715 |
</value> |
| 9716 | 9716 |
</value> |
| 9717 | 9717 |
<value _ptr_="0xa8c0838" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/> |
| ... | ... | |
| 11070 | 11070 |
<value type="int" key="visible">1</value> |
| 11071 | 11071 |
<value type="string" key="name"></value> |
| 11072 | 11072 |
</value> |
| 11073 |
<value type="object" struct-name="workbench.physical.Connection" id="43c8e0d6-a7a1-11e2-b667-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 11074 |
<value type="string" key="caption">fk_taxon_determination_party1</value> |
|
| 11075 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 11076 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 11077 |
<value type="string" key="comment"></value> |
|
| 11078 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 11079 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 11080 |
<value type="string" key="extraCaption"></value> |
|
| 11081 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 11082 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 11083 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">3d9b390c-a7a1-11e2-b667-080027bcf912</link> |
|
| 11084 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 11085 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 11086 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 11087 |
<value type="int" key="drawSplit">1</value> |
|
| 11088 |
<link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link> |
|
| 11089 |
<link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link> |
|
| 11090 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 11091 |
<value type="int" key="visible">1</value> |
|
| 11092 |
<value type="string" key="name"></value> |
|
| 11093 |
</value> |
|
| 11094 | 11073 |
<value type="object" struct-name="workbench.physical.Connection" id="43c9ece2-a7a1-11e2-b667-080027bcf912" struct-checksum="0x9baebc92"> |
| 11095 | 11074 |
<value type="string" key="caption">fk_taxon_occurrence_taxon_determination1</value> |
| 11096 | 11075 |
<value type="real" key="captionXOffs">0.e+00</value> |
| ... | ... | |
| 11511 | 11490 |
<value type="int" key="visible">1</value> |
| 11512 | 11491 |
<value type="string" key="name"></value> |
| 11513 | 11492 |
</value> |
| 11514 |
<value type="object" struct-name="workbench.physical.Connection" id="b9beaa74-acff-11e2-b309-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 11515 |
<value type="string" key="caption">fk_taxon_observation_party1</value> |
|
| 11516 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 11517 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 11518 |
<value type="string" key="comment"></value> |
|
| 11519 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 11520 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 11521 |
<value type="string" key="extraCaption"></value> |
|
| 11522 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 11523 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 11524 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">b9be8a58-acff-11e2-b309-080027bcf912</link> |
|
| 11525 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 11526 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 11527 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 11528 |
<value type="int" key="drawSplit">1</value> |
|
| 11529 |
<link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link> |
|
| 11530 |
<link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link> |
|
| 11531 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 11532 |
<value type="int" key="visible">1</value> |
|
| 11533 |
<value type="string" key="name"></value> |
|
| 11534 |
</value> |
|
| 11535 | 11493 |
<value type="object" struct-name="workbench.physical.Connection" id="eb77bcd4-ad01-11e2-b309-080027bcf912" struct-checksum="0x9baebc92"> |
| 11536 | 11494 |
<value type="string" key="caption">fk_specimen_taxon_observation1</value> |
| 11537 | 11495 |
<value type="real" key="captionXOffs">0.e+00</value> |
| ... | ... | |
| 11847 | 11805 |
<value type="int" key="visible">1</value> |
| 11848 | 11806 |
<value type="string" key="name"></value> |
| 11849 | 11807 |
</value> |
| 11808 |
<value type="object" struct-name="workbench.physical.Connection" id="21b637c2-f680-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 11809 |
<value type="string" key="caption">fk_taxon_observation_party_list1</value> |
|
| 11810 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 11811 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 11812 |
<value type="string" key="comment"></value> |
|
| 11813 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 11814 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 11815 |
<value type="string" key="extraCaption"></value> |
|
| 11816 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 11817 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 11818 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">21b40060-f680-11e2-aebb-080027bcf912</link> |
|
| 11819 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 11820 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 11821 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 11822 |
<value type="int" key="drawSplit">1</value> |
|
| 11823 |
<link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link> |
|
| 11824 |
<link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link> |
|
| 11825 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 11826 |
<value type="int" key="visible">1</value> |
|
| 11827 |
<value type="string" key="name"></value> |
|
| 11828 |
</value> |
|
| 11829 |
<value type="object" struct-name="workbench.physical.Connection" id="2ed617ce-f680-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92"> |
|
| 11830 |
<value type="string" key="caption">fk_taxon_determination_party_list1</value> |
|
| 11831 |
<value type="real" key="captionXOffs">0.e+00</value> |
|
| 11832 |
<value type="real" key="captionYOffs">0.e+00</value> |
|
| 11833 |
<value type="string" key="comment"></value> |
|
| 11834 |
<value type="real" key="endCaptionXOffs">0.e+00</value> |
|
| 11835 |
<value type="real" key="endCaptionYOffs">0.e+00</value> |
|
| 11836 |
<value type="string" key="extraCaption"></value> |
|
| 11837 |
<value type="real" key="extraCaptionXOffs">0.e+00</value> |
|
| 11838 |
<value type="real" key="extraCaptionYOffs">0.e+00</value> |
|
| 11839 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">2ed4b280-f680-11e2-aebb-080027bcf912</link> |
|
| 11840 |
<value type="real" key="middleSegmentOffset">0.e+00</value> |
|
| 11841 |
<value type="real" key="startCaptionXOffs">0.e+00</value> |
|
| 11842 |
<value type="real" key="startCaptionYOffs">0.e+00</value> |
|
| 11843 |
<value type="int" key="drawSplit">1</value> |
|
| 11844 |
<link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link> |
|
| 11845 |
<link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link> |
|
| 11846 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
|
| 11847 |
<value type="int" key="visible">1</value> |
|
| 11848 |
<value type="string" key="name"></value> |
|
| 11849 |
</value> |
|
| 11850 | 11850 |
</value> |
| 11851 | 11851 |
<value type="string" key="description"></value> |
| 11852 | 11852 |
<value _ptr_="0xa9484c8" type="list" content-type="object" content-struct-name="model.Figure" key="figures"> |
| ... | ... | |
| 13193 | 13193 |
<value type="int" key="visible">1</value> |
| 13194 | 13194 |
<value type="string" key="name"></value> |
| 13195 | 13195 |
</value> |
| 13196 |
<value _ptr_="0xa9485a0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/> |
|
| 13196 |
<value _ptr_="0xa9485a0" type="list" content-type="object" content-struct-name="model.Object" key="selection"> |
|
| 13197 |
<link type="object">21b637c2-f680-11e2-aebb-080027bcf912</link> |
|
| 13198 |
</value> |
|
| 13197 | 13199 |
<value type="int" key="updateBlocked">0</value> |
| 13198 | 13200 |
<value type="real" key="width">1.6215e+03</value> |
| 13199 | 13201 |
<value type="real" key="x">0.e+00</value> |
| ... | ... | |
| 13288 | 13290 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 13289 | 13291 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 13290 | 13292 |
<value type="string" key="caption">New Model</value> |
| 13291 |
<value type="string" key="dateChanged">2013-07-26 22:36</value>
|
|
| 13293 |
<value type="string" key="dateChanged">2013-07-26 22:49</value>
|
|
| 13292 | 13294 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 13293 | 13295 |
<value type="string" key="description"></value> |
| 13294 | 13296 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 169 | 169 |
KEY `fk_event1_idx` (`parent`), |
| 170 | 170 |
KEY `fk_event_method1_idx` (`method`), |
| 171 | 171 |
KEY `fk_event_party_list1_idx` (`participants`), |
| 172 |
CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 173 |
CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 172 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 174 | 173 |
CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 175 | 174 |
CONSTRAINT `fk_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 176 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 175 |
CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 176 |
CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 177 | 177 |
) 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)';
|
| 178 | 178 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 179 | 179 |
|
| ... | ... | |
| 185 | 185 |
/*!40000 ALTER TABLE `event` ENABLE KEYS */; |
| 186 | 186 |
|
| 187 | 187 |
-- |
| 188 |
-- Table structure for table `event_participant` |
|
| 189 |
-- |
|
| 190 |
|
|
| 191 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 192 |
/*!40101 SET character_set_client = utf8 */; |
|
| 193 |
CREATE TABLE `event_participant` ( |
|
| 194 |
`event` varbinary(767) NOT NULL, |
|
| 195 |
`party` varbinary(767) NOT NULL, |
|
| 196 |
`sort_order` int(11) DEFAULT NULL, |
|
| 197 |
PRIMARY KEY (`event`,`party`), |
|
| 198 |
KEY `fk_event_has_party_party1_idx` (`party`), |
|
| 199 |
KEY `fk_event_has_party_event1_idx` (`event`), |
|
| 200 |
CONSTRAINT `fk_event_has_party_event1` FOREIGN KEY (`event`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 201 |
CONSTRAINT `fk_event_has_party_party1` FOREIGN KEY (`party`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 202 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 203 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 204 |
|
|
| 205 |
-- |
|
| 206 |
-- Dumping data for table `event_participant` |
|
| 207 |
-- |
|
| 208 |
|
|
| 209 |
/*!40000 ALTER TABLE `event_participant` DISABLE KEYS */; |
|
| 210 |
/*!40000 ALTER TABLE `event_participant` ENABLE KEYS */; |
|
| 211 |
|
|
| 212 |
-- |
|
| 213 | 188 |
-- Table structure for table `geological_context` |
| 214 | 189 |
-- |
| 215 | 190 |
|
| ... | ... | |
| 289 | 264 |
`traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 290 | 265 |
PRIMARY KEY (`id`), |
| 291 | 266 |
KEY `fk_individual_observation_individual1_idx` (`individual`), |
| 292 |
CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 293 |
CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 267 |
CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 268 |
CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 294 | 269 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'; |
| 295 | 270 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 296 | 271 |
|
| ... | ... | |
| 383 | 358 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 384 | 359 |
PRIMARY KEY (`id`), |
| 385 | 360 |
KEY `fk_party_organization1_idx` (`organization`), |
| 386 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 387 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 361 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 362 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 388 | 363 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 389 | 364 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 390 | 365 |
|
| ... | ... | |
| 728 | 703 |
KEY `fk_specimen_collection2_idx` (`current_collection`), |
| 729 | 704 |
KEY `fk_specimen_organization3_idx` (`owner_collection`), |
| 730 | 705 |
KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`), |
| 731 |
CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 732 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 733 | 706 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 734 | 707 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 735 | 708 |
CONSTRAINT `fk_specimen_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 736 | 709 |
CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 737 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 710 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 711 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 712 |
CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 738 | 713 |
) 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';
|
| 739 | 714 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 740 | 715 |
|
| ... | ... | |
| 770 | 745 |
/*!40000 ALTER TABLE `specimen_observation` ENABLE KEYS */; |
| 771 | 746 |
|
| 772 | 747 |
-- |
| 773 |
-- Table structure for table `specimenholder_institution` |
|
| 774 |
-- |
|
| 775 |
|
|
| 776 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 777 |
/*!40101 SET character_set_client = utf8 */; |
|
| 778 |
CREATE TABLE `specimenholder_institution` ( |
|
| 779 |
`specimen` varbinary(767) NOT NULL, |
|
| 780 |
`institution` varbinary(767) NOT NULL, |
|
| 781 |
`sort_order` int(11) DEFAULT NULL, |
|
| 782 |
PRIMARY KEY (`specimen`,`institution`), |
|
| 783 |
KEY `fk_specimen_has_organization_organization1_idx` (`institution`), |
|
| 784 |
KEY `fk_specimen_has_organization_specimen1_idx` (`specimen`), |
|
| 785 |
CONSTRAINT `fk_specimen_has_organization_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 786 |
CONSTRAINT `fk_specimen_has_organization_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 787 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 788 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 789 |
|
|
| 790 |
-- |
|
| 791 |
-- Dumping data for table `specimenholder_institution` |
|
| 792 |
-- |
|
| 793 |
|
|
| 794 |
/*!40000 ALTER TABLE `specimenholder_institution` DISABLE KEYS */; |
|
| 795 |
/*!40000 ALTER TABLE `specimenholder_institution` ENABLE KEYS */; |
|
| 796 |
|
|
| 797 |
-- |
|
| 798 | 748 |
-- Table structure for table `stem` |
| 799 | 749 |
-- |
| 800 | 750 |
|
| ... | ... | |
| 961 | 911 |
PRIMARY KEY (`id`), |
| 962 | 912 |
UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`), |
| 963 | 913 |
KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`), |
| 964 |
KEY `fk_taxon_determination_party1_idx` (`identified_by`), |
|
| 914 |
KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),
|
|
| 965 | 915 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 966 | 916 |
CONSTRAINT `fk_taxon_determination_record1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 967 |
CONSTRAINT `fk_taxon_determination_party1` FOREIGN KEY (`identified_by`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 917 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 968 | 918 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'; |
| 969 | 919 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 970 | 920 |
|
| ... | ... | |
| 1012 | 962 |
CREATE TABLE `taxon_observation` ( |
| 1013 | 963 |
`id` varbinary(767) NOT NULL, |
| 1014 | 964 |
`taxon_occurrence` varbinary(767) NOT NULL, |
| 1015 |
`collector` varbinary(767) DEFAULT NULL, |
|
| 965 |
`collectors` varbinary(767) DEFAULT NULL,
|
|
| 1016 | 966 |
`collector_number` varbinary(767) DEFAULT NULL, |
| 1017 | 967 |
`voucher` varbinary(767) DEFAULT NULL, |
| 1018 | 968 |
`growth_form` varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 1021 | 971 |
PRIMARY KEY (`id`), |
| 1022 | 972 |
KEY `fk_taxon_observation_taxon_occurrence2_idx` (`taxon_occurrence`), |
| 1023 | 973 |
KEY `fk_taxon_observation_specimen1_idx` (`voucher`), |
| 1024 |
KEY `fk_taxon_observation_party1_idx` (`collector`), |
|
| 974 |
KEY `fk_taxon_observation_party_list1_idx` (`collectors`), |
|
| 975 |
CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1025 | 976 |
CONSTRAINT `fk_taxon_observation_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1026 |
CONSTRAINT `fk_taxon_observation_taxon_occurrence2` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1027 | 977 |
CONSTRAINT `fk_taxon_observation_specimen1` FOREIGN KEY (`voucher`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1028 |
CONSTRAINT `fk_taxon_observation_party1` FOREIGN KEY (`collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 978 |
CONSTRAINT `fk_taxon_observation_taxon_occurrence2` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 1029 | 979 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 1030 | 980 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1031 | 981 |
|
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 171 | 171 |
/*KEY "fk_event1_idx" ("parent")*/CHECK (true),
|
| 172 | 172 |
/*KEY "fk_event_method1_idx" ("method")*/CHECK (true),
|
| 173 | 173 |
/*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),
|
| 174 |
/*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 175 |
/*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 174 |
/*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 176 | 175 |
/*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 177 | 176 |
/*CONSTRAINT "fk_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 178 |
/*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 177 |
/*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 178 |
/*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 179 | 179 |
) /*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)'*/;
|
| 180 | 180 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 181 | 181 |
|
| ... | ... | |
| 187 | 187 |
/*!40000 ALTER TABLE "event" ENABLE KEYS */; |
| 188 | 188 |
|
| 189 | 189 |
-- |
| 190 |
-- Table structure for table "event_participant" |
|
| 191 |
-- |
|
| 192 |
|
|
| 193 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 194 |
/*!40101 SET character_set_client = utf8 */; |
|
| 195 |
CREATE TABLE "event_participant" ( |
|
| 196 |
"event" text NOT NULL, |
|
| 197 |
"party" text NOT NULL, |
|
| 198 |
"sort_order" integer DEFAULT NULL, |
|
| 199 |
PRIMARY KEY ("event","party"),
|
|
| 200 |
/*KEY "fk_event_has_party_party1_idx" ("party")*/CHECK (true),
|
|
| 201 |
/*KEY "fk_event_has_party_event1_idx" ("event")*/CHECK (true),
|
|
| 202 |
/*CONSTRAINT "fk_event_has_party_event1" FOREIGN KEY ("event") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 203 |
/*CONSTRAINT "fk_event_has_party_party1" FOREIGN KEY ("party") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 204 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 205 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 206 |
|
|
| 207 |
-- |
|
| 208 |
-- Dumping data for table "event_participant" |
|
| 209 |
-- |
|
| 210 |
|
|
| 211 |
/*!40000 ALTER TABLE "event_participant" DISABLE KEYS */; |
|
| 212 |
/*!40000 ALTER TABLE "event_participant" ENABLE KEYS */; |
|
| 213 |
|
|
| 214 |
-- |
|
| 215 | 190 |
-- Table structure for table "geological_context" |
| 216 | 191 |
-- |
| 217 | 192 |
|
| ... | ... | |
| 291 | 266 |
"traits" hstore DEFAULT NULL, |
| 292 | 267 |
PRIMARY KEY ("id"),
|
| 293 | 268 |
/*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
|
| 294 |
/*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 295 |
/*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 269 |
/*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 270 |
/*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 296 | 271 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'*/; |
| 297 | 272 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 298 | 273 |
|
| ... | ... | |
| 385 | 360 |
"info" hstore DEFAULT NULL, |
| 386 | 361 |
PRIMARY KEY ("id"),
|
| 387 | 362 |
/*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),
|
| 388 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 389 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 363 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 364 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 390 | 365 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 391 | 366 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 392 | 367 |
|
| ... | ... | |
| 730 | 705 |
/*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),
|
| 731 | 706 |
/*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),
|
| 732 | 707 |
/*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),
|
| 733 |
/*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 734 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 735 | 708 |
/*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 736 | 709 |
/*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 737 | 710 |
/*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 738 | 711 |
/*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 739 |
/*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 712 |
/*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 713 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 714 |
/*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 740 | 715 |
) /*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'*/;
|
| 741 | 716 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 742 | 717 |
|
| ... | ... | |
| 772 | 747 |
/*!40000 ALTER TABLE "specimen_observation" ENABLE KEYS */; |
| 773 | 748 |
|
| 774 | 749 |
-- |
| 775 |
-- Table structure for table "specimenholder_institution" |
|
| 776 |
-- |
|
| 777 |
|
|
| 778 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 779 |
/*!40101 SET character_set_client = utf8 */; |
|
| 780 |
CREATE TABLE "specimenholder_institution" ( |
|
| 781 |
"specimen" text NOT NULL, |
|
| 782 |
"institution" text NOT NULL, |
|
| 783 |
"sort_order" integer DEFAULT NULL, |
|
| 784 |
PRIMARY KEY ("specimen","institution"),
|
|
| 785 |
/*KEY "fk_specimen_has_organization_organization1_idx" ("institution")*/CHECK (true),
|
|
| 786 |
/*KEY "fk_specimen_has_organization_specimen1_idx" ("specimen")*/CHECK (true),
|
|
| 787 |
/*CONSTRAINT "fk_specimen_has_organization_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 788 |
/*CONSTRAINT "fk_specimen_has_organization_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 789 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 790 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 791 |
|
|
| 792 |
-- |
|
| 793 |
-- Dumping data for table "specimenholder_institution" |
|
| 794 |
-- |
|
| 795 |
|
|
| 796 |
/*!40000 ALTER TABLE "specimenholder_institution" DISABLE KEYS */; |
|
| 797 |
/*!40000 ALTER TABLE "specimenholder_institution" ENABLE KEYS */; |
|
| 798 |
|
|
| 799 |
-- |
|
| 800 | 750 |
-- Table structure for table "stem" |
| 801 | 751 |
-- |
| 802 | 752 |
|
| ... | ... | |
| 963 | 913 |
PRIMARY KEY ("id"),
|
| 964 | 914 |
/*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),
|
| 965 | 915 |
/*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),
|
| 966 |
/*KEY "fk_taxon_determination_party1_idx" ("identified_by")*/CHECK (true),
|
|
| 916 |
/*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),
|
|
| 967 | 917 |
/*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 968 | 918 |
/*CONSTRAINT "fk_taxon_determination_record1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 969 |
/*CONSTRAINT "fk_taxon_determination_party1" FOREIGN KEY ("identified_by") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 919 |
/*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 970 | 920 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/; |
| 971 | 921 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 972 | 922 |
|
| ... | ... | |
| 1014 | 964 |
CREATE TABLE "taxon_observation" ( |
| 1015 | 965 |
"id" text NOT NULL, |
| 1016 | 966 |
"taxon_occurrence" text NOT NULL, |
| 1017 |
"collector" text DEFAULT NULL, |
|
| 967 |
"collectors" text DEFAULT NULL,
|
|
| 1018 | 968 |
"collector_number" text DEFAULT NULL, |
| 1019 | 969 |
"voucher" text DEFAULT NULL, |
| 1020 | 970 |
"growth_form" text DEFAULT NULL, |
| ... | ... | |
| 1023 | 973 |
PRIMARY KEY ("id"),
|
| 1024 | 974 |
/*KEY "fk_taxon_observation_taxon_occurrence2_idx" ("taxon_occurrence")*/CHECK (true),
|
| 1025 | 975 |
/*KEY "fk_taxon_observation_specimen1_idx" ("voucher")*/CHECK (true),
|
| 1026 |
/*KEY "fk_taxon_observation_party1_idx" ("collector")*/CHECK (true),
|
|
| 976 |
/*KEY "fk_taxon_observation_party_list1_idx" ("collectors")*/CHECK (true),
|
|
| 977 |
/*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1027 | 978 |
/*CONSTRAINT "fk_taxon_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1028 |
/*CONSTRAINT "fk_taxon_observation_taxon_occurrence2" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1029 | 979 |
/*CONSTRAINT "fk_taxon_observation_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1030 |
/*CONSTRAINT "fk_taxon_observation_party1" FOREIGN KEY ("collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 980 |
/*CONSTRAINT "fk_taxon_observation_taxon_occurrence2" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 1031 | 981 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 1032 | 982 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1033 | 983 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: collector, identified_by: allow multiple parties for these fields, using the new party_list array table