Project

General

Profile

« Previous | Next » 

Revision 11121

schemas/VegCore/ERD/VegCore.ERD.mwb: individual_observation.place_observed_at: merged with inherited place field, documenting that for this table, this contains the place the individual was observed at

View differences:

schemas/VegCore/ERD/document.mwb.xml
7086 7086
                      <value type="string" key="oldName">id</value>
7087 7087
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7088 7088
                    </value>
7089
                    <value type="object" struct-name="db.mysql.Column" id="323a39a4-011b-11e3-b872-080027bcf912" struct-checksum="0x783b5183">
7090
                      <value type="int" key="autoIncrement">0</value>
7091
                      <value type="string" key="characterSetName"></value>
7092
                      <value _ptr_="0xbb35128" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
7093
                      <value type="string" key="collationName"></value>
7094
                      <value type="string" key="datatypeExplicitParams"></value>
7095
                      <value type="string" key="defaultValue"></value>
7096
                      <value type="int" key="defaultValueIsNull">1</value>
7097
                      <value _ptr_="0xbb35488" type="list" content-type="string" key="flags"/>
7098
                      <value type="int" key="isNotNull">0</value>
7099
                      <value type="int" key="length">767</value>
7100
                      <value type="int" key="precision">-1</value>
7101
                      <value type="int" key="scale">-1</value>
7102
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
7103
                      <value type="string" key="comment"></value>
7104
                      <value type="string" key="name">place_observed_at</value>
7105
                      <value type="string" key="oldName">place_observed_at</value>
7106
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7107
                    </value>
7108 7089
                    <value type="object" struct-name="db.mysql.Column" id="0ab98c50-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
7109 7090
                      <value type="int" key="autoIncrement">0</value>
7110 7091
                      <value type="string" key="characterSetName"></value>
......
7191 7172
                      <value type="string" key="name">fk_individual_observation_individual1</value>
7192 7173
                      <value type="string" key="oldName">fk_individual_observation_individual1</value>
7193 7174
                    </value>
7194
                    <value type="object" struct-name="db.mysql.ForeignKey" id="323a36d4-011b-11e3-b872-080027bcf912" struct-checksum="0x70a8fc40">
7195
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
7196
                      <value _ptr_="0xbb36378" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7197
                        <link type="object">323a39a4-011b-11e3-b872-080027bcf912</link>
7198
                      </value>
7199
                      <value type="int" key="deferability">0</value>
7200
                      <value type="string" key="deleteRule">CASCADE</value>
7201
                      <link type="object" struct-name="db.Index" key="index">323a5f56-011b-11e3-b872-080027bcf912</link>
7202
                      <value type="int" key="mandatory">1</value>
7203
                      <value type="int" key="many">1</value>
7204
                      <value type="int" key="modelOnly">0</value>
7205
                      <link type="object" struct-name="db.Table" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7206
                      <value _ptr_="0xbb36700" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7207
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
7208
                      </value>
7209
                      <value type="int" key="referencedMandatory">0</value>
7210
                      <value type="string" key="updateRule">CASCADE</value>
7211
                      <value type="string" key="comment"></value>
7212
                      <value type="string" key="name">fk_individual_observation_place1</value>
7213
                      <value type="string" key="oldName">fk_individual_observation_place1</value>
7214
                    </value>
7215 7175
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0ab99696-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
7216 7176
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
7217 7177
                      <value _ptr_="0xbb36770" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
7281 7241
                      <value type="string" key="oldName">fk_individual_observation_individual1_idx</value>
7282 7242
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7283 7243
                    </value>
7284
                    <value type="object" struct-name="db.mysql.Index" id="323a5f56-011b-11e3-b872-080027bcf912" struct-checksum="0x309b847a">
7285
                      <value _ptr_="0xbb37648" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
7286
                        <value type="object" struct-name="db.mysql.IndexColumn" id="323a6168-011b-11e3-b872-080027bcf912" struct-checksum="0x62630b3c">
7287
                          <value type="int" key="columnLength">0</value>
7288
                          <value type="string" key="comment"></value>
7289
                          <value type="int" key="descend">0</value>
