Revision 495
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2259 | 2259 |
individualplant_id integer, |
| 2260 | 2260 |
reference_id integer NOT NULL, |
| 2261 | 2261 |
collectioncode_dwc character varying(255) NOT NULL, |
| 2262 |
catalognumber_dwc character varying(255) NOT NULL, |
|
| 2263 |
collectionnumber character varying(100), |
|
| 2262 |
catalognumber_dwc character varying(255), |
|
| 2264 | 2263 |
collectiondate timestamp with time zone |
| 2265 | 2264 |
); |
| 2266 | 2265 |
|
Also available in: Unified diff
VegBIEN: Merged specimen.collectionnumber and catalognumber_dwc fields. Removed NOT NULL constraints on several specimen columns because not all specimens have all identifiers. Mapped to new specimen fields.