Project

General

Profile

« Previous | Next » 

Revision 11134

schemas/VegCore/ERD/VegCore.ERD.mwb: individual_observation.specimenholder_institutions: documented that when provided, the source (i.e. traceable.source) should be set to the value of this field, because these institutions together provided the data for this entity

View differences:

schemas/VegCore/ERD/document.mwb.xml
7224 7224
                      <value type="int" key="precision">-1</value>
7225 7225
                      <value type="int" key="scale">-1</value>
7226 7226
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
7227
                      <value type="string" key="comment">institutions which store specimens from this plant</value>
7227
                      <value type="string" key="comment">institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).</value>
7228 7228
                      <value type="string" key="name">specimenholder_institutions</value>
7229 7229
                      <value type="string" key="oldName">specimenholder_institutions</value>
7230 7230
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
......
7400 7400
                  <value type="int" key="commentedOut">0</value>
7401 7401
                  <value type="string" key="createDate">2013-04-17 13:54</value>
7402 7402
                  <value _ptr_="0xad83ce8" type="dict" key="customData"/>
7403
                  <value type="string" key="lastChangeDate">2013-09-30 01:20</value>
7403
                  <value type="string" key="lastChangeDate">2013-09-30 03:02</value>
7404 7404
                  <value type="int" key="modelOnly">0</value>
7405 7405
                  <value type="string" key="name">individual_observation</value>
7406 7406
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17462 17462
              <value type="int" key="visible">1</value>
17463 17463
              <value type="string" key="name"></value>
17464 17464
            </value>
17465
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17465
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17466
              <link type="object">D1965EDA-481F-496B-9C24-79553E7891E8</link>
17467
            </value>
17466 17468
            <value type="int" key="updateBlocked">0</value>
17467 17469
            <value type="real" key="width">1.6215e+03</value>
17468 17470
            <value type="real" key="x">0.e+00</value>
......
18100 18102
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18101 18103
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18102 18104
      <value type="string" key="caption">New Model</value>
18103
      <value type="string" key="dateChanged">2013-09-30 02:57</value>
18105
      <value type="string" key="dateChanged">2013-09-30 03:02</value>
18104 18106
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18105 18107
      <value type="string" key="description"></value>
18106 18108
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
420 420
CREATE TABLE `individual_observation` (
421 421
  `id` varbinary(767) NOT NULL,
422 422
  `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',
423
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant',
423
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).',
424 424
  PRIMARY KEY (`id`),
425 425
  KEY `fk_individual_observation_individual1_idx` (`individual`),
426 426
  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),
427
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
427 428
  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
428
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
429
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
429
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
430 430
) 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';
431 431
/*!40101 SET character_set_client = @saved_cs_client */;
432 432

  
schemas/VegCore/VegCore.pg.sql
422 422
CREATE TABLE "individual_observation" (
423 423
  "id" text NOT NULL,
424 424
  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
425
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant'*/,
425
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).'*/,
426 426
  PRIMARY KEY ("id"),
427 427
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
428 428
  /*KEY "individual_observation_id_fkey1_idx" ("specimenholder_institutions")*/CHECK (true),
429
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
429 430
  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
430
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
431
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
431
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
432 432
) /*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'*/;
433 433
/*!40101 SET character_set_client = @saved_cs_client */;
434 434

  

Also available in: Unified diff