`*Accepted_name_lsid` varchar(255),

    is_valid_match int(1) NOT NULL,

    scrubbed_unique_taxon_name varchar(255),

    `[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),

    `[matched_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255),

    matched_has_accepted int(1),

    `__accepted_{genus,specific_epithet}` varchar(255),

    `[accepted_]genus__@DwC__@vegpath.org` varchar(255),

    `[accepted_]specificEpithet__@DwC__@vegpath.org` varchar(255),

    __accepted_infraspecific_label varchar(255),

    `__accepted_infraspecific_{rank,epithet}` varchar(255),

    `[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255),

    `[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255),

    `[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),

    `[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),

CASE

    WHEN (`*Accepted_name_rank` = CAST('family' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name_family`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)

    WHEN (`*Accepted_name_rank` = CAST('genus' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)

--

-- Name: COLUMN taxon_match.`[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: COLUMN taxon_match.__accepted_infraspecific_label; Type: COMMENT; Schema: TNRS; Owner: -

--

--

-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -

--