Project

General

Profile

« Previous | Next » 

Revision 10475

bugfix: schemas/VegCore/VegCore.ERD.mwb: geovalidation: need to inherit from record now that this is source-specific

View differences:

schemas/VegCore/document.mwb.xml
9125 9125
                      <value type="string" key="name">fk_geovalidation_geoplace2</value>
9126 9126
                      <value type="string" key="oldName">fk_geovalidation_geoplace2</value>
9127 9127
                    </value>
9128
                    <value type="object" struct-name="db.mysql.ForeignKey" id="f6c9182a-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
9129
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
9130
                      <value _ptr_="0xc968f80" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9131
                        <link type="object">24508724-a763-11e2-aa10-080027bcf912</link>
9132
                      </value>
9133
                      <value type="int" key="deferability">0</value>
9134
                      <value type="string" key="deleteRule">CASCADE</value>
9135
                      <value type="int" key="mandatory">0</value>
9136
                      <value type="int" key="many">0</value>
9137
                      <value type="int" key="modelOnly">0</value>
9138
                      <link type="object" struct-name="db.Table" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9139
                      <value _ptr_="0xc4b3508" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9140
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
9141
                      </value>
9142
                      <value type="int" key="referencedMandatory">1</value>
9143
                      <value type="string" key="updateRule">CASCADE</value>
9144
                      <value type="string" key="comment"></value>
9145
                      <value type="string" key="name">fk_geovalidation_record1</value>
9146
                      <value type="string" key="oldName">fk_geovalidation_record1</value>
9147
                    </value>
9128 9148
                  </value>
9129 9149
                  <value _ptr_="0xb2acac8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
9130 9150
                    <value type="object" struct-name="db.mysql.Index" id="2450919c-a763-11e2-aa10-080027bcf912" struct-checksum="0x309b847a">
......
9193 9213
                      <value type="int" key="isPrimary">0</value>
9194 9214
                      <value type="string" key="name">fk_geovalidation_geoplace2_idx</value>
9195 9215
                      <value type="int" key="unique">0</value>
9196
                      <value type="string" key="oldName">fk_geovalidation_geoplace2</value>
9216
                      <value type="string" key="oldName">fk_geovalidation_geoplace2_idx</value>
9197 9217
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9198 9218
                    </value>
9199 9219
                  </value>
......
12594 12614
                <value type="int" key="visible">1</value>
12595 12615
                <value type="string" key="name"></value>
12596 12616
              </value>
12617
              <value type="object" struct-name="workbench.physical.Connection" id="f6c93b66-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12618
                <value type="string" key="caption">fk_geovalidation_record1</value>
12619
                <value type="real" key="captionXOffs">0.e+00</value>
12620
                <value type="real" key="captionYOffs">0.e+00</value>
12621
                <value type="string" key="comment"></value>
12622
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12623
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12624
                <value type="string" key="extraCaption"></value>
12625
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12626
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12627
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">f6c9182a-f6e0-11e2-b6d1-080027bcf912</link>
12628
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12629
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12630
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12631
                <value type="int" key="drawSplit">1</value>
12632
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
12633
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
12634
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12635
                <value type="int" key="visible">1</value>
12636
                <value type="string" key="name"></value>
12637
              </value>
12597 12638
            </value>
12598 12639
            <value type="string" key="description"></value>
12599 12640
            <value _ptr_="0xb2c2dd8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13549 13590
                <value type="int" key="expanded">1</value>
13550 13591
                <value type="real" key="height">1.69e+02</value>
13551 13592
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13552
                <value type="real" key="left">5.89e+02</value>
13593
                <value type="real" key="left">5.88e+02</value>
13553 13594
                <value type="int" key="locked">0</value>
13554 13595
                <value type="int" key="manualSizing">0</value>
13555
                <value type="real" key="top">2.e+01</value>
13596
                <value type="real" key="top">1.4e+01</value>
13556 13597
                <value type="real" key="width">1.4e+02</value>
13557 13598
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13558 13599
                <value type="int" key="visible">1</value>
......
13995 14036
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
13996 14037
        <value _ptr_="0xb2394c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
13997 14038
        <value _ptr_="0xaa26720" type="dict" key="syncProfiles">
13998
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ef417d32-f6df-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13999
            <value _ptr_="0xc16f6f8" type="dict" key="lastKnownDBNames">
14039
          <value type="object" struct-name="db.mgmt.SyncProfile" id="158d5114-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
14040
            <value _ptr_="0xce19288" type="dict" key="lastKnownDBNames">
14000 14041
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
14001 14042
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
14002 14043
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
14003 14044
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
14004 14045
              <value type="string" key="0621717a-a90f-11e2-8576-080027bcf912">fk_taxon_presence_taxon_name1</value>
14005 14046
              <value type="string" key="06217332-a90f-11e2-8576-080027bcf912">taxon_concept</value>
14047
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14048
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
14006 14049
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">footprint_geom_WKT</value>
14007 14050
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
14008 14051
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
......
14069 14112
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
14070 14113
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
14071 14114
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
14072
              <value type="string" key="35cce59e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14073 14115
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">scrubbed_geoplace</value>
14074
              <value type="string" key="35ccfbf6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
14075 14116
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
14076 14117
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">coords</value>
14077 14118
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
......
14515 14556
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14516 14557
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14517 14558
      <value type="string" key="caption">New Model</value>
14518
      <value type="string" key="dateChanged">2013-07-27 10:14</value>
14559
      <value type="string" key="dateChanged">2013-07-27 10:21</value>
14519 14560
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14520 14561
      <value type="string" key="description"></value>
14521 14562
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
268 268
  PRIMARY KEY (`id`),
269 269
  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),
270 270
  KEY `fk_geovalidation_geoplace2_idx` (`scrubbed_geoplace`),
271
  CONSTRAINT `fk_geovalidation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
271 272
  CONSTRAINT `fk_geovalidation_geoplace1` FOREIGN KEY (`input_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
272 273
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`scrubbed_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
273 274
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]';
schemas/VegCore/VegCore.pg.sql
270 270
  PRIMARY KEY ("id"),
271 271
  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),
272 272
  /*KEY "fk_geovalidation_geoplace2_idx" ("scrubbed_geoplace")*/CHECK (true),
273
  /*CONSTRAINT "fk_geovalidation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
273 274
  /*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
274 275
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
275 276
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/;

Also available in: Unified diff