Revision 527
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2268 | 2268 |
collector_id integer, |
| 2269 | 2269 |
museum_id integer, |
| 2270 | 2270 |
sourceaccessionnumber character varying(100), |
| 2271 |
accessioncode character varying(255) |
|
| 2271 |
accessioncode character varying(255), |
|
| 2272 |
taxonoccurrence_id integer |
|
| 2272 | 2273 |
); |
| 2273 | 2274 |
|
| 2274 | 2275 |
|
| ... | ... | |
| 6444 | 6445 |
|
| 6445 | 6446 |
|
| 6446 | 6447 |
-- |
| 6448 |
-- Name: specimen_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6449 |
-- |
|
| 6450 |
|
|
| 6451 |
ALTER TABLE ONLY specimen |
|
| 6452 |
ADD CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6453 |
|
|
| 6454 |
|
|
| 6455 |
-- |
|
| 6447 | 6456 |
-- Name: stem_individualplant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6448 | 6457 |
-- |
| 6449 | 6458 |
|
Also available in: Unified diff
vegbien.sql: Added specimen.taxonoccurrence_id fkey