Revision 14281
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 15473 | 15473 |
`__accepted_infraspecific_{rank,epithet}` varchar(255),
|
| 15474 | 15474 |
`[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255), |
| 15475 | 15475 |
`[accepted_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255), |
| 15476 |
`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255) |
|
| 15476 |
`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
|
| 15477 |
`[scrubbed_]taxonRank__@DwC__@vegpath.org` varchar(255), |
|
| 15478 |
`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
|
| 15479 |
`[scrubbed_]genus__@DwC__@vegpath.org` varchar(255), |
|
| 15480 |
`[scrubbed_]specificEpithet__@DwC__@vegpath.org` varchar(255), |
|
| 15481 |
`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
|
| 15482 |
`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255), |
|
| 15483 |
`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255), |
|
| 15484 |
`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
|
| 15485 |
`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
|
| 15486 |
`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255) |
|
| 15487 |
CASE |
|
| 15488 |
WHEN matched_has_accepted THEN `[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` |
|
| 15489 |
ELSE `*Infraspecific_rank` |
|
| 15490 |
END))) |
|
| 15491 |
CASE |
|
| 15492 |
WHEN matched_has_accepted THEN `*Accepted_name_author` |
|
| 15493 |
ELSE `*Name_matched_author` |
|
| 15494 |
END))) |
|
| 15495 |
CASE |
|
| 15496 |
WHEN matched_has_accepted THEN `*Accepted_name_family` |
|
| 15497 |
ELSE `*Name_matched_accepted_family` |
|
| 15498 |
END))) |
|
| 15499 |
CASE |
|
| 15500 |
WHEN matched_has_accepted THEN `[accepted_]genus__@DwC__@vegpath.org` |
|
| 15501 |
ELSE `*Genus_matched` |
|
| 15502 |
END))) |
|
| 15503 |
CASE |
|
| 15504 |
WHEN matched_has_accepted THEN `[accepted_]specificEpithet__@DwC__@vegpath.org` |
|
| 15505 |
ELSE `*Infraspecific_epithet_matched` |
|
| 15506 |
END))) |
|
| 15507 |
CASE |
|
| 15508 |
WHEN matched_has_accepted THEN `*Accepted_name` |
|
| 15509 |
ELSE `*Name_matched` |
|
| 15510 |
END))) |
|
| 15511 |
CASE |
|
| 15512 |
WHEN matched_has_accepted THEN `[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` |
|
| 15513 |
ELSE `[matched_]scientificName[_with_author]__@DwC__@vegpath.org` |
|
| 15514 |
END))) |
|
| 15515 |
CASE |
|
| 15516 |
WHEN matched_has_accepted THEN `*Accepted_name_species` |
|
| 15517 |
ELSE `[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org` |
|
| 15518 |
END))) |
|
| 15519 |
CASE |
|
| 15520 |
WHEN matched_has_accepted THEN `[accepted_]specificEpithet__@DwC__@vegpath.org` |
|
| 15521 |
ELSE `*Specific_epithet_matched` |
|
| 15522 |
END))) |
|
| 15523 |
CASE |
|
| 15524 |
WHEN matched_has_accepted THEN `*Accepted_name_rank` |
|
| 15525 |
ELSE `*Name_matched_rank` |
|
| 15526 |
END))) |
|
| 15477 | 15527 |
); |
| 15478 | 15528 |
|
| 15479 | 15529 |
|
| ... | ... | |
| 15562 | 15612 |
|
| 15563 | 15613 |
|
| 15564 | 15614 |
-- |
| 15615 |
-- Name: COLUMN taxon_match.`[scrubbed_]taxonRank__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15616 |
-- |
|
| 15617 |
|
|
| 15618 |
|
|
| 15619 |
|
|
| 15620 |
|
|
| 15621 |
-- |
|
| 15622 |
-- Name: COLUMN taxon_match.`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15623 |
-- |
|
| 15624 |
|
|
| 15625 |
|
|
| 15626 |
|
|
| 15627 |
|
|
| 15628 |
-- |
|
| 15629 |
-- Name: COLUMN taxon_match.`[scrubbed_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15630 |
-- |
|
| 15631 |
|
|
| 15632 |
|
|
| 15633 |
|
|
| 15634 |
|
|
| 15635 |
-- |
|
| 15636 |
-- Name: COLUMN taxon_match.`[scrubbed_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15637 |
-- |
|
| 15638 |
|
|
| 15639 |
|
|
| 15640 |
|
|
| 15641 |
|
|
| 15642 |
-- |
|
| 15643 |
-- Name: COLUMN taxon_match.`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15644 |
-- |
|
| 15645 |
|
|
| 15646 |
|
|
| 15647 |
|
|
| 15648 |
|
|
| 15649 |
-- |
|
| 15650 |
-- Name: COLUMN taxon_match.`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15651 |
-- |
|
| 15652 |
|
|
| 15653 |
|
|
| 15654 |
|
|
| 15655 |
|
|
| 15656 |
-- |
|
| 15657 |
-- Name: COLUMN taxon_match.`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15658 |
-- |
|
| 15659 |
|
|
| 15660 |
|
|
| 15661 |
|
|
| 15662 |
|
|
| 15663 |
-- |
|
| 15664 |
-- Name: COLUMN taxon_match.`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15665 |
-- |
|
| 15666 |
|
|
| 15667 |
|
|
| 15668 |
|
|
| 15669 |
|
|
| 15670 |
-- |
|
| 15671 |
-- Name: COLUMN taxon_match.`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15672 |
-- |
|
| 15673 |
|
|
| 15674 |
|
|
| 15675 |
|
|
| 15676 |
|
|
| 15677 |
-- |
|
| 15678 |
-- Name: COLUMN taxon_match.`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15679 |
-- |
|
| 15680 |
|
|
| 15681 |
|
|
| 15682 |
|
|
| 15683 |
|
|
| 15684 |
-- |
|
| 15565 | 15685 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 15566 | 15686 |
-- |
| 15567 | 15687 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added derived columns scrubbed_*