Revision 7052
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2229 | 2229 |
party_id integer, |
| 2230 | 2230 |
role role DEFAULT 'unknown'::role NOT NULL, |
| 2231 | 2231 |
determinationtype text, |
| 2232 |
reference_id integer, |
|
| 2232 | 2233 |
isoriginal boolean DEFAULT false NOT NULL, |
| 2233 | 2234 |
iscurrent boolean DEFAULT false NOT NULL, |
| 2234 | 2235 |
taxonfit text, |
| ... | ... | |
| 7543 | 7544 |
|
| 7544 | 7545 |
|
| 7545 | 7546 |
-- |
| 7547 |
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7548 |
-- |
|
| 7549 |
|
|
| 7550 |
ALTER TABLE ONLY taxondetermination |
|
| 7551 |
ADD CONSTRAINT taxondetermination_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7552 |
|
|
| 7553 |
|
|
| 7554 |
-- |
|
| 7546 | 7555 |
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7547 | 7556 |
-- |
| 7548 | 7557 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added back reference_id, which is different than the scoping source_id (reference_id was previously renamed to source_id in a bulk rename)