3110 |
3110 |
<value type="string" key="oldName">all_collectors</value>
|
3111 |
3111 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3112 |
3112 |
</value>
|
3113 |
|
<value type="object" struct-name="db.mysql.Column" id="aecb1a5e-1de2-11e3-b950-080027bcf912" struct-checksum="0x783b5183">
|
3114 |
|
<value type="int" key="autoIncrement">0</value>
|
3115 |
|
<value type="string" key="characterSetName"></value>
|
3116 |
|
<value _ptr_="0xb6dbc00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
3117 |
|
<value type="string" key="collationName"></value>
|
3118 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
3119 |
|
<value type="string" key="defaultValue"></value>
|
3120 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
3121 |
|
<value _ptr_="0xb6dbf80" type="list" content-type="string" key="flags"/>
|
3122 |
|
<value type="int" key="isNotNull">0</value>
|
3123 |
|
<value type="int" key="length">767</value>
|
3124 |
|
<value type="int" key="precision">-1</value>
|
3125 |
|
<value type="int" key="scale">-1</value>
|
3126 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
3127 |
|
<value type="string" key="comment">points to the observation of the same taxon/individual in the parent event; = VegBank.vegpath.org?taxonImportance.taxonObservation_ID</value>
|
3128 |
|
<value type="string" key="name">observation_in_parent_event</value>
|
3129 |
|
<value type="string" key="oldName">observation_in_parent_event</value>
|
3130 |
|
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3131 |
|
</value>
|
3132 |
3113 |
<value type="object" struct-name="db.mysql.Column" id="16538808-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">
|
3133 |
3114 |
<value type="int" key="autoIncrement">0</value>
|
3134 |
3115 |
<value type="string" key="characterSetName"></value>
|
... | ... | |
3192 |
3173 |
<value type="string" key="defaultCollationName">utf8_bin</value>
|
3193 |
3174 |
<value type="int" key="delayKeyWrite">0</value>
|
3194 |
3175 |
<value _ptr_="0xb6d9cc0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
|
3195 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="aecb187e-1de2-11e3-b950-080027bcf912" struct-checksum="0x70a8fc40">
|
3196 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3197 |
|
<value _ptr_="0xb6dcf68" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
3198 |
|
<link type="object">aecb1a5e-1de2-11e3-b950-080027bcf912</link>
|
3199 |
|
</value>
|
3200 |
|
<value type="int" key="deferability">0</value>
|
3201 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
3202 |
|
<link type="object" struct-name="db.Index" key="index">aecb3a34-1de2-11e3-b950-080027bcf912</link>
|
3203 |
|
<value type="int" key="mandatory">1</value>
|
3204 |
|
<value type="int" key="many">1</value>
|
3205 |
|
<value type="int" key="modelOnly">0</value>
|
3206 |
|
<link type="object" struct-name="db.Table" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3207 |
|
<value _ptr_="0xb6dd2d0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
3208 |
|
<link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
|
3209 |
|
</value>
|
3210 |
|
<value type="int" key="referencedMandatory">0</value>
|
3211 |
|
<value type="string" key="updateRule">CASCADE</value>
|
3212 |
|
<value type="string" key="comment"></value>
|
3213 |
|
<value type="string" key="name">fk_taxon_observation_taxon_observation1</value>
|
3214 |
|
<value type="string" key="oldName">fk_taxon_observation_taxon_observation1</value>
|
3215 |
|
</value>
|
3216 |
3176 |
<value type="object" struct-name="db.mysql.ForeignKey" id="713ff706-2998-11e3-a80d-080027bcf912" struct-checksum="0x70a8fc40">
|
3217 |
3177 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
|
3218 |
3178 |
<value _ptr_="0xb6dd340" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
... | ... | |
3388 |
3348 |
<value type="string" key="oldName">fk_taxon_observation_taxa_sampling_event1_idx</value>
|
3389 |
3349 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3390 |
3350 |
</value>
|
3391 |
|
<value type="object" struct-name="db.mysql.Index" id="aecb3a34-1de2-11e3-b950-080027bcf912" struct-checksum="0x309b847a">
|
3392 |
|
<value _ptr_="0xb6df8d8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
3393 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="aecb3e94-1de2-11e3-b950-080027bcf912" struct-checksum="0x62630b3c">
|
3394 |
|
<value type="int" key="columnLength">0</value>
|
3395 |
|
<value type="string" key="comment"></value>
|
3396 |
|
<value type="int" key="descend">0</value>
|
3397 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">aecb1a5e-1de2-11e3-b950-080027bcf912</link>
|
3398 |
|
<value type="string" key="name"></value>
|
3399 |
|
<link type="object" struct-name="GrtObject" key="owner">aecb3a34-1de2-11e3-b950-080027bcf912</link>
|
3400 |
|
</value>
|
3401 |
|
</value>
|
3402 |
|
<value type="string" key="indexKind"></value>
|
3403 |
|
<value type="int" key="keyBlockSize">0</value>
|
3404 |
|
<value type="string" key="withParser"></value>
|
3405 |
|
<value type="string" key="comment"></value>
|
3406 |
|
<value type="int" key="deferability">0</value>
|
3407 |
|
<value type="string" key="indexType">INDEX</value>
|
3408 |
|
<value type="int" key="isPrimary">0</value>
|
3409 |
|
<value type="string" key="name">fk_taxon_observation_taxon_observation1_idx</value>
|
3410 |
|
<value type="int" key="unique">0</value>
|
3411 |
|
<value type="string" key="oldName">fk_taxon_observation_taxon_observation1_idx</value>
|
3412 |
|
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
3413 |
|
</value>
|
3414 |
3351 |
<value type="object" struct-name="db.mysql.Index" id="714100ce-2998-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">
|
3415 |
3352 |
<value _ptr_="0xb6dffb8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
3416 |
3353 |
<value type="object" struct-name="db.mysql.IndexColumn" id="71413ae4-2998-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
|
... | ... | |
3532 |
3469 |
<value type="string" key="name">taxon_observation</value>
|
3533 |
3470 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
3534 |
3471 |
<value type="string" key="temp_sql"></value>
|
3535 |
|
<value type="string" key="comment">= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)</value>
|
|
3472 |
<value type="string" key="comment">= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence); inherited fields: parent: contains the observation of the same taxon_occurrence in the parent sampling_event</value>
|
3536 |
3473 |
<value type="string" key="oldName">taxon_observation</value>
|
3537 |
3474 |
</value>
|
3538 |
3475 |
<value type="object" struct-name="db.mysql.Table" id="be8f1784-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
... | ... | |
13891 |
13828 |
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
13892 |
13829 |
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
13893 |
13830 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e8fe4-a6e0-11e2-95e9-080027bcf912</link>
|
13894 |
|
<value type="real" key="middleSegmentOffset">4.715454256184551695696427486836910247802734375e+01</value>
|
|
13831 |
<value type="real" key="middleSegmentOffset">6.007780790614521038150996901094913482666015625e+01</value>
|
13895 |
13832 |
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
13896 |
13833 |
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
13897 |
13834 |
<value type="int" key="drawSplit">0</value>
|
... | ... | |
13933 |
13870 |
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
13934 |
13871 |
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
13935 |
13872 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">f62bfaf6-a797-11e2-8681-080027bcf912</link>
|
13936 |
|
<value type="real" key="middleSegmentOffset">5.7000641529401292473266948945820331573486328125e+01</value>
|
|
13873 |
<value type="real" key="middleSegmentOffset">6.8693153443453610407232190482318401336669921875e+01</value>
|
13937 |
13874 |
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
13938 |
13875 |
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
13939 |
13876 |
<value type="int" key="drawSplit">0</value>
|
... | ... | |
15424 |
15361 |
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
15425 |
15362 |
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
15426 |
15363 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
|
15427 |
|
<value type="real" key="middleSegmentOffset">-6.069062987439656353672035038471221923828125e+01</value>
|
|
15364 |
<value type="real" key="middleSegmentOffset">-4.061325955806017873328528366982936859130859375e+01</value>
|
15428 |
15365 |
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
15429 |
15366 |
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
15430 |
15367 |
<value type="int" key="drawSplit">0</value>
|
... | ... | |
15434 |
15371 |
<value type="int" key="visible">1</value>
|
15435 |
15372 |
<value type="string" key="name"></value>
|
15436 |
15373 |
</value>
|
15437 |
|
<value type="object" struct-name="workbench.physical.Connection" id="aecb459c-1de2-11e3-b950-080027bcf912" struct-checksum="0x9baebc92">
|
15438 |
|
<value type="string" key="caption">fk_taxon_observation_taxon_observation1</value>
|
15439 |
|
<value type="real" key="captionXOffs">0.e+00</value>
|
15440 |
|
<value type="real" key="captionYOffs">0.e+00</value>
|
15441 |
|
<value type="string" key="comment"></value>
|
15442 |
|
<value type="real" key="endCaptionXOffs">0.e+00</value>
|
15443 |
|
<value type="real" key="endCaptionYOffs">0.e+00</value>
|
15444 |
|
<value type="string" key="extraCaption"></value>
|
15445 |
|
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
15446 |
|
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
15447 |
|
<link type="object" struct-name="db.ForeignKey" key="foreignKey">aecb187e-1de2-11e3-b950-080027bcf912</link>
|
15448 |
|
<value type="real" key="middleSegmentOffset">0.e+00</value>
|
15449 |
|
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
15450 |
|
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
15451 |
|
<value type="int" key="drawSplit">0</value>
|
15452 |
|
<link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
|
15453 |
|
<link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
|
15454 |
|
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
15455 |
|
<value type="int" key="visible">1</value>
|
15456 |
|
<value type="string" key="name"></value>
|
15457 |
|
</value>
|
15458 |
15374 |
<value type="object" struct-name="workbench.physical.Connection" id="813e8be6-1de9-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">
|
15459 |
15375 |
<value type="string" key="caption">fk_party_list_entry_party_list1</value>
|
15460 |
15376 |
<value type="real" key="captionXOffs">0.e+00</value>
|
... | ... | |
16889 |
16805 |
<value type="int" key="triggersExpanded">0</value>
|
16890 |
16806 |
<value type="string" key="color">#FFFF00</value>
|
16891 |
16807 |
<value type="int" key="expanded">1</value>
|
16892 |
|
<value type="real" key="height">2.61e+02</value>
|
|
16808 |
<value type="real" key="height">2.38e+02</value>
|
16893 |
16809 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
|
16894 |
|
<value type="real" key="left">8.42e+02</value>
|
|
16810 |
<value type="real" key="left">8.47e+02</value>
|
16895 |
16811 |
<value type="int" key="locked">0</value>
|
16896 |
16812 |
<value type="int" key="manualSizing">0</value>
|
16897 |
|
<value type="real" key="top">1.76e+02</value>
|
16898 |
|
<value type="real" key="width">1.63e+02</value>
|
|
16813 |
<value type="real" key="top">1.59e+02</value>
|
|
16814 |
<value type="real" key="width">1.56e+02</value>
|
16899 |
16815 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
16900 |
16816 |
<value type="int" key="visible">1</value>
|
16901 |
16817 |
<value type="string" key="name">taxon_observation</value>
|
... | ... | |
17754 |
17670 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
|
17755 |
17671 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value>
|
17756 |
17672 |
<value type="string" key="caption">New Model</value>
|
17757 |
|
<value type="string" key="dateChanged">2013-09-30 01:32</value>
|
|
17673 |
<value type="string" key="dateChanged">2013-09-30 01:36</value>
|
17758 |
17674 |
<value type="string" key="dateCreated">2012-01-19 14:06</value>
|
17759 |
17675 |
<value type="string" key="description"></value>
|
17760 |
17676 |
<value type="string" key="project">Name of the project</value>
|
schemas/VegCore/ERD/VegCore.ERD.mwb: taxon_observation.observation_in_parent_place: merged with inherited parent field, documenting that for this table, this contains the observation of the same taxon_occurrence in the parent sampling_event