Revision 6777
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 80 | 80 |
|
| 81 | 81 |
|
| 82 | 82 |
-- |
| 83 |
-- Name: observationtype; Type: TYPE; Schema: public; Owner: - |
|
| 84 |
-- |
|
| 85 |
|
|
| 86 |
CREATE TYPE observationtype AS ENUM ( |
|
| 87 |
'plot', |
|
| 88 |
'specimen' |
|
| 89 |
); |
|
| 90 |
|
|
| 91 |
|
|
| 92 |
-- |
|
| 83 | 93 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 84 | 94 |
-- |
| 85 | 95 |
|
| ... | ... | |
| 277 | 287 |
|
| 278 | 288 |
|
| 279 | 289 |
-- |
| 280 |
-- Name: sampletype; Type: TYPE; Schema: public; Owner: - |
|
| 281 |
-- |
|
| 282 |
|
|
| 283 |
CREATE TYPE sampletype AS ENUM ( |
|
| 284 |
'plot', |
|
| 285 |
'specimen' |
|
| 286 |
); |
|
| 287 |
|
|
| 288 |
|
|
| 289 |
-- |
|
| 290 | 290 |
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: - |
| 291 | 291 |
-- |
| 292 | 292 |
|
| ... | ... | |
| 2042 | 2042 |
sourcetype sourcetype, |
| 2043 | 2043 |
accesslevel accesslevel, |
| 2044 | 2044 |
accessconditions text, |
| 2045 |
sampletype sampletype,
|
|
| 2045 |
observationtype observationtype,
|
|
| 2046 | 2046 |
title text, |
| 2047 | 2047 |
titlesuperior text, |
| 2048 | 2048 |
volume text, |
Also available in: Unified diff
schemas/vegbien.sql: Renamed sampletype to observationtype to match the VegCore term