Project

General

Profile

« Previous | Next » 

Revision 543

Added by Aaron Marcuse-Kubitza about 13 years ago

VegBIEN: specimen links directly to taxonoccurrence rather than indirectly via individualplant

View differences:

schemas/vegbien.for_ERD.my.sql
227 227 
CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
228 228 
(
229 229 
  specimen_id int(11) NOT NULL AUTO_INCREMENT,
230 
  individualplant_id int(11),
231 230 
  reference_id int(11) NOT NULL,
232 231 
  collectioncode_dwc character varying(255),
233 232 
  catalognumber_dwc character varying(255),
schemas/vegbien.for_wiki.sql
89 89 
CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
90 90 
(
91 91 
  specimen_id serial NOT NULL,
92 
  individualplant_id integer,
93 92 
  reference_id integer NOT NULL,
94 93 
  collectioncode_dwc character varying(255),
95 94 
  catalognumber_dwc character varying(255),
schemas/vegbien.for_ERD.sql
227 227 
CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
228 228 
(
229 229 
  specimen_id serial NOT NULL,
230 
  individualplant_id integer,
231 230 
  reference_id integer NOT NULL,
232 231 
  collectioncode_dwc character varying(255),
233 232 
  catalognumber_dwc character varying(255),

Also available in: Unified diff