Project

General

Profile

« Previous | Next » 

Revision 11139

schemas/VegCore/ERD/VegCore.ERD.mwb: taxon_observation.taxon_occurrence: documented that when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation. this operation should eventually be perfomed by a trigger.

View differences:

schemas/VegCore/ERD/document.mwb.xml
3090 3090
                      <value type="int" key="precision">-1</value>
3091 3091
                      <value type="int" key="scale">-1</value>
3092 3092
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
3093
                      <value type="string" key="comment"></value>
3093
                      <value type="string" key="comment">when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation</value>
3094 3094
                      <value type="string" key="name">taxon_occurrence</value>
3095 3095
                      <value type="string" key="oldName">taxon_occurrence</value>
3096 3096
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
......
3569 3569
                  <value type="int" key="commentedOut">0</value>
3570 3570
                  <value type="string" key="createDate">2013-04-17 13:52</value>
3571 3571
                  <value _ptr_="0xad45e10" type="dict" key="customData"/>
3572
                  <value type="string" key="lastChangeDate">2013-09-30 02:24</value>
3572
                  <value type="string" key="lastChangeDate">2013-09-30 04:02</value>
3573 3573
                  <value type="int" key="modelOnly">0</value>
3574 3574
                  <value type="string" key="name">taxon_observation</value>
3575 3575
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
6415 6415
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6416 6416
                      <value type="string" key="comment">the parent geoplace</value>
6417 6417
                      <value type="string" key="name">parent</value>
6418
                      <value type="string" key="oldName">parent_geoplace</value>
6418
                      <value type="string" key="oldName">parent</value>
6419 6419
                      <link type="object" struct-name="GrtObject" key="owner">be8f78aa-a6e0-11e2-95e9-080027bcf912</link>
6420 6420
                    </value>
6421 6421
                  </value>
......
17463 17463
              <value type="string" key="name"></value>
17464 17464
            </value>
17465 17465
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17466
              <link type="object">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
17466
              <link type="object">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
17467 17467
            </value>
17468 17468
            <value type="int" key="updateBlocked">0</value>
17469 17469
            <value type="real" key="width">1.6215e+03</value>
......
17477 17477
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17478 17478
        <value _ptr_="0xad2bf00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17479 17479
        <value _ptr_="0xa5b9c88" type="dict" key="syncProfiles">
17480
          <value type="object" struct-name="db.mgmt.SyncProfile" id="693a939c-29b9-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17481
            <value _ptr_="0xc07e5d0" type="dict" key="lastKnownDBNames">
17480
          <value type="object" struct-name="db.mgmt.SyncProfile" id="1ab37652-29bf-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17481
            <value _ptr_="0xc5bb328" type="dict" key="lastKnownDBNames">
17482 17482
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17483 17483
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17484 17484
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17662 17662
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
17663 17663
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
17664 17664
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
17665
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent_geoplace</value>
17665
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent</value>
17666 17666
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
17667 17667
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
17668 17668
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
......
18102 18102
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18103 18103
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18104 18104
      <value type="string" key="caption">New Model</value>
18105
      <value type="string" key="dateChanged">2013-09-30 03:57</value>
18105
      <value type="string" key="dateChanged">2013-09-30 04:02</value>
18106 18106
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18107 18107
      <value type="string" key="description"></value>
18108 18108
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1245 1245
CREATE TABLE `taxon_observation` (
1246 1246
  `id` varbinary(767) NOT NULL,
1247 1247
  `parent` varbinary(767) DEFAULT NULL COMMENT 'contains the observation of the same taxon_occurrence in the parent sampling_event',
1248
  `taxon_occurrence` varbinary(767) NOT NULL,
1248
  `taxon_occurrence` varbinary(767) NOT NULL COMMENT 'when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation',
1249 1249
  `sampling_event` varbinary(767) NOT NULL COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation',
1250 1250
  `primary_collector` varbinary(767) DEFAULT NULL,
1251 1251
  `collector_number` varbinary(767) DEFAULT NULL,
......
1260 1260
  KEY `fk_taxon_observation_party_list1_idx` (`all_collectors`),
1261 1261
  KEY `taxon_observation__unique` (`sampling_event`,`primary_collector`,`collector_number`),
1262 1262
  KEY `taxon_observation_id_fkey2_idx` (`parent`),
1263
  CONSTRAINT `taxon_observation_id_fkey1` FOREIGN KEY (`primary_collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1264
  CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1265
  CONSTRAINT `taxon_observation_id_fkey2` FOREIGN KEY (`parent`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1263
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1266 1264
  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`all_collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1267 1265
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1268
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1266
  CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1267
  CONSTRAINT `taxon_observation_id_fkey1` FOREIGN KEY (`primary_collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1268
  CONSTRAINT `taxon_observation_id_fkey2` FOREIGN KEY (`parent`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1269 1269
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)';
1270 1270
/*!40101 SET character_set_client = @saved_cs_client */;
1271 1271

  
schemas/VegCore/VegCore.pg.sql
1247 1247
CREATE TABLE "taxon_observation" (
1248 1248
  "id" text NOT NULL,
1249 1249
  "parent" text DEFAULT NULL /*COMMENT 'contains the observation of the same taxon_occurrence in the parent sampling_event'*/,
1250
  "taxon_occurrence" text NOT NULL,
1250
  "taxon_occurrence" text NOT NULL /*COMMENT 'when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation'*/,
1251 1251
  "sampling_event" text NOT NULL /*COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation'*/,
1252 1252
  "primary_collector" text DEFAULT NULL,
1253 1253
  "collector_number" text DEFAULT NULL,
......
1262 1262
  /*KEY "fk_taxon_observation_party_list1_idx" ("all_collectors")*/CHECK (true),
1263 1263
  /*KEY "taxon_observation__unique" ("sampling_event","primary_collector","collector_number")*/CHECK (true),
1264 1264
  /*KEY "taxon_observation_id_fkey2_idx" ("parent")*/CHECK (true),
1265
  /*CONSTRAINT "taxon_observation_id_fkey1" FOREIGN KEY ("primary_collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1266
  /*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1267
  /*CONSTRAINT "taxon_observation_id_fkey2" FOREIGN KEY ("parent") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1265
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1268 1266
  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("all_collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1269 1267
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1270
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1268
  /*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1269
  /*CONSTRAINT "taxon_observation_id_fkey1" FOREIGN KEY ("primary_collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1270
  /*CONSTRAINT "taxon_observation_id_fkey2" FOREIGN KEY ("parent") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1271 1271
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)'*/;
1272 1272
/*!40101 SET character_set_client = @saved_cs_client */;
1273 1273

  

Also available in: Unified diff