Revision 424
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 140 | 140 |
|
| 141 | 141 |
CREATE TABLE collection ( |
| 142 | 142 |
collection_id integer NOT NULL, |
| 143 |
individualplant_id integer NOT NULL |
|
| 143 |
individualplant_id integer NOT NULL, |
|
| 144 |
reference_id integer NOT NULL, |
|
| 145 |
code text NOT NULL, |
|
| 146 |
catalognumber text |
|
| 144 | 147 |
); |
| 145 | 148 |
|
| 146 | 149 |
|
| ... | ... | |
| 4568 | 4571 |
|
| 4569 | 4572 |
|
| 4570 | 4573 |
-- |
| 4574 |
-- Name: fki_collection_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4575 |
-- |
|
| 4576 |
|
|
| 4577 |
CREATE INDEX fki_collection_reference_id_fkey ON collection USING btree (reference_id); |
|
| 4578 |
|
|
| 4579 |
|
|
| 4580 |
-- |
|
| 4571 | 4581 |
-- Name: fki_r10taxondetermination_collection_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4572 | 4582 |
-- |
| 4573 | 4583 |
|
| ... | ... | |
| 5395 | 5405 |
|
| 5396 | 5406 |
|
| 5397 | 5407 |
-- |
| 5408 |
-- Name: collection_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5409 |
-- |
|
| 5410 |
|
|
| 5411 |
ALTER TABLE ONLY collection |
|
| 5412 |
ADD CONSTRAINT collection_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5413 |
|
|
| 5414 |
|
|
| 5415 |
-- |
|
| 5398 | 5416 |
-- Name: r10taxondetermination_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5399 | 5417 |
-- |
| 5400 | 5418 |
|
Also available in: Unified diff
vegbien.sql: Added some DarwinCore attributes to collection table