Project

General

Profile

« Previous | Next » 

Revision 10953

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual_count: inherit from taxon_presence because this is also a type of taxon_observation (and specifically, a taxon_presence), in addition to the general taxon_presence it's associated with. it is possible e.g. for different diameter classes to be counted by different collectors, and thus to need separate taxon_observations to store the different collectors.

View differences:

schemas/VegCore/VegCore.pg.sql
365 365 
  PRIMARY KEY ("id"),
366 366 
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),
367 367 
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),
368 
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
368 
  /*CONSTRAINT "fk_individual_count_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
369 369 
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
370 370 
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
371 371 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org'*/;
schemas/VegCore/document.mwb.xml
2522 2522 
                      <value type="string" key="name">fk_aggregate_observation_taxon_presence1</value>
2523 2523 
                      <value type="string" key="oldName">fk_aggregate_observation_taxon_presence1</value>
2524 2524 
                    </value>
2525 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="18c810aa-0084-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">
2526 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
2527 
                      <value _ptr_="0xa647078" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2525 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="426f5d76-1dcd-11e3-b98c-080027bcf912" struct-checksum="0x70a8fc40">
2526 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2527 
                      <value _ptr_="0xb593a30" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2528 2528 
                        <link type="object">be8e9bba-a6e0-11e2-95e9-080027bcf912</link>
2529 2529 
                      </value>
2530 2530 
                      <value type="int" key="deferability">0</value>
......
2533 2533 
                      <value type="int" key="many">0</value>
2534 2534 
                      <value type="int" key="modelOnly">0</value>
2535 2535 
                      <link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2536 
                      <value _ptr_="0xa647400" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2537 
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
2536 
                      <value _ptr_="0xbc66f28" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2537 
                        <link type="object">be8eaa06-a6e0-11e2-95e9-080027bcf912</link>
2538 2538 
                      </value>
2539 2539 
                      <value type="int" key="referencedMandatory">1</value>
2540 2540 
                      <value type="string" key="updateRule">CASCADE</value>
2541 2541 
                      <value type="string" key="comment"></value>
2542 
                      <value type="string" key="name">fk_aggregate_observation_record1</value>
2543 
                      <value type="string" key="oldName">fk_aggregate_observation_record1</value>
2542 
                      <value type="string" key="name">fk_individual_count_taxon_presence1</value>
2543 
                      <value type="string" key="oldName">fk_individual_count_taxon_presence1</value>
2544 2544 
                    </value>
2545 2545 
                  </value>
2546 2546 
                  <value _ptr_="0xa644e60" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
14828 14828 
                <value type="int" key="visible">1</value>
14829 14829 
                <value type="string" key="name"></value>
14830 14830 
              </value>
14831 
              <value type="object" struct-name="workbench.physical.Connection" id="18c831ca-0084-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">
14832 
                <value type="string" key="caption">fk_aggregate_observation_record1</value>
14833 
                <value type="real" key="captionXOffs">0.e+00</value>
14834 
                <value type="real" key="captionYOffs">0.e+00</value>
14835 
                <value type="string" key="comment"></value>
14836 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
14837 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
14838 
                <value type="string" key="extraCaption"></value>
14839 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14840 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14841 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">18c810aa-0084-11e3-ac06-080027bcf912</link>
14842 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
14843 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14844 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14845 
                <value type="int" key="drawSplit">1</value>
14846 
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
14847 
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
14848 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14849 
                <value type="int" key="visible">1</value>
14850 
                <value type="string" key="name"></value>
14851 
              </value>
14852 14831 
              <value type="object" struct-name="workbench.physical.Connection" id="293ddb6c-0085-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">
14853 14832 
                <value type="string" key="caption">fk_reobservable_presence_taxon_presence1</value>
14854 14833 
                <value type="real" key="captionXOffs">0.e+00</value>
......
15175 15154 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15176 15155 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15177 15156 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1427502e-1bf0-11e3-849d-080027bcf912</link>
15178 
                <value type="real" key="middleSegmentOffset">2.6792558607415747928826021961867809295654296875e+02</value>
15157 
                <value type="real" key="middleSegmentOffset">2.6407976917413139972268254496157169342041015625e+02</value>
15179 15158 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15180 15159 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15181 15160 
                <value type="int" key="drawSplit">0</value>
......
15290 15269 
                <value type="int" key="visible">1</value>
15291 15270 
                <value type="string" key="name"></value>
15292 15271 
              </value>
15272 
              <value type="object" struct-name="workbench.physical.Connection" id="426f74f0-1dcd-11e3-b98c-080027bcf912" struct-checksum="0x9baebc92">
15273 
                <value type="string" key="caption">fk_individual_count_taxon_presence1</value>
15274 
                <value type="real" key="captionXOffs">0.e+00</value>
15275 
                <value type="real" key="captionYOffs">0.e+00</value>
15276 
                <value type="string" key="comment"></value>
15277 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15278 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15279 
                <value type="string" key="extraCaption"></value>
15280 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15281 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15282 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">426f5d76-1dcd-11e3-b98c-080027bcf912</link>
15283 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15284 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15285 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15286 
                <value type="int" key="drawSplit">0</value>
15287 
                <link type="object" struct-name="model.Figure" key="endFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
15288 
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
15289 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15290 
                <value type="int" key="visible">1</value>
15291 
                <value type="string" key="name"></value>
15292 
              </value>
15293 15293 
            </value>
15294 15294 
            <value type="string" key="description"></value>
15295 15295 
            <value _ptr_="0xa6dbf30" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15679 15679 
                <value type="int" key="expanded">1</value>
15680 15680 
                <value type="real" key="height">1.e+02</value>
15681 15681 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15682 
                <value type="real" key="left">1.256e+03</value>
15682 
                <value type="real" key="left">1.244e+03</value>
15683 15683 
                <value type="int" key="locked">0</value>
15684 15684 
                <value type="int" key="manualSizing">0</value>
15685 15685 
                <value type="real" key="top">6.64e+02</value>
......
17638 17638 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17639 17639 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17640 17640 
      <value type="string" key="caption">New Model</value>
17641 
      <value type="string" key="dateChanged">2013-09-14 23:03</value>
17641 
      <value type="string" key="dateChanged">2013-09-14 23:09</value>
17642 17642 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17643 17643 
      <value type="string" key="description"></value>
17644 17644 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
363 363 
  PRIMARY KEY (`id`),
364 364 
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`taxon`),
365 365 
  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),
366 
  CONSTRAINT `fk_aggregate_observation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
366 
  CONSTRAINT `fk_individual_count_taxon_presence1` FOREIGN KEY (`id`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
367 367 
  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
368 368 
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
369 369 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= stemCount.VegBank.vegpath.org';

Also available in: Unified diff