Project

General

Profile

« Previous | Next » 

Revision 613

vegbien.sql: Removed specimen.collectornumber_dwc and replaced it with verbatimcollectorname to reflect that the collectornumber_dwc is actually an ID of the specimen, and the collector's name is what we want to store

View differences:

vegbien.for_ERD.my.sql
290 290
  sourceaccessioncode character varying(100),
291 291
  accessioncode character varying(255),
292 292
  taxonoccurrence_id int(11) NOT NULL,
293
  collectornumber_dwc character varying(255),
293
  verbatimcollectorname character varying(255),
294 294
  authorspecimencode character varying(20),
295 295
  CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
296 296
  CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)

Also available in: Unified diff