Revision 6178
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 3503 | 3503 |
|
| 3504 | 3504 |
CREATE TABLE referencename ( |
| 3505 | 3505 |
referencename_id integer NOT NULL, |
| 3506 |
reference_id integer, |
|
| 3506 |
reference_id integer NOT NULL,
|
|
| 3507 | 3507 |
system text, |
| 3508 |
name text NOT NULL |
|
| 3508 |
name text NOT NULL, |
|
| 3509 |
matched_reference_id integer |
|
| 3509 | 3510 |
); |
| 3510 | 3511 |
|
| 3511 | 3512 |
|
| ... | ... | |
| 6068 | 6069 |
-- Name: referencename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6069 | 6070 |
-- |
| 6070 | 6071 |
|
| 6071 |
CREATE UNIQUE INDEX referencename_unique ON referencename USING btree ((COALESCE(name, '\\N'::text))); |
|
| 6072 |
CREATE UNIQUE INDEX referencename_unique ON referencename USING btree (reference_id, (COALESCE(name, '\\N'::text)));
|
|
| 6072 | 6073 |
|
| 6073 | 6074 |
|
| 6074 | 6075 |
-- |
| ... | ... | |
| 6988 | 6989 |
|
| 6989 | 6990 |
|
| 6990 | 6991 |
-- |
| 6992 |
-- Name: referencename_matched_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6993 |
-- |
|
| 6994 |
|
|
| 6995 |
ALTER TABLE ONLY referencename |
|
| 6996 |
ADD CONSTRAINT referencename_matched_reference_id_fkey FOREIGN KEY (matched_reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6997 |
|
|
| 6998 |
|
|
| 6999 |
-- |
|
| 6991 | 7000 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6992 | 7001 |
-- |
| 6993 | 7002 |
|
Also available in: Unified diff
schemas/vegbien.sql: referencename: Scope it by top-level datasource, because institutionCodes (which map to this field) are not globally unique. This involves renaming the previous reference_id field, which was for the matched reference, to matched_reference_id, to allow a scoping reference_id field.