Project

General

Profile

« Previous | Next » 

Revision 6131

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/filter_ERD.csv: Display referencecontributor->party connection in ERD

View differences:

schemas/vegbien.my.sql
5957 5957 
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5958 5958 
--
5959 5959 

  		




  
  5960
  
    
ALTER TABLE referencecontributor


  		




  
  5961
  
    
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5960
  5962
  
    

  		




  5961
  5963
  
    

  		




  5962
  
  
    

  		




  5963
  5964
  
    
--


  		




  5964
  5965
  
    
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5965
  5966
  
    
--


  		












  

    
      schemas/filter_ERD.csv
    
  





  7
  7
  
    
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES coverindex\b[^;]*;",,inward


  		




  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
  
  
    
"^ALTER TABLE (?!party|address|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward


  		




  
  10
  
    
"^ALTER TABLE (?!party|address|referencecontributor|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward


  		




  11
  11
  
    
"^ALTER TABLE (?!reference)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES reference\b[^;]*;",,inward


  		












Also available in:  Unified diff