Revision 1151
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 142 | 142 |
basalarea double precision, |
| 143 | 143 |
biomass double precision, |
| 144 | 144 |
inferencearea double precision, |
| 145 |
stratumbase double precision, |
|
| 146 |
stratumheight double precision, |
|
| 147 | 145 |
emb_aggregateoccurrence integer, |
| 148 |
covercode text, |
|
| 149 | 146 |
count integer, |
| 150 | 147 |
accessioncode text, |
| 151 | 148 |
sourceaccessioncode text, |
| 152 | 149 |
plantobservation_id integer, |
| 153 | 150 |
stratum_id integer, |
| 154 |
sizeclass_id integer, |
|
| 155 | 151 |
coverindex_id integer, |
| 156 | 152 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 157 | 153 |
method_id integer, |
| ... | ... | |
| 4348 | 4344 |
|
| 4349 | 4345 |
|
| 4350 | 4346 |
-- |
| 4347 |
-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4348 |
-- |
|
| 4349 |
|
|
| 4350 |
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence USING btree (coverindex_id); |
|
| 4351 |
|
|
| 4352 |
|
|
| 4353 |
-- |
|
| 4351 | 4354 |
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4352 | 4355 |
-- |
| 4353 | 4356 |
|
| ... | ... | |
| 5197 | 5200 |
|
| 5198 | 5201 |
|
| 5199 | 5202 |
-- |
| 5203 |
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5204 |
-- |
|
| 5205 |
|
|
| 5206 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 5207 |
ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5208 |
|
|
| 5209 |
|
|
| 5210 |
-- |
|
| 5200 | 5211 |
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5201 | 5212 |
-- |
| 5202 | 5213 |
|
Also available in: Unified diff
vegbien.sql: aggregateoccurrence: Removed unneeded fields. Added aggregateoccurrence->coverindex fkey.