Project

General

Profile

« Previous | Next » 

Revision 13878

fix: inputs/.TNRS/schema.sql: MatchedTaxon: use taxon_best_match instead of taxon_match because this should provide only one match per taxon

View differences:

vegbien.my.sql
15410 15410

  
15411 15411

  
15412 15412
--
15413
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -
15414
--
15415

  
15416

  
15417

  
15418

  
15419
--
15420
-- Name: VIEW taxon_best_match; Type: COMMENT; Schema: TNRS; Owner: -
15421
--
15422

  
15423

  
15424

  
15425

  
15426
--
15413 15427
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -
15414 15428
--
15415 15429

  
......
15519 15533

  
15520 15534

  
15521 15535
--
15522
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -
15523
--
15524

  
15525

  
15526

  
15527

  
15528
--
15529
-- Name: VIEW taxon_best_match; Type: COMMENT; Schema: TNRS; Owner: -
15530
--
15531

  
15532

  
15533

  
15534

  
15535
--
15536 15536
-- Name: taxon_match_input; Type: VIEW; Schema: TNRS; Owner: -
15537 15537
--
15538 15538

  
......
15834 15834

  
15835 15835

  
15836 15836
--
15837
-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -
15837
-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: -
15838 15838
--
15839 15839

  
15840 15840

  
......
15844 15844

  
15845 15845

  
15846 15846
--
15847
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -
15847
-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -
15848 15848
--
15849 15849

  
15850 15850

  
......
15854 15854

  
15855 15855

  
15856 15856
--
15857
-- Name: taxon_best_match; Type: ACL; Schema: TNRS; Owner: -
15857
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -
15858 15858
--
15859 15859

  
15860 15860

  

Also available in: Unified diff