Project

General

Profile

« Previous | Next » 

Revision 8572

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon tables: added nonidentifying columns

View differences:

schemas/VegCore/VegCore.my.sql
93 93 
  `according_to` TEXT NOT NULL ,
94 94 
  `taxon_name` TEXT NOT NULL ,
95 95 
  `parent` TEXT NOT NULL ,
96 
  `rank` TEXT NULL ,
96 97 
  `accepted_taxon` TEXT NULL ,
97 98 
  PRIMARY KEY (`id`) ,
98 99 
  INDEX `fk_taxon_taxon1` (`parent` ASC) ,
......
140 141 
-- -----------------------------------------------------
141 142 
CREATE  TABLE IF NOT EXISTS `taxon_path` (
142 143 
  `id` TEXT NOT NULL ,
144 
  `family` TEXT NULL ,
145 
  `genus` TEXT NULL ,
146 
  `specific_epithet` TEXT NULL ,
147 
  `ranks` SET('hstore') NULL ,
143 148 
  PRIMARY KEY (`id`) ,
144 149 
  CONSTRAINT `fk_taxon_path_taxon_concept1`
145 150 
    FOREIGN KEY (`id` )
......
157 162 
CREATE  TABLE IF NOT EXISTS `parsed_taxon_assertion` (
158 163 
  `id` TEXT NOT NULL ,
159 164 
  `matched_taxon` TEXT NULL ,
165 
  `match_score` FLOAT NULL ,
160 166 
  PRIMARY KEY (`id`) ,
161 167 
  INDEX `fk_parsed_taxon_assertion_taxon_path1` (`matched_taxon` ASC) ,
162 168 
  CONSTRAINT `fk_matched_taxon_qualified_taxon10`
......
198 204 
CREATE  TABLE IF NOT EXISTS `taxon_assertion` (
199 205 
  `id` TEXT NOT NULL ,
200 206 
  `string` TEXT NOT NULL ,
201 
  `taxon_concept` TEXT NULL ,
207 
  `taxon` TEXT NULL ,
208 
  `cf_aff` TEXT NULL ,
202 209 
  PRIMARY KEY (`id`) ,
203 210 
  INDEX `fk_taxon_assertion_taxon_string1` (`string` ASC) ,
204 
  INDEX `fk_taxon_assertion_taxon_concept1` (`taxon_concept` ASC) ,
211 
  INDEX `fk_taxon_assertion_taxon_concept1` (`taxon` ASC) ,
205 212 
  CONSTRAINT `fk_qualified_taxon_record1`
206 213 
    FOREIGN KEY (`id` )
207 214 
    REFERENCES `record` (`id` )
......
213 220 
    ON DELETE CASCADE
214 221 
    ON UPDATE CASCADE,
215 222 
  CONSTRAINT `fk_taxon_assertion_taxon_concept1`
216 
    FOREIGN KEY (`taxon_concept` )
223 
    FOREIGN KEY (`taxon` )
217 224 
    REFERENCES `taxon_concept` (`id` )
218 225 
    ON DELETE CASCADE
219 226 
    ON UPDATE CASCADE)

Also available in: Unified diff