7086 |
7086 |
<value type="string" key="oldName">id</value>
|
7087 |
7087 |
<link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
|
7088 |
7088 |
</value>
|
7089 |
|
<value type="object" struct-name="db.mysql.Column" id="323a39a4-011b-11e3-b872-080027bcf912" struct-checksum="0x783b5183">
|
7090 |
|
<value type="int" key="autoIncrement">0</value>
|
7091 |
|
<value type="string" key="characterSetName"></value>
|
7092 |
|
<value _ptr_="0xbb35128" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
|
7093 |
|
<value type="string" key="collationName"></value>
|
7094 |
|
<value type="string" key="datatypeExplicitParams"></value>
|
7095 |
|
<value type="string" key="defaultValue"></value>
|
7096 |
|
<value type="int" key="defaultValueIsNull">1</value>
|
7097 |
|
<value _ptr_="0xbb35488" type="list" content-type="string" key="flags"/>
|
7098 |
|
<value type="int" key="isNotNull">0</value>
|
7099 |
|
<value type="int" key="length">767</value>
|
7100 |
|
<value type="int" key="precision">-1</value>
|
7101 |
|
<value type="int" key="scale">-1</value>
|
7102 |
|
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
|
7103 |
|
<value type="string" key="comment"></value>
|
7104 |
|
<value type="string" key="name">place_observed_at</value>
|
7105 |
|
<value type="string" key="oldName">place_observed_at</value>
|
7106 |
|
<link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
|
7107 |
|
</value>
|
7108 |
7089 |
<value type="object" struct-name="db.mysql.Column" id="0ab98c50-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
|
7109 |
7090 |
<value type="int" key="autoIncrement">0</value>
|
7110 |
7091 |
<value type="string" key="characterSetName"></value>
|
... | ... | |
7191 |
7172 |
<value type="string" key="name">fk_individual_observation_individual1</value>
|
7192 |
7173 |
<value type="string" key="oldName">fk_individual_observation_individual1</value>
|
7193 |
7174 |
</value>
|
7194 |
|
<value type="object" struct-name="db.mysql.ForeignKey" id="323a36d4-011b-11e3-b872-080027bcf912" struct-checksum="0x70a8fc40">
|
7195 |
|
<link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
|
7196 |
|
<value _ptr_="0xbb36378" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
7197 |
|
<link type="object">323a39a4-011b-11e3-b872-080027bcf912</link>
|
7198 |
|
</value>
|
7199 |
|
<value type="int" key="deferability">0</value>
|
7200 |
|
<value type="string" key="deleteRule">CASCADE</value>
|
7201 |
|
<link type="object" struct-name="db.Index" key="index">323a5f56-011b-11e3-b872-080027bcf912</link>
|
7202 |
|
<value type="int" key="mandatory">1</value>
|
7203 |
|
<value type="int" key="many">1</value>
|
7204 |
|
<value type="int" key="modelOnly">0</value>
|
7205 |
|
<link type="object" struct-name="db.Table" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
|
7206 |
|
<value _ptr_="0xbb36700" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
|
7207 |
|
<link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
|
7208 |
|
</value>
|
7209 |
|
<value type="int" key="referencedMandatory">0</value>
|
7210 |
|
<value type="string" key="updateRule">CASCADE</value>
|
7211 |
|
<value type="string" key="comment"></value>
|
7212 |
|
<value type="string" key="name">fk_individual_observation_place1</value>
|
7213 |
|
<value type="string" key="oldName">fk_individual_observation_place1</value>
|
7214 |
|
</value>
|
7215 |
7175 |
<value type="object" struct-name="db.mysql.ForeignKey" id="0ab99696-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
|
7216 |
7176 |
<link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
|
7217 |
7177 |
<value _ptr_="0xbb36770" type="list" content-type="object" content-struct-name="db.Column" key="columns">
|
... | ... | |
7281 |
7241 |
<value type="string" key="oldName">fk_individual_observation_individual1_idx</value>
|
7282 |
7242 |
<link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
|
7283 |
7243 |
</value>
|
7284 |
|
<value type="object" struct-name="db.mysql.Index" id="323a5f56-011b-11e3-b872-080027bcf912" struct-checksum="0x309b847a">
|
7285 |
|
<value _ptr_="0xbb37648" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
7286 |
|
<value type="object" struct-name="db.mysql.IndexColumn" id="323a6168-011b-11e3-b872-080027bcf912" struct-checksum="0x62630b3c">
|
7287 |
|
<value type="int" key="columnLength">0</value>
|
7288 |
|
<value type="string" key="comment"></value>
|
7289 |
|
<value type="int" key="descend">0</value>
|
7290 |
|
<link type="object" struct-name="db.Column" key="referencedColumn">323a39a4-011b-11e3-b872-080027bcf912</link>
|
7291 |
|
<value type="string" key="name"></value>
|
7292 |
|
<link type="object" struct-name="GrtObject" key="owner">323a5f56-011b-11e3-b872-080027bcf912</link>
|
7293 |
|
</value>
|
7294 |
|
</value>
|
7295 |
|
<value type="string" key="indexKind"></value>
|
7296 |
|
<value type="int" key="keyBlockSize">0</value>
|
7297 |
|
<value type="string" key="withParser"></value>
|
7298 |
|
<value type="string" key="comment"></value>
|
7299 |
|
<value type="int" key="deferability">0</value>
|
7300 |
|
<value type="string" key="indexType">INDEX</value>
|
7301 |
|
<value type="int" key="isPrimary">0</value>
|
7302 |
|
<value type="string" key="name">fk_individual_observation_place1_idx</value>
|
7303 |
|
<value type="int" key="unique">0</value>
|
7304 |
|
<value type="string" key="oldName">fk_individual_observation_place1_idx</value>
|
7305 |
|
<link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
|
7306 |
|
</value>
|
7307 |
7244 |
<value type="object" struct-name="db.mysql.Index" id="bb865680-2992-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">
|
7308 |
7245 |
<value _ptr_="0xd0848b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
|
7309 |
7246 |
<value type="object" struct-name="db.mysql.IndexColumn" id="bb86582e-2992-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
|
... | ... | |
7358 |
7295 |
<value type="int" key="commentedOut">0</value>
|
7359 |
7296 |
<value type="string" key="createDate">2013-04-17 13:54</value>
|
7360 |
7297 |
<value _ptr_="0xbb347b0" type="dict" key="customData"/>
|
7361 |
|
<value type="string" key="lastChangeDate">2013-09-29 22:43</value>
|
|
7298 |
<value type="string" key="lastChangeDate">2013-09-30 01:20</value>
|
7362 |
7299 |
<value type="int" key="modelOnly">0</value>
|
7363 |
7300 |
<value type="string" key="name">individual_observation</value>
|
7364 |
7301 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
|
7365 |
7302 |
<value type="string" key="temp_sql"></value>
|
7366 |
|
<value type="string" key="comment">An observation of an [[VegCore#Individual|Individual]]</value>
|
|
7303 |
<value type="string" key="comment">An observation of an [[VegCore#Individual|Individual]]; inherited fields: place: contains the place the individual was observed at</value>
|
7367 |
7304 |
<value type="string" key="oldName">individual_observation</value>
|
7368 |
7305 |
</value>
|
7369 |
7306 |
<value type="object" struct-name="db.mysql.Table" id="be8e6514-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
|
... | ... | |
13954 |
13891 |
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
13955 |
13892 |
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
13956 |
13893 |
<link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e8fe4-a6e0-11e2-95e9-080027bcf912</link>
|
13957 |
|
<value type="real" key="middleSegmentOffset">4.0539068645297447801567614078521728515625e+01</value>
|
|
13894 |
<value type="real" key="middleSegmentOffset">4.715454256184551695696427486836910247802734375e+01</value>
|
13958 |
13895 |
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
13959 |
13896 |
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
13960 |
13897 |
<value type="int" key="drawSplit">0</value>
|
... | ... | |
15161 |
15098 |
<value type="int" key="visible">1</value>
|
15162 |
15099 |
<value type="string" key="name"></value>
|
15163 |
15100 |
</value>
|
15164 |
|
<value type="object" struct-name="workbench.physical.Connection" id="323a697e-011b-11e3-b872-080027bcf912" struct-checksum="0x9baebc92">
|
15165 |
|
<value type="string" key="caption">fk_individual_observation_place1</value>
|
15166 |
|
<value type="real" key="captionXOffs">0.e+00</value>
|
15167 |
|
<value type="real" key="captionYOffs">0.e+00</value>
|
15168 |
|
<value type="string" key="comment"></value>
|
15169 |
|
<value type="real" key="endCaptionXOffs">0.e+00</value>
|
15170 |
|
<value type="real" key="endCaptionYOffs">0.e+00</value>
|
15171 |
|
<value type="string" key="extraCaption"></value>
|
15172 |
|
<value type="real" key="extraCaptionXOffs">0.e+00</value>
|
15173 |
|
<value type="real" key="extraCaptionYOffs">0.e+00</value>
|
15174 |
|
<link type="object" struct-name="db.ForeignKey" key="foreignKey">323a36d4-011b-11e3-b872-080027bcf912</link>
|
15175 |
|
<value type="real" key="middleSegmentOffset">0.e+00</value>
|
15176 |
|
<value type="real" key="startCaptionXOffs">0.e+00</value>
|
15177 |
|
<value type="real" key="startCaptionYOffs">0.e+00</value>
|
15178 |
|
<value type="int" key="drawSplit">1</value>
|
15179 |
|
<link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
|
15180 |
|
<link type="object" struct-name="model.Figure" key="startFigure">D1965EDA-481F-496B-9C24-79553E7891E8</link>
|
15181 |
|
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
15182 |
|
<value type="int" key="visible">1</value>
|
15183 |
|
<value type="string" key="name"></value>
|
15184 |
|
</value>
|
15185 |
15101 |
<value type="object" struct-name="workbench.physical.Connection" id="39fe67ca-011e-11e3-9f3a-080027bcf912" struct-checksum="0x9baebc92">
|
15186 |
15102 |
<value type="string" key="caption">fk_taxon_observation_sampling_event1</value>
|
15187 |
15103 |
<value type="real" key="captionXOffs">0.e+00</value>
|
... | ... | |
16432 |
16348 |
<value type="real" key="left">1.292e+03</value>
|
16433 |
16349 |
<value type="int" key="locked">0</value>
|
16434 |
16350 |
<value type="int" key="manualSizing">0</value>
|
16435 |
|
<value type="real" key="top">6.5e+01</value>
|
|
16351 |
<value type="real" key="top">5.3e+01</value>
|
16436 |
16352 |
<value type="real" key="width">1.06e+02</value>
|
16437 |
16353 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
|
16438 |
16354 |
<value type="int" key="visible">1</value>
|
... | ... | |
16447 |
16363 |
<value type="int" key="triggersExpanded">0</value>
|
16448 |
16364 |
<value type="string" key="color">#CCFFCC</value>
|
16449 |
16365 |
<value type="int" key="expanded">1</value>
|
16450 |
|
<value type="real" key="height">1.23e+02</value>
|
|
16366 |
<value type="real" key="height">1.e+02</value>
|
16451 |
16367 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
|
16452 |
16368 |
<value type="real" key="left">1.068e+03</value>
|
16453 |
16369 |
<value type="int" key="locked">0</value>
|
... | ... | |
17744 |
17660 |
<value type="string" key="name"></value>
|
17745 |
17661 |
</value>
|
17746 |
17662 |
<value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
|
17747 |
|
<link type="object">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
|
|
17663 |
<link type="object">D1965EDA-481F-496B-9C24-79553E7891E8</link>
|
17748 |
17664 |
</value>
|
17749 |
17665 |
<value type="int" key="updateBlocked">0</value>
|
17750 |
17666 |
<value type="real" key="width">1.6215e+03</value>
|
... | ... | |
17758 |
17674 |
<link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
|
17759 |
17675 |
<value _ptr_="0xbadb488" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
|
17760 |
17676 |
<value _ptr_="0xb078db0" type="dict" key="syncProfiles">
|
17761 |
|
<value type="object" struct-name="db.mgmt.SyncProfile" id="46dd99aa-29a7-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
|
17762 |
|
<value _ptr_="0xe060c50" type="dict" key="lastKnownDBNames">
|
|
17677 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="ce716608-29a7-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
17678 |
<value _ptr_="0xe76dd98" type="dict" key="lastKnownDBNames">
|
17763 |
17679 |
<value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
|
17764 |
17680 |
<value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
|
17765 |
17681 |
<value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
|
... | ... | |
18391 |
18307 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
|
18392 |
18308 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value>
|
18393 |
18309 |
<value type="string" key="caption">New Model</value>
|
18394 |
|
<value type="string" key="dateChanged">2013-09-30 01:10</value>
|
|
18310 |
<value type="string" key="dateChanged">2013-09-30 01:22</value>
|
18395 |
18311 |
<value type="string" key="dateCreated">2012-01-19 14:06</value>
|
18396 |
18312 |
<value type="string" key="description"></value>
|
18397 |
18313 |
<value type="string" key="project">Name of the project</value>
|
schemas/VegCore/ERD/VegCore.ERD.mwb: individual_observation.place_observed_at: merged with inherited place field, documenting that for this table, this contains the place the individual was observed at