Project

General

Profile

« Previous | Next » 

Revision 8576

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon_determination: added identified_date and unique index on identifying columns

View differences:

schemas/VegCore/VegCore.my.sql
195 195 
  `taxon_occurrence` TEXT NOT NULL ,
196 196 
  `taxon_assertion` TEXT NOT NULL ,
197 197 
  `identified_by` TEXT NULL ,
198 
  `identified_date` DATE NULL ,
198 199 
  `fit_info` SET('hstore') NULL ,
199 200 
  INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`taxon_assertion` ASC) ,
200 201 
  INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) ,
201 202 
  PRIMARY KEY (`id`) ,
202 203 
  INDEX `fk_taxon_determination_party1` (`identified_by` ASC) ,
204 
  UNIQUE INDEX `taxon_determination_unique` (`taxon_occurrence` ASC, `taxon_assertion` ASC, `identified_by` ASC, `identified_date` ASC) ,
203 205 
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1`
204 206 
    FOREIGN KEY (`taxon_occurrence` )
205 207 
    REFERENCES `taxon_occurrence` (`id` )

Also available in: Unified diff