Revision 613
Added by Aaron Marcuse-Kubitza about 13 years ago
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
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