Revision 542
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2258 | 2258 |
|
| 2259 | 2259 |
CREATE TABLE specimen ( |
| 2260 | 2260 |
specimen_id integer NOT NULL, |
| 2261 |
individualplant_id integer, |
|
| 2262 | 2261 |
reference_id integer NOT NULL, |
| 2263 | 2262 |
collectioncode_dwc character varying(255), |
| 2264 | 2263 |
catalognumber_dwc character varying(255), |
| ... | ... | |
| 6403 | 6402 |
|
| 6404 | 6403 |
|
| 6405 | 6404 |
-- |
| 6406 |
-- Name: specimen_individualplant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6407 |
-- |
|
| 6408 |
|
|
| 6409 |
ALTER TABLE ONLY specimen |
|
| 6410 |
ADD CONSTRAINT specimen_individualplant_id_fkey FOREIGN KEY (individualplant_id) REFERENCES individualplant(individualplant_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6411 |
|
|
| 6412 |
|
|
| 6413 |
-- |
|
| 6414 | 6405 |
-- Name: specimen_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6415 | 6406 |
-- |
| 6416 | 6407 |
|
Also available in: Unified diff
VegBIEN: specimen links directly to taxonoccurrence rather than indirectly via individualplant