Project

General

Profile

« Previous | Next » 

Revision 10631

schemas/VegCore/VegCore.ERD.mwb: place_observation: don't inherit from sampling_event because sampling_event refers specifically to sampling taxa, and does not have anything to do with environmental measurements on the place itself. size_class: moved to occurrence half since it relates specifically to aggregate_observations, rather than plot strata.

View differences:

schemas/VegCore/VegCore.pg.sql
550 550
  /*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true),
551 551
  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),
552 552
  /*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),
553
  /*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
553
  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
554 554
  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
555
  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
556
  /*CONSTRAINT "fk_place_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
555
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
556
  /*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
557 557
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/;
558 558
/*!40101 SET character_set_client = @saved_cs_client */;
559 559

  
schemas/VegCore/document.mwb.xml
7991 7991
                      <value type="string" key="name">fk_place_observation_community1</value>
7992 7992
                      <value type="string" key="oldName">fk_place_observation_community1</value>
7993 7993
                    </value>
7994
                    <value type="object" struct-name="db.mysql.ForeignKey" id="eaefe558-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">
7995
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
7996
                      <value _ptr_="0xab9ccb0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7994
                    <value type="object" struct-name="db.mysql.ForeignKey" id="2d3c42f6-0078-11e3-906b-080027bcf912" struct-checksum="0x70a8fc40">
7995
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672743a-a7a0-11e2-b667-080027bcf912</link>
7996
                      <value _ptr_="0xb67ad10" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7997 7997
                        <link type="object">be8f3ade-a6e0-11e2-95e9-080027bcf912</link>
7998 7998
                      </value>
7999 7999
                      <value type="int" key="deferability">0</value>
......
8002 8002
                      <value type="int" key="many">0</value>
8003 8003
                      <value type="int" key="modelOnly">0</value>
8004 8004
                      <link type="object" struct-name="db.Table" key="owner">be8f387c-a6e0-11e2-95e9-080027bcf912</link>
8005
                      <value _ptr_="0xab9cfa0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
8006
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
8005
                      <value _ptr_="0xbcce6d0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
8006
                        <link type="object">c67276b0-a7a0-11e2-b667-080027bcf912</link>
8007 8007
                      </value>
8008 8008
                      <value type="int" key="referencedMandatory">1</value>
8009 8009
                      <value type="string" key="updateRule">CASCADE</value>
8010 8010
                      <value type="string" key="comment"></value>
8011
                      <value type="string" key="name">fk_place_observation_sampling_event1</value>
8012
                      <value type="string" key="oldName">fk_place_observation_sampling_event1</value>
8011
                      <value type="string" key="name">fk_place_observation_event1</value>
8012
                      <value type="string" key="oldName">fk_place_observation_event1</value>
8013 8013
                    </value>
8014 8014
                  </value>
8015 8015
                  <value _ptr_="0xab99c78" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
12255 12255
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12256 12256
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12257 12257
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c672971c-a7a0-11e2-b667-080027bcf912</link>
12258
                <value type="real" key="middleSegmentOffset">1.23462587080099410741240717470645904541015625e+02</value>
12258
                <value type="real" key="middleSegmentOffset">1.053084043469235666634631343185901641845703125e+02</value>
12259 12259
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12260 12260
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12261 12261
                <value type="int" key="drawSplit">0</value>
......
12297 12297
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12298 12298
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12299 12299
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8f4b64-a6e0-11e2-95e9-080027bcf912</link>
12300
                <value type="real" key="middleSegmentOffset">-3.04076872938481528763077221810817718505859375e+02</value>
12300
                <value type="real" key="middleSegmentOffset">-3.1061528391527326675713993608951568603515625e+02</value>
12301 12301
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12302 12302
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12303 12303
                <value type="int" key="drawSplit">0</value>
......
12759 12759
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12760 12760
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12761 12761
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>
12762
                <value type="real" key="middleSegmentOffset">-5.22661111819189727611956186592578887939453125e+01</value>
