Revision 1151
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 94 | 94 |
basalarea double precision, |
| 95 | 95 |
biomass double precision, |
| 96 | 96 |
inferencearea double precision, |
| 97 |
stratumbase double precision, |
|
| 98 |
stratumheight double precision, |
|
| 99 | 97 |
emb_aggregateoccurrence int(11), |
| 100 |
covercode text, |
|
| 101 | 98 |
count int(11), |
| 102 | 99 |
accessioncode text, |
| 103 | 100 |
sourceaccessioncode text, |
| 104 | 101 |
plantobservation_id int(11), |
| 105 | 102 |
stratum_id int(11), |
| 106 |
sizeclass_id int(11), |
|
| 107 | 103 |
coverindex_id int(11), |
| 108 | 104 |
occurrencestatus_dwc text DEFAULT 'present', |
| 109 | 105 |
method_id int(11) |
| ... | ... | |
| 3956 | 3952 |
|
| 3957 | 3953 |
|
| 3958 | 3954 |
-- |
| 3955 |
-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3956 |
-- |
|
| 3957 |
|
|
| 3958 |
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence (coverindex_id); |
|
| 3959 |
|
|
| 3960 |
|
|
| 3961 |
-- |
|
| 3959 | 3962 |
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3960 | 3963 |
-- |
| 3961 | 3964 |
|
| ... | ... | |
| 4805 | 4808 |
|
| 4806 | 4809 |
|
| 4807 | 4810 |
-- |
| 4811 |
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4812 |
-- |
|
| 4813 |
|
|
| 4814 |
ALTER TABLE aggregateoccurrence |
|
| 4815 |
ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 4816 |
|
|
| 4817 |
|
|
| 4818 |
-- |
|
| 4808 | 4819 |
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4809 | 4820 |
-- |
| 4810 | 4821 |
|
| schemas/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.