Revision 5768
Added by Aaron Marcuse-Kubitza about 12 years ago
| 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
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)