12762
                <value type="real" key="middleSegmentOffset">-4.71889836857450291063287295401096343994140625e+01</value>
12763 12763
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12764 12764
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12765 12765
                <value type="int" key="drawSplit">0</value>
......
12801 12801
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12802 12802
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12803 12803
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">238b53d6-a700-11e2-9461-080027bcf912</link>
12804
                <value type="real" key="middleSegmentOffset">7.1422632618047600772115401923656463623046875e+01</value>
12804
                <value type="real" key="middleSegmentOffset">5.10767023774923245582613162696361541748046875e+01</value>
12805 12805
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12806 12806
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12807 12807
                <value type="int" key="drawSplit">0</value>
......
13200 13200
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13201 13201
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13202 13202
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">a841b894-f6c0-11e2-af44-080027bcf912</link>
13203
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13203
                <value type="real" key="middleSegmentOffset">2.4692686143020409872406162321567535400390625e+01</value>
13204 13204
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13205 13205
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13206 13206
                <value type="int" key="drawSplit">0</value>
......
13210 13210
                <value type="int" key="visible">1</value>
13211 13211
                <value type="string" key="name"></value>
13212 13212
              </value>
13213
              <value type="object" struct-name="workbench.physical.Connection" id="eaeffb88-f6c0-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">
13214
                <value type="string" key="caption">fk_place_observation_sampling_event1</value>
13215
                <value type="real" key="captionXOffs">0.e+00</value>
13216
                <value type="real" key="captionYOffs">0.e+00</value>
13217
                <value type="string" key="comment"></value>
13218
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13219
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13220
                <value type="string" key="extraCaption"></value>
13221
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13222
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13223
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">eaefe558-f6c0-11e2-af44-080027bcf912</link>
13224
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13225
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13226
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13227
                <value type="int" key="drawSplit">0</value>
13228
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
13229
                <link type="object" struct-name="model.Figure" key="startFigure">FF3A48D7-490E-4E77-B97B-1F51BF51FA8A</link>
13230
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13231
                <value type="int" key="visible">1</value>
13232
                <value type="string" key="name"></value>
13233
              </value>
13234 13213
              <value type="object" struct-name="workbench.physical.Connection" id="67fa734c-f6c1-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">
13235 13214
                <value type="string" key="caption">fk_taxon_observation_sampling_event1</value>
13236 13215
                <value type="real" key="captionXOffs">0.e+00</value>
......
13242 13221
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13243 13222
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13244 13223
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">67fa5b28-f6c1-11e2-af44-080027bcf912</link>
13245
                <value type="real" key="middleSegmentOffset">1.7604021305452096157750929705798625946044921875e+02</value>
13224
                <value type="real" key="middleSegmentOffset">1.088839593808088466175831854343414306640625e+02</value>
13246 13225
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13247 13226
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13248 13227
                <value type="int" key="drawSplit">0</value>
......
13851 13830
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13852 13831
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13853 13832
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7afec93a-0075-11e3-906b-080027bcf912</link>
13854
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13833
                <value type="real" key="middleSegmentOffset">-7.20001140741236440590000711381435394287109375e+01</value>
13855 13834
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13856 13835
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13857 13836
                <value type="int" key="drawSplit">0</value>
......
13861 13840
                <value type="int" key="visible">1</value>
13862 13841
                <value type="string" key="name"></value>
13863 13842
              </value>
13843
              <value type="object" struct-name="workbench.physical.Connection" id="2d3c5d86-0078-11e3-906b-080027bcf912" struct-checksum="0x9baebc92">
13844
                <value type="string" key="caption">fk_place_observation_event1</value>
13845
                <value type="real" key="captionXOffs">0.e+00</value>
13846
                <value type="real" key="captionYOffs">0.e+00</value>
13847
                <value type="string" key="comment"></value>
13848
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13849
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13850
                <value type="string" key="extraCaption"></value>
13851
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13852
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13853
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">2d3c42f6-0078-11e3-906b-080027bcf912</link>
13854
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13855
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13856
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13857
                <value type="int" key="drawSplit">0</value>
