Project

General

Profile

« Previous | Next » 

Revision 6248

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.ERD.mwb: Added projectcontributor, locationeventcontributor to ERD

View differences:

schemas/vegbien.my.sql
5953 5953 
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5954 5954 
--
5955 5955 

  		




  5956
  
  
    
ALTER TABLE projectcontributor


  		




  5957
  
  
    
    ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  5958
  5956
  
    

  		




  5959
  5957
  
    

  		




  
  5958
  
    

  		




  5960
  5959
  
    
--


  		




  5961
  5960
  
    
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  5962
  5961
  
    
--


  		












  

    
      schemas/filter_ERD.csv
    
  





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


  		




  11
  11
  
    
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_source_id)\) REFERENCES source\b[^;]*;",,inward


  		




  12
  12
  
    
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES sourcename\b[^;]*;",,inward


  		




  
  13
  
    
"^ALTER TABLE (?:projectcontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:project_id)\) REFERENCES \b[^;]*;",,inward


  		












Also available in:  Unified diff