Project

General

Profile

« Previous | Next » 

Revision 10471

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: place: added coords hstore extender, for verbatim coordinates, etc.

View differences:

schemas/VegCore/document.mwb.xml
2967 2967 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
2968 2968 
                  <value type="string" key="temp_sql"></value>
2969 2969 
                  <value type="string" key="comment">A numerically-defined point</value>
2970 
                  <value type="string" key="oldName">geocoordinates</value>
2970 
                  <value type="string" key="oldName">geocoords</value>
2971 2971 
                </value>
2972 2972 
                <value type="object" struct-name="db.mysql.Table" id="16537a20-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x1a403946">
2973 2973 
                  <value type="string" key="avgRowLength"></value>
......
5285 5285 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5286 5286 
                      <value type="string" key="comment"></value>
5287 5287 
                      <value type="string" key="name">geocoords</value>
5288 
                      <value type="string" key="oldName">geocoordinates</value>
5288 
                      <value type="string" key="oldName">geocoords</value>
5289 5289 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5290 5290 
                    </value>
5291 5291 
                    <value type="object" struct-name="db.mysql.Column" id="c67244c4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
......
5326 5326 
                      <value type="string" key="oldName">locality</value>
5327 5327 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5328 5328 
                    </value>
5329 
                    <value type="object" struct-name="db.mysql.Column" id="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
5330 
                      <value type="int" key="autoIncrement">0</value>
5331 
                      <value type="string" key="characterSetName"></value>
5332 
                      <value _ptr_="0xc11e2b8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5333 
                      <value type="string" key="collationName"></value>
5334 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
5335 
                      <value type="string" key="defaultValue"></value>
5336 
                      <value type="int" key="defaultValueIsNull">0</value>
5337 
                      <value _ptr_="0xbf666b8" type="list" content-type="string" key="flags"/>
5338 
                      <value type="int" key="isNotNull">0</value>
5339 
                      <value type="int" key="length">-1</value>
5340 
                      <value type="int" key="precision">-1</value>
5341 
                      <value type="int" key="scale">-1</value>
5342 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
5343 
                      <value type="string" key="comment">for verbatim coordinates, etc.</value>
5344 
                      <value type="string" key="name">coords</value>
5345 
                      <value type="string" key="oldName">coords</value>
5346 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
5347 
                    </value>
5329 5348 
                  </value>
5330 5349 
                  <value type="string" key="connectionString"></value>
5331 5350 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
5541 5560 
                  <value type="int" key="commentedOut">0</value>
5542 5561 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
5543 5562 
                  <value _ptr_="0xb277478" type="dict" key="customData"/>
5544 
                  <value type="string" key="lastChangeDate">2013-07-27 09:05</value>
5563 
                  <value type="string" key="lastChangeDate">2013-07-27 09:27</value>
5545 5564 
                  <value type="int" key="modelOnly">0</value>
5546 5565 
                  <value type="string" key="name">place</value>
5547 5566 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
5626 5645 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
5627 5646 
                      <value type="string" key="comment"></value>
5628 5647 
                      <value type="string" key="name">coords</value>
5629 
                      <value type="string" key="oldName">coordinates</value>
5648 
                      <value type="string" key="oldName">coords</value>
5630 5649 
                      <link type="object" struct-name="GrtObject" key="owner">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
5631 5650 
                    </value>
5632 5651 
                  </value>
......
5758 5777 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5759 5778 
                      <value type="string" key="comment"></value>
5760 5779 
                      <value type="string" key="name">geocoords</value>
5761 
                      <value type="string" key="oldName">geocoordinates</value>
5780 
                      <value type="string" key="oldName">geocoords</value>
5762 5781 
                      <link type="object" struct-name="GrtObject" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link>
5763 5782 
                    </value>
5764 5783 
                    <value type="object" struct-name="db.mysql.Column" id="2ba6fbb8-a761-11e2-aa10-080027bcf912" struct-checksum="0x783b5183">
......
12426 12445 
                <value type="real" key="left">5.6e+02</value>
12427 12446 
                <value type="int" key="locked">0</value>
12428 12447 
                <value type="int" key="manualSizing">0</value>
12429 
                <value type="real" key="top">3.69e+02</value>
12448 
                <value type="real" key="top">3.77e+02</value>
12430 12449 
                <value type="real" key="width">8.1e+01</value>
12431 12450 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12432 12451 
                <value type="int" key="visible">1</value>
......
12441 12460 
                <value type="int" key="triggersExpanded">0</value>
12442 12461 
                <value type="string" key="color">#ffcc33</value>
