Project

General

Profile

« Previous | Next » 

Revision 10553

schemas/VegCore/VegCore.ERD.mwb: geovalidation: inherit from georeferencing, since applying a corrected (or confirmed) lat/long is a form of georeferencing

View differences:

schemas/VegCore/VegCore.pg.sql
275 275
  PRIMARY KEY ("id"),
276 276
  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),
277 277
  /*KEY "fk_geovalidation_geoplace2_idx" ("corrected_geoplace")*/CHECK (true),
278
  /*CONSTRAINT "fk_geovalidation_georeferencing1" FOREIGN KEY ("id") REFERENCES "georeferencing" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
278 279
  /*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "scrubbed_geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
279
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("corrected_geoplace") REFERENCES "scrubbed_geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
280
  /*CONSTRAINT "fk_geovalidation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
280
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("corrected_geoplace") REFERENCES "scrubbed_geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
281 281
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/;
282 282
/*!40101 SET character_set_client = @saved_cs_client */;
283 283

  
schemas/VegCore/document.mwb.xml
9111 9111
                      <value type="string" key="name">fk_geovalidation_geoplace2</value>
9112 9112
                      <value type="string" key="oldName">fk_geovalidation_geoplace2</value>
9113 9113
                    </value>
9114
                    <value type="object" struct-name="db.mysql.ForeignKey" id="f6c9182a-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
9115
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
9116
                      <value _ptr_="0xbc2ba20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9114
                    <value type="object" struct-name="db.mysql.ForeignKey" id="21c8f928-fa8d-11e2-9ba8-080027bcf912" struct-checksum="0x70a8fc40">
9115
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">83dbd4da-f6e8-11e2-9cf1-080027bcf912</link>
9116
                      <value _ptr_="0xc51d128" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9117 9117
                        <link type="object">24508724-a763-11e2-aa10-080027bcf912</link>
9118 9118
                      </value>
9119 9119
                      <value type="int" key="deferability">0</value>
......
9122 9122
                      <value type="int" key="many">0</value>
9123 9123
                      <value type="int" key="modelOnly">0</value>
9124 9124
                      <link type="object" struct-name="db.Table" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9125
                      <value _ptr_="0xbc2bda8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9126
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
9125
                      <value _ptr_="0xc7a6168" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9126
                        <link type="object">83dbd8ae-f6e8-11e2-9cf1-080027bcf912</link>
9127 9127
                      </value>
9128 9128
                      <value type="int" key="referencedMandatory">1</value>
9129 9129
                      <value type="string" key="updateRule">CASCADE</value>
9130 9130
                      <value type="string" key="comment"></value>
9131
                      <value type="string" key="name">fk_geovalidation_record1</value>
9132
                      <value type="string" key="oldName">fk_geovalidation_record1</value>
9131
                      <value type="string" key="name">fk_geovalidation_georeferencing1</value>
9132
                      <value type="string" key="oldName">fk_geovalidation_georeferencing1</value>
9133 9133
                    </value>
9134 9134
                  </value>
9135 9135
                  <value _ptr_="0xbc29338" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
12778 12778
                <value type="int" key="visible">1</value>
12779 12779
                <value type="string" key="name"></value>
12780 12780
              </value>
12781
              <value type="object" struct-name="workbench.physical.Connection" id="f6c93b66-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12782
                <value type="string" key="caption">fk_geovalidation_record1</value>
12783
                <value type="real" key="captionXOffs">0.e+00</value>
12784
                <value type="real" key="captionYOffs">0.e+00</value>
12785
                <value type="string" key="comment"></value>
12786
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12787
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12788
                <value type="string" key="extraCaption"></value>
12789
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12790
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12791
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">f6c9182a-f6e0-11e2-b6d1-080027bcf912</link>
12792
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12793
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12794
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12795
                <value type="int" key="drawSplit">1</value>
12796
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
12797
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
12798
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12799
                <value type="int" key="visible">1</value>
12800
                <value type="string" key="name"></value>
12801
              </value>
12802 12781
              <value type="object" struct-name="workbench.physical.Connection" id="83de8090-f6e8-11e2-9cf1-080027bcf912" struct-checksum="0x9baebc92">
12803 12782
                <value type="string" key="caption">fk_geovalidation_record100</value>
12804 12783
                <value type="real" key="captionXOffs">0.e+00</value>
......
12999 12978
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13000 12979
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13001 12980
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">2213caf6-f971-11e2-9f36-080027bcf912</link>
13002
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12981
                <value type="real" key="middleSegmentOffset">-1.4538328080482614268476027064025402069091796875e+01</value>
