Project

General

Profile

« Previous | Next » 

Revision 5768

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: aggregateoccurrence: Made taxonoccurrence_id optional when sourceaccessioncode is specified, so that aggregateoccurrence doesn't get pruned away in datasource tables that link just a stemobservation to a plantobservation (and therefore don't provide a taxonoccurrence to satisfy the previous taxonoccurrence_id NOT NULL constraint)

View differences:

schemas/vegbien.my.sql
400 400 
    aggregateoccurrence_id int(11) NOT NULL,
401 401 
    creator_id int(11) NOT NULL,
402 402 
    sourceaccessioncode text,
403 
    taxonoccurrence_id int(11) NOT NULL,
403 
    taxonoccurrence_id int(11),
404 404 
    collectiondate date,
405 405 
    cover_fraction double precision,
406 406 
    linecover_m double precision,
schemas/vegbien.sql
841 841 
    aggregateoccurrence_id integer NOT NULL,
842 842 
    creator_id integer NOT NULL,
843 843 
    sourceaccessioncode text,
844 
    taxonoccurrence_id integer NOT NULL,
844 
    taxonoccurrence_id integer,
845 845 
    collectiondate date,
846 846 
    cover_fraction double precision,
847 847 
    linecover_m double precision,
......
854 854 
    occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL,
855 855 
    method_id integer,
856 856 
    notes text,
857 
    accessioncode text
857 
    accessioncode text,
858 
    CONSTRAINT aggregateoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (taxonoccurrence_id IS NOT NULL)))
858 859 
);
859 860 

  		




  860
  861
  
    

  		












Also available in:  Unified diff