Revision 5526
Added by Aaron Marcuse-Kubitza about 12 years ago
inputs/.TNRS/schema.sql | ||
---|---|---|
41 | 41 |
WITH ( |
42 | 42 |
OIDS=FALSE |
43 | 43 |
); |
44 |
COMMENT ON TABLE tnrs |
|
45 |
IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves.';
|
|
44 |
COMMENT ON TABLE "TNRS".tnrs
|
|
45 |
IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves. |
|
46 | 46 |
|
47 |
Accepted names must be processed before any names that resolve to them, because the entry for the accepted name contains all the ranks parsed out but the resolved name of another entry contains just some ranks and the taxonomic name. Column-based import will do this automatically when the total # of rows is <= the partition_size (because _taxonconcept_set_matched_concept_id()''s accepted taxonconcept is created after the main taxonconcept), but TNRS has more rows than this so sorting is needed to ensure that all the accepted names are processed in the first partitions.'; |
|
48 |
|
|
47 | 49 |
CREATE INDEX tnrs_accepted_names |
48 | 50 |
ON tnrs |
49 | 51 |
USING btree |
Also available in: Unified diff
inputs/.TNRS/schema.sql: Documented that accepted names must be processed before any names that resolve to them, because the entry for the accepted name contains all the ranks parsed out but the resolved name of another entry contains just some ranks and the taxonomic name. Column-based import will do this automatically when the total # of rows is <= the partition_size (because _taxonconcept_set_matched_concept_id()'s accepted taxonconcept is created after the main taxonconcept), but TNRS has more rows than this so sorting is needed to ensure that all the accepted names are processed in the first partitions.