13858
                <link type="object" struct-name="model.Figure" key="endFigure">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
13859
                <link type="object" struct-name="model.Figure" key="startFigure">FF3A48D7-490E-4E77-B97B-1F51BF51FA8A</link>
13860
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13861
                <value type="int" key="visible">1</value>
13862
                <value type="string" key="name"></value>
13863
              </value>
13864 13864
            </value>
13865 13865
            <value type="string" key="description"></value>
13866 13866
            <value _ptr_="0xae42300" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13950 13950
                <value type="int" key="expanded">1</value>
13951 13951
                <value type="real" key="height">1.69e+02</value>
13952 13952
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13953
                <value type="real" key="left">5.52e+02</value>
13953
                <value type="real" key="left">5.4e+02</value>
13954 13954
                <value type="int" key="locked">0</value>
13955 13955
                <value type="int" key="manualSizing">0</value>
13956
                <value type="real" key="top">5.41e+02</value>
13956
                <value type="real" key="top">5.91e+02</value>
13957 13957
                <value type="real" key="width">8.1e+01</value>
13958 13958
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13959 13959
                <value type="int" key="visible">1</value>
......
13990 13990
                <value type="int" key="expanded">1</value>
13991 13991
                <value type="real" key="height">1.e+02</value>
13992 13992
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13993
                <value type="real" key="left">6.76e+02</value>
13993
                <value type="real" key="left">4.66e+02</value>
13994 13994
                <value type="int" key="locked">0</value>
13995 13995
                <value type="int" key="manualSizing">0</value>
13996
                <value type="real" key="top">6.18e+02</value>
13996
                <value type="real" key="top">8.15e+02</value>
13997 13997
                <value type="real" key="width">9.e+01</value>
13998 13998
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13999 13999
                <value type="int" key="visible">1</value>
......
14030 14030
                <value type="int" key="expanded">1</value>
14031 14031
                <value type="real" key="height">1.e+02</value>
14032 14032
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14033
                <value type="real" key="left">7.15e+02</value>
14033
                <value type="real" key="left">5.93e+02</value>
14034 14034
                <value type="int" key="locked">0</value>
14035 14035
                <value type="int" key="manualSizing">0</value>
14036
                <value type="real" key="top">7.5e+02</value>
14036
                <value type="real" key="top">7.67e+02</value>
14037 14037
                <value type="real" key="width">9.3e+01</value>
14038 14038
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14039 14039
                <value type="int" key="visible">1</value>
......
14050 14050
                <value type="int" key="expanded">1</value>
14051 14051
                <value type="real" key="height">7.7e+01</value>
14052 14052
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14053
                <value type="real" key="left">3.54e+02</value>
14053
                <value type="real" key="left">3.51e+02</value>
14054 14054
                <value type="int" key="locked">0</value>
14055 14055
                <value type="int" key="manualSizing">0</value>
14056 14056
                <value type="real" key="top">5.17e+02</value>
......
14073 14073
                <value type="real" key="left">4.77e+02</value>
14074 14074
                <value type="int" key="locked">0</value>
14075 14075
                <value type="int" key="manualSizing">0</value>
14076
                <value type="real" key="top">8.95e+02</value>
14076
                <value type="real" key="top">9.46e+02</value>
14077 14077
                <value type="real" key="width">1.55e+02</value>
14078 14078
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14079 14079
                <value type="int" key="visible">1</value>
......
14110 14110
                <value type="int" key="expanded">1</value>
14111 14111
                <value type="real" key="height">7.7e+01</value>
14112 14112
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14113
                <value type="real" key="left">4.06e+02</value>
14113
                <value type="real" key="left">3.03e+02</value>
14114 14114
                <value type="int" key="locked">0</value>
14115 14115
                <value type="int" key="manualSizing">0</value>
14116
                <value type="real" key="top">1.152e+03</value>
14116
                <value type="real" key="top">9.61e+02</value>
14117 14117
                <value type="real" key="width">1.45e+02</value>
