Project

General

Profile

« Previous | Next » 

Revision 5173

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: taxonpath, placepath: Added *_required_key check constraints to ensure that empty entries are not created when a row does not have taxonpath/placepath data

View differences:

inputs/.TNRS/tnrs/test.xml.ref
95 95 
        </path>
96 96 
    </_simplifyPath>
97 97 
</VegBIEN>
98 
Inserted 8 new rows into database
98 
Inserted 6 new rows into database
schemas/vegbien.sql
966 966 
    county text,
967 967 
    municipality text,
968 968 
    site text,
969 
    otherranks rankedplacename[]
969 
    otherranks rankedplacename[],
970 
    CONSTRAINT placepath_required_key CHECK (((((((placecode IS NOT NULL) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL)) OR (otherranks IS NOT NULL)))
970 971 
);
971 972 

  		




  972
  973
  
    

  		




  ......




  1174
  1175
  
    
    cultivar text,


  		




  1175
  1176
  
    
    otherranks rankedtaxonname[],


  		




  1176
  1177
  
    
    scope_id integer,


  		




  1177
  
  
    
    accessioncode text


  		




  
  1178
  
    
    accessioncode text,


  		




  
  1179
  
    
    CONSTRAINT taxonpath_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)))


  		




  1178
  1180
  
    
);


  		




  1179
  1181
  
    

  		




  1180
  1182
  
    

  		












Also available in:  Unified diff