Revision 1203
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 110 | 110 |
coverindex_id int(11), |
| 111 | 111 |
occurrencestatus_dwc text DEFAULT 'present', |
| 112 | 112 |
method_id int(11), |
| 113 |
linecover double precision |
|
| 113 |
linecover double precision, |
|
| 114 |
verbatimcollectorname text |
|
| 114 | 115 |
); |
| 115 | 116 |
|
| 116 | 117 |
|
| ... | ... | |
| 2000 | 2001 |
taxonoccurrence_id int(11) NOT NULL, |
| 2001 | 2002 |
collectionnumber text, |
| 2002 | 2003 |
specimen_id int(11), |
| 2003 |
description text |
|
| 2004 |
description text, |
|
| 2005 |
verbatimcollectorname text |
|
| 2004 | 2006 |
); |
| 2005 | 2007 |
|
| 2006 | 2008 |
|
| ... | ... | |
| 2228 | 2230 |
taxonoccurrence_id int(11) NOT NULL, |
| 2229 | 2231 |
locationevent_id int(11), |
| 2230 | 2232 |
emb_taxonoccurrence int(11), |
| 2231 |
accessioncode text, |
|
| 2232 |
verbatimcollectorname text |
|
| 2233 |
accessioncode text |
|
| 2233 | 2234 |
); |
| 2234 | 2235 |
|
| 2235 | 2236 |
|
Also available in: Unified diff
VegBIEN: Moved taxonoccurrence.verbatimcollectorname to specimenreplicate and aggregateoccurrence so that it can be used in specimenreplicate duplicate elimination