12443 12462 
                <value type="int" key="expanded">1</value>
12444 
                <value type="real" key="height">1.46e+02</value>
12463 
                <value type="real" key="height">1.69e+02</value>
12445 12464 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12446 12465 
                <value type="real" key="left">4.34e+02</value>
12447 12466 
                <value type="int" key="locked">0</value>
12448 12467 
                <value type="int" key="manualSizing">0</value>
12449 
                <value type="real" key="top">2.95e+02</value>
12468 
                <value type="real" key="top">2.84e+02</value>
12450 12469 
                <value type="real" key="width">8.e+01</value>
12451 12470 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12452 12471 
                <value type="int" key="visible">1</value>
......
12466 12485 
                <value type="real" key="left">6.78e+02</value>
12467 12486 
                <value type="int" key="locked">0</value>
12468 12487 
                <value type="int" key="manualSizing">0</value>
12469 
                <value type="real" key="top">4.46e+02</value>
12488 
                <value type="real" key="top">4.54e+02</value>
12470 12489 
                <value type="real" key="width">9.e+01</value>
12471 12490 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12472 12491 
                <value type="int" key="visible">1</value>
......
12546 12565 
                <value type="real" key="left">4.97e+02</value>
12547 12566 
                <value type="int" key="locked">0</value>
12548 12567 
                <value type="int" key="manualSizing">0</value>
12549 
                <value type="real" key="top">8.19e+02</value>
12568 
                <value type="real" key="top">8.28e+02</value>
12550 12569 
                <value type="real" key="width">1.55e+02</value>
12551 12570 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12552 12571 
                <value type="int" key="visible">1</value>
......
12566 12585 
                <value type="real" key="left">3.46e+02</value>
12567 12586 
                <value type="int" key="locked">0</value>
12568 12587 
                <value type="int" key="manualSizing">0</value>
12569 
                <value type="real" key="top">6.82e+02</value>
12588 
                <value type="real" key="top">6.89e+02</value>
12570 12589 
                <value type="real" key="width">9.3e+01</value>
12571 12590 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12572 12591 
                <value type="int" key="visible">1</value>
......
12586 12605 
                <value type="real" key="left">5.02e+02</value>
12587 12606 
                <value type="int" key="locked">0</value>
12588 12607 
                <value type="int" key="manualSizing">0</value>
12589 
                <value type="real" key="top">1.072e+03</value>
12608 
                <value type="real" key="top">1.081e+03</value>
12590 12609 
                <value type="real" key="width">1.45e+02</value>
12591 12610 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12592 12611 
                <value type="int" key="visible">1</value>
......
12606 12625 
                <value type="real" key="left">3.06e+02</value>
12607 12626 
                <value type="int" key="locked">0</value>
12608 12627 
                <value type="int" key="manualSizing">0</value>
12609 
                <value type="real" key="top">8.41e+02</value>
12628 
                <value type="real" key="top">8.5e+02</value>
12610 12629 
                <value type="real" key="width">1.58e+02</value>
12611 12630 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12612 12631 
                <value type="int" key="visible">1</value>
......
12626 12645 
                <value type="real" key="left">3.32e+02</value>
12627 12646 
                <value type="int" key="locked">0</value>
12628 12647 
                <value type="int" key="manualSizing">0</value>
12629 
                <value type="real" key="top">9.71e+02</value>
12648 
                <value type="real" key="top">9.8e+02</value>
12630 12649 
                <value type="real" key="width">1.14e+02</value>
12631 12650 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12632 12651 
                <value type="int" key="visible">1</value>
......
13232 13251 
                <value type="real" key="left">3.3e+02</value>
13233 13252 
                <value type="int" key="locked">0</value>
13234 13253 
                <value type="int" key="manualSizing">0</value>
13235 
                <value type="real" key="top">4.57e+02</value>
13254 
                <value type="real" key="top">4.64e+02</value>
13236 13255 
                <value type="real" key="width">1.25e+02</value>
13237 13256 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13238 13257 
                <value type="int" key="visible">1</value>
......
13292 13311 
                <value type="real" key="left">4.12e+02</value>
13293 13312 
                <value type="int" key="locked">0</value>
13294 13313 
                <value type="int" key="manualSizing">0</value>
13295 
                <value type="real" key="top">1.47e+02</value>
13314 
                <value type="real" key="top">1.43e+02</value>
13296 13315 
                <value type="real" key="width">1.4e+02</value>
13297 13316 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13298 13317 
                <value type="int" key="visible">1</value>
......
13722 13741 
              <value type="int" key="visible">1</value>
