PRIMARY KEY (`string`) )

-- Table `taxon_name`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `taxon_name` (

  `name` TEXT NOT NULL ,

  PRIMARY KEY (`name`) ,

  CONSTRAINT `fk_taxon_name_taxon_string1`

    FOREIGN KEY (`name` )

    REFERENCES `taxon_string` (`string` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `taxon_concept`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `taxon_concept` (

  `id` TEXT NOT NULL ,

  `according_to` TEXT NOT NULL ,

  `taxon_name` TEXT NOT NULL ,

  `parent` TEXT NOT NULL ,

  `accepted_taxon` TEXT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `fk_taxon_taxon1` (`parent` ASC) ,

  INDEX `fk_taxon_concept_source1` (`according_to` ASC) ,

  INDEX `fk_taxon_concept_taxon_concept1` (`accepted_taxon` ASC) ,

  INDEX `fk_taxon_concept_taxon_name1` (`taxon_name` ASC) ,

  UNIQUE INDEX `taxon_concept_unique_name` (`according_to` ASC, `taxon_name` ASC) ,

  CONSTRAINT `fk_taxon_record1`

    FOREIGN KEY (`id` )

    REFERENCES `record` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_taxon1`

    FOREIGN KEY (`parent` )

    REFERENCES `taxon_concept` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_concept_source1`

    FOREIGN KEY (`according_to` )

    REFERENCES `source` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_concept_taxon_concept1`

    FOREIGN KEY (`accepted_taxon` )

    REFERENCES `taxon_concept` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_concept_taxon_name1`

    FOREIGN KEY (`taxon_name` )

    REFERENCES `taxon_name` (`name` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `taxon_path`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `taxon_path` (

  `id` TEXT NOT NULL ,

  PRIMARY KEY (`id`) ,

  CONSTRAINT `fk_taxon_path_taxon_concept1`

    FOREIGN KEY (`id` )

    REFERENCES `taxon_concept` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `parsed_taxon_assertion`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `parsed_taxon_assertion` (

  `id` TEXT NOT NULL ,

  `matched_taxon` TEXT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `fk_parsed_taxon_assertion_taxon_path1` (`matched_taxon` ASC) ,

  CONSTRAINT `fk_matched_taxon_qualified_taxon10`

    FOREIGN KEY (`id` )

    REFERENCES `taxon_assertion` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_parsed_taxon_assertion_taxon_path1`

    FOREIGN KEY (`matched_taxon` )

    REFERENCES `taxon_path` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `verbatim_taxon_assertion`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `verbatim_taxon_assertion` (

  `id` TEXT NOT NULL ,

  `parsed_taxon_assertion` TEXT NULL ,

  PRIMARY KEY (`id`) ,

  INDEX `fk_verbatim_taxon_parsed_taxon1` (`parsed_taxon_assertion` ASC) ,

  CONSTRAINT `fk_matched_taxon_qualified_taxon100`

    FOREIGN KEY (`id` )

    REFERENCES `taxon_assertion` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_verbatim_taxon_parsed_taxon1`

    FOREIGN KEY (`parsed_taxon_assertion` )

    REFERENCES `parsed_taxon_assertion` (`id` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------