Revision 1466
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 23 | 23 |
|
| 24 | 24 |
CREATE TYPE establishmentmeans_dwc AS ENUM ( |
| 25 | 25 |
'cultivated', |
| 26 |
'invasive', |
|
| 27 |
'escaped from captivity', |
|
| 28 | 26 |
'wild', |
| 27 |
'native', |
|
| 29 | 28 |
'exotic', |
| 30 |
'native' |
|
| 29 |
'invasive', |
|
| 30 |
'escaped from captivity' |
|
| 31 | 31 |
); |
| 32 | 32 |
|
| 33 | 33 |
|
| ... | ... | |
| 52 | 52 |
'epiphyte', |
| 53 | 53 |
'grass', |
| 54 | 54 |
'forb', |
| 55 |
'woody' |
|
| 55 |
'moss', |
|
| 56 |
'lichen', |
|
| 57 |
'fungus', |
|
| 58 |
'floating aquatic', |
|
| 59 |
'submerged aquatic' |
|
| 56 | 60 |
); |
| 57 | 61 |
|
| 58 | 62 |
|
| ... | ... | |
| 125 | 129 |
'epiphyte', |
| 126 | 130 |
'grass', |
| 127 | 131 |
'forb', |
| 128 |
'woody', |
|
| 132 |
'moss', |
|
| 133 |
'lichen', |
|
| 134 |
'fungus', |
|
| 135 |
'floating aquatic', |
|
| 136 |
'submerged aquatic', |
|
| 129 | 137 |
'cultivated', |
| 138 |
'wild', |
|
| 139 |
'native', |
|
| 140 |
'exotic', |
|
| 130 | 141 |
'invasive', |
| 131 | 142 |
'escaped from captivity', |
| 132 |
'wild', |
|
| 133 |
'exotic', |
|
| 134 |
'native', |
|
| 135 | 143 |
'dominant', |
| 136 |
'vascular',
|
|
| 137 |
'nonvascular'
|
|
| 144 |
'vascular' |
|
| 145 |
'woody'
|
|
| 138 | 146 |
); |
| 139 | 147 |
|
| 140 | 148 |
|
Also available in: Unified diff
vegbien.sql: growthform (and taxonclass) enum: Added options suggested by Michael Lee. Removed "woody". establishmentmeans_dwc (and taxonclass) enum: Reordered to match order of taxonoccurrence boolean fields, and to place each option next to its opposite. taxonclass enum: Moved "woody" to bottom because it's no longer part of growthform.