Revision 1431
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 18 | 18 |
|
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
|
|
| 25 |
|
|
| 26 |
|
|
| 27 |
-- |
|
| 28 |
-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 29 |
-- |
|
| 30 |
|
|
| 31 |
|
|
| 32 |
|
|
| 33 |
|
|
| 34 |
-- |
|
| 35 |
-- Name: growthform; Type: TYPE; Schema: public; Owner: - |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
|
|
| 39 |
|
|
| 40 |
|
|
| 41 |
-- |
|
| 21 | 42 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 22 | 43 |
-- |
| 23 | 44 |
|
| ... | ... | |
| 53 | 74 |
|
| 54 | 75 |
|
| 55 | 76 |
-- |
| 77 |
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: - |
|
| 78 |
-- |
|
| 79 |
|
|
| 80 |
|
|
| 81 |
|
|
| 82 |
|
|
| 83 |
-- |
|
| 56 | 84 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: - |
| 57 | 85 |
-- |
| 58 | 86 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 18 | 18 |
SET search_path = public, pg_catalog; |
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
CREATE TYPE establishmentmeans_dwc AS ENUM ( |
|
| 25 |
'cultivated', |
|
| 26 |
'invasive', |
|
| 27 |
'escaped from captivity', |
|
| 28 |
'wild', |
|
| 29 |
'exotic', |
|
| 30 |
'native' |
|
| 31 |
); |
|
| 32 |
|
|
| 33 |
|
|
| 34 |
-- |
|
| 35 |
-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
COMMENT ON TYPE establishmentmeans_dwc IS 'See http://rs.tdwg.org/dwc/terms/#establishmentMeans'; |
|
| 39 |
|
|
| 40 |
|
|
| 41 |
-- |
|
| 42 |
-- Name: growthform; Type: TYPE; Schema: public; Owner: - |
|
| 43 |
-- |
|
| 44 |
|
|
| 45 |
CREATE TYPE growthform AS ENUM ( |
|
| 46 |
'tree', |
|
| 47 |
'shrub', |
|
| 48 |
'liana', |
|
| 49 |
'vine', |
|
| 50 |
'herb', |
|
| 51 |
'hemiepiphyte', |
|
| 52 |
'epiphyte', |
|
| 53 |
'grass', |
|
| 54 |
'forb', |
|
| 55 |
'woody' |
|
| 56 |
); |
|
| 57 |
|
|
| 58 |
|
|
| 59 |
-- |
|
| 21 | 60 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
| 22 | 61 |
-- |
| 23 | 62 |
|
| ... | ... | |
| 88 | 127 |
'forb', |
| 89 | 128 |
'woody', |
| 90 | 129 |
'cultivated', |
| 130 |
'invasive', |
|
| 131 |
'escaped from captivity', |
|
| 132 |
'wild', |
|
| 91 | 133 |
'exotic', |
| 92 | 134 |
'native', |
| 93 | 135 |
'dominant', |
| ... | ... | |
| 97 | 139 |
|
| 98 | 140 |
|
| 99 | 141 |
-- |
| 142 |
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: - |
|
| 143 |
-- |
|
| 144 |
|
|
| 145 |
COMMENT ON TYPE taxonclass IS '= growthform + establishmentmeans_dwc + some others'; |
|
| 146 |
|
|
| 147 |
|
|
| 148 |
-- |
|
| 100 | 149 |
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: - |
| 101 | 150 |
-- |
| 102 | 151 |
|
Also available in: Unified diff
vegbien.sql: Added growthform and establishmentmeans_dwc enums using values from taxonclass. Documented that taxonclass is growthform + establishmentmeans_dwc + some other values.