Project

General

Profile

« Previous | Next » 

Revision 8574

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon tables: added catch-all hstores for custom columns

View differences:

schemas/VegCore/VegCore.my.sql
103 103 
  `id` TEXT NOT NULL ,
104 104 
  `matched_taxon` TEXT NULL ,
105 105 
  `match_score` FLOAT NULL ,
106 
  `match_info` SET('hstore') NULL ,
106 107 
  PRIMARY KEY (`id`) ,
107 108 
  INDEX `fk_parsed_taxon_assertion_taxon_name1` (`matched_taxon` ASC) ,
108 109 
  CONSTRAINT `fk_matched_taxon_qualified_taxon10`
......
146 147 
  `string` TEXT NOT NULL ,
147 148 
  `taxon` TEXT NULL ,
148 149 
  `cf_aff` TEXT NULL ,
150 
  `annotations` SET('hstore') NULL ,
149 151 
  PRIMARY KEY (`id`) ,
150 152 
  INDEX `fk_taxon_assertion_taxon_string1` (`string` ASC) ,
151 153 
  INDEX `fk_taxon_assertion_taxon_name1` (`taxon` ASC) ,
......
176 178 
  `id` TEXT NOT NULL ,
177 179 
  `taxon_occurrence` TEXT NOT NULL ,
178 180 
  `taxon_assertion` TEXT NOT NULL ,
181 
  `fit_info` SET('hstore') NULL ,
179 182 
  INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`taxon_assertion` ASC) ,
180 183 
  INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) ,
181 184 
  PRIMARY KEY (`id`) ,

Also available in: Unified diff