Revision 392
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 140 | 140 |
|
| 141 | 141 |
CREATE TABLE collection ( |
| 142 | 142 |
collection_id integer NOT NULL, |
| 143 |
stemobservation_id integer NOT NULL
|
|
| 143 |
individualplant_id integer NOT NULL
|
|
| 144 | 144 |
); |
| 145 | 145 |
|
| 146 | 146 |
|
| ... | ... | |
| 5377 | 5377 |
|
| 5378 | 5378 |
|
| 5379 | 5379 |
-- |
| 5380 |
-- Name: collection_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5380 |
-- Name: collection_individualplant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5381 | 5381 |
-- |
| 5382 | 5382 |
|
| 5383 | 5383 |
ALTER TABLE ONLY collection |
| 5384 |
ADD CONSTRAINT collection_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id);
|
|
| 5384 |
ADD CONSTRAINT collection_individualplant_id_fkey FOREIGN KEY (individualplant_id) REFERENCES individualplant(individualplant_id);
|
|
| 5385 | 5385 |
|
| 5386 | 5386 |
|
| 5387 | 5387 |
-- |
Also available in: Unified diff
vegbien.sql: Updated collection table for recent refactorings