Project

General

Profile

« Previous | Next » 

Revision 5651

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