Revision 712
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 18 | 18 |
|
| 19 | 19 |
|
| 20 | 20 |
-- |
| 21 |
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
CREATE TYPE occurrencestatus_dwc AS ENUM ( |
|
| 25 |
'present', |
|
| 26 |
'absent', |
|
| 27 |
'common', |
|
| 28 |
'irregular', |
|
| 29 |
'rare', |
|
| 30 |
'doubtful' |
|
| 31 |
); |
|
| 32 |
|
|
| 33 |
|
|
| 34 |
-- |
|
| 21 | 35 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 22 | 36 |
-- |
| 23 | 37 |
|
| ... | ... | |
| 90 | 104 |
plantobservation_id int(11), |
| 91 | 105 |
stratum_id int(11), |
| 92 | 106 |
sizeclass_id int(11), |
| 93 |
coverindex_id int(11) |
|
| 107 |
coverindex_id int(11), |
|
| 108 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present' |
|
| 94 | 109 |
); |
| 95 | 110 |
|
| 96 | 111 |
|
| ... | ... | |
| 102 | 117 |
|
| 103 | 118 |
|
| 104 | 119 |
-- |
| 120 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 121 |
-- |
|
| 122 |
|
|
| 123 |
|
|
| 124 |
|
|
| 125 |
|
|
| 126 |
-- |
|
| 105 | 127 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 106 | 128 |
-- |
| 107 | 129 |
|
Also available in: Unified diff
vegbien.sql: Added aggregateoccurrence.occurrencestatus_dwc field