Revision 7052
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1417 | 1417 |
party_id int(11), |
| 1418 | 1418 |
role varchar(255) DEFAULT 'unknown' NOT NULL, |
| 1419 | 1419 |
determinationtype varchar(255), |
| 1420 |
reference_id int(11), |
|
| 1420 | 1421 |
isoriginal int(1) DEFAULT false NOT NULL, |
| 1421 | 1422 |
iscurrent int(1) DEFAULT false NOT NULL, |
| 1422 | 1423 |
taxonfit varchar(255), |
| ... | ... | |
| 6390 | 6391 |
|
| 6391 | 6392 |
|
| 6392 | 6393 |
-- |
| 6394 |
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6395 |
-- |
|
| 6396 |
|
|
| 6397 |
|
|
| 6398 |
|
|
| 6399 |
|
|
| 6400 |
-- |
|
| 6393 | 6401 |
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6394 | 6402 |
-- |
| 6395 | 6403 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 8 | 8 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 9 | 9 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\(submethod_id\) REFERENCES method\b[^;]*;",,inward |
| 10 | 10 |
"^ALTER TABLE (?!party|address|sourcecontributor|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_reference_id)\) REFERENCES source\b[^;]*;",,inward |
|
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_reference_id|reference_id)\) REFERENCES source\b[^;]*;",,inward
|
|
| 12 | 12 |
"^ALTER TABLE (?!sourcename)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES sourcelist\b[^;]*;",,inward |
| 13 | 13 |
"^ALTER TABLE (?:projectcontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:project_id)\) REFERENCES \b[^;]*;",,inward |
| 14 | 14 |
"^ALTER TABLE (?:partymember)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:parentparty_id)\) REFERENCES \b[^;]*;",,inward |
| schemas/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)