Revision 11134
Added by Aaron Marcuse-Kubitza about 11 years ago
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
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