13003 12982
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13004 12983
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13005 12984
                <value type="int" key="drawSplit">0</value>
......
13177 13156
                <value type="int" key="visible">1</value>
13178 13157
                <value type="string" key="name"></value>
13179 13158
              </value>
13159
              <value type="object" struct-name="workbench.physical.Connection" id="21c91340-fa8d-11e2-9ba8-080027bcf912" struct-checksum="0x9baebc92">
13160
                <value type="string" key="caption">fk_geovalidation_georeferencing1</value>
13161
                <value type="real" key="captionXOffs">0.e+00</value>
13162
                <value type="real" key="captionYOffs">0.e+00</value>
13163
                <value type="string" key="comment"></value>
13164
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13165
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13166
                <value type="string" key="extraCaption"></value>
13167
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13168
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13169
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">21c8f928-fa8d-11e2-9ba8-080027bcf912</link>
13170
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13171
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13172
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13173
                <value type="int" key="drawSplit">1</value>
13174
                <link type="object" struct-name="model.Figure" key="endFigure">83dc3f6a-f6e8-11e2-9cf1-080027bcf912</link>
13175
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
13176
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13177
                <value type="int" key="visible">1</value>
13178
                <value type="string" key="name"></value>
13179
              </value>
13180 13180
            </value>
13181 13181
            <value type="string" key="description"></value>
13182 13182
            <value _ptr_="0xbc47df8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
14132 14132
                <value type="int" key="expanded">1</value>
14133 14133
                <value type="real" key="height">1.69e+02</value>
14134 14134
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14135
                <value type="real" key="left">3.51e+02</value>
14135
                <value type="real" key="left">3.47e+02</value>
14136 14136
                <value type="int" key="locked">0</value>
14137 14137
                <value type="int" key="manualSizing">0</value>
14138
                <value type="real" key="top">6.19e+02</value>
14138
                <value type="real" key="top">6.18e+02</value>
14139 14139
                <value type="real" key="width">1.4e+02</value>
14140 14140
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14141 14141
                <value type="int" key="visible">1</value>
......
14771 14771
              <value type="string" key="name"></value>
14772 14772
            </value>
14773 14773
            <value _ptr_="0xbc47ed0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14774
              <link type="object">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
14774
              <link type="object">2450a09c-a763-11e2-aa10-080027bcf912</link>
14775 14775
            </value>
14776 14776
            <value type="int" key="updateBlocked">0</value>
14777 14777
            <value type="real" key="width">1.6215e+03</value>
......
14785 14785
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14786 14786
        <value _ptr_="0xbbb5e58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14787 14787
        <value _ptr_="0xb354b48" type="dict" key="syncProfiles">
14788
          <value type="object" struct-name="db.mgmt.SyncProfile" id="41447e86-fa8c-11e2-9ba8-080027bcf912" struct-checksum="0xc64972c2" key="">
14789
            <value _ptr_="0xc6684a8" type="dict" key="lastKnownDBNames">
14788
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9d49c556-fa8c-11e2-9ba8-080027bcf912" struct-checksum="0xc64972c2" key="">
14789
            <value _ptr_="0xc61a590" type="dict" key="lastKnownDBNames">
14790 14790
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14791 14791
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14792 14792
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
15326 15326
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
15327 15327
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
15328 15328
      <value type="string" key="caption">New Model</value>
15329
      <value type="string" key="dateChanged">2013-08-01 02:25</value>
15329
      <value type="string" key="dateChanged">2013-08-01 02:32</value>
15330 15330
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
15331 15331
      <value type="string" key="description"></value>
15332 15332
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
273 273
  PRIMARY KEY (`id`),
274 274
  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),
275 275
  KEY `fk_geovalidation_geoplace2_idx` (`corrected_geoplace`),
276
  CONSTRAINT `fk_geovalidation_georeferencing1` FOREIGN KEY (`id`) REFERENCES `georeferencing` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
276 277
  CONSTRAINT `fk_geovalidation_geoplace1` FOREIGN KEY (`input_geoplace`) REFERENCES `scrubbed_geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
277
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`corrected_geoplace`) REFERENCES `scrubbed_geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
278
  CONSTRAINT `fk_geovalidation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
278
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`corrected_geoplace`) REFERENCES `scrubbed_geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
279 279
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]';
280 280
/*!40101 SET character_set_client = @saved_cs_client */;
281 281

  

Also available in: Unified diff