Revision 14279
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 15463 | 15463 |
`*Accepted_name_lsid` varchar(255), |
| 15464 | 15464 |
is_valid_match int(1) NOT NULL, |
| 15465 | 15465 |
scrubbed_unique_taxon_name varchar(255), |
| 15466 |
`[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
|
| 15467 |
`[matched_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
|
| 15468 |
matched_has_accepted int(1), |
|
| 15466 | 15469 |
`__accepted_{genus,specific_epithet}` varchar(255),
|
| 15467 | 15470 |
`[accepted_]genus__@DwC__@vegpath.org` varchar(255), |
| 15468 | 15471 |
`[accepted_]specificEpithet__@DwC__@vegpath.org` varchar(255), |
| ... | ... | |
| 15470 | 15473 |
`__accepted_infraspecific_{rank,epithet}` varchar(255),
|
| 15471 | 15474 |
`[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255), |
| 15472 | 15475 |
`[accepted_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255), |
| 15473 |
`[matched_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
|
| 15474 |
`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
|
| 15475 |
matched_has_accepted int(1), |
|
| 15476 |
`[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255) |
|
| 15476 |
`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255) |
|
| 15477 | 15477 |
); |
| 15478 | 15478 |
|
| 15479 | 15479 |
|
| ... | ... | |
| 15485 | 15485 |
|
| 15486 | 15486 |
|
| 15487 | 15487 |
-- |
| 15488 |
-- Name: COLUMN taxon_match.`__accepted_{genus,specific_epithet}`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15488 |
-- Name: COLUMN taxon_match.`[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15489 | 15489 |
-- |
| 15490 | 15490 |
|
| 15491 | 15491 |
|
| 15492 | 15492 |
|
| 15493 | 15493 |
|
| 15494 | 15494 |
-- |
| 15495 |
-- Name: COLUMN taxon_match.`[accepted_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15495 |
-- Name: COLUMN taxon_match.`[matched_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15496 | 15496 |
-- |
| 15497 | 15497 |
|
| 15498 | 15498 |
|
| 15499 | 15499 |
|
| 15500 | 15500 |
|
| 15501 | 15501 |
-- |
| 15502 |
-- Name: COLUMN taxon_match.`[accepted_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15502 |
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15503 | 15503 |
-- |
| 15504 | 15504 |
|
| 15505 | 15505 |
|
| 15506 | 15506 |
|
| 15507 | 15507 |
|
| 15508 | 15508 |
-- |
| 15509 |
-- Name: COLUMN taxon_match.__accepted_infraspecific_label; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15509 |
-- Name: COLUMN taxon_match.`__accepted_{genus,specific_epithet}`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15510 | 15510 |
-- |
| 15511 | 15511 |
|
| 15512 | 15512 |
|
| 15513 | 15513 |
|
| 15514 | 15514 |
|
| 15515 | 15515 |
-- |
| 15516 |
-- Name: COLUMN taxon_match.`__accepted_infraspecific_{rank,epithet}`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15516 |
-- Name: COLUMN taxon_match.`[accepted_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15517 | 15517 |
-- |
| 15518 | 15518 |
|
| 15519 | 15519 |
|
| 15520 | 15520 |
|
| 15521 | 15521 |
|
| 15522 | 15522 |
-- |
| 15523 |
-- Name: COLUMN taxon_match.`[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15523 |
-- Name: COLUMN taxon_match.`[accepted_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15524 | 15524 |
-- |
| 15525 | 15525 |
|
| 15526 | 15526 |
|
| 15527 | 15527 |
|
| 15528 | 15528 |
|
| 15529 | 15529 |
-- |
| 15530 |
-- Name: COLUMN taxon_match.`[accepted_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15530 |
-- Name: COLUMN taxon_match.__accepted_infraspecific_label; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15531 | 15531 |
-- |
| 15532 | 15532 |
|
| 15533 | 15533 |
|
| 15534 | 15534 |
|
| 15535 | 15535 |
|
| 15536 | 15536 |
-- |
| 15537 |
-- Name: COLUMN taxon_match.`[matched_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15537 |
-- Name: COLUMN taxon_match.`__accepted_infraspecific_{rank,epithet}`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15538 | 15538 |
-- |
| 15539 | 15539 |
|
| 15540 | 15540 |
|
| 15541 | 15541 |
|
| 15542 | 15542 |
|
| 15543 | 15543 |
-- |
| 15544 |
-- Name: COLUMN taxon_match.`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15544 |
-- Name: COLUMN taxon_match.`[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15545 | 15545 |
-- |
| 15546 | 15546 |
|
| 15547 | 15547 |
|
| 15548 | 15548 |
|
| 15549 | 15549 |
|
| 15550 | 15550 |
-- |
| 15551 |
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15551 |
-- Name: COLUMN taxon_match.`[accepted_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15552 | 15552 |
-- |
| 15553 | 15553 |
|
| 15554 | 15554 |
|
| 15555 | 15555 |
|
| 15556 | 15556 |
|
| 15557 | 15557 |
-- |
| 15558 |
-- Name: COLUMN taxon_match.`[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15558 |
-- Name: COLUMN taxon_match.`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15559 | 15559 |
-- |
| 15560 | 15560 |
|
| 15561 | 15561 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: put matched-taxon derived columns before accepted-taxon derived columns