Project

General

Profile

« Previous | Next » 

Revision 5269

schemas/vegbien.sql: taxonconcept: taxonconcept_required_key check constraint: Added taxonname

View differences:

schemas/vegbien.sql
1139 1139
    cultivar text,
1140 1140
    otherranks rankedtaxonname[],
1141 1141
    accessioncode text,
1142
    CONSTRAINT taxonconcept_required_key CHECK (((((((identifyingtaxonomicname IS NOT NULL) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)) OR (otherranks IS NOT NULL)))
1142
    CONSTRAINT taxonconcept_required_key CHECK ((((((((identifyingtaxonomicname IS NOT NULL) OR (taxonname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR (family IS NOT NULL)) OR (genus IS NOT NULL)) OR (otherranks IS NOT NULL)))
1143 1143
);
1144 1144

  
1145 1145

  

Also available in: Unified diff