Project

General

Profile

« Previous | Next » 

Revision 10490

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen_observation: added description (vegcore.vegpath.org?specimenDescription). taxon_presence: added occurrence_status (vegcore.vegpath.org?occurrenceStatus). stem_observation, aggregate_observation: made room for them to expand with additional first-class fields.

View differences:

VegCore.my.sql
809 809 
CREATE TABLE `specimen_observation` (
810 810 
  `id` varbinary(767) NOT NULL,
811 811 
  `specimen` varbinary(767) NOT NULL,
812 
  `description` varbinary(767) DEFAULT NULL,
812 813 
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
813 814 
  PRIMARY KEY (`id`),
814 815 
  KEY `fk_specimen_observation_specimen1_idx` (`specimen`),
......
1116 1117 
/*!40101 SET character_set_client = utf8 */;
1117 1118 
CREATE TABLE `taxon_presence` (
1118 1119 
  `id` varbinary(767) NOT NULL,
1120 
  `occurrence_status` varbinary(767) DEFAULT NULL,
1119 1121 
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
1120 1122 
  PRIMARY KEY (`id`),
1121 1123 
  CONSTRAINT `fk_taxon_presence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

Also available in: Unified diff