Revision 7053
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 2495 | 2495 |
CREATE TABLE commconcept ( |
| 2496 | 2496 |
commconcept_id integer NOT NULL, |
| 2497 | 2497 |
commname_id integer NOT NULL, |
| 2498 |
source_id integer,
|
|
| 2498 |
reference_id integer,
|
|
| 2499 | 2499 |
commdescription text, |
| 2500 | 2500 |
commname text, |
| 2501 | 2501 |
accessioncode text |
| ... | ... | |
| 6804 | 6804 |
-- |
| 6805 | 6805 |
|
| 6806 | 6806 |
ALTER TABLE ONLY commconcept |
| 6807 |
ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6807 |
ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6808 | 6808 |
|
| 6809 | 6809 |
|
| 6810 | 6810 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: commconcept: Renamed source_id back to reference_id (it was previously renamed to source_id in a bulk rename)