Revision 3725
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1958 | 1958 |
plantnamescope_id integer NOT NULL, |
| 1959 | 1959 |
locationevent_id integer, |
| 1960 | 1960 |
project_id integer, |
| 1961 |
namedplace_id integer |
|
| 1961 |
namedplace_id integer, |
|
| 1962 |
CONSTRAINT plantnamescope_required_key CHECK ((((locationevent_id IS NOT NULL) OR (project_id IS NOT NULL)) OR (namedplace_id IS NOT NULL))) |
|
| 1962 | 1963 |
); |
| 1963 | 1964 |
|
| 1964 | 1965 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantnamescope: Added CHECK constraint to ensure that at least one key column is specified (an empty plantnamescope doesn't make sense; use NULL instead)