Project

General

Profile

« Previous | Next » 

Revision 4941

schemas/vegbien.sql: taxonpath: Added canon_id for the canonical (scrubbed) taxonpath determined by TNRS

View differences:

vegbien.my.sql
831 831
    taxonpath_id int(11) NOT NULL,
832 832
    datasource_id int(11) NOT NULL,
833 833
    plantcode text,
834
    canon_id int(11),
834 835
    taxon_id int(11),
835 836
    scientificname text,
836 837
    scientificnameauthor text,
......
5025 5026

  
5026 5027

  
5027 5028
--
5029
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5030
--
5031

  
5032

  
5033

  
5034

  
5035
--
5028 5036
-- Name: taxonpath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5029 5037
--
5030 5038

  

Also available in: Unified diff