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