Project

General

Profile

« Previous | Next » 

Revision 5606

inputs/test_taxonomic_names/_scrub/public.sql, TNRS.sql: Regenerated with schema changes

View differences:

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