14118 14118
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14119 14119
                <value type="int" key="visible">1</value>
......
14130 14130
                <value type="int" key="expanded">1</value>
14131 14131
                <value type="real" key="height">1.e+02</value>
14132 14132
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14133
                <value type="real" key="left">2.93e+02</value>
14133
                <value type="real" key="left">1.85e+02</value>
14134 14134
                <value type="int" key="locked">0</value>
14135 14135
                <value type="int" key="manualSizing">0</value>
14136
                <value type="real" key="top">8.53e+02</value>
14136
                <value type="real" key="top">1.14e+03</value>
14137 14137
                <value type="real" key="width">1.58e+02</value>
14138 14138
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14139 14139
                <value type="int" key="visible">1</value>
......
14150 14150
                <value type="int" key="expanded">1</value>
14151 14151
                <value type="real" key="height">1.e+02</value>
14152 14152
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14153
                <value type="real" key="left">3.13e+02</value>
14153
                <value type="real" key="left">3.53e+02</value>
14154 14154
                <value type="int" key="locked">0</value>
14155 14155
                <value type="int" key="manualSizing">0</value>
14156
                <value type="real" key="top">9.89e+02</value>
14156
                <value type="real" key="top">1.14e+03</value>
14157 14157
                <value type="real" key="width">1.14e+02</value>
14158 14158
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14159 14159
                <value type="int" key="visible">1</value>
......
14190 14190
                <value type="int" key="expanded">1</value>
14191 14191
                <value type="real" key="height">1.46e+02</value>
14192 14192
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14193
                <value type="real" key="left">8.55e+02</value>
14193
                <value type="real" key="left">8.82e+02</value>
14194 14194
                <value type="int" key="locked">0</value>
14195 14195
                <value type="int" key="manualSizing">0</value>
14196 14196
                <value type="real" key="top">9.19e+02</value>
......
14210 14210
                <value type="int" key="expanded">1</value>
14211 14211
                <value type="real" key="height">1.69e+02</value>
14212 14212
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14213
                <value type="real" key="left">1.048e+03</value>
14213
                <value type="real" key="left">1.059e+03</value>
14214 14214
                <value type="int" key="locked">0</value>
14215 14215
                <value type="int" key="manualSizing">0</value>
14216 14216
                <value type="real" key="top">1.103e+03</value>
......
14250 14250
                <value type="int" key="expanded">1</value>
14251 14251
                <value type="real" key="height">1.e+02</value>
14252 14252
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14253
                <value type="real" key="left">9.86e+02</value>
14253
                <value type="real" key="left">1.013e+03</value>
14254 14254
                <value type="int" key="locked">0</value>
14255 14255
                <value type="int" key="manualSizing">0</value>
14256 14256
                <value type="real" key="top">6.43e+02</value>
......
14270 14270
                <value type="int" key="expanded">1</value>
14271 14271
                <value type="real" key="height">1.23e+02</value>
14272 14272
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14273
                <value type="real" key="left">8.84e+02</value>
14273
                <value type="real" key="left">9.11e+02</value>
14274 14274
                <value type="int" key="locked">0</value>
14275 14275
                <value type="int" key="manualSizing">0</value>
14276 14276
                <value type="real" key="top">4.95e+02</value>
......
14290 14290
                <value type="int" key="expanded">1</value>
14291 14291
                <value type="real" key="height">7.7e+01</value>
14292 14292
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14293
                <value type="real" key="left">1.153e+03</value>
14293
                <value type="real" key="left">1.18e+03</value>
14294 14294
                <value type="int" key="locked">0</value>
14295 14295
                <value type="int" key="manualSizing">0</value>
14296 14296
                <value type="real" key="top">6.73e+02</value>
......
14330 14330
                <value type="int" key="expanded">1</value>
14331 14331
                <value type="real" key="height">1.23e+02</value>
14332 14332
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14333
                <value type="real" key="left">1.071e+03</value>
14333
                <value type="real" key="left">1.084e+03</value>
