Project

General

Profile

« Previous | Next » 

Revision 10636

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: *.footprint_geom_WKT: renamed to boundary_WKT for clarity

View differences:

schemas/VegCore/VegCore.pg.sql
222 222 
  "id" text NOT NULL,
223 223 
  "latitude_deg" text NOT NULL,
224 224 
  "longitude_deg" text NOT NULL,
225 
  "footprint_geom_WKT" text NOT NULL DEFAULT 'point',
225 
  "boundary_WKT" text NOT NULL DEFAULT 'point',
226 226 
  "official_name" text DEFAULT NULL,
227 227 
  PRIMARY KEY ("id"),
228 228 
  /*CONSTRAINT "fk_geoplace_place1" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
......
584 584 
  "length_m" text DEFAULT NULL,
585 585 
  "width_m" text DEFAULT NULL,
586 586 
  "azimuth_deg_N" text DEFAULT NULL,
587 
  "footprint_geom_WKT" text DEFAULT NULL,
587 
  "boundary_WKT" text DEFAULT NULL,
588 588 
  "dimensions" hstore DEFAULT NULL,
589 589 
  PRIMARY KEY ("id"),
590 590 
  /*CONSTRAINT "fk_subplot_place1" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
schemas/VegCore/document.mwb.xml
3123 3123 
                      <value type="int" key="scale">-1</value>
3124 3124 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
3125 3125 
                      <value type="string" key="comment"></value>
3126 
                      <value type="string" key="name">footprint_geom_WKT</value>
3126 
                      <value type="string" key="name">boundary_WKT</value>
3127 3127 
                      <value type="string" key="oldName">footprint_geom_WKT</value>
3128 3128 
                      <link type="object" struct-name="GrtObject" key="owner">be8d4a58-a6e0-11e2-95e9-080027bcf912</link>
3129 3129 
                    </value>
......
3228 3228 
                  <value type="int" key="commentedOut">0</value>
3229 3229 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
3230 3230 
                  <value _ptr_="0xb0c9650" type="dict" key="customData"/>
3231 
                  <value type="string" key="lastChangeDate">2013-08-01 02:52</value>
3231 
                  <value type="string" key="lastChangeDate">2013-08-08 17:14</value>
3232 3232 
                  <value type="int" key="modelOnly">0</value>
3233 3233 
                  <value type="string" key="name">geoplace</value>
3234 3234 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
8515 8515 
                      <value type="int" key="scale">-1</value>
8516 8516 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8517 8517 
                      <value type="string" key="comment"></value>
8518 
                      <value type="string" key="name">footprint_geom_WKT</value>
8518 
                      <value type="string" key="name">boundary_WKT</value>
8519 8519 
                      <value type="string" key="oldName">footprint_geom_WKT</value>
8520 8520 
                      <link type="object" struct-name="GrtObject" key="owner">9f4bd98c-a6fb-11e2-9461-080027bcf912</link>
8521 8521 
                    </value>
......
8621 8621 
                  <value type="int" key="commentedOut">0</value>
8622 8622 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
8623 8623 
                  <value _ptr_="0xb118350" type="dict" key="customData"/>
8624 
                  <value type="string" key="lastChangeDate">2013-07-30 18:48</value>
8624 
                  <value type="string" key="lastChangeDate">2013-08-08 17:15</value>
8625 8625 
                  <value type="int" key="modelOnly">0</value>
8626 8626 
                  <value type="string" key="name">plot</value>
8627 8627 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11472 11472 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
11473 11473 
                      <value type="string" key="comment"></value>
11474 11474 
                      <value type="string" key="name">voucher</value>
11475 
                      <value type="string" key="oldName">occurrence_status</value>
11475 
                      <value type="string" key="oldName">voucher</value>
11476 11476 
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>
11477 11477 
                    </value>
11478 11478 
                  </value>
......
11587 11587 
                      <value type="int" key="isPrimary">0</value>
11588 11588 
                      <value type="string" key="name">fk_reobservable_presence_specimen1_idx</value>
11589 11589 
                      <value type="int" key="unique">0</value>
11590 
                      <value type="string" key="oldName">fk_reobservable_presence_specimen1</value>
11590 
                      <value type="string" key="oldName">fk_reobservable_presence_specimen1_idx</value>
11591 11591 
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>
11592 11592 
                    </value>
11593 11593 
                  </value>
......
11627 11627 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
11628 11628 
                  <value type="string" key="temp_sql"></value>
11629 11629 
                  <value type="string" key="comment"></value>
11630 
                  <value type="string" key="oldName"></value>
11630 
                  <value type="string" key="oldName">reobservable_presence</value>
11631 11631 
                </value>
11632 11632 
              </value>
11633 11633 
              <value _ptr_="0xb0afb48" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>
......
13585 13585 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13586 13586 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13587 13587 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">dbe10c36-f6e8-11e2-9cf1-080027bcf912</link>
13588 
                <value type="real" key="middleSegmentOffset">-1.492248553211726402878412045538425445556640625e+01</value>
13588 
                <value type="real" key="middleSegmentOffset">-2.199921468585029060704982839524745941162109375e+01</value>
13589 13589 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13590 13590 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13591 13591 
                <value type="int" key="drawSplit">0</value>
......
13753 13753 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13754 13754 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13755 13755 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6b43aacc-f979-11e2-9f36-080027bcf912</link>
13756 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13756 
                <value type="real" key="middleSegmentOffset">7.69257573687440299181616865098476409912109375e-01</value>
13757 13757 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13758 13758 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13759 13759 
                <value type="int" key="drawSplit">0</value>
......
13816 13816 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13817 13817 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13818 13818 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">686ec05a-f9bc-11e2-a599-080027bcf912</link>
13819 
                <value type="real" key="middleSegmentOffset">5.23198513735400183577439747750759124755859375e+00</value>
13819 
                <value type="real" key="middleSegmentOffset">6.616848308009821266750805079936981201171875e+00</value>
13820 13820 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13821 13821 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13822 13822 
                <value type="int" key="drawSplit">0</value>
......
14273 14273 
                <value type="int" key="expanded">1</value>
14274 14274 
                <value type="real" key="height">1.46e+02</value>
14275 14275 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14276 
                <value type="real" key="left">2.97e+02</value>
14276 
                <value type="real" key="left">3.14e+02</value>
14277 14277 
                <value type="int" key="locked">0</value>
14278 14278 
                <value type="int" key="manualSizing">0</value>
14279 14279 
                <value type="real" key="top">2.61e+02</value>
14280 
                <value type="real" key="width">1.25e+02</value>
14280 
                <value type="real" key="width">1.02e+02</value>
14281 14281 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14282 14282 
                <value type="int" key="visible">1</value>
14283 14283 
                <value type="string" key="name">geoplace</value>
......
14313 14313 
                <value type="int" key="expanded">1</value>
14314 14314 
                <value type="real" key="height">1.92e+02</value>
14315 14315 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14316 
                <value type="real" key="left">4.97e+02</value>
14316 
                <value type="real" key="left">4.85e+02</value>
14317 14317 
                <value type="int" key="locked">0</value>
14318 14318 
                <value type="int" key="manualSizing">0</value>
14319 14319 
                <value type="real" key="top">3.3e+01</value>
......
14333 14333 
                <value type="int" key="expanded">1</value>
14334 14334 
                <value type="real" key="height">1.e+02</value>
14335 14335 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14336 
                <value type="real" key="left">5.61e+02</value>
14336 
                <value type="real" key="left">5.6e+02</value>
14337 14337 
                <value type="int" key="locked">0</value>
14338 14338 
                <value type="int" key="manualSizing">0</value>
14339 
                <value type="real" key="top">4.9e+02</value>
14339 
                <value type="real" key="top">4.91e+02</value>
14340 14340 
                <value type="real" key="width">9.e+01</value>
14341 14341 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14342 14342 
                <value type="int" key="visible">1</value>
......
14356 14356 
                <value type="real" key="left">4.46e+02</value>
14357 14357 
                <value type="int" key="locked">0</value>
14358 14358 
                <value type="int" key="manualSizing">0</value>
14359 
                <value type="real" key="top">2.6e+02</value>
14359 
                <value type="real" key="top">2.61e+02</value>
14360 14360 
                <value type="real" key="width">9.6e+01</value>
14361 14361 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14362 14362 
                <value type="int" key="visible">1</value>
......
15099 15099 
                <value type="int" key="expanded">1</value>
15100 15100 
                <value type="real" key="height">2.38e+02</value>
15101 15101 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15102 
                <value type="real" key="left">6.e+02</value>
15102 
                <value type="real" key="left">6.29e+02</value>
15103 15103 
                <value type="int" key="locked">0</value>
15104 15104 
                <value type="int" key="manualSizing">0</value>
15105 
                <value type="real" key="top">2.11e+02</value>
15106 
                <value type="real" key="width">1.25e+02</value>
15105 
                <value type="real" key="top">1.95e+02</value>
15106 
                <value type="real" key="width">9.9e+01</value>
15107 15107 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15108 15108 
                <value type="int" key="visible">1</value>
15109 15109 
                <value type="string" key="name">plot</value>
......
15509 15509 
                <value type="int" key="expanded">1</value>
15510 15510 
                <value type="real" key="height">2.5e+01</value>
15511 15511 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15512 
                <value type="real" key="left">4.25e+02</value>
15512 
                <value type="real" key="left">4.13e+02</value>
15513 15513 
                <value type="int" key="locked">0</value>
15514 15514 
                <value type="int" key="manualSizing">0</value>
15515 15515 
                <value type="real" key="top">8.6e+01</value>
......
15525 15525 
                <value type="int" key="expanded">1</value>
15526 15526 
                <value type="real" key="height">4.1e+01</value>
15527 15527 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15528 
                <value type="real" key="left">2.36e+02</value>
15528 
                <value type="real" key="left">2.43e+02</value>
15529 15529 
                <value type="int" key="locked">0</value>
15530 15530 
                <value type="int" key="manualSizing">0</value>
15531 
                <value type="real" key="top">2.15e+02</value>
15531 
                <value type="real" key="top">2.16e+02</value>
15532 15532 
                <value type="real" key="width">1.01e+02</value>
15533 15533 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15534 15534 
                <value type="int" key="visible">1</value>
......
15540 15540 
                <value type="int" key="expanded">1</value>
15541 15541 
                <value type="real" key="height">2.5e+01</value>
15542 15542 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15543 
                <value type="real" key="left">4.04e+02</value>
15543 
                <value type="real" key="left">3.92e+02</value>
15544 15544 
                <value type="int" key="locked">0</value>
15545 15545 
                <value type="int" key="manualSizing">0</value>
15546 15546 
                <value type="real" key="top">3.9e+01</value>
......
15570 15570 
                <value type="int" key="expanded">1</value>
15571 15571 
                <value type="real" key="height">2.5e+01</value>
15572 15572 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15573 
                <value type="real" key="left">4.01e+02</value>
15573 
                <value type="real" key="left">3.89e+02</value>
15574 15574 
                <value type="int" key="locked">0</value>
15575 15575 
                <value type="int" key="manualSizing">0</value>
15576 15576 
                <value type="real" key="top">2.17e+02</value>
......
15641 15641 
                <value type="real" key="left">6.74e+02</value>
15642 15642 
                <value type="int" key="locked">0</value>
15643 15643 
                <value type="int" key="manualSizing">0</value>
15644 
                <value type="real" key="top">4.86e+02</value>
15644 
                <value type="real" key="top">4.73e+02</value>
15645 15645 
                <value type="real" key="width">9.3e+01</value>
15646 15646 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15647 15647 
                <value type="int" key="visible">1</value>
......
15879 15879 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
15880 15880 
        <value _ptr_="0xb0ae9c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
15881 15881 
        <value _ptr_="0xa79b4b0" type="dict" key="syncProfiles">
15882 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="458985ec-0084-11e3-ac06-080027bcf912" struct-checksum="0xc64972c2" key="">
15883 
            <value _ptr_="0xc2da8e8" type="dict" key="lastKnownDBNames">
15882 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="16f876fc-0089-11e3-ac06-080027bcf912" struct-checksum="0xc64972c2" key="">
15883 
            <value _ptr_="0xc52fdc0" type="dict" key="lastKnownDBNames">
15884 15884 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
15885 15885 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
15886 15886 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
15891 15891 
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
15892 15892 
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
15893 15893 
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
15894 
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">footprint_geom_WKT</value>
15894 
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>
15895 15895 
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
15896 15896 
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
15897 15897 
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>
......
15960 15960 
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
15961 15961 
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
15962 15962 
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
15963 
              <value type="string" key="293dc5b4-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_taxon_presence1</value>
15963 15964 
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
15964 15965 
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
15965 15966 
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
......
15971 15972 
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
15972 15973 
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
15973 15974 
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
15974 
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
15975 15975 
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
15976 15976 
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
15977 15977 
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
......
16038 16038 
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
16039 16039 
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
16040 16040 
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
16041 
              <value type="string" key="565fd9e8-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1</value>
16042 
              <value type="string" key="565fe000-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1_idx</value>
16043 16041 
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
16044 16042 
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
16045 16043 
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
......
16089 16087 
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
16090 16088 
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
16091 16089 
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
16090 
              <value type="string" key="7627a20a-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_specimen1</value>
16091 
              <value type="string" key="7627b66e-0085-11e3-ac06-080027bcf912">fk_reobservable_presence_specimen1_idx</value>
16092 16092 
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
16093 16093 
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>
16094 16094 
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>
......
16096 16096 
              <value type="string" key="7afec6ec-0075-11e3-906b-080027bcf912">info</value>
16097 16097 
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
16098 16098 
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
16099 
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">footprint_geom_WKT</value>
16099 
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
16100 16100 
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
16101 16101 
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>
16102 16102 
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
......
16154 16154 
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
16155 16155 
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
16156 16156 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
16157 
              <value type="string" key="b3ac613c-0086-11e3-ac06-080027bcf912">fk_reobservable_presence_reobservable1</value>
16157 16158 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
16158 16159 
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
16159 16160 
              <value type="string" key="b922e5ba-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1</value>
......
16361 16362 
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
16362 16363 
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
16363 16364 
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
16365 
              <value type="string" key="f903388e-0084-11e3-ac06-080027bcf912">reobservable_presence</value>
16366 
              <value type="string" key="f9033c9e-0084-11e3-ac06-080027bcf912">id</value>
16367 
              <value type="string" key="f903400e-0084-11e3-ac06-080027bcf912">voucher</value>
16368 
              <value type="string" key="f903472a-0084-11e3-ac06-080027bcf912">PRIMARY</value>
16364 16369 
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">record_unique</value>
16365 16370 
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
16366 16371 
            </value>
......
16450 16455 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
16451 16456 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
16452 16457 
      <value type="string" key="caption">New Model</value>
16453 
      <value type="string" key="dateChanged">2013-08-08 17:03</value>
16458 
      <value type="string" key="dateChanged">2013-08-08 17:19</value>
16454 16459 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
16455 16460 
      <value type="string" key="description"></value>
16456 16461 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
220 220 
  `id` varbinary(767) NOT NULL,
221 221 
  `latitude_deg` varbinary(767) NOT NULL,
222 222 
  `longitude_deg` varbinary(767) NOT NULL,
223 
  `footprint_geom_WKT` varbinary(767) NOT NULL DEFAULT 'point',
223 
  `boundary_WKT` varbinary(767) NOT NULL DEFAULT 'point',
224 224 
  `official_name` varbinary(767) DEFAULT NULL,
225 225 
  PRIMARY KEY (`id`),
226 226 
  CONSTRAINT `fk_geoplace_place1` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
......
582 582 
  `length_m` varbinary(767) DEFAULT NULL,
583 583 
  `width_m` varbinary(767) DEFAULT NULL,
584 584 
  `azimuth_deg_N` varbinary(767) DEFAULT NULL,
585 
  `footprint_geom_WKT` varbinary(767) DEFAULT NULL,
585 
  `boundary_WKT` varbinary(767) DEFAULT NULL,
586 586 
  `dimensions` set('hstore') COLLATE utf8_bin DEFAULT NULL,
587 587 
  PRIMARY KEY (`id`),
588 588 
  CONSTRAINT `fk_subplot_place1` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

Also available in: Unified diff