Revision 10438
Added by Aaron Marcuse-Kubitza almost 11 years ago
VegCore.pg.sql | ||
---|---|---|
1059 | 1059 |
/*!40101 SET character_set_client = utf8 */; |
1060 | 1060 |
CREATE TABLE "taxon_string" ( |
1061 | 1061 |
"string" text NOT NULL, |
1062 |
"parsed_taxon_assertion" text DEFAULT NULL, |
|
1063 |
PRIMARY KEY ("string"), |
|
1064 |
/*KEY "fk_taxon_string_parsed_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true), |
|
1065 |
/*CONSTRAINT "fk_taxon_string_parsed_taxon_assertion1" FOREIGN KEY ("parsed_taxon_assertion") REFERENCES "parsed_taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
1062 |
PRIMARY KEY ("string") |
|
1066 | 1063 |
); |
1067 | 1064 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1068 | 1065 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_string: removed parsed_taxon_assertion field, since there may be more than one parsing (TNRS result) for a given taxon_string. the parsing relationship can better be represented by adding a parsed_taxon_assertion whose taxon_assertion.string points to the parsed taxon_string. getting the parsed_taxon_assertion for a taxon_string now requires joining on parsed_taxon_assertion using a backwards instead of forwards fkey, and filtering the corresponding assertions to include only the ones for TNRS (of the desired TNRS version). documented that taxon_assertion.string was previously the concatenated matched name, but is now the TNRS input name. the concatenated matched name is still in parsed_taxon_assertion.matched_taxon_concept->:taxon_name.unique_name.