7290
                          <link type="object" struct-name="db.Column" key="referencedColumn">323a39a4-011b-11e3-b872-080027bcf912</link>
7291
                          <value type="string" key="name"></value>
7292
                          <link type="object" struct-name="GrtObject" key="owner">323a5f56-011b-11e3-b872-080027bcf912</link>
7293
                        </value>
7294
                      </value>
7295
                      <value type="string" key="indexKind"></value>
7296
                      <value type="int" key="keyBlockSize">0</value>
7297
                      <value type="string" key="withParser"></value>
7298
                      <value type="string" key="comment"></value>
7299
                      <value type="int" key="deferability">0</value>
7300
                      <value type="string" key="indexType">INDEX</value>
7301
                      <value type="int" key="isPrimary">0</value>
7302
                      <value type="string" key="name">fk_individual_observation_place1_idx</value>
7303
                      <value type="int" key="unique">0</value>
7304
                      <value type="string" key="oldName">fk_individual_observation_place1_idx</value>
7305
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7306
                    </value>
7307 7244
                    <value type="object" struct-name="db.mysql.Index" id="bb865680-2992-11e3-a80d-080027bcf912" struct-checksum="0x309b847a">
7308 7245
                      <value _ptr_="0xd0848b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
7309 7246
                        <value type="object" struct-name="db.mysql.IndexColumn" id="bb86582e-2992-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
......
7358 7295
                  <value type="int" key="commentedOut">0</value>
7359 7296
                  <value type="string" key="createDate">2013-04-17 13:54</value>
7360 7297
                  <value _ptr_="0xbb347b0" type="dict" key="customData"/>
7361
                  <value type="string" key="lastChangeDate">2013-09-29 22:43</value>
7298
                  <value type="string" key="lastChangeDate">2013-09-30 01:20</value>
7362 7299
                  <value type="int" key="modelOnly">0</value>
7363 7300
                  <value type="string" key="name">individual_observation</value>
7364 7301
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
7365 7302
                  <value type="string" key="temp_sql"></value>
