Revision 6150
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 213 | 213 |
|
| 214 | 214 |
|
| 215 | 215 |
-- |
| 216 |
-- Name: referencetype; Type: TYPE; Schema: public; Owner: - |
|
| 217 |
-- |
|
| 218 |
|
|
| 219 |
CREATE TYPE referencetype AS ENUM ( |
|
| 220 |
'herbarium', |
|
| 221 |
'primary database', |
|
| 222 |
'aggregator', |
|
| 223 |
'website', |
|
| 224 |
'journal', |
|
| 225 |
'book', |
|
| 226 |
'dissertation', |
|
| 227 |
'thesis', |
|
| 228 |
'report', |
|
| 229 |
'article' |
|
| 230 |
); |
|
| 231 |
|
|
| 232 |
|
|
| 233 |
-- |
|
| 216 | 234 |
-- Name: relationship; Type: TYPE; Schema: public; Owner: - |
| 217 | 235 |
-- |
| 218 | 236 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added referencetype enum, containing VegBank's values in reference.referencetype as well as values for bien_web.datasource.aggregatorOrPrimary and bien_web.dataSourceNormalized.isHerbarium,isAggregator