Revision 5279
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4861 | 4861 |
-- Name: plantstatus_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4862 | 4862 |
-- |
| 4863 | 4863 |
|
| 4864 |
ALTER TABLE plantstatus |
|
| 4865 |
ADD CONSTRAINT plantstatus_taxonconcept_id_fkey FOREIGN KEY (taxonconcept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4864 | 4866 |
|
| 4865 | 4867 |
|
| 4866 |
|
|
| 4867 | 4868 |
-- |
| 4868 | 4869 |
-- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4869 | 4870 |
-- |
| schemas/filter_ERD.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"fkeys to heavily-linked tables" |
| 3 | 3 |
"^ALTER TABLE (?:commclass)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward |
| 4 |
"^ALTER TABLE (?:plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonconcept\b[^;]*;",,inward |
|
| 4 |
"^ALTER TABLE (?!plantstatus)(?:plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonconcept\b[^;]*;",,inward
|
|
| 5 | 5 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES coverindex\b[^;]*;",,inward |
| 6 | 6 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 7 | 7 |
"^ALTER TABLE (?!party|address|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
Also available in: Unified diff
schemas/filter_ERD.csv: Changed the table with the visible fkey from plant* to taxon* to be plantstatus rather than plantusage, since it contains more core fields