Revision 11139
Added by Aaron Marcuse-Kubitza over 11 years ago
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
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.