Revision 712
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 18 | 18 |
SET search_path = public, pg_catalog; |
| 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 |
|
| ... | ... | |
| 109 | 123 |
stratum_id integer, |
| 110 | 124 |
sizeclass_id integer, |
| 111 | 125 |
coverindex_id integer, |
| 126 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
|
| 112 | 127 |
CONSTRAINT aggregateoccurrence_plantobs_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1)))) |
| 113 | 128 |
); |
| 114 | 129 |
|
| ... | ... | |
| 121 | 136 |
|
| 122 | 137 |
|
| 123 | 138 |
-- |
| 139 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: - |
|
| 140 |
-- |
|
| 141 |
|
|
| 142 |
COMMENT ON COLUMN aggregateoccurrence.occurrencestatus_dwc IS 'The extent to which the taxon is present. See <http://code.google.com/p/darwincore/wiki/Occurrence#occurrenceStatus>.'; |
|
| 143 |
|
|
| 144 |
|
|
| 145 |
-- |
|
| 124 | 146 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 125 | 147 |
-- |
| 126 | 148 |
|
Also available in: Unified diff
vegbien.sql: Added aggregateoccurrence.occurrencestatus_dwc field