Revision 5606
Added by Aaron Marcuse-Kubitza over 11 years ago
TNRS.sql | ||
---|---|---|
74 | 74 |
-- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: bien |
75 | 75 |
-- |
76 | 76 |
|
77 |
COMMENT ON TABLE tnrs IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves.';
|
|
77 |
COMMENT ON TABLE tnrs IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves. |
|
78 | 78 |
|
79 |
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.'; |
|
79 | 80 |
|
81 |
|
|
80 | 82 |
-- |
81 | 83 |
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: bien |
82 | 84 |
-- |
Also available in: Unified diff
inputs/test_taxonomic_names/_scrub/public.sql, TNRS.sql: Regenerated with schema changes