Revision 518
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2513 | 2513 |
taxonfit character varying(50), |
| 2514 | 2514 |
taxonconfidence character varying(50), |
| 2515 | 2515 |
museum_id integer, |
| 2516 |
museumaccessionnumber character varying(100),
|
|
| 2516 |
sourceaccessionnumber character varying(100),
|
|
| 2517 | 2517 |
grouptype character varying(20), |
| 2518 | 2518 |
notes text, |
| 2519 | 2519 |
notespublic boolean, |
| ... | ... | |
| 4359 | 4359 |
-- |
| 4360 | 4360 |
|
| 4361 | 4361 |
ALTER TABLE ONLY taxondetermination |
| 4362 |
ADD CONSTRAINT taxondetermination_keys UNIQUE (taxonoccurrence_id, individualplant_id, role_id, plantname_id, museumaccessionnumber);
|
|
| 4362 |
ADD CONSTRAINT taxondetermination_keys UNIQUE (taxonoccurrence_id, individualplant_id, role_id, plantname_id, sourceaccessionnumber);
|
|
| 4363 | 4363 |
|
| 4364 | 4364 |
|
| 4365 | 4365 |
-- |
Also available in: Unified diff
VegBIEN: Renamed museumaccessionnumber to sourceaccessionnumber