-- Name: COLUMN taxonpath.plantcode; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN taxonpath.canon_taxonpath_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN taxonpath.taxon_id; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN taxonpath.scientificname; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: COLUMN taxonpath.plantcode; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonpath.plantcode IS 'The datasource''s unique identifier for this taxonomic name.';

--

-- Name: COLUMN taxonpath.canon_taxonpath_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonpath.canon_taxonpath_id IS 'The taxonpath containing the scrubbed name of this verbatim taxonomic name. taxonpaths should be linked only one level deep, with verbatim taxonomic names pointing to scrubbed names.';

--

-- Name: COLUMN taxonpath.taxon_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonpath.taxon_id IS 'The corresponding taxon in the tree of life. Only used for scrubbed names.';

--

-- Name: COLUMN taxonpath.scientificname; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN taxonpath.scientificname IS 'The concatenated taxonomic name which uniquely identifies this taxon. Does not include the author of the name.

Equivalent to Darwin Core''s scientificName.';

--

COMMENT ON COLUMN taxonpath.author IS 'The author of the scientific name.';

COMMENT ON COLUMN taxonpath.scientificnamewithauthor IS 'The concatenated taxonomic name which uniquely identifies this taxon, plus the author of that name.

Equivalent to Darwin Core''s scientificName + scientificNameAuthorship.

Equivalent to "Name sec. x".';

COMMENT ON COLUMN taxonpath.otherranks IS 'Additional ranks which do not have a named column. Put ranks in path order, so that lower-level taxa come after higher-level taxa.';

COMMENT ON COLUMN taxonpath.scope_id IS 'The morphospecies scope.';