Revision 677
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 225 | 225 |
accessioncode character varying(255), |
| 226 | 226 |
sourceaccessioncode character varying(100), |
| 227 | 227 |
plantobservation_id int(11), |
| 228 |
stratum_id int(11), |
|
| 228 | 229 |
CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ), |
| 229 | 230 |
CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) |
| 230 | 231 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 231 | 232 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 233 |
CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) |
|
| 234 |
REFERENCES stratum (stratum_id) MATCH SIMPLE |
|
| 235 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 232 | 236 |
CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id) |
| 233 | 237 |
REFERENCES taxonbinmethod (taxonbinmethod_id) MATCH SIMPLE |
| 234 | 238 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 59 | 59 |
accessioncode character varying(255), |
| 60 | 60 |
sourceaccessioncode character varying(100), |
| 61 | 61 |
plantobservation_id integer, |
| 62 |
stratum_id integer, |
|
| 62 | 63 |
); |
| 63 | 64 |
|
| 64 | 65 |
CREATE TABLE plant -- A physical, tagged plant. |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 225 | 225 |
accessioncode character varying(255), |
| 226 | 226 |
sourceaccessioncode character varying(100), |
| 227 | 227 |
plantobservation_id integer, |
| 228 |
stratum_id integer, |
|
| 228 | 229 |
CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ), |
| 229 | 230 |
CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) |
| 230 | 231 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 231 | 232 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 233 |
CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) |
|
| 234 |
REFERENCES stratum (stratum_id) MATCH SIMPLE |
|
| 235 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 232 | 236 |
CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id) |
| 233 | 237 |
REFERENCES taxonbinmethod (taxonbinmethod_id) MATCH SIMPLE |
| 234 | 238 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| schemas/vegbien.sql | ||
|---|---|---|
| 90 | 90 |
count integer, |
| 91 | 91 |
accessioncode character varying(255), |
| 92 | 92 |
sourceaccessioncode character varying(100), |
| 93 |
plantobservation_id integer |
|
| 93 |
plantobservation_id integer, |
|
| 94 |
stratum_id integer |
|
| 94 | 95 |
); |
| 95 | 96 |
|
| 96 | 97 |
|
| ... | ... | |
| 5190 | 5191 |
|
| 5191 | 5192 |
|
| 5192 | 5193 |
-- |
| 5194 |
-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5195 |
-- |
|
| 5196 |
|
|
| 5197 |
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence USING btree (stratum_id); |
|
| 5198 |
|
|
| 5199 |
|
|
| 5200 |
-- |
|
| 5193 | 5201 |
-- Name: fki_location_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5194 | 5202 |
-- |
| 5195 | 5203 |
|
| ... | ... | |
| 6061 | 6069 |
|
| 6062 | 6070 |
|
| 6063 | 6071 |
-- |
| 6072 |
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6073 |
-- |
|
| 6074 |
|
|
| 6075 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 6076 |
ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6077 |
|
|
| 6078 |
|
|
| 6079 |
-- |
|
| 6064 | 6080 |
-- Name: aggregateoccurrence_taxonbinmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6065 | 6081 |
-- |
| 6066 | 6082 |
|
Also available in: Unified diff
vegbien.sql: Added back aggregateoccurrence.stratum_id