Revision 496
Added by Aaron Marcuse-Kubitza almost 13 years ago
schemas/vegbien.sql | ||
---|---|---|
2258 | 2258 |
specimen_id integer NOT NULL, |
2259 | 2259 |
individualplant_id integer, |
2260 | 2260 |
reference_id integer NOT NULL, |
2261 |
collectioncode_dwc character varying(255) NOT NULL,
|
|
2261 |
collectioncode_dwc character varying(255), |
|
2262 | 2262 |
catalognumber_dwc character varying(255), |
2263 | 2263 |
collectiondate timestamp with time zone |
2264 | 2264 |
); |
... | ... | |
2511 | 2511 |
taxonfit character varying(50), |
2512 | 2512 |
taxonconfidence character varying(50), |
2513 | 2513 |
collector_id integer, |
2514 |
collectionnumber character varying(100), |
|
2515 | 2514 |
museum_id integer, |
2516 | 2515 |
museumaccessionnumber character varying(100), |
2517 | 2516 |
grouptype character varying(20), |
... | ... | |
2520 | 2519 |
notesmgt boolean, |
2521 | 2520 |
revisions boolean, |
2522 | 2521 |
determinationdate timestamp with time zone NOT NULL, |
2523 |
collectiondate timestamp with time zone, |
|
2524 | 2522 |
emb_taxondetermination integer, |
2525 | 2523 |
accessioncode character varying(255), |
2526 | 2524 |
specimen_id integer |
Also available in: Unified diff
vegbien.sql: Removed taxondetermination columns that have been moved to specimen