14334 14334
                <value type="int" key="locked">0</value>
14335 14335
                <value type="int" key="manualSizing">0</value>
14336 14336
                <value type="real" key="top">4.5e+01</value>
......
14370 14370
                <value type="int" key="expanded">1</value>
14371 14371
                <value type="real" key="height">1.23e+02</value>
14372 14372
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14373
                <value type="real" key="left">1.08e+03</value>
14373
                <value type="real" key="left">1.093e+03</value>
14374 14374
                <value type="int" key="locked">0</value>
14375 14375
                <value type="int" key="manualSizing">0</value>
14376 14376
                <value type="real" key="top">2.96e+02</value>
......
14736 14736
                <value type="int" key="expanded">1</value>
14737 14737
                <value type="real" key="height">2.3e+01</value>
14738 14738
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14739
                <value type="real" key="left">8.1e+02</value>
14739
                <value type="real" key="left">8.3e+02</value>
14740 14740
                <value type="int" key="locked">0</value>
14741 14741
                <value type="int" key="manualSizing">0</value>
14742 14742
                <value type="real" key="top">0.e+00</value>
......
14776 14776
                <value type="int" key="expanded">1</value>
14777 14777
                <value type="real" key="height">7.7e+01</value>
14778 14778
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14779
                <value type="real" key="left">6.74e+02</value>
14779
                <value type="real" key="left">7.18e+02</value>
14780 14780
                <value type="int" key="locked">0</value>
14781 14781
                <value type="int" key="manualSizing">0</value>
14782
                <value type="real" key="top">1.025e+03</value>
14782
                <value type="real" key="top">1.024e+03</value>
14783 14783
                <value type="real" key="width">9.4e+01</value>
14784 14784
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14785 14785
                <value type="int" key="visible">1</value>
......
14796 14796
                <value type="int" key="expanded">1</value>
14797 14797
                <value type="real" key="height">5.4e+01</value>
14798 14798
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14799
                <value type="real" key="left">1.058e+03</value>
14799
                <value type="real" key="left">1.069e+03</value>
14800 14800
                <value type="int" key="locked">0</value>
14801 14801
                <value type="int" key="manualSizing">0</value>
14802 14802
                <value type="real" key="top">9.9e+02</value>
......
14816 14816
                <value type="int" key="expanded">1</value>
14817 14817
                <value type="real" key="height">1.69e+02</value>
14818 14818
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14819
                <value type="real" key="left">3.41e+02</value>
14819
                <value type="real" key="left">3.38e+02</value>
14820 14820
                <value type="int" key="locked">0</value>
14821 14821
                <value type="int" key="manualSizing">0</value>
14822 14822
                <value type="real" key="top">6.33e+02</value>
......
14876 14876
                <value type="int" key="expanded">1</value>
14877 14877
                <value type="real" key="height">1.92e+02</value>
14878 14878
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14879
                <value type="real" key="left">8.22e+02</value>
14879
                <value type="real" key="left">8.49e+02</value>
14880 14880
                <value type="int" key="locked">0</value>
14881 14881
                <value type="int" key="manualSizing">0</value>
14882
                <value type="real" key="top">1.41e+02</value>
14882
                <value type="real" key="top">1.53e+02</value>
14883 14883
                <value type="real" key="width">1.56e+02</value>
14884 14884
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14885 14885
                <value type="int" key="visible">1</value>
......
14896 14896
                <value type="int" key="expanded">1</value>
14897 14897
                <value type="real" key="height">1.23e+02</value>
14898 14898
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14899
                <value type="real" key="left">1.251e+03</value>
14899
                <value type="real" key="left">1.259e+03</value>
14900 14900
                <value type="int" key="locked">0</value>
14901 14901
                <value type="int" key="manualSizing">0</value>
14902 14902
                <value type="real" key="top">4.8e+02</value>
......
14931 14931
                <value type="int" key="expanded">1</value>
14932 14932
                <value type="real" key="height">2.7e+01</value>
