Revision 422
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2407 | 2407 |
determinationdate timestamp with time zone NOT NULL, |
| 2408 | 2408 |
collectiondate timestamp with time zone, |
| 2409 | 2409 |
emb_taxondetermination integer, |
| 2410 |
accessioncode character varying(255) |
|
| 2410 |
accessioncode character varying(255), |
|
| 2411 |
collection_id integer |
|
| 2411 | 2412 |
); |
| 2412 | 2413 |
|
| 2413 | 2414 |
|
| ... | ... | |
| 4567 | 4568 |
|
| 4568 | 4569 |
|
| 4569 | 4570 |
-- |
| 4571 |
-- Name: fki_r10taxondetermination_collection_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4572 |
-- |
|
| 4573 |
|
|
| 4574 |
CREATE INDEX fki_r10taxondetermination_collection_id ON taxondetermination USING btree (collection_id); |
|
| 4575 |
|
|
| 4576 |
|
|
| 4577 |
-- |
|
| 4570 | 4578 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4571 | 4579 |
-- |
| 4572 | 4580 |
|
| ... | ... | |
| 5387 | 5395 |
|
| 5388 | 5396 |
|
| 5389 | 5397 |
-- |
| 5398 |
-- Name: r10taxondetermination_collection_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5399 |
-- |
|
| 5400 |
|
|
| 5401 |
ALTER TABLE ONLY taxondetermination |
|
| 5402 |
ADD CONSTRAINT r10taxondetermination_collection_id FOREIGN KEY (collection_id) REFERENCES collection(collection_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5403 |
|
|
| 5404 |
|
|
| 5405 |
-- |
|
| 5390 | 5406 |
-- Name: r1address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5391 | 5407 |
-- |
| 5392 | 5408 |
|
Also available in: Unified diff
vegbien.sql: Added taxondetermination.collection_id column