Revision 11119
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/ERD/document.mwb.xml | ||
|---|---|---|
| 3041 | 3041 |
<value type="string" key="collationName"></value> |
| 3042 | 3042 |
<value type="string" key="datatypeExplicitParams"></value> |
| 3043 | 3043 |
<value type="string" key="defaultValue"></value> |
| 3044 |
<value type="int" key="defaultValueIsNull">1</value>
|
|
| 3044 |
<value type="int" key="defaultValueIsNull">0</value>
|
|
| 3045 | 3045 |
<value _ptr_="0xbaf5200" type="list" content-type="string" key="flags"/> |
| 3046 |
<value type="int" key="isNotNull">0</value>
|
|
| 3046 |
<value type="int" key="isNotNull">1</value>
|
|
| 3047 | 3047 |
<value type="int" key="length">767</value> |
| 3048 | 3048 |
<value type="int" key="precision">-1</value> |
| 3049 | 3049 |
<value type="int" key="scale">-1</value> |
| 3050 | 3050 |
<link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link> |
| 3051 |
<value type="string" key="comment"></value> |
|
| 3051 |
<value type="string" key="comment">for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation</value>
|
|
| 3052 | 3052 |
<value type="string" key="name">sampling_event</value> |
| 3053 | 3053 |
<value type="string" key="oldName">sampling_event</value> |
| 3054 | 3054 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| ... | ... | |
| 3290 | 3290 |
<value _ptr_="0xbaf7fa8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns"> |
| 3291 | 3291 |
<link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link> |
| 3292 | 3292 |
</value> |
| 3293 |
<value type="int" key="referencedMandatory">0</value>
|
|
| 3293 |
<value type="int" key="referencedMandatory">1</value>
|
|
| 3294 | 3294 |
<value type="string" key="updateRule">CASCADE</value> |
| 3295 | 3295 |
<value type="string" key="comment"></value> |
| 3296 | 3296 |
<value type="string" key="name">fk_taxon_observation_taxa_sampling_event1</value> |
| ... | ... | |
| 3493 | 3493 |
<value type="int" key="isPrimary">0</value> |
| 3494 | 3494 |
<value type="string" key="name">taxon_observation__unique</value> |
| 3495 | 3495 |
<value type="int" key="unique">0</value> |
| 3496 |
<value type="string" key="oldName"></value> |
|
| 3496 |
<value type="string" key="oldName">taxon_observation__unique</value>
|
|
| 3497 | 3497 |
<link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link> |
| 3498 | 3498 |
</value> |
| 3499 | 3499 |
</value> |
| ... | ... | |
| 3527 | 3527 |
<value type="int" key="commentedOut">0</value> |
| 3528 | 3528 |
<value type="string" key="createDate">2013-04-17 13:52</value> |
| 3529 | 3529 |
<value _ptr_="0xbaf4058" type="dict" key="customData"/> |
| 3530 |
<value type="string" key="lastChangeDate">2013-09-30 00:08</value>
|
|
| 3530 |
<value type="string" key="lastChangeDate">2013-09-30 01:06</value>
|
|
| 3531 | 3531 |
<value type="int" key="modelOnly">0</value> |
| 3532 | 3532 |
<value type="string" key="name">taxon_observation</value> |
| 3533 | 3533 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| ... | ... | |
| 17756 | 17756 |
<link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link> |
| 17757 | 17757 |
<value _ptr_="0xbadb488" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/> |
| 17758 | 17758 |
<value _ptr_="0xb078db0" type="dict" key="syncProfiles"> |
| 17759 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="47518bba-299a-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
| 17760 |
<value _ptr_="0xe032dc8" type="dict" key="lastKnownDBNames">
|
|
| 17759 |
<value type="object" struct-name="db.mgmt.SyncProfile" id="734aac04-29a6-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
|
|
| 17760 |
<value _ptr_="0xd8691c8" type="dict" key="lastKnownDBNames">
|
|
| 17761 | 17761 |
<value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value> |
| 17762 | 17762 |
<value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value> |
| 17763 | 17763 |
<value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value> |
| ... | ... | |
| 18071 | 18071 |
<value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value> |
| 18072 | 18072 |
<value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value> |
| 18073 | 18073 |
<value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value> |
| 18074 |
<value type="string" key="a2c503c8-299a-11e3-a80d-080027bcf912">taxon_observation__unique</value> |
|
| 18074 | 18075 |
<value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value> |
| 18075 | 18076 |
<value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value> |
| 18076 | 18077 |
<value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value> |
| ... | ... | |
| 18388 | 18389 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 18389 | 18390 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 18390 | 18391 |
<value type="string" key="caption">New Model</value> |
| 18391 |
<value type="string" key="dateChanged">2013-09-30 00:32</value>
|
|
| 18392 |
<value type="string" key="dateChanged">2013-09-30 01:06</value>
|
|
| 18392 | 18393 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 18393 | 18394 |
<value type="string" key="description"></value> |
| 18394 | 18395 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 1271 | 1271 |
CREATE TABLE `taxon_observation` ( |
| 1272 | 1272 |
`id` varbinary(767) NOT NULL, |
| 1273 | 1273 |
`taxon_occurrence` varbinary(767) NOT NULL, |
| 1274 |
`sampling_event` varbinary(767) DEFAULT NULL,
|
|
| 1274 |
`sampling_event` varbinary(767) NOT NULL COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation',
|
|
| 1275 | 1275 |
`primary_collector` varbinary(767) DEFAULT NULL, |
| 1276 | 1276 |
`collector_number` varbinary(767) DEFAULT NULL, |
| 1277 | 1277 |
`all_collectors` varbinary(767) DEFAULT NULL, |
| ... | ... | |
| 1286 | 1286 |
KEY `taxon_observation_id_fkey1_idx` (`primary_collector`), |
| 1287 | 1287 |
KEY `fk_taxon_observation_party_list1_idx` (`all_collectors`), |
| 1288 | 1288 |
KEY `taxon_observation__unique` (`sampling_event`,`primary_collector`,`collector_number`), |
| 1289 |
CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1289 | 1290 |
CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`all_collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1290 | 1291 |
CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1291 |
CONSTRAINT `fk_taxon_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1292 | 1292 |
CONSTRAINT `fk_taxon_observation_taxon_observation1` FOREIGN KEY (`observation_in_parent_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1293 | 1293 |
CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1294 | 1294 |
CONSTRAINT `taxon_observation_id_fkey1` FOREIGN KEY (`primary_collector`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 1273 | 1273 |
CREATE TABLE "taxon_observation" ( |
| 1274 | 1274 |
"id" text NOT NULL, |
| 1275 | 1275 |
"taxon_occurrence" text NOT NULL, |
| 1276 |
"sampling_event" text DEFAULT NULL,
|
|
| 1276 |
"sampling_event" text NOT NULL /*COMMENT 'for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation'*/,
|
|
| 1277 | 1277 |
"primary_collector" text DEFAULT NULL, |
| 1278 | 1278 |
"collector_number" text DEFAULT NULL, |
| 1279 | 1279 |
"all_collectors" text DEFAULT NULL, |
| ... | ... | |
| 1288 | 1288 |
/*KEY "taxon_observation_id_fkey1_idx" ("primary_collector")*/CHECK (true),
|
| 1289 | 1289 |
/*KEY "fk_taxon_observation_party_list1_idx" ("all_collectors")*/CHECK (true),
|
| 1290 | 1290 |
/*KEY "taxon_observation__unique" ("sampling_event","primary_collector","collector_number")*/CHECK (true),
|
| 1291 |
/*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1291 | 1292 |
/*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("all_collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1292 | 1293 |
/*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1293 |
/*CONSTRAINT "fk_taxon_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 1294 | 1294 |
/*CONSTRAINT "fk_taxon_observation_taxon_observation1" FOREIGN KEY ("observation_in_parent_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1295 | 1295 |
/*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 1296 | 1296 |
/*CONSTRAINT "taxon_observation_id_fkey1" FOREIGN KEY ("primary_collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
Also available in: Unified diff
schemas/VegCore/ERD/VegCore.ERD.mwb: taxon_observation.sampling_event: made it required so that there is always a sampling_event to scope the primary_collector/collector_number when provided. (for specimens, this will have the same event information (date_range, participants, place) as the taxon_observation.)