Revision 3231
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2676 | 2676 |
collectionnumber text, |
| 2677 | 2677 |
collectiondate timestamp with time zone, |
| 2678 | 2678 |
description text, |
| 2679 |
specimen_id integer |
|
| 2679 |
specimen_id integer, |
|
| 2680 |
CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL))) |
|
| 2680 | 2681 |
) |
| 2681 | 2682 |
INHERITS (taxonoccurrence); |
| 2682 | 2683 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added CHECK constraint which ensures that there is at least one key to sufficiently uniquely identify the specimenreplicate