Project

General

Profile

« Previous | Next » 

Revision 5651

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: taxonlabel: Require either an identifyingtaxonomicname or a taxonepithet. The NCBI inserted row count decreases by one because this prunes off a taxonlabel created for a parent node which was not contained in the first two rows (remember that NCBI taxa are not in dependency order, so parents are often imported after children).

View differences:

inputs/.NCBI/higher_taxa/test.xml.ref
35 35 
        </path>
36 36 
    </_simplifyPath>
37 37 
</VegBIEN>
38 
Inserted 10 new rows into database
38 
Inserted 9 new rows into database
schemas/vegbien.sql
557 557 
    description text,
558 558 
    accessioncode text,
559 559 
    CONSTRAINT taxonlabel_matched_label_fit_fraction_range CHECK (((matched_label_fit_fraction >= (0)::double precision) AND (matched_label_fit_fraction <= (1)::double precision))),
560 
    CONSTRAINT taxonlabel_required_key CHECK ((((((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (binomial IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (morphospecies IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
560 
    CONSTRAINT taxonlabel_required_key CHECK (((taxonepithet IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)))
561 561 
);
562 562 

  		




  563
  563
  
    

  		












Also available in:  Unified diff