Project

General

Profile

« Previous | Next » 

Revision 14264

inputs/.TNRS/schema.sql: taxon_match: added derived column __accepted_infraspecific_label

View differences:

vegbien.my.sql
15465 15465
    scrubbed_unique_taxon_name varchar(255),
15466 15466
    `__accepted_{genus,specific_epithet}` varchar(255),
15467 15467
    `[accepted_]genus__@DwC__@vegpath.org` varchar(255),
15468
    `[accepted_]specificEpithet__@DwC__@vegpath.org` varchar(255)
15468
    `[accepted_]specificEpithet__@DwC__@vegpath.org` varchar(255),
15469
    __accepted_infraspecific_label varchar(255)
15469 15470
);
15470 15471

  
15471 15472

  
......
15498 15499

  
15499 15500

  
15500 15501
--
15502
-- Name: COLUMN taxon_match.__accepted_infraspecific_label; Type: COMMENT; Schema: TNRS; Owner: -
15503
--
15504

  
15505

  
15506

  
15507

  
15508
--
15501 15509
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -
15502 15510
--
15503 15511

  

Also available in: Unified diff