Revision 529
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2511 | 2511 |
taxondetermination_id integer NOT NULL, |
| 2512 | 2512 |
taxonoccurrence_id integer NOT NULL, |
| 2513 | 2513 |
plantconcept_id integer NOT NULL, |
| 2514 |
plantname_id integer, |
|
| 2515 | 2514 |
party_id integer NOT NULL, |
| 2516 | 2515 |
role_id integer NOT NULL, |
| 2517 | 2516 |
determinationtype character varying(30), |
| ... | ... | |
| 4360 | 4359 | |
| 4361 | 4360 | |
| 4362 | 4361 |
-- |
| 4363 |
-- Name: taxondetermination_keys_taxonoccurrence_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4364 |
-- |
|
| 4365 | ||
| 4366 |
ALTER TABLE ONLY taxondetermination |
|
| 4367 |
ADD CONSTRAINT taxondetermination_keys_taxonoccurrence_id UNIQUE (taxonoccurrence_id, role_id, plantname_id); |
|
| 4368 | ||
| 4369 | ||
| 4370 |
-- |
|
| 4371 | 4362 |
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4372 | 4363 |
-- |
| 4373 | 4364 | |
| ... | ... | |
| 5527 | 5518 | |
| 5528 | 5519 | |
| 5529 | 5520 |
-- |
| 5530 |
-- Name: taxondetermination_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5531 |
-- |
|
| 5532 | ||
| 5533 |
CREATE INDEX taxondetermination_plantname_id_x ON taxondetermination USING btree (plantname_id); |
|
| 5534 | ||
| 5535 | ||
| 5536 |
-- |
|
| 5537 | 5521 |
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5538 | 5522 |
-- |
| 5539 | 5523 | |
| ... | ... | |
| 6541 | 6525 | |
| 6542 | 6526 | |
| 6543 | 6527 |
-- |
| 6544 |
-- Name: taxondetermination_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6545 |
-- |
|
| 6546 | ||
| 6547 |
ALTER TABLE ONLY taxondetermination |
|
| 6548 |
ADD CONSTRAINT taxondetermination_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6549 | ||
| 6550 | ||
| 6551 |
-- |
|
| 6552 | 6528 |
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6553 | 6529 |
-- |
| 6554 | 6530 | |
Also available in: Unified diff
vegbien.sql: Removed no longer needed taxondetermination.plantname_id