Project

General

Profile

« Previous | Next » 

Revision 8540

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: renamed fkeys to match renamed tables

View differences:

schemas/VegCore/VegCore.my.sql
135 135 
CREATE  TABLE IF NOT EXISTS `taxon_determination` (
136 136 
  `id` TEXT NOT NULL ,
137 137 
  `taxon_occurrence` TEXT NOT NULL ,
138 
  `qualified_taxon` TEXT NOT NULL ,
139 
  INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`qualified_taxon` ASC) ,
138 
  `taxon_assertion` TEXT NOT NULL ,
139 
  INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`taxon_assertion` ASC) ,
140 140 
  INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) ,
141 141 
  PRIMARY KEY (`id`) ,
142 142 
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1`
......
145 145 
    ON DELETE CASCADE
146 146 
    ON UPDATE CASCADE,
147 147 
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1`
148 
    FOREIGN KEY (`qualified_taxon` )
148 
    FOREIGN KEY (`taxon_assertion` )
149 149 
    REFERENCES `taxon_assertion` (`id` )
150 150 
    ON DELETE CASCADE
151 151 
    ON UPDATE CASCADE,
......
719 719 
-- -----------------------------------------------------
720 720 
CREATE  TABLE IF NOT EXISTS `verbatim_taxon_assertion` (
721 721 
  `id` TEXT NOT NULL ,
722 
  `parsed_taxon` TEXT NULL ,
722 
  `parsed_taxon_assertion` TEXT NULL ,
723 723 
  PRIMARY KEY (`id`) ,
724 
  INDEX `fk_verbatim_taxon_parsed_taxon1` (`parsed_taxon` ASC) ,
724 
  INDEX `fk_verbatim_taxon_parsed_taxon1` (`parsed_taxon_assertion` ASC) ,
725 725 
  CONSTRAINT `fk_matched_taxon_qualified_taxon100`
726 726 
    FOREIGN KEY (`id` )
727 727 
    REFERENCES `taxon_assertion` (`id` )
728 728 
    ON DELETE CASCADE
729 729 
    ON UPDATE CASCADE,
730 730 
  CONSTRAINT `fk_verbatim_taxon_parsed_taxon1`
731 
    FOREIGN KEY (`parsed_taxon` )
731 
    FOREIGN KEY (`parsed_taxon_assertion` )
732 732 
    REFERENCES `parsed_taxon_assertion` (`id` )
733 733 
    ON DELETE CASCADE
734 734 
    ON UPDATE CASCADE)

Also available in: Unified diff