14933 14933
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14934
                <value type="real" key="left">9.32e+02</value>
14934
                <value type="real" key="left">9.59e+02</value>
14935 14935
                <value type="int" key="locked">0</value>
14936 14936
                <value type="int" key="manualSizing">0</value>
14937 14937
                <value type="real" key="top">8.58e+02</value>
......
14946 14946
                <value type="int" key="expanded">1</value>
14947 14947
                <value type="real" key="height">2.5e+01</value>
14948 14948
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14949
                <value type="real" key="left">1.e+03</value>
14949
                <value type="real" key="left">1.027e+03</value>
14950 14950
                <value type="int" key="locked">0</value>
14951 14951
                <value type="int" key="manualSizing">0</value>
14952 14952
                <value type="real" key="top">9.39e+02</value>
......
14976 14976
                <value type="int" key="expanded">1</value>
14977 14977
                <value type="real" key="height">2.7e+01</value>
14978 14978
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14979
                <value type="real" key="left">1.036e+03</value>
14979
                <value type="real" key="left">1.047e+03</value>
14980 14980
                <value type="int" key="locked">0</value>
14981 14981
                <value type="int" key="manualSizing">0</value>
14982 14982
                <value type="real" key="top">1.049e+03</value>
......
14991 14991
                <value type="int" key="expanded">1</value>
14992 14992
                <value type="real" key="height">2.5e+01</value>
14993 14993
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14994
                <value type="real" key="left">1.192e+03</value>
14994
                <value type="real" key="left">1.203e+03</value>
14995 14995
                <value type="int" key="locked">0</value>
14996 14996
                <value type="int" key="manualSizing">0</value>
14997 14997
                <value type="real" key="top">1.194e+03</value>
......
15021 15021
                <value type="int" key="expanded">1</value>
15022 15022
                <value type="real" key="height">2.5e+01</value>
15023 15023
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15024
                <value type="real" key="left">9.32e+02</value>
15024
                <value type="real" key="left">9.59e+02</value>
15025 15025
                <value type="int" key="locked">0</value>
15026 15026
                <value type="int" key="manualSizing">0</value>
15027 15027
                <value type="real" key="top">8.9e+02</value>
......
15036 15036
                <value type="int" key="expanded">1</value>
15037 15037
                <value type="real" key="height">2.7e+01</value>
15038 15038
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15039
                <value type="real" key="left">7.64e+02</value>
15039
                <value type="real" key="left">7.84e+02</value>
15040 15040
                <value type="int" key="locked">0</value>
15041 15041
                <value type="int" key="manualSizing">0</value>
15042 15042
                <value type="real" key="top">0.e+00</value>
......
15096 15096
                <value type="int" key="expanded">1</value>
15097 15097
                <value type="real" key="height">5.4e+01</value>
15098 15098
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15099
                <value type="real" key="left">9.59e+02</value>
15099
                <value type="real" key="left">9.86e+02</value>
15100 15100
                <value type="int" key="locked">0</value>
15101 15101
                <value type="int" key="manualSizing">0</value>
15102 15102
                <value type="real" key="top">7.84e+02</value>
......
15116 15116
                <value type="int" key="expanded">1</value>
15117 15117
                <value type="real" key="height">7.7e+01</value>
15118 15118
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15119
                <value type="real" key="left">5.46e+02</value>
15119
                <value type="real" key="left">6.73e+02</value>
15120 15120
                <value type="int" key="locked">0</value>
15121 15121
                <value type="int" key="manualSizing">0</value>
15122
                <value type="real" key="top">7.78e+02</value>
15122
                <value type="real" key="top">5.95e+02</value>
15123 15123
                <value type="real" key="width">1.4e+02</value>
15124 15124
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15125 15125
                <value type="int" key="visible">1</value>
......
15242 15242
                <value type="int" key="expanded">1</value>
15243 15243
                <value type="real" key="height">2.7e+01</value>
15244 15244
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15245
                <value type="real" key="left">2.77e+02</value>
15245
                <value type="real" key="left">2.74e+02</value>
