Revision 14257
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 |
`__accepted_{genus,specific_epithet}` varchar(255)
|
|
| 15466 |
`__accepted_{genus,specific_epithet}` varchar(255),
|
|
| 15467 |
`[accepted_]genus__@DwC__@vegpath.org` varchar(255), |
|
| 15468 |
`[accepted_]specificEpithet__@DwC__@vegpath.org` varchar(255) |
|
| 15467 | 15469 |
); |
| 15468 | 15470 |
|
| 15469 | 15471 |
|
| ... | ... | |
| 15482 | 15484 |
|
| 15483 | 15485 |
|
| 15484 | 15486 |
-- |
| 15487 |
-- Name: COLUMN taxon_match.`[accepted_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15488 |
-- |
|
| 15489 |
|
|
| 15490 |
|
|
| 15491 |
|
|
| 15492 |
|
|
| 15493 |
-- |
|
| 15494 |
-- Name: COLUMN taxon_match.`[accepted_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 15495 |
-- |
|
| 15496 |
|
|
| 15497 |
|
|
| 15498 |
|
|
| 15499 |
|
|
| 15500 |
-- |
|
| 15485 | 15501 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 15486 | 15502 |
-- |
| 15487 | 15503 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added derived columns "[accepted_]genus__@DwC__@vegpath.org", "[accepted_]specificEpithet__@DwC__@vegpath.org"