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.pg.sql
811 811 
CREATE TABLE "specimen_observation" (
812 812 
  "id" text NOT NULL,
813 813 
  "specimen" text NOT NULL,
814 
  "description" text DEFAULT NULL,
814 815 
  "traits" hstore DEFAULT NULL,
815 816 
  PRIMARY KEY ("id"),
816 817 
  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),
......
1118 1119 
/*!40101 SET character_set_client = utf8 */;
1119 1120 
CREATE TABLE "taxon_presence" (
1120 1121 
  "id" text NOT NULL,
1122 
  "occurrence_status" text DEFAULT NULL,
1121 1123 
  "traits" hstore DEFAULT NULL,
1122 1124 
  PRIMARY KEY ("id"),
1123 1125 
  /*CONSTRAINT "fk_taxon_presence_taxon_determination1" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

Also available in: Unified diff