Revision 5229
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/filter_ERD.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"fkeys to heavily-linked tables" |
| 3 | 3 |
"^ALTER TABLE (?:commclass|taxonscope)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward |
| 4 |
"^ALTER TABLE (?:taxon|plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonconcept\b[^;]*;",,inward
|
|
| 4 |
"^ALTER TABLE (?: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: taxonconcept inward fkeys: Removed not applicable taxon filtered table, since the fkey points in the opposite direction and thus is not part of this filter