Project

General

Profile

« Previous | Next » 

Revision 3992

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/filter_ERD.csv: Removed extraneous lines to improve readability. schemas/vegbien.ERD.mwb: Reconfigured elements to put only the most important ones in the core subset (the top page).

View differences:

schemas/vegbien.my.sql
3954 3954 
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3955 3955 
--
3956 3956 

  		




  3957
  
  
    
ALTER TABLE aggregateoccurrence


  		




  3958
  
  
    
    ADD CONSTRAINT aggregateoccurrence_coverindex_id_fkey FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;


  		




  3959
  3957
  
    

  		




  3960
  3958
  
    

  		




  
  3959
  
    

  		




  3961
  3960
  
    
--


  		




  3962
  3961
  
    
-- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  3963
  3962
  
    
--


  		




  ......




  3969
  3968
  
    
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  3970
  3969
  
    
--


  		




  3971
  3970
  
    

  		




  3972
  
  
    
ALTER TABLE aggregateoccurrence


  		




  3973
  
  
    
    ADD CONSTRAINT aggregateoccurrence_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  3974
  3971
  
    

  		




  3975
  3972
  
    

  		




  
  3973
  
    

  		




  3976
  3974
  
    
--


  		




  3977
  3975
  
    
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  3978
  3976
  
    
--


  		




  ......




  4015
  4013
  
    
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4016
  4014
  
    
--


  		




  4017
  4015
  
    

  		




  4018
  
  
    
ALTER TABLE commclass


  		




  4019
  
  
    
    ADD CONSTRAINT commclass_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4020
  4016
  
    

  		




  4021
  4017
  
    

  		




  
  4018
  
    

  		




  4022
  4019
  
    
--


  		




  4023
  4020
  
    
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4024
  4021
  
    
--


  		




  ......




  4253
  4250
  
    
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4254
  4251
  
    
--


  		




  4255
  4252
  
    

  		




  4256
  
  
    
ALTER TABLE locationevent


  		




  4257
  
  
    
    ADD CONSTRAINT locationevent_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4258
  4253
  
    

  		




  4259
  4254
  
    

  		




  
  4255
  
    

  		




  4260
  4256
  
    
--


  		




  4261
  4257
  
    
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4262
  4258
  
    
--


  		




  ......




  4465
  4461
  
    
-- Name: plantcorrelation_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4466
  4462
  
    
--


  		




  4467
  4463
  
    

  		




  4468
  
  
    
ALTER TABLE plantcorrelation


  		




  4469
  
  
    
    ADD CONSTRAINT plantcorrelation_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4470
  4464
  
    

  		




  4471
  4465
  
    

  		




  
  4466
  
    

  		




  4472
  4467
  
    
--


  		




  4473
  4468
  
    
-- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4474
  4469
  
    
--


  		




  ......




  4529
  4524
  
    
-- Name: plantnamescope_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4530
  4525
  
    
--


  		




  4531
  4526
  
    

  		




  4532
  
  
    
ALTER TABLE plantnamescope


  		




  4533
  
  
    
    ADD CONSTRAINT plantnamescope_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4534
  4527
  
    

  		




  4535
  4528
  
    

  		




  
  4529
  
    

  		




  4536
  4530
  
    
--


  		




  4537
  4531
  
    
-- Name: plantnamescope_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4538
  4532
  
    
--


  		




  4539
  4533
  
    

  		




  4540
  
  
    
ALTER TABLE plantnamescope


  		




  4541
  
  
    
    ADD CONSTRAINT plantnamescope_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4542
  4534
  
    

  		




  4543
  4535
  
    

  		




  
  4536
  
    

  		




  4544
  4537
  
    
--


  		




  4545
  4538
  
    
-- Name: plantnamescope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4546
  4539
  
    
--


  		




  4547
  4540
  
    

  		




  4548
  
  
    
ALTER TABLE plantnamescope


  		




  4549
  
  
    
    ADD CONSTRAINT plantnamescope_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4550
  4541
  
    

  		




  4551
  4542
  
    

  		




  
  4543
  
    

  		




  4552
  4544
  
    
--


  		




  4553
  4545
  
    
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4554
  4546
  
    
--


  		




  ......




  4583
  4575
  
    
-- Name: plantstatus_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4584
  4576
  
    
--


  		




  4585
  4577
  
    

  		




  4586
  
  
    
ALTER TABLE plantstatus


  		




  4587
  
  
    
    ADD CONSTRAINT plantstatus_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4588
  4578
  
    

  		




  4589
  4579
  
    

  		




  
  4580
  
    

  		




  4590
  4581
  
    
--


  		




  4591
  4582
  
    
-- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4592
  4583
  
    
--


  		




  ......




  4605
  4596
  
    
-- Name: plantusage_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4606
  4597
  
    
--


  		




  4607
  4598
  
    

  		




  4608
  
  
    
ALTER TABLE plantusage


  		




  4609
  
  
    
    ADD CONSTRAINT plantusage_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4610
  4599
  
    

  		




  4611
  4600
  
    

  		




  
  4601
  
    

  		




  4612
  4602
  
    
--


  		




  4613
  4603
  
    
-- Name: plantusage_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4614
  4604
  
    
--


  		




  ......




  4776
  4766
  
    
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4777
  4767
  
    
--


  		




  4778
  4768
  
    

  		




  4779
  
  
    
ALTER TABLE stratum


  		




  4780
  
  
    
    ADD CONSTRAINT stratum_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;


  		




  4781
  4769
  
    

  		




  4782
  4770
  
    

  		




  
  4771
  
    

  		




  4783
  4772
  
    
--


  		




  4784
  4773
  
    
-- Name: taxonalt_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -


  		




  4785
  4774
  
    
--


  		












  

    
      schemas/filter_ERD.csv
    
  





  1
  1
  
    
"PostgreSQL","MySQL","Comments"


  		




  2
  2
  
    
,,"fkeys to heavily-linked tables"


  		




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


  		




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


  		




  
  3
  
    
"^ALTER TABLE (?:commclass|plantnamescope)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward


  		




  
  4
  
    
"^ALTER TABLE (?:plant\w+)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES plantconcept\b[^;]*;",,inward


  		




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


  		




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


  		




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


  		




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


  		












Also available in:  Unified diff