Revision 1166
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 102 | 102 |
stratum_id int(11), |
| 103 | 103 |
coverindex_id int(11), |
| 104 | 104 |
occurrencestatus_dwc text DEFAULT 'present', |
| 105 |
method_id int(11) |
|
| 105 |
method_id int(11), |
|
| 106 |
linecover double precision |
|
| 106 | 107 |
); |
| 107 | 108 |
|
| 108 | 109 |
|
| ... | ... | |
| 121 | 122 |
|
| 122 | 123 |
|
| 123 | 124 |
-- |
| 125 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: - |
|
| 126 |
-- |
|
| 127 |
|
|
| 128 |
|
|
| 129 |
|
|
| 130 |
|
|
| 131 |
-- |
|
| 124 | 132 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 125 | 133 |
-- |
| 126 | 134 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 151 | 151 |
coverindex_id integer, |
| 152 | 152 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 153 | 153 |
method_id integer, |
| 154 |
linecover double precision, |
|
| 154 | 155 |
CONSTRAINT aggregateoccurrence_plantobservation_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1)))) |
| 155 | 156 |
); |
| 156 | 157 |
|
| ... | ... | |
| 170 | 171 |
|
| 171 | 172 |
|
| 172 | 173 |
-- |
| 174 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: - |
|
| 175 |
-- |
|
| 176 |
|
|
| 177 |
COMMENT ON COLUMN aggregateoccurrence.linecover IS 'The distance in m along which this occurrence intercepts a line subplot.'; |
|
| 178 |
|
|
| 179 |
|
|
| 180 |
-- |
|
| 173 | 181 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 174 | 182 |
-- |
| 175 | 183 |
|
Also available in: Unified diff
vegbien.sql: aggregateoccurrence: Added linecover