Project

General

Profile

« Previous | Next » 

Revision 8540

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