Project

General

Profile

« Previous | Next » 

Revision 4942

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/filter_ERD.csv: Don't filter out fkeys from taxonpath to itself

View differences:

schemas/vegbien.my.sql
5029 5029 
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5030 5030 
--
5031 5031 

  		




  
  5032
  
    
ALTER TABLE taxonpath


  		




  
  5033
  
    
    ADD CONSTRAINT taxonpath_canon_id_fkey FOREIGN KEY (canon_id) REFERENCES taxonpath(taxonpath_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5032
  5034
  
    

  		




  5033
  5035
  
    

  		




  5034
  
  
    

  		




  5035
  5036
  
    
--


  		




  5036
  5037
  
    
-- Name: taxonpath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5037
  5038
  
    
--


  		












  

    
      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|taxonpath|plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonpath\b[^;]*;",,inward


  		




  
  4
  
    
"^ALTER TABLE (?:taxon|plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonpath\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