Revision 5243
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2690 | 2690 |
CREATE TABLE voucher ( |
| 2691 | 2691 |
voucher_id int(11) NOT NULL, |
| 2692 | 2692 |
taxonoccurrence_id int(11) NOT NULL, |
| 2693 |
specimenreplicate_id int(11) NOT NULL, |
|
| 2694 |
accessioncode text |
|
| 2693 |
specimenreplicate_id int(11) NOT NULL |
|
| 2695 | 2694 |
); |
| 2696 | 2695 |
|
| 2697 | 2696 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3334 | 3334 |
CREATE TABLE voucher ( |
| 3335 | 3335 |
voucher_id integer NOT NULL, |
| 3336 | 3336 |
taxonoccurrence_id integer NOT NULL, |
| 3337 |
specimenreplicate_id integer NOT NULL, |
|
| 3338 |
accessioncode text |
|
| 3337 |
specimenreplicate_id integer NOT NULL |
|
| 3339 | 3338 |
); |
| 3340 | 3339 |
|
| 3341 | 3340 |
|
Also available in: Unified diff
schemas/vegbien.sql: voucher: Removed accessioncode because this table has no sourceaccessioncode which it would be generated from (it just links a taxonoccurrence to a vouchering specimenreplicate)