13723 13742 
              <value type="string" key="name"></value>
13724 13743 
            </value>
13725 
            <value _ptr_="0xb2c2eb0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
13744 
            <value _ptr_="0xb2c2eb0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
13745 
              <link type="object">286AE59E-913E-4F00-A662-693F828EFB6F</link>
13746 
            </value>
13726 13747 
            <value type="int" key="updateBlocked">0</value>
13727 13748 
            <value type="real" key="width">1.6215e+03</value>
13728 13749 
            <value type="real" key="x">0.e+00</value>
......
13735 13756 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
13736 13757 
        <value _ptr_="0xb2394c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
13737 13758 
        <value _ptr_="0xaa26720" type="dict" key="syncProfiles">
13738 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="0a610a66-f6d5-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13739 
            <value _ptr_="0xbdc7870" type="dict" key="lastKnownDBNames">
13759 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="c7a2393a-f6d8-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13760 
            <value _ptr_="0xc8ae978" type="dict" key="lastKnownDBNames">
13740 13761 
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
13741 13762 
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
13742 13763 
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
......
13799 13820 
              <value type="string" key="2ba6fbb8-a761-11e2-aa10-080027bcf912">geopath</value>
13800 13821 
              <value type="string" key="2ba715bc-a761-11e2-aa10-080027bcf912">fk_geovalidation_place_path1_idx</value>
13801 13822 
              <value type="string" key="2e2885fa-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1</value>
13802 
              <value type="string" key="2e2887c6-a761-11e2-aa10-080027bcf912">geocoordinates</value>
13823 
              <value type="string" key="2e2887c6-a761-11e2-aa10-080027bcf912">geocoords</value>
13803 13824 
              <value type="string" key="2e28a288-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1_idx</value>
13804 13825 
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
13805 13826 
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
13806 13827 
              <value type="string" key="2eedb6e2-a764-11e2-b6a9-080027bcf912">validatable_place_unique</value>
13807 13828 
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
13808 13829 
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
13830 
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">coords</value>
13809 13831 
              <value type="string" key="3c2be5be-a763-11e2-aa10-080027bcf912">fk_geovalidation_validatable_place1</value>
13810 13832 
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
13811 13833 
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
......
13985 14007 
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
13986 14008 
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
13987 14009 
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
13988 
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geocoordinates</value>
14010 
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geocoords</value>
13989 14011 
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
13990 14012 
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
13991 14013 
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
......
14081 14103 
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
14082 14104 
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
14083 14105 
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
14084 
              <value type="string" key="c6724334-a7a0-11e2-b667-080027bcf912">geocoordinates</value>
14106 
              <value type="string" key="c6724334-a7a0-11e2-b667-080027bcf912">geocoords</value>
14085 14107 
              <value type="string" key="c67244c4-a7a0-11e2-b667-080027bcf912">geopath</value>
14086 14108 
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
14087 14109 
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
......
14134 14156 
              <value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value>
14135 14157 
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
14136 14158 
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
14137 
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coordinates</value>
14159 
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
14138 14160 
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
14139 14161 
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
14140 14162 
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>
......
14245 14267 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14246 14268 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14247 14269 
      <value type="string" key="caption">New Model</value>
14248 
      <value type="string" key="dateChanged">2013-07-27 09:05</value>
14270 
      <value type="string" key="dateChanged">2013-07-27 09:27</value>
14249 14271 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14250 14272 
      <value type="string" key="description"></value>
14251 14273 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
448 448 
  `geocoords` varbinary(767) DEFAULT NULL,
449 449 
  `geopath` varbinary(767) DEFAULT NULL,
450 450 
  `locality` varbinary(767) DEFAULT NULL,
451 
  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL COMMENT 'for verbatim coordinates, etc.',
451 452 
  PRIMARY KEY (`id`),
452 453 
  KEY `fk_place_coordinates1_idx` (`geocoords`),
453 454 
  KEY `fk_place1_idx` (`parent`),
schemas/VegCore/VegCore.pg.sql
450 450 
  "geocoords" text DEFAULT NULL,
451 451 
  "geopath" text DEFAULT NULL,
452 452 
  "locality" text DEFAULT NULL,
453 
  "coords" hstore DEFAULT NULL /*COMMENT 'for verbatim coordinates, etc.'*/,
453 454 
  PRIMARY KEY ("id"),
454 455 
  /*KEY "fk_place_coordinates1_idx" ("geocoords")*/CHECK (true),
455 456 
  /*KEY "fk_place1_idx" ("parent")*/CHECK (true),

Also available in: Unified diff