7366
                  <value type="string" key="comment">An observation of an [[VegCore#Individual|Individual]]</value>
7303
                  <value type="string" key="comment">An observation of an [[VegCore#Individual|Individual]]; inherited fields: place: contains the place the individual was observed at</value>
7367 7304
                  <value type="string" key="oldName">individual_observation</value>
7368 7305
                </value>
7369 7306
                <value type="object" struct-name="db.mysql.Table" id="be8e6514-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946">
......
13954 13891
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13955 13892
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13956 13893
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e8fe4-a6e0-11e2-95e9-080027bcf912</link>
13957
                <value type="real" key="middleSegmentOffset">4.0539068645297447801567614078521728515625e+01</value>
13894
                <value type="real" key="middleSegmentOffset">4.715454256184551695696427486836910247802734375e+01</value>
13958 13895
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13959 13896
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13960 13897
                <value type="int" key="drawSplit">0</value>
......
15161 15098
                <value type="int" key="visible">1</value>
15162 15099
                <value type="string" key="name"></value>
15163 15100
              </value>
15164
              <value type="object" struct-name="workbench.physical.Connection" id="323a697e-011b-11e3-b872-080027bcf912" struct-checksum="0x9baebc92">
15165
                <value type="string" key="caption">fk_individual_observation_place1</value>
15166
                <value type="real" key="captionXOffs">0.e+00</value>
15167
                <value type="real" key="captionYOffs">0.e+00</value>
15168
                <value type="string" key="comment"></value>
15169
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15170
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15171
                <value type="string" key="extraCaption"></value>
15172
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15173
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15174
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">323a36d4-011b-11e3-b872-080027bcf912</link>
15175
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15176
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15177
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15178
                <value type="int" key="drawSplit">1</value>
15179
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
15180
                <link type="object" struct-name="model.Figure" key="startFigure">D1965EDA-481F-496B-9C24-79553E7891E8</link>
15181
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15182
                <value type="int" key="visible">1</value>
15183
                <value type="string" key="name"></value>
15184
              </value>
15185 15101
              <value type="object" struct-name="workbench.physical.Connection" id="39fe67ca-011e-11e3-9f3a-080027bcf912" struct-checksum="0x9baebc92">
15186 15102
                <value type="string" key="caption">fk_taxon_observation_sampling_event1</value>
15187 15103
                <value type="real" key="captionXOffs">0.e+00</value>
......
16432 16348
                <value type="real" key="left">1.292e+03</value>
16433 16349
                <value type="int" key="locked">0</value>
16434 16350
                <value type="int" key="manualSizing">0</value>
16435
                <value type="real" key="top">6.5e+01</value>
16351
                <value type="real" key="top">5.3e+01</value>
16436 16352
                <value type="real" key="width">1.06e+02</value>
16437 16353
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16438 16354
                <value type="int" key="visible">1</value>
......
16447 16363
                <value type="int" key="triggersExpanded">0</value>
16448 16364
                <value type="string" key="color">#CCFFCC</value>
16449 16365
                <value type="int" key="expanded">1</value>
16450
                <value type="real" key="height">1.23e+02</value>
16366
                <value type="real" key="height">1.e+02</value>
16451 16367
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16452 16368
                <value type="real" key="left">1.068e+03</value>
16453 16369
                <value type="int" key="locked">0</value>
......
17744 17660
              <value type="string" key="name"></value>
17745 17661
            </value>
17746 17662
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17747
              <link type="object">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
17663
              <link type="object">D1965EDA-481F-496B-9C24-79553E7891E8</link>
17748 17664
            </value>
17749 17665
            <value type="int" key="updateBlocked">0</value>
17750 17666
            <value type="real" key="width">1.6215e+03</value>
......
17758 17674
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17759 17675
        <value _ptr_="0xbadb488" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17760 17676
        <value _ptr_="0xb078db0" type="dict" key="syncProfiles">
17761
          <value type="object" struct-name="db.mgmt.SyncProfile" id="46dd99aa-29a7-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17762
            <value _ptr_="0xe060c50" type="dict" key="lastKnownDBNames">
17677
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ce716608-29a7-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17678
            <value _ptr_="0xe76dd98" type="dict" key="lastKnownDBNames">
17763 17679
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17764 17680
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17765 17681
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18391 18307
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18392 18308
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18393 18309
      <value type="string" key="caption">New Model</value>
18394
      <value type="string" key="dateChanged">2013-09-30 01:10</value>
18310
      <value type="string" key="dateChanged">2013-09-30 01:22</value>
18395 18311
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18396 18312
      <value type="string" key="description"></value>
18397 18313
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
422 422
/*!40101 SET character_set_client = utf8 */;
423 423
CREATE TABLE `individual_observation` (
424 424
  `id` varbinary(767) NOT NULL,
425
  `place_observed_at` varbinary(767) DEFAULT NULL,
426 425
  `individual` varbinary(767) DEFAULT NULL COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant',
427 426
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant',
428 427
  PRIMARY KEY (`id`),
429 428
  KEY `fk_individual_observation_individual1_idx` (`individual`),
430
  KEY `fk_individual_observation_place1_idx` (`place_observed_at`),
431 429
  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),
432
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
433 430
  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
434
  CONSTRAINT `fk_individual_observation_place1` FOREIGN KEY (`place_observed_at`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
435
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
436
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]';
431
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
432
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
433
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]; inherited fields: place: contains the place the individual was observed at';
437 434
/*!40101 SET character_set_client = @saved_cs_client */;
438 435

  
439 436
--
schemas/VegCore/VegCore.pg.sql
424 424
/*!40101 SET character_set_client = utf8 */;
425 425
CREATE TABLE "individual_observation" (
426 426
  "id" text NOT NULL,
427
  "place_observed_at" text DEFAULT NULL,
428 427
  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
429 428
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant'*/,
430 429
  PRIMARY KEY ("id"),
431 430
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
432
  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),
433 431
  /*KEY "individual_observation_id_fkey1_idx" ("specimenholder_institutions")*/CHECK (true),
434
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
435 432
  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
436
  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
437
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
438
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'*/;
433
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
434
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
435
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]; inherited fields: place: contains the place the individual was observed at'*/;
439 436
/*!40101 SET character_set_client = @saved_cs_client */;
440 437

  
441 438
--

Also available in: Unified diff