15246 15246
                <value type="int" key="locked">0</value>
15247 15247
                <value type="int" key="manualSizing">0</value>
15248 15248
                <value type="real" key="top">6.01e+02</value>
......
15259 15259
                <value type="int" key="expanded">1</value>
15260 15260
                <value type="real" key="height">5.5e+01</value>
15261 15261
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15262
                <value type="real" key="left">2.81e+02</value>
15262
                <value type="real" key="left">2.78e+02</value>
15263 15263
                <value type="int" key="locked">0</value>
15264 15264
                <value type="int" key="manualSizing">0</value>
15265 15265
                <value type="real" key="top">5.32e+02</value>
......
15275 15275
                <value type="int" key="expanded">1</value>
15276 15276
                <value type="real" key="height">4.1e+01</value>
15277 15277
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15278
                <value type="real" key="left">2.71e+02</value>
15278
                <value type="real" key="left">2.68e+02</value>
15279 15279
                <value type="int" key="locked">0</value>
15280 15280
                <value type="int" key="manualSizing">0</value>
15281 15281
                <value type="real" key="top">4.73e+02</value>
......
15315 15315
                <value type="int" key="expanded">1</value>
15316 15316
                <value type="real" key="height">1.e+02</value>
15317 15317
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15318
                <value type="real" key="left">6.4e+02</value>
15318
                <value type="real" key="left">6.9e+02</value>
15319 15319
                <value type="int" key="locked">0</value>
15320 15320
                <value type="int" key="manualSizing">0</value>
15321
                <value type="real" key="top">8.95e+02</value>
15321
                <value type="real" key="top">8.83e+02</value>
15322 15322
                <value type="real" key="width">1.32e+02</value>
15323 15323
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15324 15324
                <value type="int" key="visible">1</value>
......
15335 15335
                <value type="int" key="expanded">1</value>
15336 15336
                <value type="real" key="height">1.46e+02</value>
15337 15337
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15338
                <value type="real" key="left">5.98e+02</value>
15338
                <value type="real" key="left">6.55e+02</value>
15339 15339
                <value type="int" key="locked">0</value>
15340 15340
                <value type="int" key="manualSizing">0</value>
15341
                <value type="real" key="top">1.128e+03</value>
15341
                <value type="real" key="top">1.112e+03</value>
15342 15342
                <value type="real" key="width">9.4e+01</value>
15343 15343
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15344 15344
                <value type="int" key="visible">1</value>
......
15355 15355
                <value type="int" key="expanded">1</value>
15356 15356
                <value type="real" key="height">1.23e+02</value>
15357 15357
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15358
                <value type="real" key="left">6.99e+02</value>
15358
                <value type="real" key="left">8.39e+02</value>
15359 15359
                <value type="int" key="locked">0</value>
15360 15360
                <value type="int" key="manualSizing">0</value>
15361
                <value type="real" key="top">1.128e+03</value>
15361
                <value type="real" key="top">6.89e+02</value>
15362 15362
                <value type="real" key="width">1.09e+02</value>
15363 15363
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15364 15364
                <value type="int" key="visible">1</value>
......
16080 16080
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
16081 16081
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
16082 16082
      <value type="string" key="caption">New Model</value>
16083
      <value type="string" key="dateChanged">2013-08-08 15:13</value>
16083
      <value type="string" key="dateChanged">2013-08-08 16:07</value>
16084 16084
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
16085 16085
      <value type="string" key="description"></value>
16086 16086
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
548 548
  KEY `fk_place_observation_place1_idx` (`place`),
549 549
  KEY `fk_place_observation_geological_context1_idx` (`geological_context`),
550 550
  KEY `fk_place_observation_community1_idx` (`community`),
551
  CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
551
  CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
552 552
  CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
553
  CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
554
  CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
553
  CONSTRAINT `fk_place_observation_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
554
  CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
555 555
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]';
556 556
/*!40101 SET character_set_client = @saved_cs_client */;
557 557

  

Also available in: Unified diff